check.jsp

JSP 办公系统 eclipse+MYSQL

<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" %>

<%
String username=request.getParameter("username");
String pass=request.getParameter("pass");



Connection con = null;
Statement sm = null;
ResultSet rs = null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
 String url = "jdbc:mysql://localhost/mydb";
  con = DriverManager.getConnection(url,"root","111");
  sm = con.createStatement();
  rs = sm.executeQuery("select * from userlogin where USER_ID='"+username+"'");
  
  if (rs.next()){
  if(rs.getString("PASSWORD").equals(pass)){
  response.sendRedirect("hello.jsp");
  session.setAttribute("user",username);
  }
  else
  {
  %>
  <script>
  alert("密码错误！");
  </script>
  <%
  response.sendRedirect("userlogin.jsp");
  }
  }
  else{
  
  %>
  <script>
  alert("用户不存在！");
  </script>
  <%
  response.sendRedirect("userlogin.jsp");
  ;

}
}
catch(Exception e)
{
e.printStackTrace();
}
finally 
{
if(rs!=null){try{rs.close();}catch(Exception e)
{
e.printStackTrace();
}}
}
if(sm!=null){try{sm.close();}catch(Exception e)
{
e.printStackTrace();
}}

if(con!=null){try{con.close();}catch(Exception e)
{
e.printStackTrace();
}}



%>