📄 login.jsp

📁 一个自己完成的网上书店
💻 JSP
字号:
<%@page language="java" contentType="text/html;charset=gb2312"
	import="java.sql.*" pageEncoding="gb2312"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>
		<base href="<%=basePath%>">

		<title>My JSP 'login.jsp' starting page</title>

		<meta http-equiv="pragma" content="no-cache">
		<meta http-equiv="cache-control" content="no-cache">
		<meta http-equiv="expires" content="0">
		<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
		<meta http-equiv="description" content="This is my page">
		<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

	</head>

	<body>
		<%!String logname, logpass;

	boolean logattempt = false;

	boolean logsuccess = false;%>
		<%
			Class.forName("com.mysql.jdbc.Driver");
			DriverManager.registerDriver(new com.mysql.jdbc.Driver());
			String dburl = "jdbc:mysql://localhost:3306/bookstore?useUnicode=true&characterEncoding=GB2312";
			String user = "root";
			String pass = "ptnest";
			Connection con;
			con = java.sql.DriverManager.getConnection(dburl, user, pass);
			Statement stmt = con.createStatement();
		%>
		<%
			if (request.getParameterValues("logname") != null&& request.getParameterValues("logpass") != null) {
				logattempt = true;
			}
			out.println("尝试登陆......");
			if (logattempt) {

				logname = request.getParameter("logname");
				logpass = request.getParameter("logpass");
				String sql = "select *from user where name='" + logname
				+ "'and pass='" + logpass + "'";
				ResultSet rs = stmt.executeQuery(sql);
				int number = 0;
				try {
					while (rs.next()) {
				number++;
					}

				} catch (Exception e) {
					e.printStackTrace();
				}
				out.println(number);
				if (number != 0) {
					session.setAttribute("username", logname);
					logsuccess = true;
					if (logsuccess) {
				out.println("登陆成功");
				response.sendRedirect("../index.htm");
					} else {
				out.println("您注册过了么？");
					}
				}
				else
				{
					out.println("请您重新输入！");
					response.sendRedirect("relogin.html");
				}
			}
		%>

	</body>
</html>
⌨️ 快捷键说明

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