上一篇我们已经实现了页面注册,信息保存在数据库中,下面我们必须使用数据库里的用户和密码登录,否则不能登录。
本篇还补充了部分代码,详细如下:
步骤说明:
1、代码请参考—— 第十三篇JDBC操作数据库之注册功能。2、在第十三篇基础上继续实现功能——第十四篇JDBC操作数据库之登录功能。
一.loginUser.jsp
1.简单的登录界面
2.密码为了测试并没有显示为“*”
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8" %>
<%
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>用户登录</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="css/userStyle.css">
</head>
<body>
<div class="border">
<div class="head">登录用户</div>
<div class="div1">
<ul>
<li><a href="registerUser.jsp"> 用户注册 |</a></li>
<li><a href="loginUser.jsp"> 用户登录 |</a> </li>
<li><a href="message.jsp"> 当前用户 |</a></li>
<li><a href="ExitLogin"> 退出登录 |</a></li>
<li><a href="#"> 真的没了 |</a></li>
</ul>
</div>
<div class="div2">
<form action="<%=request.getContextPath()%>/LoginUser" method="post" οnsubmit="return login(this)">
<table align="center" width="300" border="0">
<tr>
<td align="right">用户名:</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td align="right">密码:</td>
<td><input type="text" name="password"></td>
</tr>
<tr>
<td colspan="2" align="center" height="50">
<input type="submit" value="登录">
</td>
</tr>
</table>
</form>
</div>
</body>
</html>
二.message.jsp
1.添加部分代码
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8" %>
<%@ page import="com.entity.User" %>
<%
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>提示信息</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="css/userStyle.css">
</head>
<body>
<div class="head">提示信息</div>
<div class="div1">
<ul>
<li><a href="registerUser.jsp"> 用户注册 |</a></li>
<li><a href="loginUser.jsp"> 用户登录 |</a></li>
<li><a href="message.jsp"> 当前用户 |</a></li>
<li><a href="ExitLogin"> 退出登录 |</a></li>
<li><a href="#"> 真的没了 |</a></li>
</ul>
</div>
<div class="out">
<%
//获取提示信息
String info = String.valueOf(request.getAttribute("info"));
//如果提示信息不为空,则输出提示信息
if (info != "null") {
out.print(info);
}
//获取登录的用户信息
User user = (User) session.getAttribute("user");
//判断用户是否登录
if (user != null) {
%>
<div class="divmsg">
<table align="center" width="350" border="1" height="200" bordercolor="#E8F4CC">
<tr>
<td align="center" colspan="2">
<span style="font-weight: bold;font-size: 18px;"><%=user.getUsername() %></span>登录成功!
</td>
</tr>
<tr>
<td align="right" width="30%">头像:</td>
<td><img src="<%=user.getPhoto() %>"></td>
</tr>
<tr>
<td align="right">性别:</td>
<td><%=user.getSex() %>
</td>
</tr>
<tr>
<td align="right">联系电话:</td>
<td><%=user.getTel()%>
</td>
</tr>
<tr>
<td align="right">电子邮箱:</td>
<td><%=user.getEmail()%>
</td>
</tr>
</table>
</div>
<%
} else {
out.print("<br>对不起,您还没有<a href='loginUser.jsp'>登录</a>!");
}
%>
</div>
</body>
</html>
三.LoginUser.java
1.调用模型---调用登录方法
package com.control;
import com.entity.User;
import com.model.UserDao;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
/**
* Created by Ray on 2018/3/14 0014.
**/
public class LoginUser extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//获取用户名和密码
String username = request.getParameter("username");
String password = request.getParameter("password");
//调用模型
UserDao userDao = new UserDao();
//调用登录方法
User user = userDao.login(username,password);
if(user != null){
request.getSession().setAttribute("user",user);
request.getRequestDispatcher("message.jsp").forward(request,response);
}else{
request.setAttribute("info","错误:用户名或密码有误!");
request.getRequestDispatcher("message.jsp").forward(request,response);
}
}
}
四.UserDao.java
1.添加用户登录方法
package com.model;
import com.dbutil.Dbconn;
import com.entity.User;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
* Created by Ray on 2018/3/14 0014.
**/
public class UserDao {
User user = null;
Dbconn dbconn = new Dbconn();
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
/**
* @Author: Ray
* @Date: 2018/3/14 0014
* @Description: 用户登录
* @Return: User对象
*/
public User login(String username,String password){
//数据库连接
connection = dbconn.getConnection();
//查询是否用户和密码
String sql = "select * from user where username = ? and password = ?";
try {
//获取PreparedStatement对象
preparedStatement = connection.prepareStatement(sql);
//对占位符进行动态赋值
preparedStatement.setString(1,username);
preparedStatement.setString(2,password);
//执行查询并获取结果集
resultSet = preparedStatement.executeQuery();
//判断结果集是否有效
if(resultSet.next()){
//实例化user对象
user = new User();
user.setId(resultSet.getInt("id"));
user.setUsername(resultSet.getString("username"));
user.setPassword(resultSet.getString("password"));
user.setSex(resultSet.getString("sex"));
user.setTel(resultSet.getString("tel"));
user.setPhoto(resultSet.getString("photo"));
user.setEmail(resultSet.getString("email"));
}
//释放资源
resultSet.close();
preparedStatement.close();
connection.close();
}catch (Exception e){
e.printStackTrace();
}
return user;
}
/**
* @Author: Ray
* @Date: 2018/3/14 0014
* @Description: 判断用户名在数据库中是否存在
* @Return: boolean
*/
public boolean userIsExist(String username){
//获取数据库连接
connection = dbconn.getConnection();
//根据用户名查询的sql语句
String sql = "select * from user where username = ?";
try{
//获取PreparedStatement对象
preparedStatement= connection.prepareStatement(sql);
//对占位符进行动态赋值
preparedStatement.setString(1,username);
//执行查询并获取结果集
resultSet = preparedStatement.executeQuery();
//判断结果集是否有效
if(!resultSet.next()){
//如果无效则证明此用户名可用
return true;
}
//释放资源
resultSet.close();
preparedStatement.close();
}catch (Exception e){
e.printStackTrace();
}
return false;
}
/**
* @Author: Ray
* @Date: 2018/3/14 0014
* @Description: 新增用户
* @Return:
*/
public void addUser(User user){
//获取数据库连接
connection = dbconn.getConnection();
//新增用户信息的sql语句
String sql = "insert into user(username,password,sex,tel,photo,email) values (?,?,?,?,?,?)";
try{
//获取PreparedStatement对象
preparedStatement = connection.prepareStatement(sql);
//对占位符进行动态赋值
preparedStatement.setString(1,user.getUsername());
preparedStatement.setString(2,user.getPassword());
preparedStatement.setString(3,user.getSex());
preparedStatement.setString(4,user.getTel());
preparedStatement.setString(5,user.getPhoto());
preparedStatement.setString(6,user.getEmail());
//执行新增操作
preparedStatement.executeUpdate();
//释放资源
preparedStatement.close();
connection.close();
}catch (Exception e){
e.printStackTrace();
}
}
}
五.ExitLogin.java
package com.control;
import com.entity.User;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
/**
* Created by Ray on 2018/3/14 0014.
**/
public class ExitLogin extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//获取session
HttpSession session = request.getSession();
//获取用户对象
User user = (User) session.getAttribute("user");
//判断用户是否有效
if(user != null){
//将用户对象逐出session
session.removeAttribute("user");
//设置提示信息
request.setAttribute("info",user.getUsername() + " 已成功退出!");
}
//转发到message.jsp页面
request.getRequestDispatcher("message.jsp").forward(request,response);
}
}
六.web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<servlet>
<servlet-name>BookList</servlet-name>
<servlet-class>com.control.BookList</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>BookList</servlet-name>
<url-pattern>/BookList</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>BookAdd</servlet-name>
<servlet-class>com.control.BookAdd</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>BookAdd</servlet-name>
<url-pattern>/BookAdd</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>BookUpdate</servlet-name>
<servlet-class>com.control.BookUpdate</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>BookUpdate</servlet-name>
<url-pattern>/BookUpdate</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>BookDoUpdate</servlet-name>
<servlet-class>com.control.BookDoUpdate</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>BookDoUpdate</servlet-name>
<url-pattern>/BookDoUpdate</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>BookDelete</servlet-name>
<servlet-class>com.control.BookDelete</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>BookDelete</servlet-name>
<url-pattern>/BookDelete</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>BookDoDelete</servlet-name>
<servlet-class>com.control.BookDoDelete</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>BookDoDelete</servlet-name>
<url-pattern>/BookDoDelete</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>BookBatchAdd</servlet-name>
<servlet-class>com.control.BookBatchAdd</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>BookBatchAdd</servlet-name>
<url-pattern>/BookBatchAdd</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>BookBatchDelete</servlet-name>
<servlet-class>com.control.BookBatchDelete</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>BookBatchDelete</servlet-name>
<url-pattern>/BookBatchDelete</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>BookFind</servlet-name>
<servlet-class>com.control.BookFind</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>BookFind</servlet-name>
<url-pattern>/BookFind</url-pattern>
</servlet-mapping>
<!--验证码功能-->
<servlet>
<servlet-name>Login</servlet-name>
<servlet-class>com.control.Login</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Login</servlet-name>
<url-pattern>/Login</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>DrawImage</servlet-name>
<servlet-class>com.control.DrawImage</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>DrawImage</servlet-name>
<url-pattern>/DrawImage</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>Register</servlet-name>
<servlet-class>com.control.Register</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Register</servlet-name>
<url-pattern>/Register</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>LoginUser</servlet-name>
<servlet-class>com.control.LoginUser</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>LoginUser</servlet-name>
<url-pattern>/LoginUser</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>ExitLogin</servlet-name>
<servlet-class>com.control.ExitLogin</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ExitLogin</servlet-name>
<url-pattern>/ExitLogin</url-pattern>
</servlet-mapping>
<!--登录拦截-->
<!--<filter>-->
<!--<filter-name>LoginFilter</filter-name>-->
<!--<filter-class>com.Filter.LoginFilter</filter-class>-->
<!--<init-param>-->
<!--<param-name>noLoginPaths</param-name>-->
<!--<param-value>registerUser.jsp;bookList.css;userStyle.css;loginSql.jsp;login.jsp;fail.jsp;Login;ErrorFilter;DrawImage</param-value>-->
<!--</init-param>-->
<!--</filter>-->
<!--<filter-mapping>-->
<!--<filter-name>LoginFilter</filter-name>-->
<!--<url-pattern>/*</url-pattern>-->
<!--</filter-mapping>-->
<!--配置过滤器-->
<filter>
<filter-name>CharSetFilter</filter-name>
<filter-class>com.Filter.CharSetFilter</filter-class>
<init-param>
<!--用来指定一个具体的字符集-->
<param-name>charset</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<!--映射过滤器-->
<filter-mapping>
<filter-name>CharSetFilter</filter-name>
<!--“/*”表示拦截所有的请求 -->
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--拦截404,500页面-->
<error-page>
<error-code>404</error-code>
<location>/error/error404.jsp</location>
</error-page>
<error-page>
<error-code>500</error-code>
<location>/error/error500.jsp</location>
</error-page>
<filter>
<filter-name>ErrorFilter</filter-name>
<filter-class>com.Filter.ErrorFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>ErrorFilter</filter-name>
<url-pattern>/error.jsp</url-pattern>
<dispatcher>ERROR</dispatcher>
</filter-mapping>
</web-app>
七.页面效果