package Part1;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class FindInfroServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
//验证用户是否已经登录
//已登录的标志:session这个会话对象保存了User
HttpSession session = request.getSession(false);
if(session!= null&&session.getAttribute("user")!=null) {
//表示已经登录
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.print("<html>");
out.print("<head>");
out.print("<title>员工信息</title>");
out.print("</head>");
out.print("<body>");
out.print("<h2 align='center'>员工列表</h2>");
out.print("<hr width='60%'>");
out.print("<table border='1' align='center' width='50%'>");
out.print("<tr align='center'>");
out.print("<th>编号</th>");
out.print("<th>姓名</th>");
out.print("<th>岗位</th>");
out.print("<th>月薪</th>");
out.print("<th>入职时间</th>");
out.print("</tr>");
//连接数据库验证用户名和密码
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/xingkong","root","0910");
String sql ="select empno,ename,job,sal,hiredate from emp order by sal asc";
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()) {
String empno = rs.getString("empno");
String ename= rs.getString("ename");
String job = rs.getString("job");
String sal = rs.getString("sal");
String hiredate =rs.getString("hiredate");
out.print("<tr align='center'>");
out.print("<th>"+empno+"</th>");
out.print("<th>"+ename+"</th>");
out.print("<th>"+job+"</th>");
out.print("<th>"+sal+"</th>");
out.print("<th>"+hiredate+"</th>");
out.print("</tr>");
}
}catch(Exception e) {
e.printStackTrace();
}finally {
if(rs!=null)
try {
rs.close();
}catch(Exception e) {
e.printStackTrace();
}
if(ps!=null) {
try {
ps.close();
}catch(Exception e) {
e.printStackTrace();
}
}
if(conn!=null) {
try {
conn.close();
}catch(Exception e) {
e.printStackTrace();
}
}
}
out.print("</table>");
out.print("</body>");
out.print("</html>");
//销毁session
session.invalidate();
}
else {
response.sendRedirect(request.getContextPath()+"/index.html");
}
}
}