Spring MVC + Spring + MyBatis 整合

使用ssm框架，肯定是web项目所以先来配web.xml

web.xml

配置Spring 项目启动而启动
配置Spring MVC前端控制器（加载SpringMVC.xml） 设置拦截规则

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">

<!-- 配置Spring随项目的启动而创键 -->

<context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:Config/bean*.xml</param-value>
</context-param>

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


 <!-- 配置Spring Mvc前端控制器 -->
 <servlet>
     <servlet-name>SpringMvc</servlet-name>
     <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
   <!-- 指定SpringMvc配置文件
      如果没有配置那么默认找/WEB-INF/[servlet的名称]-servlet.xml
      (即：classpath:[servlet的名称]-servlet.xml)
   -->
   <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:Config/SpringMvc.xml</param-value>
   </init-param>
 </servlet>

 <!-- 映射 -->
 <servlet-mapping>
     <servlet-name>SpringMvc</servlet-name>
   <!-- 拦截规则：（适用于SpringMvc)
      1. /* 拦截所有 包括jsp js png css

      2. *.action  *.do 拦截以do action 结尾的请求
      3. /  拦截所有（不包括jsp) （包含js png css）
    -->
     <url-pattern>*.action</url-pattern>
 </servlet-mapping>

</web-app>

SpringMVC.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-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">

   <!-- 注解扫描 -->
   <context:component-scan base-package="com.Google.controller" />

   <!-- 注解驱动  作用：默认处理器映射器与处理器适配器已不推荐使用
(使用此配置将处理器映射器与处理器适配器的实现类换成新的)-->
   <mvc:annotation-driven />

   <!-- 配置视图解析器 -->
   <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
      <!-- 配置逻辑视图的前缀 -->
      <property name="prefix" value="/WEB-INF/jsp/" />
      <!-- 配置逻辑视图的后缀 -->
      <property name="suffix" value=".jsp" />
   </bean>

</beans>

到此Spring+SpringMVC整合完成

下面是Spring+MyBatis

MyBatis总配置文件

SqlMapConfig.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="mapper.UserMapper">

   <select id="findUserById" parameterType="Integer" resultType="user">
      select * from user where id = #{id}
   </select>

</mapper>

Mapper.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="mapper.UserMapper">

    <select id="findUserById" parameterType="Integer" resultType="user">
        select * from user where id = #{id}
    </select>

</mapper>

DB.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/springmvc
jdbc.username=root
jdbc.password=root

bean.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: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.xsd
         http://www.springframework.org/schema/context
         http://www.springframework.org/schema/context/spring-context.xsd
         http://www.springframework.org/schema/aop
         http://www.springframework.org/schema/aop/spring-aop.xsd
         http://www.springframework.org/schema/tx
         http://www.springframework.org/schema/tx/spring-tx.xsd">

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

    <!-- 将数据库连接池交由Spring管理 -->
   <bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" >
      <property name="jdbcUrl" value="${jdbc.url}"></property>
      <property name="driverClass" value="${jdbc.driver}"></property>
      <property name="user" value="${jdbc.username}"></property>
      <property name="password" value="${jdbc.password}"></property>
   </bean>

   <!-- MyBatis工厂 -->
   <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
      <!-- 注入数据源 -->
      <property name="dataSource" ref="dataSource"></property>
      <!-- MyBatis核心配置文件的位置 -->
      <property name="configLocation" value="classpath:config/SqlMapConfig.xml"></property>
   </bean>

   <!-- Mapper动态代理开发增强  扫描
      不需要手动注入工厂，他会去Spring容器中自己找
    -->
   <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
   <!-- 自动从指定包下扫描mapper代理接口 加入到容器-->
      <property name="basePackage" value="com.Google.mapper"></property>
   </bean>

</beans>

jar包依赖
pom.xml

<dependencies>

     <!-- Spring MVC -->
         <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-webmvc</artifactId>
    <version>4.2.4.RELEASE</version>
</dependency>

      <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

     <!-- junit测试 -->
     <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.9</version>
      <scope>test</scope>
    </dependency>

<!-- MyBatis -->
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.2.7</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.mybatis/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>
         <dependency>
    <groupId>com.mchange</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.2.1</version>
</dependency>

<!-- Spring -->
  <!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-aspects</artifactId>
    <version>4.2.4.RELEASE</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.springframework/spring-core -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-core</artifactId>
    <version>4.2.4.RELEASE</version>
</dependency>

<dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-log4j12</artifactId>
    <version>1.7.25</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.2.4.RELEASE</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.springframework/spring-orm -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-orm</artifactId>
    <version>4.2.4.RELEASE</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-test</artifactId>
    <version>4.2.4.RELEASE</version>
</dependency>

<!-- https://mvnrepository.com/artifact/org.springframework/spring-web -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-web</artifactId>
    <version>4.2.4.RELEASE</version>
</dependency>

    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>4.2.4.RELEASE</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-beans</artifactId>
    <version>4.2.4.RELEASE</version>
</dependency>

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-expression</artifactId>
    <version>4.2.4.RELEASE</version>
</dependency>

  </dependencies>

ssm整合完毕