SSM框架详细整合教程（Spring+SpringMVC+MyBatis）

左手的ㄟ右手 2022-05-04 14:56 200阅读 0赞

**动机**

使用maven已经有一段时间了，但项目是别人搭建好的，因此一直想着自己要学习搭建一下。网上找了些资料后，结合自己实验，花了点时间就搞好，老样子，写在博客上，免得日后忘记。

**本文链接：[http://blog.csdn.net/v123411739/article/details/50742885][http_blog.csdn.net_v123411739_article_details_50742885]**

**博文中的MyEclipse链接：https://pan.baidu.com/s/1pMhiygz 密码：mqmc**

**博文中的完整项目代码：关注微信公众号发送“SSM”即可获得。**

**注：文末有直接导入项目的方法。**

# 1.安装maven和配置（此步骤并非必须，可以根据情况选择） #

1.  进入官网下载中心[http://maven.apache.org/download.cgi][http_maven.apache.org_download.cgi]，下载[apache-maven-3.5.2-bin.zip][]，\*\*-src.zip为Maven的源码
2.  配置环境变量，打开系统环境变量新建一个M2\_HOME将解压后的Maven存放路径放在此，然后在path路径加入%M2\_HOME%\\bin路径
3.  检测是否配置成功，打开命令行输入echo %M2\_HOME%查看M2\_HOME指向的Maven存放安装目录是否正确，输入mvn -v查看是否能找到正确的mvn执行脚本
4.  以后升级的话将M2\_HOME的路径换为最新的安装目录就行
5.  Maven实践：初次安装完后输入mvn help:system的命令，此时会打印出所有的Java系统属性和环境变量，然后Maven会执行一个真正的任务将相应的所需的构件下载到本地仓库中包括pom和jar文件，然后用户在C:\\Users\\Administrator\\.m2下就能看到本地仓库了
6.  用户需要复制M2\_HOME/conf/setting.xml文件到C:/Users/Administrator/.m2/setting.xml，这样用户每次升级后就不要在次修改setting.xml文件了

# 2.MyEclipse配置Maven #

1.  在本地创建一个文件夹MavenRepository，并在MavenRepository文件夹下创建文件夹repository。
2.  进入Maven解压后的文件夹，进入conf文件夹，将settings.xml文件复制到上一步创建的MavenRepository文件夹下
3.  打开MavenRepository文件夹下的settings.xml文件，找到localRepository标签，此时是被注释掉的，我们解除注释，然后配置步骤1中的repository路径，如<localRepository>F:\\m2\\repository</localRepository>![SouthEast][]
4.  在MyEclipse中的Perferences进行如下配置，添加自己的Maven![Center][]
5.  User Settings设置为之前修改过的setting.xml![Center 1][]
6.  File->New->others，搜索maven，如果看到有Maven Project则代表配置成功。

![Center 2][]

# 3.MyEclipse使用maven创建web项目 #

**1、创建一个maven项目**

![Center 3][]

![Center 3][]![Center 4][]![Center 5][]

![Center 6][]

**2、按照上面教程，即可创建出一个Maven项目，项目结构如下图**![Center 7][]

**3、将JRE版本设置为1.7，可使用默认的或者自己导入**

![Center 8][]

**4、此时index.jsp会报以下错误**

![Center 9][]

**在pom.xml文件的dependencies节点下添加如下代码即可，添加完后，会下载对应的jar包**

![Center 10][]

**5、右键项目，选择Properties，进行如下配置**

![Center 11][]

# 4.搭建Spring+SpringMVC+Mybatis框架 #

## 1、Maven引入项目用到的jar包，修改pom.xml后保存会自动下载，存放在之前配置的本地仓库中，即：F:\\m2\\repository文件夹 ##

**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/maven-v4_0_0.xsd"> 
       <modelVersion>4.0.0 </modelVersion> 
       <groupId>com.chillax </groupId> 
       <artifactId>Maven_Project </artifactId> 
       <packaging>war </packaging> 
       <version>0.0.1-SNAPSHOT </version> 
       <name>Maven_Project Maven Webapp </name> 
       <url>http://maven.apache.org </url> 
       
        
       <properties> 
       <spring.version>4.0.2.RELEASE </spring.version> 
       <mybatis.version>3.2.8 </mybatis.version> 
       <slf4j.version>1.7.12 </slf4j.version> 
       <log4j.version>1.2.17 </log4j.version> 
       </properties> 
        
       <dependencies> 
        
       <dependency> 
       <groupId>junit </groupId> 
       <artifactId>junit </artifactId> 
       <version>4.11 </version> 
        
       <scope>test </scope> 
       </dependency> 
        
       <dependency> 
       <groupId>javax </groupId> 
       <artifactId>javaee-api </artifactId> 
       <version>7.0 </version> 
       </dependency> 
        
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-test </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-core </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-oxm </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-tx </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-jdbc </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-aop </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-context </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-context-support </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-expression </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-orm </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-web </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-webmvc </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.springframework </groupId> 
       <artifactId>spring-aspects </artifactId> 
       <version>${spring.version} </version> 
       </dependency> 
        
        
       <dependency> 
       <groupId>org.mybatis </groupId> 
       <artifactId>mybatis </artifactId> 
       <version>${mybatis.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.mybatis </groupId> 
       <artifactId>mybatis-spring </artifactId> 
       <version>1.2.2 </version> 
       </dependency> 
        
        
       <dependency> 
       <groupId>mysql </groupId> 
       <artifactId>mysql-connector-java </artifactId> 
       <version>5.1.35 </version> 
       </dependency> 
        
       <dependency> 
       <groupId>commons-dbcp </groupId> 
       <artifactId>commons-dbcp </artifactId> 
       <version>1.4 </version> 
       </dependency> 
        
       <dependency> 
       <groupId>jstl </groupId> 
       <artifactId>jstl </artifactId> 
       <version>1.2 </version> 
       </dependency> 
       <dependency> 
       <groupId>taglibs </groupId> 
       <artifactId>standard </artifactId> 
       <version>1.1.2 </version> 
       </dependency> 
        
       <dependency> 
       <groupId>log4j </groupId> 
       <artifactId>log4j </artifactId> 
       <version>${log4j.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.slf4j </groupId> 
       <artifactId>slf4j-api </artifactId> 
       <version>${slf4j.version} </version> 
       </dependency> 
       <dependency> 
       <groupId>org.slf4j </groupId> 
       <artifactId>slf4j-log4j12 </artifactId> 
       <version>${slf4j.version} </version> 
       </dependency> 
        
        
        
       <dependency> 
       <groupId>com.alibaba </groupId> 
       <artifactId>fastjson </artifactId> 
       <version>1.2.6 </version> 
       </dependency> 
       <dependency> 
       <groupId>org.codehaus.jackson </groupId> 
       <artifactId>jackson-mapper-asl </artifactId> 
       <version>1.9.13 </version> 
       </dependency> 
        
       <dependency> 
       <groupId>commons-fileupload </groupId> 
       <artifactId>commons-fileupload </artifactId> 
       <version>1.3.1 </version> 
       </dependency> 
       <dependency> 
       <groupId>commons-io </groupId> 
       <artifactId>commons-io </artifactId> 
       <version>2.4 </version> 
       </dependency> 
       <dependency> 
       <groupId>commons-codec </groupId> 
       <artifactId>commons-codec </artifactId> 
       <version>1.10 </version> 
       </dependency> 
        
       
        
       <dependency> 
       <groupId>net.sourceforge.jexcelapi </groupId> 
       <artifactId>jxl </artifactId> 
       <version>2.6 </version> 
       </dependency> 
       <dependency> 
       <groupId>org.apache.poi </groupId> 
       <artifactId>poi </artifactId> 
       <version>3.8 </version> 
       </dependency> 
       <dependency> 
       <groupId>org.apache.poi </groupId> 
       <artifactId>poi-ooxml </artifactId> 
       <version>3.9 </version> 
       </dependency> 
        
       </dependencies> 
       
       <build> 
       <finalName>Maven_Project </finalName> 
       <plugins> 
       <plugin> 
       <groupId>org.apache.maven.plugins </groupId> 
       <artifactId>maven-compiler-plugin </artifactId> 
       <version>2.3.2 </version> 
       <configuration> 
       <source>1.7 </source> 
       <target>1.7 </target> 
       </configuration> 
       </plugin> 
       </plugins> 
       </build> 
       </project>

## 2、在src/main/resources下添加如下配置文件 ##

**applicationContext.xml**

**jdbc.properties，**有多人反映直接复制时，第一行的driver最后面多了个空格，请注意

driver=com.mysql.jdbc.Driver 
       url=jdbc:mysql://127.0.0.1:3306/maventest 
       username=root 
       password=root 
       #定义初始连接数 
       initialSize=0 
       #定义最大连接数 
       maxActive=20 
       #定义最大空闲 
       maxIdle=20 
       #定义最小空闲 
       minIdle=1 
       #定义最长等待时间 
       maxWait=60000

**log4j.properties**

#定义LOG输出级别 
       log4j.rootLogger=INFO,Console,File 
       #定义日志输出目的地为控制台 
       log4j.appender.Console=org.apache.log4j.ConsoleAppender 
       log4j.appender.Console.Target=System.out 
       #可以灵活地指定日志输出格式，下面一行是指定具体的格式 
       log4j.appender.Console.layout = org.apache.log4j.PatternLayout 
       log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n 
       
       #文件大小到达指定尺寸的时候产生一个新的文件 
       log4j.appender.File = org.apache.log4j.RollingFileAppender 
       #指定输出目录 
       log4j.appender.File.File = logs/ssm.log 
       #定义文件最大大小 
       log4j.appender.File.MaxFileSize = 10MB 
       # 输出所以日志，如果换成DEBUG表示输出DEBUG以上级别日志 
       log4j.appender.File.Threshold = ALL 
       log4j.appender.File.layout = org.apache.log4j.PatternLayout 
       log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n

**spring-dao.xml**

**spring-db.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:p= "http://www.springframework.org/schema/p" 
       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-3.1.xsd 
       http://www.springframework.org/schema/context 
       http://www.springframework.org/schema/context/spring-context-3.1.xsd 
       http://www.springframework.org/schema/mvc 
       http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd"> 
       
        
       <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> 
       <property name="location" value="classpath:jdbc.properties" /> 
       </bean> 
       
       <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> 
       <property name="driverClassName" value="${driver}" /> 
       <property name="url" value="${url}" /> 
       <property name="username" value="${username}" /> 
       <property name="password" value="${password}" /> 
        
       <property name="initialSize" value="${initialSize}"> </property> 
        
       <property name="maxActive" value="${maxActive}"> </property> 
        
       <property name="maxIdle" value="${maxIdle}"> </property> 
        
       <property name="minIdle" value="${minIdle}"> </property> 
        
       <property name="maxWait" value="${maxWait}"> </property> 
       </bean> 
       
        
       <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 
       <property name="dataSource" ref="dataSource" /> 
        
       <property name="mapperLocations" value="classpath:com/chillax/mapper/*.xml"> </property> 
       </bean> 
       
       </beans>

**spring-tx.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:p= "http://www.springframework.org/schema/p" 
       xmlns:context= "http://www.springframework.org/schema/context" 
       xmlns:aop= "http://www.springframework.org/schema/aop" 
       xmlns:tx= "http://www.springframework.org/schema/tx" 
       xmlns:mvc= "http://www.springframework.org/schema/mvc" 
       xsi:schemaLocation= "http://www.springframework.org/schema/beans 
       http://www.springframework.org/schema/beans/spring-beans-3.1.xsd 
       http://www.springframework.org/schema/context 
       http://www.springframework.org/schema/context/spring-context-3.1.xsd 
       http://www.springframework.org/schema/aop 
       http://www.springframework.org/schema/aop/spring-aop-3.1.xsd 
       http://www.springframework.org/schema/tx 
       http://www.springframework.org/schema/tx/spring-tx-3.1.xsd"> 
       
        
       <bean id="transactionManager" 
       class= "org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
       <property name="dataSource" ref="dataSource" /> 
       </bean> 
       
        
       <aop:config> 
       <aop:pointcut id="allServiceMethod" expression="execution(* com.chillax.service.*.*(..))"/> 
       <aop:advisor pointcut-ref="allServiceMethod" advice-ref="TxAdvice" /> 
       </aop:config> 
       
        
       <tx:advice id="TxAdvice" transaction-manager="transactionManager"> 
       <tx:attributes> 
       <tx:method name="*" propagation="REQUIRED" rollback-for="java.lang.Exception"/> 
       </tx:attributes> 
       </tx:advice> 
       
       </beans>

## 3、在WEB-INF文件夹下添加/修改以下配置文件 ##

**spring-mvc.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:p= "http://www.springframework.org/schema/p" 
       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-3.1.xsd 
       http://www.springframework.org/schema/context 
       http://www.springframework.org/schema/context/spring-context-3.1.xsd 
       http://www.springframework.org/schema/mvc 
       http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd"> 
       
        
       <mvc:annotation-driven /> 
       <mvc:default-servlet-handler/> 
       
        
       <context:component-scan base-package="com.chillax.controller" /> 
       
        
       <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> 
        
       <property name="prefix" value="/WEB-INF/jsp/" /> 
       <property name="suffix" value=".jsp" /> 
       </bean> 
       
        
       <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"> 
        
       <property name="defaultEncoding" value="utf-8" /> 
        
       <property name="maxUploadSize" value="10485760000" /> 
        
       <property name="maxInMemorySize" value="40960" /> 
       </bean> 
       
       </beans>

**web.xml**

<?xml version="1.0" encoding="UTF-8"?> 
       <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
       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_3_0.xsd" 
       version= "3.0"> 
       <display-name>Archetype Created Web Application </display-name> 
       
       <welcome-file-list> 
       <welcome-file>/index.jsp </welcome-file> 
       </welcome-file-list> 
       
        
       <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> 
       
        
       <filter> 
       <filter-name>encodingFilter </filter-name> 
       <filter-class>org.springframework.web.filter.CharacterEncodingFilter </filter-class> 
       <async-supported>true </async-supported> 
       <init-param> 
       <param-name>encoding </param-name> 
       <param-value>UTF-8 </param-value> 
       </init-param> 
       </filter> 
       <filter-mapping> 
       <filter-name>encodingFilter </filter-name> 
       <url-pattern>/* </url-pattern> 
       </filter-mapping> 
       
        
       <servlet> 
       <servlet-name>SpringMVC </servlet-name> 
       <servlet-class>org.springframework.web.servlet.DispatcherServlet </servlet-class> 
       <init-param> 
       <param-name>contextConfigLocation </param-name> 
       <param-value>/WEB-INF/spring-mvc.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>/ </url-pattern> 
       </servlet-mapping> 
       
       </web-app>

## 4、在src/main/java下添加如下包和类 ##

**UserController.java**

package com.chillax.controller; 
       
       import java.util.List; 
       
       import javax.annotation.Resource; 
       import javax.servlet.http.HttpServletRequest; 
       
       import org.springframework.stereotype.Controller; 
       import org.springframework.ui.Model; 
       import org.springframework.web.bind.annotation.RequestMapping; 
       
       import com.chillax.dto.User; 
       import com.chillax.service.IUserService; 
       
       @Controller 
       @RequestMapping( "/user") 
       public class UserController { 
       @Resource 
       private IUserService userService; 
       
       @RequestMapping( "/userList") 
       public String userList(HttpServletRequest request,Model model){ 
       List<User> uList = userService.getAllUser(); 
       model.addAttribute( "uList", uList); 
       return "userList"; 
       } 
       
       @RequestMapping( "/showUser") 
       public String showUser(HttpServletRequest request,Model model){ 
       int userId = Integer.parseInt(request.getParameter( "id")); 
       User user = userService.getUserById(userId); 
       model.addAttribute( "user", user); 
       return "showUser"; 
       } 
       
       @RequestMapping( "/addUserUI") 
       public String addUserUI(){ 
       return "addUser"; 
       } 
       
       @RequestMapping( "/addUser") 
       public String addUser(HttpServletRequest request,Model model){ 
       User user = new User(); 
       user.setName(String.valueOf(request.getParameter( "name"))); 
       user.setPassword(String.valueOf(request.getParameter( "password"))); 
       user.setAge(Integer.parseInt(String.valueOf(request.getParameter( "age")))); 
       userService.addUser(user); 
       return "redirect:/user/userList"; 
       } 
       }

**IUserDao.java**

package com.chillax.dao; 
       
       import java.util.List; 
       import java.util.Map; 
       
       import com.chillax.dto.User; 
       
       public interface IUserDao { 
       
       public User queryByPrimaryKey(Integer id); 
       
       public List<User> getAllUser(); 
       
       public void insertUser(User user); 
       
       public void insertUserByBatch(List<User> list); 
       
       public void deleteByPrimaryKey(Integer id); 
       
       public void delteUserByBatch(Map<String,Object> params); 
       
       public void updateByPrimaryKey(User user); 
       
       }

**User.java**

package com.chillax.dto; 
       
       public class User { 
       private Integer id; 
       
       private String name; 
       
       private String password; 
       
       private Integer age; 
       
       public Integer getId() { 
       return id; 
       } 
       
       public void setId(Integer id) { 
       this.id = id; 
       } 
       
       public String getName() { 
       return name; 
       } 
       
       public void setName(String name) { 
       this.name = name; 
       } 
       
       public String getPassword() { 
       return password; 
       } 
       
       public void setPassword(String password) { 
       this.password = password == null ? null : password.trim(); 
       } 
       
       public Integer getAge() { 
       return age; 
       } 
       
       public void setAge(Integer age) { 
       this.age = age; 
       } 
       }

**UserMapper.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.chillax.dao.IUserDao" > 
       <resultMap id="BaseResultMap" type="com.chillax.dto.User"> 
       <result column="id" property="id" jdbcType="INTEGER" /> 
       <result column="name" property="name" jdbcType="VARCHAR" /> 
       <result column="password" property="password" jdbcType="VARCHAR" /> 
       <result column="age" property="age" jdbcType="INTEGER" /> 
       </resultMap> 
       
       <sql id="Base_Column_List"> 
       id, name, password, age 
       </sql> 
       
        
       <select id="queryByPrimaryKey" resultMap="BaseResultMap" 
       parameterType= "java.lang.Integer"> 
       select 
       <include refid="Base_Column_List" /> 
       from user 
       where id = #{id,jdbcType=INTEGER} 
       </select> 
       
        
       <select id="getAllUser" resultMap="BaseResultMap"> 
       select 
       <include refid="Base_Column_List" /> 
       from user 
       </select> 
       
        
       <insert id="insertUser" parameterType="com.chillax.dto.User"> 
       insert into user 
       <trim prefix="(" suffix=")" suffixOverrides="," > 
       <if test="id != null" > 
       id, 
       </if> 
       <if test="name != null" > 
       name, 
       </if> 
       <if test="password != null" > 
       password, 
       </if> 
       <if test="age != null" > 
       age, 
       </if> 
       </trim> 
       <trim prefix="values (" suffix=")" suffixOverrides="," > 
       <if test="id != null" > 
       #{id,jdbcType=INTEGER}, 
       </if> 
       <if test="name != null" > 
       #{name,jdbcType=VARCHAR}, 
       </if> 
       <if test="password != null" > 
       #{password,jdbcType=VARCHAR}, 
       </if> 
       <if test="age != null" > 
       #{age,jdbcType=INTEGER}, 
       </if> 
       </trim> 
       </insert> 
       
        
       <insert id="insertUserByBatch" parameterType="java.util.List" > 
       insert into USER 
       (ID, 
       NAME, 
       PASSWORD, 
       AGE) 
       select A.* from 
       ( 
       <foreach collection="list" item="user" index="index" separator="union"> 
       select 
       #{user.id,jdbcType=INTEGER}, 
       #{user.name,jdbcType=VARCHAR}, 
       #{user.password,jdbcType=VARCHAR}, 
       #{user.age,jdbcType=INTEGER} 
       from dual 
       </foreach> 
       ) A 
       </insert> 
       
        
       <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer"> 
       delete from user 
       where id = #{id,jdbcType=INTEGER} 
       </delete> 
       
        
       <delete id="deleteUserByBatch" parameterType="java.util.Map" > 
       delete from user 
       where id IN 
       <foreach item="ids" collection="iList" open="(" separator="," close=")"> 
       #{ids,jdbcType=DECIMAL} 
       </foreach> 
       </delete> 
       
        
       <update id="updateByPrimaryKey" parameterType="com.chillax.dto.User" > 
       update user 
       <set > 
       <if test="name != null" > 
       name = #{name,jdbcType=VARCHAR}, 
       </if> 
       <if test="password != null" > 
       password = #{password,jdbcType=VARCHAR}, 
       </if> 
       <if test="age != null" > 
       age = #{age,jdbcType=INTEGER}, 
       </if> 
       </set> 
       where id = #{id,jdbcType=INTEGER} 
       </update> 
       
       </mapper>

**IUserService.java**

package com.chillax.service; 
       
       import java.util.List; 
       
       import com.chillax.dto.User; 
       
       public interface IUserService { 
       
       public User getUserById(int userId); 
       
       public void insertUser(User user); 
       
       public void addUser(User user); 
       
       public List<User> getAllUser(); 
       }

**UserServiceImpl.java**

package com.chillax.service.Impl; 
       
       import java.util.List; 
       
       import javax.annotation.Resource; 
       
       import org.springframework.stereotype.Service; 
       
       import com.chillax.dao.IUserDao; 
       import com.chillax.dto.User; 
       import com.chillax.service.IUserService; 
       
       @Service( "userService") 
       public class UserServiceImpl implements IUserService { 
       @Resource 
       private IUserDao userDao; 
       
       public User getUserById(int userId) { 
       return userDao.queryByPrimaryKey(userId); 
       } 
       
       public void insertUser(User user) { 
       userDao.insertUser(user); 
       } 
       
       public void addUser(User user) { 
       userDao.insertUser(user); 
       } 
       
       @Override 
       public List<User> getAllUser() { 
       return userDao.getAllUser(); 
       } 
       
       }

## 5、在WEB-INF文件夹下创建jsp文件夹，并添加userList.jsp，showUser.jsp、addUser.jsp ##

**userList.jsp**

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> 
       <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> 
       <% 
       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>My JSP 'showUser.jsp' starting page </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"> 
        
       
       </head> 
       
       <body> 
       <c:forEach items="${uList }" var="u"> 
       用户名称：${u.name} 
       用户年龄：${u.age } 
       <br/> 
       </c:forEach> 
       </body> 
       </html>

**addUser.jsp**

<%@ 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>My JSP 'addUser.jsp' starting page </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"> 
        
       
       </head> 
       
       <body> 
       <form id="addUser" action="user/addUser" method="post"> 
       userName: <input id="name" name="name" /> <br/> 
       password: <input id="password" name="password" /> <br/> 
       age: <input id="age" name="age"/> <br/> 
       <input type="submit" value="添加新用户"/> 
       </form> 
       </body> 
       </html>

**showUser.jsp**

<%@ 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>My JSP 'showUser.jsp' starting page </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"> 
        
       
       </head> 
       
       <body> 
       ${user.name } <br> 
       </body> 
       </html>

## 6、创建数据库，并创建表 ##

create database maventest; 
       use maventest; 
       
       CREATE TABLE `user` ( 
       `id` int( 12) NOT NULL AUTO_INCREMENT, 
       `name` varchar( 50) NOT

[http_blog.csdn.net_v123411739_article_details_50742885]: http://blog.csdn.net/v123411739/article/details/50742885
[http_maven.apache.org_download.cgi]: http://maven.apache.org/download.cgi
[apache-maven-3.5.2-bin.zip]: http://mirrors.hust.edu.cn/apache/maven/maven-3/3.5.2/binaries/apache-maven-3.5.2-bin.zip
[SouthEast]: /images/20220504/0e6f28c8443b4fb298d11920e77b2678.png
[Center]: /images/20220504/d133b70adf894b4fa3c189a9d5c7e183.png
[Center 1]: /images/20220504/e313de09b24c49368600c375e96f3a83.png
[Center 2]: /images/20220504/3576ff7f718f4f07955c8694d8fe3155.png
[Center 3]: /images/20220504/c2c78625a21943f9ac54522a1f6177a0.png
[Center 4]: https://img-blog.csdn.net/20180114223058576?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvdjEyMzQxMTczOQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center
[Center 5]: /images/20220504/6739b68947644891ba570847dd35906c.png
[Center 6]: /images/20220504/8b7c6f7a618b4d8db7de05df2d79a5df.png
[Center 7]: /images/20220504/1bc3a0b945164c63b75af9300c2262c4.png
[Center 8]: /images/20220504/f26c0cc1814c4b9685b255ccf03a3ccc.png
[Center 9]: /images/20220504/91030144cb8f44a786a399efbcbc0641.png
[Center 10]: /images/20220504/5a8ec3f1c86f452ba343bb491444fd4e.png
[Center 11]: /images/20220504/f95392e7d2ca4cb6b72a38dfecde22e9.png