SpringMVC框架搭建并整合MyBatis-CSDN博客

本文链接：https://blog.csdn.net/ws_flying/article/details/78374920

开发工具：IntelliJ idea
开发环境：jdk1.8，tomcat7

项目源码下载链接：http://download.csdn.net/download/ws_flying/10042768

最终项目结构图：
这里写图片描述

第一步：使用idea创建maven web项目
1、File->New->Project
这里写图片描述
2、选择Maven…具体步骤如下图

3、填写GroupId与ArtifactId（相信使用过maven的对这两个参数并不陌生吧），点击下一步

4、填写Project name，为你的项目取一个名字，点击Finish，等待完成即可

5、创建完成后，项目结构大致是这个样子
这里写图片描述

第二步：搭建SpringMVC环境
1、添加SpringMVC环境所需的依赖，具体如下

<?xml version="1.0" encoding="UTF-8"?>
<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>com.spring</groupId>
    <artifactId>springdemo</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <spring.version>4.3.10.RELEASE</spring.version>
        <fastjson.version>1.1.28</fastjson.version>
        <jackson.version>2.8.9</jackson.version>
        <mysql.version>5.1.21</mysql.version>
        <mybatis.version>3.2.3</mybatis.version>
        <commons-dbcp.version>1.4</commons-dbcp.version>
        <spring.mybatis.version>1.2.1</spring.mybatis.version>
        <aspectjweaver.version>1.8.10</aspectjweaver.version>
        <javax.servlet.version>3.0.1</javax.servlet.version>
        <commons-fileupload.version>1.3.1</commons-fileupload.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>3.8.1</version>
            <scope>test</scope>
        </dependency>

        <!-- spring依赖 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</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-test</artifactId>
            <version>${spring.version}</version>
        </dependency>

        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>${aspectjweaver.version}</version>
        </dependency>

        <!-- json相关依赖 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>${fastjson.version}</version>
        </dependency>

        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-core</artifactId>
            <version>${jackson.version}</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>${jackson.version}</version>
        </dependency>

        <!-- mysql依赖 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql.version}</version>
        </dependency>

        <!-- mybatis依赖 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>${mybatis.version}</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>${spring.mybatis.version}</version>
        </dependency>

        <dependency>
            <groupId>commons-dbcp</groupId>
            <artifactId>commons-dbcp</artifactId>
            <version>${commons-dbcp.version}</version>
        </dependency>

        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
            <version>${commons-fileupload.version}</version>
        </dependency>

        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>${javax.servlet.version}</version>
        </dependency>

        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.2</version>
        </dependency>

        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

    </dependencies>
</project>

2、修改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"
         id="WebApp_ID" version="3.0">

    <display-name>springmvc</display-name>

    <!-- 指定Spring Bean的配置文件所在目录。默认配置在WEB-INF目录下 -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath*:/spring/spring-*.xml</param-value>
    </context-param>

    <!-- 启动web容器时，自动装配spring的配置信息 -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <!-- spring核心 -->
    <servlet>
        <servlet-name>dispatcher</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <!-- 自定义servlet.xml配置文件的位置和名称，默认为WEB-INF目录下，名称为[<servlet-name>]-servlet.xml，如spring-servlet.xml -->
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath*:/spring/spring-servlet.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcher</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <filter>
        <description>字符编码过滤器</description>
        <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>
</web-app>

3、在resources目录下新建config，spring目录；在config下新建jdbc.properties文件，里面存放数据库配置信息，在spring下新建spring-application.xml及spring-servlet.xml文件（配置DispatchServlet时指定的文件），配置文件具体内容如下

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/springmvc?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
jdbc.username=root
jdbc.password=123456

dbcp.maxIdle=2
dbcp.maxActive=8
dbcp.defaultAutoCommit=false
dbcp.timeBetweenEvictionRunsMillis=30000
dbcp.minEvictableIdleTimeMillis=600000

spring-servlet.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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">

    <description>Spring-web MVC配置</description>

    <!-- 配置spring视图解析器，因为后面我使用的都是ajax模式的请求，所以这里不配置也不碍事 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
        <property name="prefix" value="/pages/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
</beans>

spring-application.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">

    <description>Spring公共配置文件</description>

    <!-- 对所有类进行扫描，以完成Bean创建和自动依赖注入的功能 -->
    <context:component-scan base-package="com.springmvc"/>

    <!-- 激活@Controller模式 -->
    <mvc:annotation-driven/>

    <aop:aspectj-autoproxy proxy-target-class="true"/>

    <!-- 静态资源 -->
    <mvc:default-servlet-handler/>

    <context:property-placeholder location="classpath:config/jdbc.properties"></context:property-placeholder>

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="maxActive" value="${dbcp.maxActive}"/>
        <property name="maxIdle" value="${dbcp.maxIdle}"/>
        <property name="defaultAutoCommit" value="${dbcp.defaultAutoCommit}"/>
        <property name="timeBetweenEvictionRunsMillis" value="${dbcp.timeBetweenEvictionRunsMillis}"/>
        <property name="minEvictableIdleTimeMillis" value="${dbcp.minEvictableIdleTimeMillis}"/>
    </bean>

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="select*" read-only="false"/>
            <tx:method name="find*" read-only="false"/>
            <tx:method name="get*" read-only="false"/>
            <tx:method name="update*" propagation="REQUIRED"/>
            <tx:method name="insert*" propagation="REQUIRED"/>
            <tx:method name="save*" propagation="REQUIRED"/>
            <tx:method name="add*" propagation="REQUIRED"/>
            <tx:method name="del*" propagation="REQUIRED"/>
            <tx:method name="*"/>
        </tx:attributes>
    </tx:advice>

    <aop:config proxy-target-class="true">
        <aop:pointcut id="interceptorPointCuts"
                      expression="execution(* com.springmvc.service.*.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="interceptorPointCuts"/>
    </aop:config>

    <!-- 解析上传文件 -->
    <bean id="multipartResolver"
          class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
        <property name="defaultEncoding" value="UTF-8"/>
        <!-- 指定所上传文件的总大小不能超过50M。注意maxUploadSize属性的限制不是针对单个文件，而是所有文件的容量之和 -->
        <property name="maxUploadSize" value="52428800"/>
    </bean>

    <bean id="multipartFilter"
          class="org.springframework.web.multipart.support.MultipartFilter">
        <property name="multipartResolverBeanName" value="multipartResolver"></property>
    </bean>
