基于SpringMVC+Mybatis搭建简单的前后台交互系统

一、摘要

　　1、所需软件列表：

　　　　1) tomcat : apache-tomcat-7.0.54　 服务端容器

　　　　2) Intellij： Intellij IDEA 2016.3.1 开发工具　　

　　　　3) Syslog: SQLyog Community 　 数据库工具

　　2. 步骤简述：

　　　1） 新建一个 Java 项目， 依次选择Spring--->Spring MVC--->Finish；

　　　2） web目录下新建前台页面相关目录（css/js/page等）；

　　   3） WEB-INF文件夹下新建如下两个文件夹：
　　　　lib: 用于存放项目相关jar包，项目如已导入maven可无视该步骤；
　　　　resources: 用于存放Spring,Mybatis等相关配置文件。
　　  4）src目录下用于存放服务端相关代码

　　完成后的工程目录如下：

　　

二、Spring配置：

1、需要导入的包如下：

　　

2、 相关配置文件

　　1）web.xml配置（用于配置Spring 相关配置项：上下文、日志、字符集、监听器等）

<?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_3_1.xsd"
         version="3.1">

    <!-- 告知javaEE容器，哪些内容需要添加到上下文中去 -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>
            classpath:applicationContext.xml
        </param-value>
    </context-param>

    <!-- 加载LOG4J -->
    <context-param>
        <param-name>log4jConfigLocation</param-name>
        <param-value>classpath:log4j.xml</param-value>
    </context-param>

    <context-param>
        <param-name>log4jRefreshInterval</param-name>
        <param-value>60000</param-value>
    </context-param>

    <!-- 动态设置项目的运行路径 -->
    <context-param>
        <param-name>webAppRootKey</param-name>
        <param-value>mvc.root</param-value>
    </context-param>

    <!-- 配置静态资源 -->
    <servlet-mapping>
        <servlet-name>default</servlet-name>
        <url-pattern>/static/*</url-pattern>
    </servlet-mapping>

    <!-- 配置springmvc的前端控制器 -->
    <servlet>
        <servlet-name>mvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <!-- 默认情况下：DispatcherServlet会寻找WEB-INF下，命名规范为[servlet-name]-servlet.xml文件。
        如：在上例中，它就会找/WEB-INF/mvc-servlet.xml
         如果需要修改，需要在web.xml中的<servlet>标记中增加 <init-param>。。。</init-param>：-->
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:mvc-servlet.xml</param-value>
        </init-param>
    </servlet>
    <servlet-mapping>
        <servlet-name>mvc</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <!-- spring框架提供的字符集过滤器 -->
    <!-- spring Web MVC框架提供了org.springframework.web.filter.CharacterEncodingFilter用于解决POST方式造成的中文乱码问题  -->
    <filter>
        <filter-name>encodingFilter</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>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!-- 监听器 -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <listener>
        <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
    </listener>

    <welcome-file-list>
        <welcome-file>/page/index.html</welcome-file>
    </welcome-file-list>
</web-app>

　　2）spring-servlet.xml配置（用于配置SpringMVC相关： 注解、视图解析器、自动扫描等）

<?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-3.0.xsd
    http://www.springframework.org/schema/context   http://www.springframework.org/schema/context/spring-context-3.0.xsd
    http://www.springframework.org/schema/mvc
    http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">

    <bean id="fastJsonHttpMessageConverter"
          class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">
        <property name="supportedMediaTypes">
            <list>
                <value>text/html;charset=UTF-8</value>
                <value>application/json</value>
            </list>
        </property>
        <property name="features">
            <list>
                <!-- 输出key时是否使用双引号 -->
                <value>QuoteFieldNames</value>
                <!-- 是否输出值为null的字段 -->
                <value>WriteMapNullValue</value>
                <!-- 数值字段如果为null,输出为0,而非null -->
                <value>WriteNullNumberAsZero</value>
                <!-- List字段如果为null,输出为[],而非null -->
                <value>WriteNullListAsEmpty</value>
                <!-- 字符类型字段如果为null,输出为"",而非null -->
                <value>WriteNullStringAsEmpty</value>
                <!-- Boolean字段如果为null,输出为false,而非null -->
                <value>WriteNullBooleanAsFalse</value>
                <!-- null String不输出  -->
                <value>WriteNullStringAsEmpty</value>
                <!-- Date的日期转换器 -->
                <value>WriteDateUseDateFormat</value>
            </list>
        </property>
    </bean>
    <!-- 启动注解，注册服务，如验证框架、全局类型转换器-->
    <mvc:annotation-driven>
        <mvc:message-converters>
            <ref bean="fastJsonHttpMessageConverter" />
        </mvc:message-converters>
    </mvc:annotation-driven>

    <!-- 静态资源默认servlet配置
        (1)加入对静态资源的处理：js,gif,png
        (2)允许使用"/"做整体映射
        会自动注册DefaultAnnotationHandlerMapping与AnnotationMethodHandlerAdapter 两个bean,
        是spring MVC为@Controllers分发请求所必须的。
        并提供了：数据绑定支持，@NumberFormatannotation支持，@DateTimeFormat支持，@Valid支持，
        读写XML的支持（JAXB，读写JSON的支持（Jackson
     -->
    <mvc:default-servlet-handler/>

    <!-- 启动自动扫描 -->
    <context:component-scan base-package="com.test">
        <!-- 制定扫包规则 ,只扫描使用@Controller注解的JAVA类 -->
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!-- 配置视图解析器 -->
    <!--prefix和suffix：查找视图页面的前缀和后缀（前缀[逻辑视图名]后缀），
       比如传进来的逻辑视图名为WEB-INF/page/hello，则该该jsp视图页面应该存放在“WEB-INF/page/hello.html”； -->
    <bean class="org.springframework.web.servlet.view.UrlBasedViewResolver">
        <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"></property>
        <property name="prefix" value="/page"></property>
        <property name="suffix" value=".html"></property>
    </bean>
</beans>

　　3） datasource.properties(用于配置数据库文件）

jdbc.driver= com.mysql.jdbc.Driver
jdbc.url= jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8
jdbc.username= root
jdbc.password= root

　　4)  log4j.xml(用于配置记录日志文件)

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "F:\SpringMybatis测试\SpringMVC_Mybatis\src\webapp\WEB-INF\conf\log4j.dtd">
<log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'
					 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
					 xsi:schemaLocation="http://jakarta.apache.org/log4j/ ">

	<appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
		<layout class="org.apache.log4j.PatternLayout">
			<param name="ConversionPattern" value="%c %d{yyyy-MM-dd HH:mm:ss} -- %p -- %m%n"/>
		</layout>
	</appender>

	<appender name="DEBUG" class="org.apache.log4j.RollingFileAppender">
		<param name="File" value="${ssm.root}/ssm-debug.log"/>
		<param name="Append" value="true"/>
		<param name="MaxFileSize" value="10240KB"/>
		<param name="MaxBackupIndex" value="1000"/>
		<layout class="org.apache.log4j.PatternLayout">
			<param name="ConversionPattern" value="%c %d{yyyy-MM-dd HH:mm:ss} -- %p -- %m%n"/>
		</layout>
		<filter class="org.apache.log4j.varia.LevelRangeFilter">
			<param name="LevelMin" value="DEBUG"/>
			<param name="LevelMax" value="DEBUG"/>
		</filter>
	</appender>

	<appender name="INFO" class="org.apache.log4j.RollingFileAppender">
		<param name="File" value="${ssm.root}/ssm-info.log"/>
		<param name="Append" value="true"/>
		<param name="MaxFileSize" value="10240KB"/>
		<param name="MaxBackupIndex" value="1000"/>
		<layout class="org.apache.log4j.PatternLayout">
			<param name="ConversionPattern" value="%c %d{yyyy-MM-dd HH:mm:ss} -- %p -- %m%n"/>
		</layout>
		<filter class="org.apache.log4j.varia.LevelRangeFilter">
			<param name="LevelMin" value="INFO"/>
			<param name="LevelMax" value="INFO"/>
		</filter>
	</appender>

	<appender name="WARN" class="org.apache.log4j.RollingFileAppender">
		<param name="File" value="${ssm.root}/ssm-warn.log"/>
		<param name="Append" value="true"/>
		<param name="MaxFileSize" value="10240KB"/>
		<param name="MaxBackupIndex" value="1000"/>
		<layout class="org.apache.log4j.PatternLayout">
			<param name="ConversionPattern" value="%c %d{yyyy-MM-dd HH:mm:ss} -- %p -- %m%n"/>
		</layout>
		<filter class="org.apache.log4j.varia.LevelRangeFilter">
			<param name="LevelMin" value="WARN"/>
			<param name="LevelMax" value="WARN"/>
		</filter>
	</appender>

	<appender name="ERROR" class="org.apache.log4j.RollingFileAppender">
		<param name="File" value="${ssm.root}/ssm-error.log"/>
		<param name="Append" value="true"/>
		<param name="MaxFileSize" value="10240KB"/>
		<param name="MaxBackupIndex" value="1000"/>
		<layout class="org.apache.log4j.PatternLayout">
			<param name="ConversionPattern" value="%c %d{yyyy-MM-dd HH:mm:ss} -- %p -- %m%n"/>
		</layout>
		<filter class="org.apache.log4j.varia.LevelRangeFilter">
			<param name="LevelMin" value="ERROR"/>
			<param name="LevelMax" value="ERROR"/>
		</filter>
	</appender>

	<root>
		<priority value="INFO"/>
		<appender-ref ref="STDOUT"/>
		<appender-ref ref="DEBUG"/>
		<appender-ref ref="INFO"/>
		<appender-ref ref="WARN"/>
		<appender-ref ref="ERROR"/>
	</root>

</log4j:configuration>

　　5） log4j,dtd(主要是对相应.xml进行约束验证用的)

<?xml version="1.0" encoding="UTF-8" ?>

<!ELEMENT log4j:configuration (renderer*, throwableRenderer?,
                               appender*,plugin*, (category|logger)*,root?,
                               (categoryFactory|loggerFactory)?)>

<!ATTLIST log4j:configuration
  xmlns:log4j              CDATA #FIXED "http://jakarta.apache.org/log4j/"
  threshold                (all|trace|debug|info|warn|error|fatal|off|null) "null"
  debug                    (true|false|null)  "null"
  reset                    (true|false) "false"
>

<!ELEMENT renderer EMPTY>
<!ATTLIST renderer
  renderedClass  CDATA #REQUIRED
  renderingClass CDATA #REQUIRED
>

<!ELEMENT throwableRenderer (param*)>
<!ATTLIST throwableRenderer
  class  CDATA #REQUIRED
>

<!ELEMENT appender (errorHandler?, param*,
      rollingPolicy?, triggeringPolicy?, connectionSource?,
      layout?, filter*, appender-ref*)>
<!ATTLIST appender
  name 		CDATA 	#REQUIRED
  class 	CDATA	#REQUIRED
>

<!ELEMENT layout (param*)>
<!ATTLIST layout
  class		CDATA	#REQUIRED
>

<!ELEMENT filter (param*)>
<!ATTLIST filter
  class		CDATA	#REQUIRED
>

<!ELEMENT errorHandler (param*, root-ref?, logger-ref*,  appender-ref?)>
<!ATTLIST errorHandler
   class        CDATA   #REQUIRED
>

<!ELEMENT root-ref EMPTY>

<!ELEMENT logger-ref EMPTY>
<!ATTLIST logger-ref
  ref CDATA #REQUIRED
>

<!ELEMENT param EMPTY>
<!ATTLIST param
  name		CDATA   #REQUIRED
  value		CDATA	#REQUIRED
>

<!ELEMENT priority (param*)>
<!ATTLIST priority
  class   CDATA	#IMPLIED
  value	  CDATA #REQUIRED
>
<!ELEMENT level (param*)>
<!ATTLIST level
  class   CDATA	#IMPLIED
  value	  CDATA #REQUIRED
>

<!ELEMENT category (param*,(priority|level)?,appender-ref*)>
<!ATTLIST category
  class         CDATA   #IMPLIED
  name		CDATA	#REQUIRED
  additivity	(true|false) "true"
>

<!ELEMENT logger (param*,level?,appender-ref*)>
<!ATTLIST logger
  class         CDATA   #IMPLIED
  name		CDATA	#REQUIRED
  additivity	(true|false) "true"
>

<!ELEMENT categoryFactory (param*)>
<!ATTLIST categoryFactory
   class        CDATA #REQUIRED>

<!ELEMENT loggerFactory (param*)>
<!ATTLIST loggerFactory
   class        CDATA #REQUIRED>

<!ELEMENT appender-ref EMPTY>
<!ATTLIST appender-ref
  ref CDATA #REQUIRED
>

<!-- plugins must have a name and class and can have optional parameters -->
<!ELEMENT plugin (param*, connectionSource?)>
<!ATTLIST plugin
  name 		CDATA 	   #REQUIRED
  class 	CDATA  #REQUIRED
>

<!ELEMENT connectionSource (dataSource?, param*)>
<!ATTLIST connectionSource
  class        CDATA  #REQUIRED
>

<!ELEMENT dataSource (param*)>
<!ATTLIST dataSource
  class        CDATA  #REQUIRED
>

<!ELEMENT triggeringPolicy ((param|filter)*)>
<!ATTLIST triggeringPolicy
  name 		CDATA  #IMPLIED
  class 	CDATA  #REQUIRED
>

<!ELEMENT rollingPolicy (param*)>
<!ATTLIST rollingPolicy
  name 		CDATA  #IMPLIED
  class 	CDATA  #REQUIRED
>

<!ELEMENT root (param*, (priority|level)?, appender-ref*)>

<!ELEMENT log4j:eventSet (log4j:event*)>
<!ATTLIST log4j:eventSet
  xmlns:log4j             CDATA #FIXED "http://jakarta.apache.org/log4j/"
  version                (1.1|1.2) "1.2"
  includesLocationInfo   (true|false) "true"
>

<!ELEMENT log4j:event (log4j:message, log4j:NDC?, log4j:throwable?,
                       log4j:locationInfo?, log4j:properties?) >

<!ATTLIST log4j:event
    logger     CDATA #REQUIRED
    level      CDATA #REQUIRED
    thread     CDATA #REQUIRED
    Date  CDATA #REQUIRED
    time       CDATA #IMPLIED
>

<!ELEMENT log4j:message (#PCDATA)>
<!ELEMENT log4j:NDC (#PCDATA)>

<!ELEMENT log4j:throwable (#PCDATA)>

<!ELEMENT log4j:locationInfo EMPTY>
<!ATTLIST log4j:locationInfo
  class  CDATA	#REQUIRED
  method CDATA	#REQUIRED
  file   CDATA	#REQUIRED
  line   CDATA	#REQUIRED
>

<!ELEMENT log4j:properties (log4j:data*)>

<!ELEMENT log4j:data EMPTY>
<!ATTLIST log4j:data
  name   CDATA	#REQUIRED
  value  CDATA	#REQUIRED
>

　6）applicationContext.xml(Mybatis sqlSessionFactoryBuilder相关配置及Spring AOP等)

<?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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
    http://www.springframework.org/schema/aop
    http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context-4.2.xsd">

    <!-- 开启自动扫包 -->
    <context:component-scan base-package="com.test">
        <!--制定扫包规则，不扫描@Controller注解的JAVA类，其他的还是要扫描  -->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!-- 启动AOP支持 -->
    <aop:aspectj-autoproxy/>

    <!-- 引入外部数据源配置信息 -->
    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <value>classpath:datasource.properties</value>
        </property>
    </bean>

    <!-- 配置数据源 -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${jdbc.driver}"></property>
        <property name="url" value="${jdbc.url}"></property>
        <property name="username" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>

    <!-- 配置Session工厂 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <!-- 加载mybatis.mapper.xml文件 -->
        <property name="mapperLocations" value="classpath*:UserMapper.xml"></property>
        <!-- 自动扫描需要定义类别名的包，将包内的JAVA类的类名作为类别名 -->
        <property name="typeAliasesPackage" value="com.test.pojo"></property>
    </bean>

    <!-- 自动扫描所的Mapper接口与文件 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.test.dao"></property>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>

    <!-- 配置事务管理器 -->
    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!-- 定义操作通知，指定事务管理器 -->
    <tx:advice id="txAdvice" transaction-manager="txManager">
        <tx:attributes>
            <tx:method name="delete*" propagation="REQUIRED" read-only="false"
                       rollback-for="java.lang.Exception" />
            <tx:method name="save*" propagation="REQUIRED" read-only="false"
                       rollback-for="java.lang.Exception" />
            <tx:method name="insert*" propagation="REQUIRED" read-only="false"
                       rollback-for="java.lang.Exception" />
            <tx:method name="update*" propagation="REQUIRED" read-only="false"
                       rollback-for="java.lang.Exception" />
            <tx:method name="load*" propagation="SUPPORTS" read-only="true"/>
            <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>
            <tx:method name="search*" propagation="SUPPORTS" read-only="true"/>
            <tx:method name="select*" propagation="SUPPORTS" read-only="true"/>
            <tx:method name="get*" propagation="SUPPORTS" read-only="true"/>
        </tx:attributes>
    </tx:advice>

    <aop:config>
        <!-- 配置一个切入点 -->
        <aop:pointcut id="serviceMethods" expression="execution(* com.test.service.impl.*ServiceImpl.*(..))" />
        <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceMethods" />
    </aop:config>

</beans>

　　7) UserMapper.xml(Mybatis 配置文件，用于生成所需的SQL)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.test.dao.UserDAO">
    <!-- 自定义返回结果集 -->
    <resultMap id="userMap" type="com.test.pojo.UserBean" >
        <id property="id" column="id" javaType="java.lang.Integer"></id>
        <result property="name" column="name" javaType="java.lang.String"></result>
        <result property="age" column="age" javaType="java.lang.Integer"></result>
    </resultMap>

    <!--查-->
    <select id="selectAllUser" resultMap="userMap">
		select * from user
	</select>

    <!--#{}：占位符，可用于替换动态内容，防止SQL注入
    %{}：拼接sql串，可用于替换静态内容，如表名，数据库连接方式等，不能防止sql注入-->
    <!--根据id查询单个用户-->
    <select id="selectSingleUser" parameterType="java.lang.Integer" resultMap="userMap">
        select * from user
        <if test=" id != null">
            where id=#{id,jdbcType=INTEGER}
        </if>
    </select>

    <select id="countUsers" resultType="int">
		select count(*) from user where 1=1
	</select>

    <!--choose, when, otherwise: 等价于swicth case条件执行查询语句
    bind: 用于执行左右模糊匹配字段的查询-->
    <select id="selectOneUserInfo" resultMap="userMap">
        select * from user
        <!--<choose>-->
        <!--<when test="id != null">-->
        <!--where id=#{id,jdbcType=INTEGER}-->
        <!--</when>-->
        <!--<when test="name != null">-->
        <!--where name like #{name}-->
        <!--</when>-->
        <!--<otherwise>-->
        <!--where 1=1-->
        <!--</otherwise>-->
        <!--</choose>-->
        <where>
            <if test="id != null">
                id=#{id,jdbcType=INTEGER}
            </if>
            <if test="name != null">
                <bind name="username" value="'%' + name + '%'" />
                and name like #{username}
            </if>
        </where>
    </select>

    <!--增-->
    <!--如果数据库支持自动生成主键的字段，可以使用useGeneratedKys+keyProperty字段来制定主键-->
    <insert id="insertUser" parameterType="java.util.List" useGeneratedKeys="true"
            keyProperty="id">
        insert into user (id, name, age) values
        <foreach collection="list" item="user" separator=",">
            (#{user.id},#{user.name},#{user.age})
        </foreach>
    </insert>

    <!--改-->
    <update id="updateUserInfo">
        update user
        <set>
            <if test="user.id != null">id=#{user.id},</if>
            <if test="user.name != null">name=#{user.name},</if>
            <if test="user.age != null">age=#{user.age}</if>
        </set>
        where id=#{id}
    </update>

    <!--删-->
    <delete id="deleteUser">
        delete from user
        <trim prefix="WHERE" prefixOverrides="AND | OR">
            <if test="id != null">
                WHERE id = #{id,jdbcType=INTEGER}
            </if>
            <!--<if test="name != null and name.length()>0">-->
                <!--AND WHERE name = #{name}-->
            <!--</if>-->
        </trim>
    </delete>
</mapper>

　三、 服务端代码

　　服务端代码使用MVC模式，使得视图（界面显示）、模型（数据）及控制器（业务逻辑）三者分离的方式组织代码，将业务逻辑聚集到一个部件里，在改进和个性化定制界面及用户交互的同时，不需要重新编写业务逻辑。
具体的编码实现如下：

1）User实体类：

package com.test.pojo;

public class UserBean{
    private int id;
    private String name;
    private int age;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "UserBean{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                '}';
    }
}

　2） 控制器类：

package com.test.controller;

import com.test.pojo.UserBean;
import com.test.service.UserService;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import javax.jws.WebMethod;
import java.lang.annotation.Target;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;

@RestController()
public class UserController {
    @Autowired
    private UserService userService;

    @RequestMapping(value = "/getUserInfo", method = RequestMethod.GET)
    public List getUserInfo() throws Exception {
        return userService.getAllUsers();
    }

    @RequestMapping(value = "/getSingleUser", method = RequestMethod.GET)
    public UserBean getSingleUser(@Param("id") String id) throws Exception {
        //return userService.getSingleUsers(id);
        return userService.getUserInfo(id);
    }

    @RequestMapping(value = "/getOneUserInfo", method = RequestMethod.GET)
    public UserBean getSingleUser(@Param("id") String id, @Param("name") String name) throws Exception {
        return userService.getOneUserInfo(id, name);
    }

    @RequestMapping(value = "/getUserCount", method = RequestMethod.GET)
    public int getUserCountForAllUsers() throws Exception {
        return userService.getUsersCount();
    }

    @RequestMapping(value = "updateUser")
    public void updateUserInfo(){
        userService.updateUserInfo();
    }

    @RequestMapping(value = "/addUsers", method = RequestMethod.GET)
    public void addUsers(List<UserBean> list) throws Exception {
        List<UserBean> users = new ArrayList<>();
        UserBean user1 = new UserBean();
        user1.setAge(28);
        user1.setId(12);
        user1.setName("Mr One");
        UserBean user2 = new UserBean();
        user2.setAge(31);
        user2.setId(11);
        user2.setName("Mr Two");
        users.add(user1);
        users.add(user2);
        userService.addUsers(list);
    }

    @RequestMapping(value = "/deleteUser", method = RequestMethod.GET)
    public void deleteUser(@Param("id") String id, @Param("name")String name) throws Exception {
        userService.deleteUser(id, name);
    }
}

　　3） 数据库操作类UserDAO：（定义为接口方式，serviceImpl用来实现具体的增删改查操作，可以使用Mybatis映射器方式直接拼写SQL（注释掉的@Select("")等）, 也可以定义UserMapper.xml文件用来通过配置文件生成SQL）

package com.test.dao;

import com.test.pojo.UserBean;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;

import java.util.List;

public interface UserDAO {

    List<UserBean> selectAllUser() throws Exception;

    //@Select("select * from user where id=#{id}") ---映射器方式：入参需要改为String类型
    UserBean selectSingleUser(@Param("id") Integer id);

    //@Select("select * from user where id=#{id} and name=#{name}") ---映射器方式：入参需要改为String类型
    UserBean selectOneUserInfo(@Param("id") Integer id, @Param("name") String name);

    int countUsers();

    void insertUser(@Param("list") List<UserBean> list);

//    @Delete("delete from user where id=#{id}")
    void deleteUser(@Param("id") Integer id, @Param("name") String name) throws Exception;

    void updateUserInfo(@Param("id")Integer id, @Param("user") UserBean user);

    @Select("select * from user where id=#{id}")
    UserBean getUserInfo(@Param("id") String id);
}

　　4） UserService(数据库操作接口类)

package com.test.service;

import com.test.pojo.UserBean;

import java.util.List;

public interface UserService {

    List<UserBean> getAllUsers() throws Exception;

    void addUsers(List<UserBean> list);

    void deleteUser(String id, String name) throws Exception;

    UserBean getSingleUsers(String id);

    int getUsersCount();

    UserBean getOneUserInfo(String id, String name);

    void updateUserInfo();

    UserBean getUserInfo(String id);
}　

　　5）UserServiceImpl(UserService的实现类)

package com.test.service.impl;

import com.test.dao.UserDAO;
import com.test.pojo.UserBean;
import com.test.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service("user")
public class UserServiceImpl implements UserService {

    @Autowired(required = false)
    UserDAO userDAO;

    @Override
    public List<UserBean> getAllUsers() throws Exception {
        return userDAO.selectAllUser();
    }

    @Override
    public UserBean getSingleUsers(String id) {
        return userDAO.selectSingleUser(Integer.parseInt(id));
    }

    @Override
    public int getUsersCount() {
        return userDAO.countUsers();
    }

    @Override
    public void addUsers(List<UserBean> list) {
        userDAO.insertUser(list);
    }

    @Override
    public void deleteUser(String id, String name) throws Exception {
        userDAO.deleteUser(Integer.parseInt(id), name);
    }

    @Override
    public UserBean getOneUserInfo(String id, String name) {
        if(id != null && !"".equals(id)){
            if(name != null){
                return userDAO.selectOneUserInfo(Integer.parseInt(id), name);
            }else{
                return userDAO.selectOneUserInfo(Integer.parseInt(id), null);
            }
        }else {
            return userDAO.selectOneUserInfo(null, name);
        }
    }

    @Override
    public void updateUserInfo() {
        UserBean user = new UserBean();
        user.setId(3);
        user.setAge(33);
        user.setName("haha");
        userDAO.updateUserInfo(1, user);
    }

    @Override
    public UserBean getUserInfo(String id) {
        return userDAO.getUserInfo(id);
    }
}

四、客户端文件：

　　本例只使用了静态页面作为初始化加载的界面展示，路径为：web/page/index.html

<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<h1>This is a test Page for Spring Test</h1>

</body>
</html>　

　　本例中的返回信息使用了Alibaba的fastJson作为返回对象（未使用视图解析器），故界面ajax请求返回数据可根据返回值作为数据填充，具体的界面设计需要*发挥。

五、 Tomcat配置：

　　两种方式查看：

　　1. 配置Tomcat文件：

　　　　1）将web文件夹放入 tomcat 解压包的 apache-tomcat-7.0.54\webapps\ 目录下;

　　　　2) 将编译后的jar包放入 WEB-INF 目录下的lib文件夹下

　　　　3）启动Tomcat

　　2. IntelliJ 集成了Tomcat 插件，可以直接启动，具体配置路径如下：
　　　　Run--->Edit Configurations--->"+"--->Tomcat Server--->Local 或者 Remote选项配置
　　　　（注意Deployment Tab页下要将对应的war包导入）
　　　　然后启动即可