81,122
社区成员




package jdbc.one;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class PersonServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection con=null;
Statement st=null;
ResultSet rs=null;
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException e){
e.printStackTrace();
System.out.println("驱动程序加载错误");
}
try{
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/study","root","19951227");
st=con.createStatement();
rs=st.executeQuery("select* from person");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>列出人员信息表</TITLE></HEAD>");
out.println(" <BODY>");
out.print("<center><h4>人员信息列表</h4>");
out.print("<table border=\"1\" width=\100%\" cellpadding=\"2\" cellspacing=\"1\">");
out.print("<tr><td>选择</td>");
out.print("<td>姓名</td>");
out.print("<td>年龄</td>");
out.print("<td>性别</td>");
out.print("<td>生日</td>");
out.print("<td>备注</td></tr>");
while(rs.next()){
int id=rs.getInt("id");
String name=rs.getString("name");
int age=rs.getInt("age");
String sex=rs.getString("sex");
Date birthday=rs.getDate("birthday");
String description=rs.getString("description");
out.print("<tr>");
out.print("<td><input type=\"checkbox\" name=\"id\" value=\""+id+"\"></td>");
out.print("<td>"+name+"</td>");
out.print("<td>"+age+"</td>");
out.print("<td>"+sex+"</td>");
out.print("<td>"+birthday+"</td>");
out.print("<td>"+description+"</td>");
out.print("</tr>");
}
out.print("</table></center>");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}catch (SQLException e){
e.printStackTrace();
}finally{
try{
rs.close();
st.close();
con.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}