📄 queryallstudent.java
字号:
package com.middle.graduate.servlet.manager.operation;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.middle.graduate.biz.dao.DBManagerDao;
import com.middle.graduate.biz.dao.impl.DBManagerImpl;
import com.middle.graduate.biz.entity.Student;
import com.middle.graduate.biz.exce.DataException;
public class QueryAllStudent extends HttpServlet {
private DBManagerDao dao = new DBManagerImpl();
private static final long serialVersionUID = -537032450843448307L;
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("gbk");
response.setContentType("text/html;charset=gb2312");
PrintWriter out = response.getWriter();
try {
List<Student> list = dao.queryAllStudent();
out.println("<html>");
out.println("<head><title>query all student</title></head>");
out.println("<body bgcolor = \"greeen\">");
out.println("<table align = \"center\" border = \"1\">");
out.println("<tr align = \"center\">");
out.println("<td>学号</td>");
out.println("<td>姓名</td>");
out.println("<td>班级</td>");
out.println("<td>院系</td>");
out.println("</tr>");
for(Student student:list) {
out.println("<tr align = \"center\">");
out.println("<td>"+ student.getStudentId() +"</td>");
out.println("<td>"+ student.getStudentName() +"</td>");
out.println("<td>"+ student.getClasses() +"</td>");
out.println("<td>"+ student.getDepartment() +"</td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</body>");
out.println("</html>");
out.close();
} catch (DataException e) {
e.printStackTrace();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -