81,091
社区成员
发帖
与我相关
我的任务
分享
package com.throne212.javaweb.ch09;
public class User {
private String username;
private String password;
private String gender;
private int age;
private String description;
public String getUsername(){
return username;
}
public void setUsername(String username){
this.username = username;
}
public String getPassword(){
return password;
}
public void setPassword(String password){
this.password = password;
}
public String getGender(){
return gender;
}
public void setGender(String gender){
this.gender = gender;
}
public int getAge(){
return age;
}
public void setAge(int age){
this.age = age;
}
public String getDescription(){
return description;
}
public void setDescription(String description){
this.description = description;
}
}
package com.throne212.javaweb.ch09;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class QueryUserServlet extends HttpServlet{
static{
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
private static final String url = "jdbc:mysql://localhost:3306/test";
private static final String username = "root";
private static final String password="123";
public void doGet(HttpServletRequest request, HttpServletResponse response)throws IOException,ServletException{
this.doPost(request, response);
}
public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
List<User> users = new ArrayList<User>();
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try{
String sql = "select * from ch09_user_table"; //获取连接
conn = DriverManager.getConnection(url, username, password); //创建会话
ps = conn.prepareStatement(sql); //执行查询
rs = ps.executeQuery();
if(rs.next()){
User user = new User();
user.setUsername(rs.getString("username"));
user.setPassword(rs.getString("password"));
user.setAge(rs.getInt("age"));
user.setGender(rs.getString("gender"));
user.setDescription(rs.getString("description"));
users.add(user);
}
}catch(SQLException e){
e.printStackTrace();
}finally{
if(rs != null){
try{
rs.close();
}catch(SQLException e){
e.printStackTrace();
}
}
if(ps != null){
try{
ps.close();
}catch(SQLException e){
e.printStackTrace();
}
}
if(conn != null){
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
request.setAttribute("users", users);
request.getRequestDispatcher("list.jsp").forward(request, response);
}
}
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>用户列表</title>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<table border="1" align="center">
<tr>
<th>用户名:</th>
<th>密码:</th>
<th>年龄:</th>
<th>性别</th>
<th>简介</th>
</tr>
<!-- 使用<c:forEach>标签遍历所有用户 -->
<c:forEach var="user" items="${requestScope.users}">
<tr>
<td>
${user.username }
</td>
<td>
<c:if test="${!empty user.password}">***</c:if>
</td>
<td>
${user.age}
</td>
<td>
<c:if test="${user.gender == 'male'}">男</c:if>
<c:if test="${user.gender == 'female'}">女</c:if>
</td>
<td>
${user.description}
</td>
</tr>
</c:forEach>
</table>
</body>
</html>
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<servlet>
<servlet-name>QueryUserServlet</servlet-name>
<servlet-class>com.throne212.javaweb.ch09.QueryUserServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>QueryUserServlet</servlet-name>
<url-pattern>/QueryUserServlet</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>list.jsp</welcome-file>
</welcome-file-list>
</web-app>