📄 studentlistservlet.java
字号:
package cn.com.tarena.web.servlet.day3;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class StudentListServlet extends HttpServlet{
public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
//设置MINE格式
response.setContentType("text/html");
//获得能够往客户端输出HTML的书写器
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println(" <title>Student List</title>");
out.println("</head>");
out.println("<body>");
out.println("<h2 align=\"center\">Student List</h2>");
out.println("<hr>");
out.println("<table width=\"600px\" align=\"center\" border=\"1\">");
out.println(" <tr>");
out.println(" <th>USER_NAME</th>");
out.println(" <th>PASSWORD</th>");
out.println(" <th>PROVINCE</th>");
out.println(" <th>GENDER</th>");
out.println(" <th>HOBBIES</th>");
out.println(" </tr>");
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.pointbase.jdbc.jdbcUniversalDriver");
conn = DriverManager.getConnection("jdbc:pointbase:server://localhost/test","test","test");
stmt = conn.createStatement();
rs = stmt.executeQuery("select USER_NAME,PASSWORD,PROVINCE,GENDER,HOBBIES from student");
while(rs.next()){
out.println(" <tr>");
out.println(" <td>" + repNull(rs.getString("USER_NAME")) + "</td>");
out.println(" <td>" + repNull(rs.getString("PASSWORD")) + "</td>");
out.println(" <td>" + repNull(rs.getString("PROVINCE")) + "</td>");
out.println(" <td>" + repNull(rs.getString("GENDER")) + "</td>");
out.println(" <td>" + repNull(rs.getString("HOBBIES")) + "</td>");
out.println(" </tr>");
}
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException("error when query students!",e);
} finally {
try{
rs.close();
stmt.close();
conn.close();
} catch (Exception e){
throw new RuntimeException("error when query students!",e);
}
}
out.println("</table>");
out.println("</body>");
out.println("</html>");
out.close();
}
public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
doGet(request,response);
}
private String repNull(String str){
return str == null || "".equals(str) ? " " : str;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -