通过前台页面选择性别作为条件进行查询 将查询结果在表格中进行显示 使用Java Web MVC模式进行开发;请给出“输入页面”代码、“结果页面”代码、“servlet”代码、“数据库连接JavaBean”代码、“数据库操作JavaBean”代码、
时间: 2023-12-21 10:03:44 浏览: 26
好的,以下是一个简单的示例代码,包括“输入页面”、JavaBean和Servlet:
### 输入页面代码
```
<!DOCTYPE html>
<html>
<head>
<title>查询</title>
</head>
<body>
<h2>查询用户</h2>
<form action="search" method="GET">
<label for="gender">性别:</label>
<select name="gender" id="gender">
<option value="male">男</option>
<option value="female">女</option>
</select>
<br><br>
<input type="submit" value="查询">
</form>
</body>
</html>
```
### 结果页面代码
```
<!DOCTYPE html>
<html>
<head>
<title>查询结果</title>
</head>
<body>
<h2>查询结果</h2>
<table>
<thead>
<tr>
<th>ID</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
</tr>
</thead>
<tbody>
<c:forEach var="user" items="${users}">
<tr>
<td>${user.id}</td>
<td>${user.name}</td>
<td>${user.gender}</td>
<td>${user.age}</td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
</html>
```
### JavaBean代码(数据库连接)
```
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBUtil {
private static final String URL = "jdbc:mysql://localhost:3306/test";
private static final String USER = "root";
private static final String PASSWORD = "password";
private static Connection conn = null;
static {
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL, USER, PASSWORD);
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
return conn;
}
}
```
### JavaBean代码(数据库操作)
```
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class UserDAO {
private Connection conn;
public UserDAO() {
conn = DBUtil.getConnection();
}
public List<User> searchByGender(String gender) {
List<User> users = new ArrayList<>();
String sql = "SELECT * FROM users WHERE gender = ?";
try {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, gender);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
User user = new User();
user.setId(rs.getInt("id"));
user.setName(rs.getString("name"));
user.setGender(rs.getString("gender"));
user.setAge(rs.getInt("age"));
users.add(user);
}
} catch (SQLException e) {
e.printStackTrace();
}
return users;
}
}
```
### Servlet代码
```
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/search")
public class SearchServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String gender = request.getParameter("gender");
UserDAO dao = new UserDAO();
List<User> users = dao.searchByGender(gender);
request.setAttribute("users", users);
request.getRequestDispatcher("result.jsp").forward(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
```
这些代码实现了一个简单的Java Web应用程序,用户可以在输入页面中选择性别,并提交表单进行查询,查询结果将被显示在结果页面中的表格中。