SpringMVC+Spring+Mybatis实现登录注册Demo

痛定思痛。 2022-09-04 03:46 179阅读 0赞

> 使用环境：MyEclipse/Eclipse + Tomcat + MySql。
> 
> 使用技术：SpringMVC + Spring + Mybatis。

# 实现效果 #

登录页面：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg5MzkwMg_size_16_color_FFFFFF_t_70]  
密码错误提示  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg5MzkwMg_size_16_color_FFFFFF_t_70 1]  
登录成功后  
![在这里插入图片描述][973843e4abc74e9b999311c3edbf0af3.png]  
注册  
![在这里插入图片描述][cabb8337bbc645a583c65c3ffee6f929.png]  
注册成功  
![在这里插入图片描述][bd53d8d0da1e46f3af892643e26c53d8.png]

# 目录结构 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg5MzkwMg_size_16_color_FFFFFF_t_70 2]

# 一、配置文件 #

### beans.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:tx="http://www.springframework.org/schema/tx" xmlns:jee="http://www.springframework.org/schema/jee" 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 http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
        
        
        <context:component-scan base-package="com.java.dao"></context:component-scan>  
        <context:component-scan base-package="com.java.service"></context:component-scan>  
        <context:component-scan base-package="com.java.serviceimpl"></context:component-scan>
        
      
        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
            <property name="driverClassName" value="${jdbc.driverClassName}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </bean>
        <context:property-placeholder location="classpath:/jdbc.properties"/>
        
       
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        	<property name="dataSource" ref="dataSource"></property>
        	
        	<property name="mapperLocations" value="classpath:com/java/mappers/*.xml"></property>
        	
        	<property name="configLocation" value="classpath:mybatis-config.xml "></property>
        </bean>
    	
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		<property name="basePackage" value="com.java.dao"></property>
    		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    	</bean>  
    	
    </beans>

### mybatis-config.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    		
    		<typeAliases>
    			<package name="com.java.entity"></package>
    		</typeAliases>
    </configuration>

### springmvc.xml ###

### jdbc.properties ###

jdbc.driverClassName=com.mysql.cj.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/db_student?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC
    jdbc.username=root
    jdbc.password=root

