目录结构:
pom.xml:
<dependencies> <!-- mybatis框架--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.14</version> </dependency> <dependency> <groupId>com.mysql</groupId> <artifactId>mysql-connector-j</artifactId> <version>8.1.0</version> </dependency> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.12</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>3.8.1</version> <scope>test</scope> </dependency> <!-- spring框架--> <dependency> <groupId>commons-dbutils</groupId> <artifactId>commons-dbutils</artifactId> <version>1.4</version> </dependency> <dependency> <groupId>c3p0</groupId> <artifactId>c3p0</artifactId> <version>0.9.1.2</version> </dependency> <!-- standard.jar --> <dependency> <groupId>taglibs</groupId> <artifactId>standard</artifactId> <version>1.1.2</version> </dependency> <dependency> <groupId>jakarta.servlet.jsp</groupId> <artifactId>jakarta.servlet.jsp-api</artifactId> <version>2.3.6</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <dependency> <groupId>org.glassfish.web</groupId> <artifactId>jakarta.servlet.jsp.jstl</artifactId> <version>2.0.0</version> </dependency> <dependency> <groupId>org.apache.taglibs</groupId> <artifactId>taglibs-standard-spec</artifactId> <version>1.2.5</version> </dependency> <dependency> <groupId>org.apache.taglibs</groupId> <artifactId>taglibs-standard-impl</artifactId> <version>1.2.5</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>6.1.2</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aspects</artifactId> <version>6.0.12</version> </dependency> </dependencies>
Usercontroller.java
package com.itproj.controller; import com.itproj.domain.User; import com.itproj.service.IUserService; import jakarta.servlet.http.HttpServletRequest; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView; import javax.swing.*; import java.util.List; @Controller("userController") @RequestMapping("/user") public class UserController { @Autowired private IUserService userService; @RequestMapping("/findAll") public ModelAndView findAll(HttpServletRequest request){ String username = request.getParameter("username"); String password = request.getParameter("password"); System.out.println(username+password); ModelAndView mv=new ModelAndView(); List<User> userList=userService.findAll(); System.out.println(userList); boolean flag = true; for (User user : userList) { if (user.getUsername().equals(username) && user.getPassword().equals(password)) { flag = false; break; // Exit the loop once a match is found } } if (!flag) { System.out.println("登录成功!!!"); JOptionPane.showMessageDialog(null, "登录成功!", "登录", JOptionPane.WARNING_MESSAGE); mv.setViewName("success"); } else { System.out.println("登录失败!!!"); JOptionPane.showMessageDialog(null, "登录失败!", "登录", JOptionPane.WARNING_MESSAGE); mv.setViewName("error"); } return mv; } @RequestMapping("/save") public ModelAndView save(User user1, HttpServletRequest request){ String username = request.getParameter("username"); String password = request.getParameter("password"); System.out.println(username+password); ModelAndView mv=new ModelAndView(); List<User> userList=userService.findAll(); System.out.println(userList); boolean flag = true; for (User user : userList) { if (user.getUsername().equals(username)) { flag = false; break; } } User user = new User(username, password); if (flag) { userService.add(user); System.out.println("注册成功,请重新登录!!!"); JOptionPane.showMessageDialog(null, "注册成功!", "注册", JOptionPane.WARNING_MESSAGE); mv.setViewName("../index"); } else { System.out.println("注册失败!!!"); JOptionPane.showMessageDialog(null, "注册失败,用户已存在!", "注册", JOptionPane.WARNING_MESSAGE); mv.setViewName("register_error"); } return mv; } } IUerDao接口:
package com.itproj.dao; import com.itproj.domain.User; import java.util.List; public interface IUserDao { List<User> findAll(); void add(User user); User findByUsername(String username); }
UserDaoImpl.java
package com.itproj.dao.impl; import com.itproj.dao.IUserDao; import com.itproj.domain.User; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.BeanHandler; import org.apache.commons.dbutils.handlers.BeanListHandler; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import java.sql.SQLException; import java.util.List; @Repository("userDao") public class UserDaoImpl implements IUserDao { @Autowired private QueryRunner runner; @Override public List<User> findAll() { try { return runner.query("select * from user",new BeanListHandler<>(User.class)); } catch (SQLException e) { throw new RuntimeException(e); } } @Override public void add(User user) { try { runner.update("insert into user(username,password) values(?,?)",user.getUsername(),user.getPassword()); } catch (SQLException e) { throw new RuntimeException(e); } } @Override public User findByUsername(String username) { try { return runner.query("select * from user where username=?",new BeanHandler<>(User.class),username); } catch (SQLException e) { throw new RuntimeException(e); } } } 实体类User:
package com.itproj.domain; /** * ClassName:User * package:com.itproj.domain * Descripion: * * @Author 李先生 * @Create 2024/6/1119:14 * @Version 11.0 */ public class User { private int id; private String username; private String password; public User() { } public User(String username, String password) { 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; } @Override public String toString() { return "User{" + "id=" + id + ", username='" + username + '\'' + ", password='" + password + '\'' + '}'; } }
IUserService接口:
package com.itproj.service; import com.itproj.domain.User; import java.util.List; public interface IUserService { List<User> findAll(); void add(User user); }
UserServiceImpl.java
package com.itproj.service.impl; import com.itproj.dao.IUserDao; import com.itproj.domain.User; import com.itproj.service.IUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service("userService") public class UserServiceImpl implements IUserService { @Autowired private IUserDao userDao; @Override public List<User> findAll() { return userDao.findAll(); } @Override public void add(User user) { userDao.add(user); } }
bean.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: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/context https://www.springframework.org/schema/context/spring-context.xsd"> <!-- <bean id="accountService" class="com.itproj.service.impl.CompanyServiceImpl">--> <!-- <property name="accountDao" ref="accountDao"></property>--> <!-- </bean>--> <!-- <bean id="accountDao" class="com.itproj.dao.impl.CompanyDaoImpl">--> <!-- <property name="runner" ref="runner"></property>--> <!-- </bean>--> <!-- <context:component-scan base-package="com.itproj"></context:component-scan>--> <!-- 一,配置runner --> <bean id="runner" class="org.apache.commons.dbutils.QueryRunner"> <!-- 注入数据源 --> <constructor-arg name="ds" ref="datasource"></constructor-arg> </bean> <!-- 二,配置数据源--> <bean id="datasource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="com.mysql.cj.jdbc.Driver"></property> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/ssm?characterEncoding=utf-8"></property> <property name="user" value="root"></property> <property name="password" value=""></property> </bean> </beans>
springmvc.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:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd"> <context:component-scan base-package="com.itproj"></context:component-scan> <!-- 配置视图解析器--> <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="/pages/"></property> <property name="suffix" value=".jsp"></property> </bean> <mvc:annotation-driven></mvc:annotation-driven> </beans>
index.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>Title</title> <style> body, html { height: 100%; margin: 0; display: flex; align-items: center; justify-content: center; } .center-form { border: 1px solid #ccc; padding: 20px; width: 300px; text-align: center; } </style> </head> <body> <div class="center-form"> <form action="/user/findAll" method="get"> 请输入你的用户名:<br> <input type="text" name="username"><br> 请输入你的密码:<br> <input type="password" name="password"><br> <input type="submit" value="确定"> <input type="reset" value="取消"> </form> <a href="/pages/register.jsp">注册</a> </div> </body> </html>
web.xml
<?xml version="1.0" encoding="UTF-8" ?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" version="4.0"> <!-- 一,配置监听器--> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:bean.xml</param-value> </context-param> <!-- 二,配置中心处理器--> <servlet> <servlet-name>dispatcherServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:springmvc.xml</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>dispatcherServlet</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <!-- 三,配置过滤器--> <filter> <filter-name>characterEncodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>characterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- 样式--> <servlet-mapping> <servlet-name>default</servlet-name> <url-pattern>*.css</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>default</servlet-name> <url-pattern>*.js</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>default</servlet-name> <url-pattern>*.ico</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>default</servlet-name> <url-pattern>*.jpg</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>default</servlet-name> <url-pattern>*.png</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>default</servlet-name> <url-pattern>*.gif</url-pattern> </servlet-mapping> </web-app>