整合Spring+SpringMVC+MyBatis
来源：互联网 发布：淘宝pc端优惠券地址 编辑：程序博客网 时间：2024/06/17 10:56
这次整合利用了maven的环境，对于maven环境搭建和项目创建大家可以先百度一下。
下面先上图看一下大概的目录结构，最后会附上源代码
1、导入项目所需的jar包
pom.xml
<properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <spring-version>3.1.1.RELEASE</spring-version> <!-- log4j日志文件管理包版本 --> <org.slf4j.version>1.6.1</org.slf4j.version> <logback.version>1.0.7</logback.version> </properties> <dependencies> <!-- SpringMVC返回json数据 --> <dependency> <groupId>org.codehaus.jackson</groupId> <artifactId>jackson-mapper-asl</artifactId> <version>1.9.5</version> </dependency> <!-- mybatis/spring包 --> <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.38</version> </dependency> <!-- mybatis核心包 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.2.6</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring-version}</version> </dependency> <dependency> <groupId>commons-pool</groupId> <artifactId>commons-pool</artifactId> <version>1.6</version> </dependency> <dependency> <groupId>commons-collections</groupId> <artifactId>commons-collections</artifactId> <version>3.2.1</version> </dependency> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <dependency> <groupId>cglib</groupId> <artifactId>cglib-nodep</artifactId> <version>2.2</version> </dependency> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>1.8.9</version> </dependency> <dependency> <groupId>org.apache.geronimo.bundles</groupId> <artifactId>aspectjrt</artifactId> <version>1.6.2_1</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aop</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-context</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-web</artifactId> <version>${spring-version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>${spring-version}</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> <!-- 日志文件管理包 --> <!-- slfj+logback --> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>${org.slf4j.version}</version> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> <version>${logback.version}</version> <type>jar</type> <scope>compile</scope> </dependency> <dependency> <groupId>ch.qos.logback</groupId> <artifactId>logback-core</artifactId> <version>${logback.version}</version> <type>jar</type> <scope>compile</scope> </dependency> </dependencies>2、Spring与MyBatis的整合
（配置文件） 
2.1 建立JDBC属性文件
jdbc.properties
driver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/selfdatabase?useUnicode=true&characterEncoding=utf-8user=rootpassword=tiger#初始连接数initialSize=2#最大连接数 maxActive=10 #最大空间maxIdle=3 #最小空间minIdle=2 #最长等待时间 maxWait=6000 #测试/验证连接池连接的SQL语句validationQuery=select 1 #连接的超时时间，默认半小时timeBetweenEvictionRunsMillis=3600000 #进行连接空闲时间判断，若为0，对空闲的连接不进行验证minEvictableIdleTimeMillis=18000000 testOnBorrow=true2.2建立dataAccessContext.xml配置文件
dataAccessContext.xml包含Spring与MyBatis的配置信息，主要是配置数据库、自动扫描、自动注入
dataAccessContext.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" 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/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-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.0.xsd"> <!-- 引入数据库配置文件 --> <context:property-placeholder location="classpath*:config/jdbc.properties" /> <!-- 数据源=连接池 --> <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="${user}" /> <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> </bean> <!-- JDBC事务管理器 --> <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <!-- 切面 --> <!-- 注意execution第一个*后面要有空格 --> <aop:config> <aop:pointcut id="point" expression="execution(* service..*ServiceImpl.*(..))" /> <aop:advisor advice-ref="txAdvice" pointcut-ref="point" /> </aop:config> <!-- spring与mybatis整合，不需要mybatis的配置文件 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"></property> <!-- 自动扫描mapper.xml文件 --> <property name="mapperLocations" value="classpath*:sql/*.xml"></property> </bean> <!-- dao接口所在包名，Spring会自动查找其下的类 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="*"></property> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property> </bean> <!-- 事务的通知 --> <tx:advice id="txAdvice" transaction-manager="txManager"> <tx:attributes> <tx:method name="save*" propagation="REQUIRED" rollback-for="java.lang.Exception" /> <tx:method name="update*" propagation="REQUIRED" rollback-for="java.lang.Exception" /> <tx:method name="edit*" propagation="REQUIRED" rollback-for="java.lang.Exception" /> <tx:method name="delete*" propagation="REQUIRED" rollback-for="java.lang.Exception" /> <tx:method name="add*" propagation="REQUIRED" rollback-for="java.lang.Exception" /> <tx:method name="remove*" propagation="REQUIRED" rollback-for="java.lang.Exception" /> <tx:method name="produce*" propagation="REQUIRED" rollback-for="java.lang.Exception" /> <tx:method name="create*" propagation="REQUIRED" rollback-for="java.lang.Exception" /> <tx:method name="insert*" propagation="REQUIRED" rollback-for="java.lang.Exception" /> </tx:attributes> </tx:advice></beans>2.3 配置logback
调试过程中，常使用日志来输出信息。logback是一个开源日志组件，配置简单，使用方便。不配置也不影响框架的整合
logback.properties
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE configuration><configuration scan="true" scanPeriod="1 seconds"> <property name="LOG_HOME" value="E:/dev/workspace/log" /> <property name="CONTEXT_NAME" value="/SSM" /> <!-- 控制台输出日志 --> <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender"> <encoder> <pattern>%-5level %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %logger{100}[line:%L] - %msg%n</pattern> </encoder> </appender> <!-- 文件输出日志 (文件大小策略进行文件输出，超过指定大小对文件备份) --> <appender name="ERROR" class="ch.qos.logback.core.rolling.RollingFileAppender"> <filter class="ch.qos.logback.classic.filter.LevelFilter"> <level>ERROR</level> <OnMismatch>DENY</OnMismatch> <OnMatch>ACCEPT</OnMatch> </filter> <File>${LOG_HOME}/${CONTEXT_NAME}/error.log</File> <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> <FileNamePattern>${LOG_HOME}/${CONTEXT_NAME}/error.%d{yyyy-MM-dd}.log</FileNamePattern> </rollingPolicy> <maxHistory>90</maxHistory> <!-- keep 90 days --> <layout class="ch.qos.logback.classic.PatternLayout"> <Pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{100}[line:%L] - %msg%n</Pattern> </layout> </appender> <appender name="DEBUG" class="ch.qos.logback.core.rolling.RollingFileAppender"> <filter class="ch.qos.logback.classic.filter.LevelFilter"> <level>DEBUG</level> <OnMismatch>DENY</OnMismatch> <OnMatch>ACCEPT</OnMatch> </filter> <File>${LOG_HOME}/${CONTEXT_NAME}/debug.log</File> <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy"> <FileNamePattern>${LOG_HOME}/${CONTEXT_NAME}/debug.%d{yyyy-MM-dd}.log</FileNamePattern> </rollingPolicy> <maxHistory>90</maxHistory> <!-- keep 90 days --> <layout class="ch.qos.logback.classic.PatternLayout"> <Pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{100}[line:%L] - %msg%n</Pattern> </layout> </appender> <logger name="Test" level="DEBUG" /> <logger name="org.apache" level="DEBUG" /> <logger name="org.springframework" level="DEBUG" /> <logger name="ch.qos.logback" level="DEBUG" /> <root level="DEBUG"> <appender-ref ref="STDOUT" /> <appender-ref ref="ERROR" /> <appender-ref ref="DEBUG" /> </root></configuration>（数据库表结构）
2.4 user.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="dao.UserDao"> <!-- namespace对应dao类 --> <resultMap id="userObjectMap" type="pojo.User"> <!-- type对应pojo的user实体类 --> <result property="username" column="USERNAME" /> <!-- property对应user的属性，column对应数据表的表元素 --> <result property="password" column="PASSWORD" /> </resultMap> <select id="getUserAccount" resultMap="userObjectMap"> SELECT * FROM T_USER </select></mapper>（java代码） 
2.5 pojo层存放实体类
User.java
public class User { private String username; private String password; public String getName() { return username; } public void setName(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public User() { super(); } @Override public String toString() { return "User [username=" + username + ", password=" + password + "]"; }}2.6 IUserService.java
import java.util.List;import pojo.User;public interface IUserService { public List<User> getUserAccount();}UserServiceImpl.java
import java.util.List;import javax.annotation.Resource;import org.springframework.stereotype.Service;import dao.UserDao;import pojo.User;import service.IUserService;@Service("UserServiceImpl")public class UserServiceImpl implements IUserService{ @Resource UserDao userDao; public List<User> getUserAccount() { return userDao.getUserAccount(); }}至此，Spring与MyBatis的整合已完成，大家可以使用JUnit4来测试一下
3、整合SpringMVC
3.1 配置spring-mvc.xml文件（启用注释扫描并生效）
spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:aop="http://www.springframework.org/schema/aop" 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-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/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd"> <!-- 启用并且扫描注解 --> <context:component-scan base-package="*" /> <!-- 让请求与注解映射生效 --> <mvc:annotation-driven /></beans>3.2 配置web.xml
web.xml
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.4" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"> <servlet> <servlet-name>dispatcherServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath*:spring/*.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>dispatcherServlet</servlet-name> <url-pattern>*.do</url-pattern> </servlet-mapping> <display-name>Archetype Created Web Application</display-name></web-app>3.3 UserController.java
import java.util.List;import javax.annotation.Resource;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import pojo.User;import service.IUserService;@Controller@RequestMapping("/user")public class UserController { @Resource(name="UserServiceImpl") IUserService userService; @RequestMapping("/getUserAccount") public void getUserAccount(){ List<User> user=userService.getUserAccount(); for(int i=0;i<user.size();i++){ System.out.println(user.get(i).toString()); } }}4、测试
SSM三大框架的整合已经完成啦，可以启动tomcat测试一下
数据库表信息： 
网址： 
控制台输出：
源码下载地址：http://pan.baidu.com/s/1pLjpoSV
0 0
- Spring-SpringMVC-Mybatis整合
- springmvc+spring+mybatis整合
- springmvc+spring+mybatis整合
- Spring+SpringMVC+Mybatis整合
- springmvc+mybatis+spring整合
- springmvc+spring+mybatis 整合
- mybatis+springmvc+spring 整合
- SpringMVC+Spring+Mybatis整合
- springmvc+spring+mybatis 整合
- springmvc+spring+mybatis整合
- Spring+Springmvc+MyBatis整合
- Spring+Springmvc+MyBatis整合
- Spring+Springmvc+MyBatis整合
- springmvc+mybatis+spring 整合
- springmvc+mybatis+spring 整合
- spring+springMVC+Mybatis整合
- spring springmvc mybatis 整合
- springmvc+mybatis+spring整合
- Spring JPA 复杂条件查询
- IntelliJ IDEA
- jQuery快速高效制作网页交互特效第五章课后4
- Linux下安装Redis并添加PHP扩展(自己测试了没有问题)
- MarkDown 语法手册
- 整合Spring+SpringMVC+MyBatis
- Timer实例
- Android Studio利用Gradle删除没有使用到的资源和代码文件
- java对象和json对象之间互相转换（下）
- ssm搭建笔记
- Android开发报Can't create handler inside thread that has not called Looper.prepare()错误
- mybatis+spring的TODO小项目记录（六）使用mybatis进行数据库操作
- Java并发编程：volatile关键字解析
- node 系列（一）
