Добрый день!
Написала простой web-проект c jsp, servlets, но почему-то не подтягиваются данные из БД в users.jsp.:-(
GetAllUsersController.java
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
public class GetAllUsersController implements Controller {
private final UserService userService;
public GetAllUsersController(UserService userService) {
this.userService = userService;
}
public ViewModel process (HttpServletRequest request, HttpServletResponse response) {
List <User> users = userService.getAllUsers();
return new ViewModel("users").withAttribute("users",users);
}
}
UserDaoImpl.java
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
public class UserDaoImpl implements UserDao {
private final Connection connection;
public UserDaoImpl(Connection connection) {
this.connection = connection;
}
@Override
public User save(User user) {
try {
PreparedStatement statement =
connection.prepareStatement("insert into users(username, password, email) values(?,?,?)");
statement.setString(1, user.getUsername());
statement.setString(2, user.getPassword());
statement.setString(3, user.getEmail());
statement.execute();
} catch (SQLException e) {
throw new RuntimeException(e);
}
return user;
}
@Override
public User getByName(String username) {
User user = null;
try {
PreparedStatement statement = connection.prepareStatement("select * from users where username = ?");
statement.setString(1, username);
ResultSet rs = statement.executeQuery();
rs.next();
String email = rs.getString("email");
int userId = rs.getInt("userId");
user = User.from(userId, username, email);
} catch (SQLException e) {
throw new RuntimeException(e);
}
return user;
}
@Override
public void remove(String username) {
try {
PreparedStatement statement =
connection.prepareStatement("delete * from users where username = ?");
statement.setString(1, username);
ResultSet rs = statement.executeQuery();
rs.next();
} catch (SQLException e) {
throw new RuntimeException();
}
return;
}
@Override
public User update(User user) {
try {
PreparedStatement statement =
connection.prepareStatement("update users set username=?, password=?, email=? where userId = ?");
statement.setString(1, user.getUsername());
statement.setString(2, user.getPassword());
statement.setString(3, user.getEmail());
statement.execute();
} catch (SQLException e) {
throw new RuntimeException(e);
}
return user;
}
@Override
public List<User> getAllUsers() {
List<User> users = new ArrayList<User>();
try {
PreparedStatement statement =
connection.prepareStatement("select * from users");
ResultSet rs = statement.executeQuery();
while (rs.next()) {
int userId = rs.getInt("userId");
String username = rs.getString("username");
String email = rs.getString("email");
String password = rs.getString("password");
User user = new User(userId,username,password,email);
users.add(user);
}
} catch (SQLException e) {
throw new RuntimeException(e);
}
return users;
}
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page isELIgnored="false" %>
<html>
<head>
<title>Users</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.1/css/bootstrap.min.css">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.1/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h3>Users List</h3>
<form class="form-inline" role="form" action="/search" method="post">
<input type="text" class="form-control" name="pattern" placeholder="Search">
<input type="submit" class="btn btn-default" value="Search">
</form>
<table class="table table-striped">
<thead>
<tr>
<td><b>userId</b></td>
<td><b>username</b></td>
<td><b>email</b></td>
<td><b>password</b></td>
<td><b>Action</b></td>
</tr>
</thead>
<tr>
<c:forEach var = "users" items="${users}">
<td>${users.userId}</td>
<td>${users.username}</td>
<td>${users.email}</td>
<td>${users.password}</td>
<td><a href="/delete?id=${users.username}">Delete</a></td>
</c:forEach>
</tr>
</table>
<form class="form-inline" role="form" action="/add_page" method="post">
<input type="submit" class="btn btn-default" value="Add new">
</form>
</div>
</body>
</html>
Посмотрите пожалуйста, может еще что-то полезное посоветуете.:-)
Ссылка на проект:
https://github.com/FeschenkoNatalia/servletTestEasy
Спасибо большое!:-)
