login_comform.jsp

来自「一个crm软件」· JSP 代码 · 共 45 行

JSP
45
字号
<%@ page contentType="text/html;charset=gb2312"%> 
<%@ page import="java.sql.*"%> 
<html> 
<body> 
<%
String username="";
String password="";
boolean checklogin=false;
String invisible="";
username=request.getParameter("username");
password=request.getParameter("password");


Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dengfen"; 
String user="sa"; 
String dbpassword="123"; 
Connection conn= DriverManager.getConnection(url,user,dbpassword);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
String sql="select * from ad where username='"+username+"'"; 
ResultSet rs=stmt.executeQuery(sql);
String password1="";
if(rs.next())
{
    password1=rs.getString(2);
}
if(password1.equals(password))
{checklogin=true;}
else
{checklogin=false;}
if(checklogin==true)
{  
	session.setAttribute("username",""+username);
   //session.setAttribute("invisible",""+invisible);
   response.sendRedirect("main.jsp");
}else{
   response.sendRedirect("login.jsp?success=0");
}

rs.close(); 
stmt.close();
conn.close();
%> 
</body> 
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?