### web.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance http://www.springmodules.org/schema/cache/springmodules-cache.xsd http://www.springmodules.org/schema/cache/springmodules-ehcache.xsd" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
    		 
    	<display-name>mybatis06-spring-springmvc</display-name>
      <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
      </welcome-file-list>
    
    
      <context-param>
      	<param-name>contextConfigLocation</param-name>
      	<param-value>classpath:beans.xml</param-value>
      </context-param>
        	
      <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> 
           <init-param> 
               <param-name>forceEncoding</param-name> 
               <param-value>true</param-value> 
           </init-param> 
       </filter> 
       <filter-mapping> 
           <filter-name>characterEncodingFilter</filter-name> 
           <url-pattern>/*</url-pattern> 
       </filter-mapping> 
       
      	<listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    	</listener>
      
    
        <servlet>
      	<servlet-name >springmvc</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>
      	
      	<load-on-startup>1</load-on-startup>
      	<async-supported>true</async-supported>
      </servlet>
      <servlet-mapping>
      	<servlet-name>springmvc</servlet-name>
        <url-pattern>*.do</url-pattern>
      </servlet-mapping>
      
    
    </web-app>

# 二、Java代码 #

## 1、com.java.entity ##

### User.java ###

package com.java.entity;
    
    public class User { 
    
    	private Integer id;
    	private String userName;
    	private String passWord;
    	
    	// 无参构造
    	public User() { 
    		super();
    	}
    	
    	// 全参构造
    	public User(String userName, String passWord) { 
    		super();
    		this.userName = userName;
    		this.passWord = passWord;
    	}
    	
    	//get、set方法
    	public Integer getId() { 
    		return id;
    	}
    	public void setId(Integer 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;
    	}
    	
    	// toString方法
    	@Override
    	public String toString() { 
    		return "User [id=" + id + ", userName=" + userName + ", passWord=" + passWord + "]";
    	}
    	
    	
    }

## 2、com.java.dao ##

### UserDao.java ###

package com.java.dao;
    
    import com.java.entity.User;
    
    public interface UserDao { 
    
    	public User login(User user);
    	
    	public User add(User user);
    	
    }

## 3、com.java.mappers ##

### user.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
      
    <mapper namespace="com.java.dao.UserDao">
    	
     	<resultMap type="com.java.entity.User" id="UserResult">
     		<id property="id" column="id"></id>
     		<result property="userName" column="userName"></result>
     		<result property="passWord" column="passWord"></result>
     	</resultMap>
     	
     	<select id="login" parameterType="com.java.entity.User" resultMap="UserResult">
     		select * from user where userName=#{userName} and passWord=#{passWord}
     	</select>
     	
     	<select id="add" parameterType="com.java.entity.User" resultMap="UserResult">
     		insert into user (userName,passWord) values(#{userName},#{passWord})
     	</select>
    
    </mapper>

## 4、com.java.controller ##

### UserController.java ###

package com.java.controller;
    
    import javax.annotation.Resource;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    import javax.servlet.http.HttpSession;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import com.java.entity.User;
    import com.java.service.UserService;
    
    @Controller
    @RequestMapping("/user")
    public class UserController { 
    
    	@Resource
    	private UserService userService;
    	
    	@RequestMapping("/login")
    	public String login(User user,HttpServletRequest request) { 
    		User resultUser=userService.login(user);
    		System.out.println(resultUser);
    		if(resultUser==null) { 
    			request.setAttribute("user", user);
    			request.setAttribute("errorMsg", "用户名或密码错误！");
    			return "index";
    		}else { 
    			HttpSession session=request.getSession();
    			session.setAttribute("currentUser", resultUser);
    			return "welcome";
    		}
    	}
    	
    	@RequestMapping("/add")
    	public String add(HttpServletRequest request,HttpServletResponse response){ 
    		response.setContentType("text/html");
    		response.setCharacterEncoding("UTF-8");
    		String username=request.getParameter("userName");
    		String password=request.getParameter("passWord");
    		User users=new User(username, password);
    		userService.add(users);
    		return "reback";
    	}
    		
    }

## 5、com.java.service ##

### UserService.java ###

package com.java.service;
    
    import com.java.entity.User;
    
    public interface UserService { 
    
    	public User login(User user);
    	
    	public User add(User user);
    }

## 6、com.java.serviceimpl ##

### ServiceImpl.java ###

package com.java.serviceimpl;
    
    import javax.annotation.Resource;
    
    import org.springframework.stereotype.Service;
    
    import com.java.dao.UserDao;
    import com.java.entity.User;
    import com.java.service.UserService;
    
    @Service("userService")
    public class ServiceImpl implements UserService{ 
    
    	@Resource
    	private UserDao userDao;
    	
    	public User login(User user) { 
    		return userDao.login(user);
    	}
    
    	public User add(User user) { 
    		return userDao.add(user);
    	}
    
    }

# 三、Jsp页面代码 #

## index.jsp ##

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>用户登录页面</title>
    </head>
    <body>
    <a href="add.jsp">注册</a> <br/>
    <form action="${pageContext.request.contextPath}/user/login.do" method="post">
    	userName:<input type="text" name="userName" value="${userName}"/><br/>
    	passWord:<input type="password" name="passWord" value="${passWord}"/><br/>
    	<input type="submit" value="登录"/><br/>
    	<font color="red">${errorMsg}</font>
    </form>
    </body>
    </html>

## welcome.jsp ##

## reback.jsp ##

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>登录成功</title>
    <script> function fun(){ alert("确认返回登录页面"); /* location.href ="http://localhost:8080/mybatis06-spring-springmvc/index.jsp"; */ window.history.go(-2); } </script>
    </head>
    <body>
    <input type="button" value="注册成功，返回登录页面" onclick="fun()"/>
    
    </body>
    </html>

## add.jsp ##

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    <form action="${pageContext.request.contextPath}/user/add.do" method="post">
    	userName:<input type="text" name="userName"/>
    	passWord:<input type="password" name="passWord"><br/>
    	<input type="submit" value="注册" />
    </form>
    </body>
    </html>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg5MzkwMg_size_16_color_FFFFFF_t_70]: /images/20220829/a4456821d9964a2bbf9af11689921ae5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg5MzkwMg_size_16_color_FFFFFF_t_70 1]: /images/20220829/35b2361a9e7c4baba88235c47b22767e.png
[973843e4abc74e9b999311c3edbf0af3.png]: /images/20220829/8c4eebdd22aa496fa98cb492ffc0889f.png
[cabb8337bbc645a583c65c3ffee6f929.png]: /images/20220829/a7980ecf4d2646e084c81c6694e38ac7.png
[bd53d8d0da1e46f3af892643e26c53d8.png]: /images/20220829/0fe25bbdb6cc41d0b78cf22b0e7fe4f6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg5MzkwMg_size_16_color_FFFFFF_t_70 2]: /images/20220829/385c1378a53a4565bd512165b413a1fa.png