check.jsp

这是一个很好的系统哦 希望大家支持

<%@page contentType = "text/html;charset=GB2312"
                import = "java.sql.*"
%>
<%
 String name = new String(request.getParameter("name").getBytes("ISO-8859-1"));
 String password = request.getParameter("password");
 int errortype=0;
 if(name.equals(""))
 {
  errortype=1;
  response.sendRedirect("enter.jsp?errortype="+errortype);
 } 
 else if(password.equals(""))
 {
  errortype=2;
  response.sendRedirect("enter.jsp?errortype="+errortype);
 }
 else
 {
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con = DriverManager.getConnection("jdbc:odbc:flower");
  Statement smt =  con.createStatement();
  String sql="select * from member where 姓名='"+name+"'";
  ResultSet rs = smt.executeQuery(sql);
  if(!rs.next())
  {
   errortype=3;
   response.sendRedirect("enter.jsp?errortype="+errortype);
  }
  else if(!rs.getString(2).equals(password))
  {
   errortype=4;
   response.sendRedirect("enter.jsp?errortype="+errortype);
  }
  else
  {
   session.putValue("name",rs.getString(1));
   response.sendRedirect("flower.jsp");
  }
  con.close();
 }
%>