项目框架
在controller包中的文件
package controller;
import model.User;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import service.UserService;
import service.UserServiceImpl;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
public class UserServlet extends HttpServlet {
private UserService userService = new UserServiceImpl();
public void init() throws ServletException {
ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
userService = context.getBean("userService", UserService.class);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String action = request.getParameter("action");
if ("add".equals(action)) {
addUser(request, response);
} else if ("delete".equals(action)) {
deleteUser(request, response);
} else if ("update".equals(action)) {
updateUser(request, response);
} else if ("query".equals(action)) {
doGet(request, response);
}
}
private void addUser(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String username = req.getParameter("username");
String password = req.getParameter("password");
try {
User user = new User();
user.setUsername(username);
user.setPassword(password);
userService.addUser(user);
resp.sendRedirect("user?action=query"); // 重定向到查询页面
} catch (Exception e) {
e.printStackTrace();
throw new ServletException(e);
}
}
private void deleteUser(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String idStr = request.getParameter("id");
int id = Integer.parseInt(idStr);
try {
userService.deleteUser(id);
response.sendRedirect("user?action=query");
} catch (SQLException e) {
e.printStackTrace();
throw new ServletException(e);
} catch (Exception e) {
throw new RuntimeException(e);
}
}
private void updateUser(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String idStr = req.getParameter("id");
int id = Integer.parseInt(idStr);
String username = req.getParameter("username");
String password = req.getParameter("password");
try {
User user = new User();
user.setId(id);
user.setUsername(username);
user.setPassword(password);
userService.updateUser(user);
resp.sendRedirect("user?action=query");
} catch (Exception e) {
e.printStackTrace();
throw new ServletException(e);
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {
List<User> users = userService.getAllUsers();
request.setAttribute("users", users);
request.getRequestDispatcher("/user.jsp").forward(request, response);
} catch (Exception e) {
e.printStackTrace();
throw new ServletException(e);
}
}
}
Dao接口
package dao;
import model.User;
import java.util.List;
public interface UserDao {
void addUser(User user) throws Exception;
void deleteUser(int id) throws Exception;
void updateUser(User user) throws Exception;
User getUserById(int id);
List<User> getAllUsers();
}
实现Dao的类
package dao;
import model.User;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import java.util.List;
public class UserDaoImpl implements UserDao {
private JdbcTemplate jdbcTemplate;
// 用于注入 JdbcTemplate 的 setter 方法
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
@Override
public void addUser(User user) {
String sql = "insert into user(username,password) values(?,?)";
jdbcTemplate.update(sql, user.getUsername(), user.getPassword());
}
// 这就是更新用户的方法,将其添加到该类中
@Override
public void updateUser(User user) {
String sql = "update user set username=?, password=? where id=?";
jdbcTemplate.update(sql, user.getUsername(), user.getPassword(), user.getId());
}
@Override
public void deleteUser(int id) throws Exception {
String sql = "delete from user where id=?";
jdbcTemplate.update(sql, id);
}
@Override
public User getUserById(int id) {
String sql = "select * from user where id =?";
List<User> users = jdbcTemplate.query(sql, new BeanPropertyRowMapper<User>(User.class), id);
if (users!= null &&!users.isEmpty()) {
return users.get(0);
}
return null;
}
@Override
public List<User> getAllUsers() {
String sql = "select * from user";
return jdbcTemplate.query(sql, new BeanPropertyRowMapper<User>(User.class));
}
}
model中的user类
package model;
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;
}
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;
}
}
service包中的接口
package service;
import model.User;
import java.util.List;
public interface UserService {
void addUser(User user) throws Exception;
void deleteUser(int id) throws Exception;
void updateUser(User user) throws Exception;
List<User> getAllUsers() throws Exception;
}
实现类
package service;
import model.User;
import dao.UserDao;
import java.util.List;
public class UserServiceImpl implements UserService {
private UserDao userDao;
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
@Override
public void addUser(User user) throws Exception {
userDao.addUser(user);
}
@Override
public void deleteUser(int id) throws Exception {
userDao.deleteUser(id);
}
@Override
public void updateUser(User user) throws Exception {
userDao.updateUser(user);
}
@Override
public List<User> getAllUsers() throws Exception {
return userDao.getAllUsers();
}
}
resource资源包中的applicationContext.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
<context:property-placeholder location="classpath:/db.properties"/>
<context:component-scan base-package="service" />
<!-- 配置数据源 -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${db.driver}" />
<property name="url" value="${db.url}" />
<property name="username" value="${db.username}" />
<property name="password" value="${db.password}" />
</bean>
<!-- 配置 JdbcTemplate -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 配置 UserDaoImpl,并注入 JdbcTemplate -->
<bean id="userDao" class="dao.UserDaoImpl">
<property name="jdbcTemplate" ref="jdbcTemplate" />
</bean>
<!-- 配置 UserServiceImpl,并注入 UserDao -->
<bean id="userService" class="service.UserServiceImpl">
<property name="userDao" ref="userDao"/>
</bean>
</beans>
properties
# db.properties
db.url=jdbc:mysql://localhost:3306/test
db.username=root
db.password=123456
db.driver=com.mysql.cj.jdbc.Driver
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>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>UserServlet</servlet-name>
<servlet-class>controller.UserServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>UserServlet</servlet-name>
<url-pattern>/user</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>user.jsp</welcome-file>
</welcome-file-list>
</web-app>
user.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.util.List" %>
<%@ page import="model.User" %>
<%@ page import="java.io.IOException" %>
<%@ page import="javax.servlet.jsp.JspWriter" %>
<%@ page import="javax.servlet.http.HttpServletRequest" %>
<html>
<head>
<title>用户管理</title>
</head>
<body>
<h1>用户管理</h1>
<!-- 添加用户表单 -->
<form action="user" method="post">
<input type="hidden" name="action" value="add">
用户名: <input type="text" name="username" required>
密码: <input type="password" name="password" required>
<input type="submit" value="添加用户">
</form>
<!-- 查询用户列表按钮 -->
<form action="user" method="post" style="display:inline;">
<input type="hidden" name="action" value="query">
<input type="submit" value="查询用户列表">
</form>
<h2>用户列表</h2>
<table border="1">
<tr>
<th>ID</th>
<th>用户名</th>
<th>密码</th>
<th>操作</th>
</tr>
<%
List<User> users = (List<User>) request.getAttribute("users");
if (users!= null &&!users.isEmpty()) {
for (User user : users) {
%>
<tr>
<td><%= user.getId() %></td>
<td><%= user.getUsername() %></td>
<td><%= user.getPassword() %></td>
<td>
<!-- 删除用户表单 -->
<form action="user" method="post" style="display:inline;">
<input type="hidden" name="action" value="delete">
<input type="hidden" name="id" value="<%= user.getId() %>">
<input type="submit" value="删除">
</form>
<!-- 更新用户表单 -->
<form action="user" method="post" style="display:inline;">
<input type="hidden" name="action" value="update">
<input type="hidden" name="id" value="<%= user.getId() %>">
用户名: <input type="text" name="username" value="<%= user.getUsername() %>" required>
密码: <input type="password" name="password" value="<%= user.getPassword() %>" required>
<input type="submit" value="更新">
</form>
</td>
</tr>
<%
}
} else {
out.println("<tr><td colspan='4'>用户列表为空</td></tr>");
}
%>
</table>
</body>
</html>
pom.xml
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>untitled2</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<name>Maven Web App</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
<spring.version>5.3.15</spring.version>
<servlet.version>4.0.1</servlet.version>
<jstl.version>1.2</jstl.version>
<mysql.connector.version>8.0.28</mysql.connector.version>
</properties>
<dependencies>
<!-- Spring Context -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.1.4.RELEASE</version>
</dependency>
<!-- Servlet API -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>${servlet.version}</version>
<scope>provided</scope>
</dependency>
<!-- 添加 spring-test 依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.1.4.RELEASE</version>
</dependency>
<!-- JSTL -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>${jstl.version}</version>
</dependency>
<!-- MySQL Connector -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.connector.version}</version>
</dependency>
<!-- Spring Web -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>5.3.15</version>
</dependency>
<!-- Spring Web MVC -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.3.15</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.30</version>
</dependency>
<!-- Logback Classic implementation -->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-classic</artifactId>
<version>1.2.3</version>
</dependency>
<!-- Spring AOP 依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>5.3.10</version>
</dependency>
<!-- AspectJ 依赖 -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.7</version>
</dependency>
<!-- 日志依赖,例如 SLF4J 和 Logback -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.30</version>
</dependency>
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-classic</artifactId>
<version>1.2.3</version>
</dependency>
<!-- JUnit for testing -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13.2</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>6.1.8</version>
</dependency>
<!-- Additional dependencies as needed -->
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-war-plugin</artifactId>
<version>3.3.1</version>
<configuration>
<failOnMissingWebXml>false</failOnMissingWebXml>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.1</version>
<configuration>
<source>${java.version}</source>
<target>${java.version}</target>
</configuration>
</plugin>
</plugins>
</build>
</project>