数据库实现用户登录
首先创造用户登录所需要的表单,在登陆页面下执行,所选择的jsp文件为login.jsp代码如下:
<%@ 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="user?method=addUser">
<h3 style="text-align: center">登录</h3>
<div class="form-group">
<label for="exampleInputEmail1">用户名:</label><input type="text" name="username" class="form-control" id="exampleInputEmail1" />
</div>
<div class="form-group">
<label for="exampleInputPassword1">密码:</label><input type="password" name="password" class="form-control" id="exampleInputPassword1" />
</div>
<button type="submit" style="width: 100%" class="btn btn-info">提交</button>
</form>
</div>
</div>
</div>
</body>
</html>
所出现的表单截图如下:
登陆成功后可以进入个人主页home,jsp,在页面中显示出用户的信息,并且也可以在个人主页的页面实现添加或者删除的跳转
<title>欢迎来到个人中心</title>
<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>
这里可以实现跳转的操作
<%
if (session.getAttribute("username") == null) {
out.print("你尚未登录,3秒之后跳转登录页面");
response.setHeader("refresh", "3;url=login.jsp");
}else {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//建立数据库连接
String url = "jdbc:mysql://localhost:3306/book";//数据库连接地址
Connection connection = DriverManager.getConnection(url, "root", "root");
String sql = "select * from user ";
PreparedStatement ps = connection.prepareStatement(sql);
//String sql = "insert into user(username,password,gender) values (?,?,?)";
ResultSet rs = ps.executeQuery();
while (rs.next()) {
out.print("<tr>");
out.print("<td>"+rs.getInt("id")+"</td>"
+"<td>"+rs.getString("username")+"</td>"
+"<td>"+rs.getString("gender")+"</td>"
+ "<td>"+rs.getString("a