myeclipse+js+SQL server数据库实现学生信息管理

package it.student.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.*; import java.sql.*; import it.student.bean.*; public class LoginServlet extends HttpServlet { @Override protected void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { String username=req.getParameter("username"); String password=req.getParameter("password"); String person=req.getParameter("person"); try{ String dataname="StudentData"; String usernamedb="he"; String passworddb="12345678"; ReportBean db=new ReportBean(); Connection con=db.getConnection(dataname,usernamedb,passworddb); String sql="select * from loginer where username=? and password=? and style=? "; PreparedStatement pstmt=con.prepareStatement(sql); pstmt.setString(1, username); pstmt.setString(2, password); pstmt.setString(3, person); ResultSet rs=pstmt.executeQuery(); if(rs.next()){ req.getSession().setAttribute("login", username); res.sendRedirect("loginresult.jsp?login=1"); }else{ res.sendRedirect("loginresult.jsp?login=0"); } rs.close(); pstmt.close(); con.close(); }catch(Exception ex){ ex.printStackTrace(); } } }