登录注册案例(Servlet+JSP+Maven)
2024-08-31 01:28:39
项目案例模板之登录注册的实现
案例演示
案例代码
设计表
pom.xml
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.0.5</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.junit.jupiter</groupId>
<artifactId>junit-jupiter-api</artifactId>
<version>RELEASE</version>
<scope>compile</scope>
</dependency>
</dependencies>
jdbc
JDBCUtils.java
package jdbc;
import org.junit.jupiter.api.Test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JDBCUtils {
public static Connection connection;
private static String url="jdbc:mysql://localhost:3306/aaa?useUnicode=true&characterEncoding=utf-8";
private static String username="root";
private static String password="root";
static{
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(url,username,password);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
return connection;
}
@Test
public void test(){
Connection connection = JDBCUtils.getConnection();
System.out.println(connection);
}
}
entity
User.java
package entity;
public class User {
private int id;
private String username;
private String password;
public User() {
}
public User(int id, String username, String password) {
this.id = id;
this.username = username;
this.password = password;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
'}';
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
dao
UserDao.java
package dao;
import entity.User;
import jdbc.JDBCUtils;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class UserDao {
private Connection connection = JDBCUtils.getConnection();
private PreparedStatement ps;
/*
*添加用户
* */
public int add(User user) throws Exception{
String sql = "insert into user(username,password) values(?,?)";
ps=connection.prepareStatement(sql);
ps.setObject(1,user.getUsername());
ps.setObject(2,user.getPassword());
int exe = ps.executeUpdate();
return exe;
}
public int delete(int id) throws SQLException {
String sql = "delete from user where id=?";
ps = connection.prepareStatement(sql);
/*
* 删除用户
* */
ps.setObject(1,id);
int exe = ps.executeUpdate();
return exe;
}
/*
* 修改用户
* */
public int update(User user) throws SQLException {
String sql = "update user set username=? , password=? where id=?";
ps = connection.prepareStatement(sql);
ps.setObject(1,user.getUsername());
ps.setObject(2,user.getPassword());
ps.setObject(3,user.getId());
return ps.executeUpdate();
}
/*
* 查询所有用户
* */
public List<User> findAll() throws SQLException {
String sql = "select * from user";
ps=connection.prepareStatement(sql);
ResultSet rs =ps.executeQuery();
List<User> list = new ArrayList<User>();
while(rs.next()){
//以 Java 编程语言中 int 的形式获取此 ResultSet 对象的当前行中指定列的值。
int id = rs.getInt("id");
String username = rs.getString("username");
String password = rs.getString("password");
User u = new User(id,username,password);
list.add(u);
}
return list;
}
/*
* 通过id查询用户
* */
public User findById(int id) throws SQLException {
String sql = "select * from user where id=?";
ps=connection.prepareStatement(sql);
ps.setInt(1,id);
ResultSet rs = ps.executeQuery();
User u = null;
while (rs.next()){
int uid = rs.getInt("id");
String username = rs.getString("username");
String password = rs.getString("password");
u = new User(uid,username,password);
}
return u;
}
/*
* 用户登录
* */
public User login(User user) throws SQLException {
String sql = "select * from user where username=? and password=?";
ps = connection.prepareStatement(sql);
ps.setObject(1,user.getUsername());
ps.setObject(2,user.getPassword());
ResultSet rs = ps.executeQuery();
User u = null;
while (rs.next()){
int uid = rs.getInt("id");
String username = rs.getString("username");
String password = rs.getString("password");
u = new User(uid,username,password);
}
return u;
}
}
service
UserService.java
package service;
import dao.UserDao;
import entity.User;
import java.sql.SQLException;
import java.util.List;
public class UserService {
private UserDao userDao = new UserDao();
public int add(User user) throws Exception {
return userDao.add(user);
}
public int delete(int id) throws SQLException {
return userDao.delete(id);
}
public int update(User user) throws SQLException {
return userDao.update(user);
}
public List<User> findAll() throws SQLException {
return userDao.findAll();
}
public User findByID(int id) throws SQLException {
return userDao.findById(id);
}
public User login(User user) throws SQLException {
return userDao.login(user);
}
}
servlet
LoginServlet.java
package servlet;
import entity.User;
import service.UserService;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
@WebServlet("/login")
public class LoginServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setCharacterEncoding("utf-8");
//接受请求参数
String username = req.getParameter("username");
String password = req.getParameter("password");
User user = new User();
user.setUsername(username);
user.setPassword(password);
//查询数据
UserService us = new UserService();
User u = null;
try {
u=us.login(user);
//跳转
if (u==null){
req.setAttribute("mess","账号或密码错误");
req.getRequestDispatcher("login.jsp").forward(req,resp);
}else {
req.getSession().setAttribute("user",u);
resp.sendRedirect("main.jsp");
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
RegServlet.java
package servlet;
import dao.UserDao;
import entity.User;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/reg")
public class RegServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setCharacterEncoding("utf-8");
//接受请求参数
String username = req.getParameter("username");
String password = req.getParameter("password");
User u = new User();
u.setUsername(username);
u.setPassword(password);
UserDao dao = new UserDao();
int i = 0;
try {
i=dao.add(u);
} catch (Exception e) {
e.printStackTrace();
}
//跳转
if(i>0){
req.setAttribute("mess","注册成功");
resp.sendRedirect("login.jsp");
}else{
req.setAttribute("mess","注册失败");
req.getRequestDispatcher("regist.jsp").forward(req,resp);
}
}
}
jsp
web.xml
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<display-name>Archetype Created Web Application</display-name>
<welcome-file-list>
<welcome-file>regist.jsp</welcome-file>
</welcome-file-list>
</web-app>
regist.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<html>
<head>
<title>注册</title>
</head>
<body>
<h1>用户注册</h1>
<hr>
<form action="reg" method="post">
<p>
用户名:<input type="text" name="username">
</p>
<p>
密码:<input type="text" name="password">
</p>
<p>
<input type="submit" value="注册">
</p>
</form>
${mess}
</body>
</html>
login.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<html>
<head>
<title>登录</title>
</head>
<body>
<h1>用户登录</h1>
<hr>
<form action="login" method="post">
<p>
用户名:<input type="text" name="username">
</p>
<p>
密码:<input type="text" name="password">
</p>
<p>
<input type="submit" value="登录">
</p>
</form>
${mess}
</body>
</html>
main.jsp
<%--
Created by IntelliJ IDEA.
User: Lenovo
Date: 2019/4/25
Time: 9:11
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<html>
<head>
<title>主页</title>
</head>
<body>
<h1>欢迎使用本系统</h1>
当前用户:${sessionScope.user.username}
</body>
</html>
*****************************************************************************************************
我的博客园地址:https://www.cnblogs.com/zyx110/
最新文章
- 定制sqlmap tamper脚本
- Sina 新浪Ip归属地Api 很好用的,使用get请求
- salesforce 零基础学习(二十三)数据记录导出至excel(自定义报表导出)
- HTML(六)——表单验证、正则表达式、事件
- php常用函数(不定时更新)
- git的牛逼
- Out of Hay
- hadoop搭建开发环境及编写Hello World
- FFT算法的完整DSP实现(转)
- 利用GPGPU计算大规模群落仿真行为
- [LeetCode] Cut Off Trees for Golf Event 为高尔夫赛事砍树
- H5学习之旅-H5的格式化(4)
- 【转】javascript笔记之apply、call、bind用法
- Servlet(九):web.xml文件和server.xml文件
- CI/CD
- oracle 查询clob 列时 很慢 , 未解决
- 【Teradata】数值类型
- 一目了然了解JAVA集合体系
- Tomcat 下配置一个ip绑定多个域名
- python 数据类型 之 利用 dict 模仿 switch语句功能
热门文章
- Django回顾--配置文件
- 用 Python 图像识别打造一个小狗分类器
- IT兄弟连 HTML5教程 HTML5表单 H5表单提交综合实例
- 【ST开发板评测】Nucleo-F411RE开箱报告
- java获取当前年份、月份和日期字符串等
- Elasticsearch 6.x版本全文检索学习之聚合分析入门
- (三十八)c#Winform自定义控件-圆形进度条-HZHControls
- Implement Custom Business Classes and Reference Properties实现自定义业务类和引用属性(EF)
- Vue结合后台导入导出Excel问题详解
- Android Studio如何配置CURL指令一键打包apk上传至蒲公英