搭建一套简单的结合Spring、SpringMVC与mybatis架构的模型

1、需求背景

部门需要做一套docker的自动化部署工具

2、前期准备

安装eclipse、jdk1.7、tomcat7

3、开发环境搭建

3.1、创建项目

File->New->Maven Project

Next

Group Id 可以填公司部门项目组名称；ArtifactId 为项目名称，这里Group Id为com.cn.hnust；Artifact Id为ideploy，点Finished。

 

注意：若此处出现下载错误，则可能是由于下载源的问题，可以通过修改setting.xml文件解决。具体方法是将window->preferences 找到Maven->UserSettings 修改为如下setting.xml。

<settingsxmlns="http://maven.apache.org/SETTINGS/1.0.0" 

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 

        xsi:schemaLocation="http://maven.apache.org/SETTINGS/1.0.0 

           http://maven.apache.org/xsd/settings-1.0.0.xsd"> 

     

    <!-- 这个是配置阿里Maven镜像 --> 

    <mirrors> 

        <mirror> 

          <id>aliyun</id> 

         <name>aliyun</name> 

         <url>http://maven.aliyun.com/nexus/content/groups/public/</url> 

         <mirrorOf>central</mirrorOf> 

        </mirror> 

    </mirrors> 

     

    <profiles> 

        <profile> 

            <id>nexus</id> 

           <repositories> 

               <repository> 

                   <id>central</id> 

                   <url>http://repo.maven.apache.org/maven2</url> 

                   <snapshots> 

                       <enabled>false</enabled> 

                   </snapshots> 

               </repository> 

               <repository> 

                   <id>ansj-repo</id> 

                   <name>ansj Repository</name> 

                   <url>http://maven.nlpcn.org/</url> 

                   <snapshots> 

                       <enabled>false</enabled> 

                   </snapshots> 

               </repository> 

           </repositories> 

        </profile> 

    </profiles> 

 

    <activeProfiles> 

        <activeProfile>nexus</activeProfile> 

    </activeProfiles> 

</settings>

 

3.2、maven引入jar包

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.0http://maven.apache.org/maven-v4_0_0.xsd">

              <modelVersion>4.0.0</modelVersion>

              <groupId>ideploy</groupId>

              <artifactId>ideploy</artifactId>

              <packaging>war</packaging>

              <version>2.0.1</version>

              <properties>

                            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

                            <maven.build.timestamp.format>yyyyMMddHHmmss</maven.build.timestamp.format>

                            <spring.version>4.0.2.RELEASE</spring.version>

                            <mybatis.version>3.2.6</mybatis.version> 

        <slf4j.version>1.7.7</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> 

        <!-- spring核心包 --> 

        <dependency> 

            <groupId>org.springframework</groupId> 

            <artifactId>spring-core</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-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-webmvc</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-support</artifactId> 

            <version>${spring.version}</version> 

        </dependency> 

        <dependency> 

            <groupId>org.springframework</groupId> 

            <artifactId>spring-test</artifactId> 

            <version>${spring.version}</version> 

        </dependency> 

        <!-- mybatis核心包 -->

        <dependency> 

            <groupId>org.mybatis</groupId> 

            <artifactId>mybatis</artifactId> 

            <version>${mybatis.version}</version> 

        </dependency>

        <!-- mybatis/spring包 --> 

        <dependency> 

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis-spring</artifactId> 

            <version>1.2.2</version> 

        </dependency> 

        <!-- 导入java ee jar 包 --> 

        <dependency> 

            <groupId>javax</groupId> 

            <artifactId>javaee-api</artifactId> 

            <version>7.0</version> 

        </dependency> 

        <!-- 导入Mysql数据库链接jar包 --> 

        <dependency> 

            <groupId>mysql</groupId> 

            <artifactId>mysql-connector-java</artifactId> 

            <version>5.1.30</version> 

        </dependency> 

        <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 --> 

        <dependency> 

            <groupId>commons-dbcp</groupId> 

            <artifactId>commons-dbcp</artifactId> 

            <version>1.2.2</version> 

        </dependency> 

        <!-- JSTL标签类 --> 

        <dependency> 

            <groupId>jstl</groupId> 

            <artifactId>jstl</artifactId> 

            <version>1.2</version> 

        </dependency> 

        <!-- 日志文件管理包 --> 

        <!-- log start --> 

        <dependency> 

            <groupId>log4j</groupId> 

            <artifactId>log4j</artifactId> 

            <version>${log4j.version}</version> 

        </dependency> 

        <!-- 格式化对象，方便输出日志 --> 

        <dependency> 

            <groupId>com.alibaba</groupId> 

            <artifactId>fastjson</artifactId> 

            <version>1.1.41</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> 

        <!-- log end --> 

        <!-- 映入JSON --> 

        <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.9</version> 

        </dependency> 

    </dependencies> 

              <build>

                            <plugins>

                                          <plugin>

                                                        <artifactId>maven-compiler-plugin</artifactId>

                                                        <version>2.3.2</version>

                                                        <configuration>

                                                                      <source>1.7</source>

                                                                      <target>1.7</target>

                                                        </configuration>

                                          </plugin>

                                          <plugin>

                                                        <artifactId>maven-war-plugin</artifactId>

                                                        <version>2.2</version>

                                                        <configuration>

                                                                      <version>3.0</version>

                                                                      <failOnMissingWebXml>false</failOnMissingWebXml>

                                                        </configuration>

                                          </plugin>

                            </plugins>

                            <finalName>${project.artifactId}_${project.version}_${maven.build.timestamp}</finalName>

              </build>

</project>

3.3、spring整合mybatis

jdbc.properties

driver=com.mysql.jdbc.Driver

url=jdbc:mysql://192.168.23.65:3306/test

username=root

password=root

initialSize=0

maxActive=20

maxIdle=20

minIdle=1

maxWait=60000

 

log4j.properties

log4j.rootLogger=info, console, debug, app, error

###Console ###

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 = %d %p[%C:%L]- %m%n

 

### debug ### 

log4j.appender.debug = org.apache.log4j.DailyRollingFileAppender

log4j.appender.debug.File = log/debug.log

log4j.appender.debug.Append = true

log4j.appender.debug.Threshold = DEBUG

log4j.appender.debug.DatePattern='.'yyyy-MM-dd

log4j.appender.debug.layout = org.apache.log4j.PatternLayout

log4j.appender.debug.layout.ConversionPattern = %d %p[%c:%L] - %m%n

 

spring-mybatis.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"> 

    <!-- 自动扫描 --> 

    <context:component-scan base-package="com.cn.hnust"/> 

    <!-- 引入配置文件 --> 

    <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> 

    <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 --> 

    <bean id="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean"> 

        <property name="dataSource"ref="dataSource" /> 

        <!-- 自动扫描mapping.xml文件 --> 

        <property name="mapperLocations"value="classpath:com/cn/hnust/mapping/*.xml"></property> 

    </bean> 

    <!-- DAO接口所在包名，Spring会自动查找其下的类 --> 

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 

        <property name="basePackage"value="com.cn.hnust.dao" /> 

        <property name="sqlSessionFactoryBeanName"value="sqlSessionFactory"></property> 

    </bean> 

    <!-- (事务管理)transactionmanager, use JtaTransactionManager for global tx --> 

    <bean id="transactionManager" 

        class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 

        <property name="dataSource"ref="dataSource" /> 

    </bean> 

</beans>

3.4、建表插入测试数据

CREATE TABLE `user_t` (

              `id` INT (11) NOT NULL AUTO_INCREMENT,

              `user_name` VARCHAR (40) NOT NULL,

              `password` VARCHAR (255) NOT NULL,

              `age` INT (4) NOT NULL,

              PRIMARY KEY (`id`)

) ENGINE = INNODBAUTO_INCREMENT = 2 DEFAULT CHARSET = utf8;

 

insert  into `user_t`(`id`,`user_name`,`password`,`age`)values (1,'测试','sfasgfaf',24);

操作成功后，查表如下图

3.5、通过myBatis Generator自动创建代码

参考博文：http://blog.csdn.net/zhshulin/article/details/23912615

生成后将文件复制到项目中，如下图。

3.6、建立Service接口和实现类

IUserService.java

package com.cn.hnust.service;

import com.cn.hnust.pojo.User;

public interface IUserService {

    public User getUserById(int userId);

}

 

UserServiceImpl.java

package com.cn.hnust.service.impl;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.cn.hnust.dao.IUserDao;

import com.cn.hnust.pojo.User;

import com.cn.hnust.service.IUserService;

 

@Service("userService")

public class UserServiceImpl implements IUserService {

    @Resource

    private IUserDao userDao;

    public User getUserById(int userId){

        return this.userDao.selectByPrimaryKey(userId);

    }

}

3.7、建立测试类

测试类在src/test/java中建立，下面测试类中注释掉的部分是不使用Spring时，一般情况下的一种测试方法；如果使用了Spring那么就可以使用注解的方式来引入配置文件和类，然后再将service接口对象注入，就可以进行测试了。

 

如果测试成功，表示Spring和Mybatis已经整合成功了。输出信息使用的是Log4j打印到控制台。

TestMyBatis.java

package org.zsl.testmybatis;

import javax.annotation.Resource;

import org.apache.log4j.Logger;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.test.context.ContextConfiguration;

import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import com.alibaba.fastjson.JSON;

import com.cn.hnust.pojo.User;

import com.cn.hnust.service.IUserService;

 

@RunWith(SpringJUnit4ClassRunner.class) // 表示继承了SpringJUnit4ClassRunner类

@ContextConfiguration(locations = {"classpath:spring-mybatis.xml"})

public class TestMyBatis {

    private static Logger logger= Logger.getLogger(TestMyBatis.class);

    @Resource

    private IUserService userService= null;

    @Test

    public void test1() {

        User user = userService.getUserById(1);

        logger.info(JSON.toJSONString(user));

    }

}

测试结果

3.8、整合springMVC

3.8.1、配置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"> 

    <!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 --> 

    <context:component-scan base-package="com.cn.hnust.controller"/> 

    <!--避免IE执行AJAX时，返回JSON出现下载文件 --> 

    <bean id="mappingJacksonHttpMessageConverter" 

        class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter"> 

        <property name="supportedMediaTypes"> 

            <list> 

                <value>text/html;charset=UTF-8</value> 

            </list> 

        </property> 

    </bean> 

    <!-- 启动SpringMVC的注解功能，完成请求和注解POJO的映射 --> 

    <bean 

        class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"> 

        <property name="messageConverters"> 

            <list> 

                <ref bean="mappingJacksonHttpMessageConverter"/> <!-- JSON转换器 --> 

            </list> 

        </property> 

    </bean> 

    <!-- 定义跳转的文件的前后缀 ，视图模式配置--> 

    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> 

        <!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀，变成一个 可用的url地址 --> 

        <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>

3.8.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/javaeehttp://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" 

        version="3.0"> 

        <display-name>ArchetypeCreated Web Application</display-name> 

        <!-- Spring和mybatis的配置文件 --> 

        <context-param> 

            <param-name>contextConfigLocation</param-name> 

            <param-value>classpath:spring-mybatis.xml</param-value> 

        </context-param> 

        <!-- 编码过滤器 --> 

        <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> 

        <!-- Spring监听器 --> 

        <listener> 

            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> 

        </listener> 

        <!-- 防止Spring内存溢出监听器 --> 

        <listener> 

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

        </listener> 

        <!-- Spring MVC servlet--> 

        <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: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> 

            <!-- 此处可以可以配置成*.do，对应struts的后缀习惯 --> 

            <url-pattern>/</url-pattern> 

        </servlet-mapping> 

        <welcome-file-list> 

            <welcome-file>/index.jsp</welcome-file> 

        </welcome-file-list> 

    </web-app> 

注意：首行不要有空格。

3.9、测试

3.9.1、新建jsp页面showUser.jsp

<%@ page language="java" contentType="text/html;charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01Transitional//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>

<h2>用户列表</h2>

<table border="1">

<tr>

              <td>id</td>

              <td>user_name</td>

              <td>password</td>

              <td>age</td>

</tr>

<tr>

              <td>${user.id}</td>

              <td>${user.userName}</td>

              <td>${user.password}</td>

              <td>${user.age}</td>

</tr>

</table>

</body>

</html>

3.9.2、建立UserController类

package com.cn.hnust.controller;

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.cn.hnust.pojo.User;

import com.cn.hnust.service.IUserService;

@Controller

@RequestMapping("/user")

public class UserController {

    @Resource

    private IUserService userService;

    @RequestMapping("/showUser")

    public StringtoIndex(HttpServletRequest request, Model model) {

        int userId = Integer.parseInt(request.getParameter("id"));

        User user = this.userService.getUserById(userId);

        model.addAttribute("user",user);

        return "showUser";

    }

}

 

3.9.3、使用tomcat部署项目

点击finished后运行tomcat，浏览器输入http://localhost:8080/ideploy//user/showUser?id=1

3.10 项目目录结构

参考：http://blog.csdn.net/zhshulin