目录
纯jsp实现数据库连接并且登录
代码段
login.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>登录页面</title></head><body><form action="dologin.jsp" method="post"><h3>登录界面</h3>账户:<input name="username" type="text"><br>密码:<input name="passward" type="password"><br><input type="submit" value="登录"></form></body></html>
数据库连接和处理阶段
dologin.jsp
数据库连接名:root 密码自己设置的
数据库名:root
表明:user
<%@page import="java.sql.DriverManager"%><%@page import="com.mysql.jdbc.Driver"%><%@page import="java.sql.Connection"%><%@page import="java.sql.*"%><%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body><%String name = request.getParameter("username");String pwd = request.getParameter("password");Class.forName("com.mysql.jdbc.Driver");Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/root", "root", "123456");PreparedStatement preparedStatement=connection.prepareStatement("select * from user where username=? and password=?");preparedStatement.setString(1,name);preparedStatement.setString(2,pwd);ResultSet resultSet=preparedStatement.executeQuery();if(resultSet.next()){response.sendRedirect("default.jsp");}else{response.sendRedirect("success.jsp");}connection.close();preparedStatement.close();%></body></html>
登录成功页面
success.jsp
<%@page import="java.sql.DriverManager"%><%@page import="com.mysql.jdbc.Driver"%><%@page import="java.sql.Connection"%><%@page import="java.sql.*"%><%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body>成功!!</body></html>
登录失败页面
default.jsp
<%@page import="java.sql.DriverManager"%><%@page import="com.mysql.jdbc.Driver"%><%@page import="java.sql.Connection"%><%@page import="java.sql.*"%><%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body>失败!!</body></html>