user_login_check.jsp

来自「jsp,javaScript实现注册页面功能」· JSP 代码 · 共 48 行

JSP
48
字号
<%@ 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>
		<%
			String strSql="";
			String database_username="root";
			String database_password="";
			String url="jdbc:mysql://localhost/ch3?useUnicode=true&characterEncoding=gb2312";
			try
			{     
				Class.forName("org.gjt.mm.mysql.Driver");
				Connection dbConn= DriverManager.getConnection(url,database_username,database_password);
				Statement stmt=dbConn.createStatement();
				ResultSet rs=null;			
				String s_UserName = request.getParameter("UserName");
				String s_UserPassword = request.getParameter("UserPassword");
				strSql = "select * from users where UserName like '"+s_UserName+"' and UserPassword like '"+s_UserPassword+"'";
				rs = stmt.executeQuery(strSql);
				if(rs.next())
				{
					session.setAttribute("UserID",rs.getInt("UserID")+"");
					response.sendRedirect("user_info.jsp");
				}
				else
				{
					out.println("<h1 align=center>您输入的用户名和密码有误!</h1>");
					out.println("<div align=center><input type=button name=btn value=返回 onClick='window.history.go(-1)'></div>");
				}
				rs.close();
				stmt.close();
				dbConn.close();
			}
			catch(Exception ex)
			{	 
				
				out.println("<h1 align=center>数据库连接错误</h1>");
				out.println("<div align=center><input type=button name=btn1 value=返回 onClick='window.history.go(-1)'></div>");
			} 
		%>
	</body>
</html>

⌨️ 快捷键说明

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