- index.jsp
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %><%--
Created by IntelliJ IDEA.
User: cc
Date: 2020/10/2
Time: 10:46
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
request.setCharacterEncoding("utf-8");
String username=request.getParameter("username");
String password=request.getParameter("password");
//加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//建立数据库连接
String url="jdbc:mysql://localhost:3306/book";
Connection connection = DriverManager.getConnection(url,"root","root");
//sql 模板
String sql="select * from user where username=? and password=?";
//使用PreparedStatement对象执行sql语句
PreparedStatement ps=connection.prepareStatement(sql);
ps.setString(1,username);
ps.setString(2,password);
ResultSet rs=ps.executeQuery();
if(rs.next()){
//表示登陆成功
out.print("登录成功");
//response.sendRedirect("home.jsp");
}else{
//表示登陆失败
out.print("登录失败");
//response.sendRedirect("login.jsp");
}
%>
- login.jsp.
<%--
Created by IntelliJ IDEA.
User: cc
Date: 2020/10/9
Time: 10:18
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>登陆页面</title>
<%--引入css文件和js文件--%>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js"></script>
<script src="js/bootstrap.bundle.js"></script>
<style>
.container{
width:20%;
height: 20%;
margin-top:10%;
}
</style>
</head>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<form role="form" method="post" action="index.jsp">
<h3 style="...">登录</h3>
<div class="form-group">
<label for="exampleInputEmail1">用户名:</label><input type="text" name="username" class="form-control" id="exampleInputEmail1" type="email" />
</div>
<div class="form-group">
<label for="exampleInputPassword1">密码:</label><input type="password" name="password" class="form-control" id="exampleInputPassword1" type="password" />
</div>
<button class="btn btn-default" type="submit">提交</button>
</form>
</div>
</div>
</div>
</body>
</html>
-
运行结果
-
提交结果
- 添加home.jsp
<%@ page import="java.sql.*" %><%--
Created by IntelliJ IDEA.
User: cc
Date: 2020/10/7
Time: 8:12
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>10.7</title>
</head>
<body>
<%
if (session.getAttribute("username")==null){
out.print("你尚未登陆成功,3秒后跳转至登陆页面");
response.setHeader("refersh","3;url=login.jsp");
}else {
out.print("欢迎来到个人主页!");
//加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//建立数据库连接
String url = "jdbc:mysql://localhost:3306/book";//数据库连接地址
Connection connection = DriverManager.getConnection(url, "root", "root");
//第一个root为数据库的用户名 第二个root为数据库的密码
String sql = "select*from user";
//在PreparedStatement 中使用问好代替实际参数
PreparedStatement ps = connection.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
out.print(rs.getString("username") + "-" + rs.getString(3) + "<br>");
}
}
/*
//使用Statement对象执行sql语句
Statement stmt=connection.createStatement();
//stmt.executeUpdate() 执行“增删改”操作的函数
String sql="select*from user";
ResultSet rs=stmt.executeQuery(sql);//执行“查询”操作的函数 返回结果集
while (rs.next()){
out.print(rs.getString("username")+"-"+rs.getString(3)+"<br>");
}
*/
%>
</body>
</html>
- 更改后index.jsp
(if内容)
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %><%--
Created by IntelliJ IDEA.
User: cc
Date: 2020/10/2
Time: 10:46
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
request.setCharacterEncoding("utf-8");
String username=request.getParameter("username");
String password=request.getParameter("password");
//加载数据库驱动
Class.forName("com.mysql.jdbc.Driver");
//建立数据库连接
String url="jdbc:mysql://localhost:3306/book";
Connection connection = DriverManager.getConnection(url,"root","root");
//sql 模板
String sql="select * from user where username=? and password=?";
//使用PreparedStatement对象执行sql语句
PreparedStatement ps=connection.prepareStatement(sql);
ps.setString(1,username);
ps.setString(2,password);
ResultSet rs=ps.executeQuery();
if(rs.next()){
//表示登陆成功
out.print("登录成功");
session.getAttribute("username",username);
response.sendRedirect("home.jsp");
}else{
//表示登陆失败
out.print("登录失败,3秒后自动跳转登录页面...");
response.setHeader("refresh","3;url=login.jsp");
}
%>