</beans>

省略部分创建java package及class的过程，至此，SpringMVC环境搭建完毕。

5、整合MyBatis，修改spring-application.xml文件即可，具体内容如下（所需依赖前面已经一起引入）

    <!-- 此处省略部分 -->

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="mapperLocations">
            <list>
                <value>classpath:mapper/*.xml</value>
            </list>
        </property>
    </bean>

    <!-- 扫描basePackage下所有以@MyBatisRepository标识的 接口 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        <property name="basePackage" value="com.springmvc.dao"/>
        <property name="annotationClass" value="com.springmvc.commons.MyBatisRepository"/>
    </bean>
    <!-- 此处省略部分 -->
</beans>

到此SpringMVC搭建及整合MyBatis已经全部完成，所以具体其他代码如下，也可直接下载源码查看

Constant.java

public class Constant {
    public static final int SUCCESS_CODE = 0;
    public static final int ERROR_CODE = 1;
    public static final String PARM_MISSING = "缺少必要参数";
}

JsonResult.java

import java.util.HashMap;

public class JsonResult {

    public static Object success() {
        HashMap<String, Object> map = new HashMap<String, Object>();
        map.put("code", Constant.SUCCESS_CODE);

        return map;
    }

    public static Object success(Object object) {
        HashMap<String, Object> map = new HashMap<String, Object>();
        map.put("code", Constant.SUCCESS_CODE);
        map.put("data", object);

        return map;
    }

    public static Object fail() {
        HashMap<String, Object> map = new HashMap<String, Object>();
        map.put("code", Constant.ERROR_CODE);

        return map;
    }

    public static Object fail(Object object) {
        HashMap<String, Object> map = new HashMap<String, Object>();
        map.put("code", Constant.ERROR_CODE);
        map.put("data", object);

        return map;
    }
}

MyBatisRepository

import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;

/**
 * 自定义注解，方便{@link org.mybatis.spring.mapper.MapperScannerConfigurer}的扫描
 */
@Target(ElementType.TYPE)
@Retention(RetentionPolicy.RUNTIME)
public @interface MyBatisRepository {

}

UserController.java

import com.springmvc.commons.JsonResult;
import com.springmvc.pojo.User;
import com.springmvc.service.IUserService;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import java.util.ArrayList;
import java.util.List;

@RestController
@RequestMapping("/user")
public class UserController {
    private static List<String> userList = new ArrayList<String>();

    @Resource
    private IUserService userService;

    @RequestMapping("/login")
    public Object login(HttpServletRequest req, User user) {
        System.out.println("login:" + user);
        if (!StringUtils.isEmpty(user.getUsername())) {
            userService.insert(user);
        }

        req.getSession().setAttribute("username", user.getUsername());

        return JsonResult.success();
    }

    @RequestMapping("/getList")
    public Object getList(User user) {

        return JsonResult.success(userService.getList(user));
    }
}

<%@ page contentType="text/html; charset=UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>用户登录</title>
<script type="text/javascript" src="../js/jquery.min.js"></script>
<script type="text/javascript">
        $(document).ready(function () {
            $("#loginForm").submit(function (e) {
                $.ajax({
                    type: "POST",
                    url: "../user/login",
                    data: {
                        username: $("#username").val()
                    },
                    async: false,
                    dataType: "json",
                    success: function (result) {
                        window.location.href = "userList.jsp";
                    },
                    error: function () {
                        alert("访问接口异常");
                    }
                });
                return false;
            });
        });
    </script>
</head>
<body>
    <form id="loginForm">
        用户名：<input type="text" id="username" name="username" /> <input
            type="submit" value="登录" />
    </form>
</body>
</html>

userList.jsp

<%@ page contentType="text/html; charset=UTF-8" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>用户列表</title>
    <script type="text/javascript" src="../js/jquery.min.js"></script>
    <script type="text/javascript">
        $(function () {
            $.ajax({
                type: "GET",
                url: "../user/getList",
                async: false,
                dataType: "json",
                success: function (result) {
                    var userList = result.data;
                    for (var i = 0; i < userList.length; i++) {
                        $("#userlist-ul").append("<li>" + userList[i].username + "</li>");
                    }
                },
                error: function () {
                    alert("访问接口异常");
                }
            });
        });
    </script>
</head>
<body>
<a href="login.jsp"><font style="font-style: italic"></font>添加用户</a>
<br> 当前登录用户：<strong>${username}</strong><br> 用户列表:
<ul id="userlist-ul">
</ul>
</body>
</html>