基于Spring MVC+Mybaits的集成

梦里梦外; 2022-07-12 05:21 183阅读 0赞

在我们开发web项目的时候，我们不断的集成框架。比如我就从一开始的Servlet+DButils到Struts2+SpringMVC+Hibernate，

然后又集成JPA。发现自己开发的时候用Struts2开发太慢，就从Struts2到Spring MVC的转换。

每次集成框架，总会有更加让自己的开发变得便捷。比如，用了JPA+Hibernate之后，对于合适的项目开发非常快。后来，由于项目需要，发现Hibernate的查询不太灵活，会配置双数据源、双ORM。

用来用去，最后还是觉得 Spring MVC+mybatis才是最适合大多数项目的。如何合适，Spring MVC+Hiberante+JPA是开发最快的（对于小型项目（当然，还有JFinal...））

在此，我要分享一套自己的Spring MVC + Mybatis 开发脚手架，可以让你马上进入开发状态。其实我们每个人都应该整理一套自己的集成。方便使用，毕竟东西那么多，每次看笔记配置也是很麻烦的。

先放上代码的的github仓库吧

[https://github.com/yuyufeng/][https_github.com_yuyufeng]ssm[\-scaf][https_github.com_yuyufeng]

项目所用的依赖：

<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</groupId>
        <artifactId>yyf</artifactId>
        <packaging>war</packaging>
        <version>1.0-SNAPSHOT</version>
        <name>yyf Maven Webapp</name>
        <url>http://maven.apache.org</url>
    
        <properties>
            <spring-version>4.1.7.RELEASE</spring-version>
        </properties>
    
        <dependencies>
            <dependency>
                
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.11</version>
                <scope>test</scope>
            </dependency>
            
            
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-api</artifactId>
                <version>1.7.7</version>
            </dependency>
            <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-core</artifactId>
                <version>1.1.7</version>
            </dependency>
            
            <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-classic</artifactId>
                <version>1.1.7</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.6</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.0.15</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.3.0</version>
            </dependency>
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper</artifactId>
                <version>4.0.1</version>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.2.3</version>
            </dependency>
            
            <dependency>
                <groupId>taglibs</groupId>
                <artifactId>standard</artifactId>
                <version>1.1.2</version>
            </dependency>
            <dependency>
                <groupId>jstl</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>2.5.0</version>
            </dependency>
            <dependency>
                <groupId>net.sf.ezmorph</groupId>
                <artifactId>ezmorph</artifactId>
                <version>1.0.4</version>
            </dependency>
            <dependency>
                <groupId>net.sf.json-lib</groupId>
                <artifactId>json-lib</artifactId>
                <classifier>jdk15</classifier>
                <version>2.4</version>
            </dependency>
    
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>3.1.0</version>
            </dependency>
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>jsp-api</artifactId>
                <version>2.2</version>
                <scope>provided</scope>
            </dependency>
            
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>${spring-version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-beans</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-jdbc</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-web</artifactId>
                <version>${spring-version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>${spring-version}</version>
            </dependency>
    
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-validator</artifactId>
                <version>4.1.0.Final</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>${spring-version}</version>
            </dependency>
    
    
            
            <dependency>
                <groupId>commons-io</groupId>
                <artifactId>commons-io</artifactId>
                <version>2.4</version>
            </dependency>
            <dependency>
                <groupId>commons-fileupload</groupId>
                <artifactId>commons-fileupload</artifactId>
                <version>1.3.1</version>
            </dependency>
    
    
            
            <dependency>
                <groupId>commons-collections</groupId>
                <artifactId>commons-collections</artifactId>
                <version>3.2.2</version>
            </dependency>
        </dependencies>
        <build>
            <finalName>yyf</finalName>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <excludes>
                        <exclude>generator*.*</exclude>
                    </excludes>
                </resource>
            </resources>
    
            <plugins>
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.3</version>
                </plugin>
    
    
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <version>3.1</version>
                    <configuration>
                        <source>1.8</source>
                        <target>1.8</target>
                        <encoding>utf8</encoding>
                    </configuration>
                </plugin>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-surefire-plugin</artifactId>
                    <version>2.19</version>
                    <configuration>
                        
                        <skip>true</skip>
                        <argLine>-Dfile.encoding=UTF-8</argLine>
                    </configuration>
                </plugin>
    
                <plugin>
                    <groupId>org.mortbay.jetty</groupId>
                    <artifactId>maven-jetty-plugin</artifactId>
                    <version>6.1.10</version>
                   
                </plugin>
    
    
            </plugins>
        </build>
    
    </project>

基本的sql，

SET FOREIGN_KEY_CHECKS=0;
    
    -- ----------------------------
    -- Table structure for role_info
    -- ----------------------------
    DROP TABLE IF EXISTS `role_info`;
    CREATE TABLE `role_info` (
      `role_id` int(10) NOT NULL AUTO_INCREMENT,
      `role_name` varchar(30) DEFAULT NULL,
      PRIMARY KEY (`role_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Table structure for user_info
    -- ----------------------------
    DROP TABLE IF EXISTS `user_info`;
    CREATE TABLE `user_info` (
      `user_id` bigint(15) NOT NULL AUTO_INCREMENT,
      `user_name` varchar(50) DEFAULT NULL,
      `user_role` int(10) DEFAULT NULL,
      `create_time` datetime DEFAULT NULL,
      PRIMARY KEY (`user_id`),
      KEY `user_role` (`user_role`)
    ) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8;

实体类很简单，只有用户和角色，执行ssm\\src\\test\\main\\java\\dao\\UserInfoMapperTest.java中的添加，插入一批用户数据

接着，在service.UserServiceTest中单元测试分页查询

##UserInfo{userId=118, userName='用户0', userRole=1, createTime=Mon Feb 13 09:34:17 CST 2017}
    ##UserInfo{userId=119, userName='用户1', userRole=1, createTime=Mon Feb 13 09:34:17 CST 2017}
    ##UserInfo{userId=120, userName='用户2', userRole=1, createTime=Mon Feb 13 09:34:17 CST 2017}
    ##UserInfo{userId=121, userName='用户3', userRole=1, createTime=Mon Feb 13 09:34:17 CST 2017}
    ##UserInfo{userId=122, userName='用户4', userRole=1, createTime=Mon Feb 13 09:34:17 CST 2017}
    ##UserInfo{userId=123, userName='用户5', userRole=1, createTime=Mon Feb 13 09:34:17 CST 2017}
    ##UserInfo{userId=124, userName='用户6', userRole=1, createTime=Mon Feb 13 09:34:17 CST 2017}
    ##UserInfo{userId=125, userName='用户7', userRole=1, createTime=Mon Feb 13 09:34:17 CST 2017}
    ##UserInfo{userId=126, userName='用户8', userRole=1, createTime=Mon Feb 13 09:34:17 CST 2017}
    ##UserInfo{userId=127, userName='用户9', userRole=1, createTime=Mon Feb 13 09:34:18 CST 2017}

然后先启动项目吧，

项目可以配置到tomcat中启动，但是我更推荐在jetty容器中。2秒热部署，开发快。

<plugin>
                    <groupId>org.mortbay.jetty</groupId>
                    <artifactId>maven-jetty-plugin</artifactId>
                    <version>6.1.10</version>
                    <configuration>
                        <scanIntervalSeconds>2</scanIntervalSeconds>
                    </configuration>
                </plugin>

启动成功后，浏览器输入路径，测试是用户分页列表的json数据

http://localhost:8080/yyf/user/list-json/2

{
        "success": true,
        "data": {
            "pageNum": 0,
            "pageSize": 0,
            "size": 0,
            "startRow": 0,
            "endRow": 0,
            "total": 0,
            "pages": 0,
            "list": [
                {
                    "userId": 128,
                    "userName": "用户10",
                    "userRole": 1,
                    "createTime": 1486949658000
                },
                {
                    "userId": 129,
                    "userName": "用户11",
                    "userRole": 1,
                    "createTime": 1486949658000
                },
                {
                    "userId": 130,
                    "userName": "用户12",
                    "userRole": 1,
                    "createTime": 1486949658000
                },
                {
                    "userId": 131,
                    "userName": "用户13",
                    "userRole": 1,
                    "createTime": 1486949658000
                },
                {
                    "userId": 132,
                    "userName": "用户14",
                    "userRole": 1,
                    "createTime": 1486949658000
                },
                {
                    "userId": 133,
                    "userName": "用户15",
                    "userRole": 1,
                    "createTime": 1486949658000
                },
                {
                    "userId": 134,
                    "userName": "用户16",
                    "userRole": 1,
                    "createTime": 1486949658000
                },
                {
                    "userId": 135,
                    "userName": "用户17",
                    "userRole": 1,
                    "createTime": 1486949658000
                },
                {
                    "userId": 136,
                    "userName": "用户18",
                    "userRole": 1,
                    "createTime": 1486949658000
                },
                {
                    "userId": 137,
                    "userName": "用户19",
                    "userRole": 1,
                    "createTime": 1486949658000
                }
            ],
            "firstPage": 0,
            "prePage": 0,
            "nextPage": 0,
            "lastPage": 0,
            "isFirstPage": false,
            "isLastPage": false,
            "hasPreviousPage": false,
            "hasNextPage": false,
            "navigatePages": 0,
            "navigatepageNums": null
        },
        "error": null
    }

返回json串，脚手架项目启动成功。

脚手架具体内容：

1.使用了mybaits generator，可以数据库反向生成java实体类和dao

2.使用了pageHelp，方便分页查询

3.logback日志集成

反正涵盖了基本开发所需要的

[https_github.com_yuyufeng]: https://github.com/yuyufeng1994/ssm-scaf