登陆验证代码[针对上篇文章]-CSDN博客

本文链接：https://blog.csdn.net/innolux_08/article/details/4492018

<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  <title>用户登录</title>
</head>
<body>
<%
   Connection conn=null;
                        Statement stmt=null;
                        ResultSet rs=null;
                        String s_UserName = request.getParameter("UserName");
   String s_UserPassword = request.getParameter("UserPassword");
   try
   {
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
                            }
                        catch(ClassNotFoundException ce){
                             out.println(ce.getMessage());
                            }
    try{
                  String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=innolux";
                  String user="innolux";
                  String password="innolux";
                  conn= DriverManager.getConnection(url,user,password);
                  stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
                  rs=stmt.executeQuery("select * from admininform where s_UserName='"+UserName+"'and s_UserPassword='"+UserPassword+"'");
       if (rs.next())
         {
            session.setAttribute("UserID",rs.getInt("UserID")+"");
     response.sendRedirect("user_info.jsp");
         }

    else
         {
              out.print("<SCRIPT language=JavaScript>alert('登陆出错！');javascript:history.go(-1);</SCRIPT>");
             out.println("<script language=/"javascript/">window.location='./admin/index.jsp';</script>");

}

catch(SQLException e)
     {
     System.out.println(e.getMessage());
     }
finally
     {
     stmt.close();
     conn.close();
     }
%>
</body>
</html>