Servlet代码
(页面中使用了DBUtil包中的方法上一篇博客中有)
package org.psh.model;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.psh.util.DBUtil;
public class UserList extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.println("<h1 style='text-align:center;color:red' >用户信息表</h1>");
out.println("<table border='1' align = 'center'>");
out.println("<tr><th>编号</th><th>姓名</th><th>年龄</th><th>用户名</th><th>密码</th></tr>");
Connection conn = DBUtil.getConn();
String sql = "select *from users";
PreparedStatement ps = null;
ResultSet rs =null;
try {
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
out.println("<tr>" +
"<td>"+rs.getInt("id")+"</td>" +
"<td>"+rs.getString("name")+"</td>" +
"<td>"+rs.getInt("age")+"</td>" +
"<td>"+rs.getString("user_name")+"</td>" +
"<td>"+rs.getString("pwd")+"</td>" +
"</tr>");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
DBUtil.close(rs, ps, conn);
}
out.println("</table>");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
}
web.xml中的代码
<?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>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>UserList</servlet-name>
<servlet-class>org.psh.model.UserList</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>UserList</servlet-name>
<url-pattern>/userList</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
成品效果图