java培训课程之整合的配置

<?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_2_5.xsd" id="WebApp_ID" version="2.5">

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

 <filter>

        <filter-name>CharacterEncodingFilter</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>

 </filter>

 <filter-mapping>

        <filter-name>CharacterEncodingFilter</filter-name>

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

 </filter-mapping>

 <!-- REST 过滤器 -->

 <filter>

        <filter-name>HiddenHttpMethodFilter</filter-name>

        <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>

 </filter>

 <filter-mapping>

        <filter-name>HiddenHttpMethodFilter</filter-name>

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

 </filter-mapping>

<!-- 实例化SpringIOC容器的监听器 -->

         <context-param>

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

                  <param-value>classpath:applicationContext.xml</param-value>

         </context-param>

         <listener>

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

    </listener>

 <!-- Springmvc的前端控制器 -->

         <servlet>

                  <servlet-name>springDispatcherServlet</servlet-name>

                  <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

                  <init-param>

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

                          <param-value>classpath:springmvc.xml</param-value>

                  </init-param>

                  <load-on-startup>1</load-on-startup>

         </servlet>

         <servlet-mapping>

                  <servlet-name>springDispatcherServlet</servlet-name>

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

         </servlet-mapping>

</web-app>

<?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:context="http://www.springframework.org/schema/context"

         xmlns:tx="http://www.springframework.org/schema/tx"

         xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"

         xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd

                  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-4.0.xsd

                  http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">

         <!-- 组件扫描 -->

         <context:component-scan base-package="com.atguigu.ssm">

                  <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>

         </context:component-scan>

         <!-- 连接池 -->

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

         <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">

                  <property name="driverClass" value="${jdbc.driver}"></property>

                  <property name="jdbcUrl" value="${jdbc.url}"></property>

                  <property name="user" value="${jdbc.username}"></property>

                  <property name="password" value="${jdbc.password}"></property>

         </bean>

         <!-- 事务 -->

         <bean id="dataSourceTransactionManager"

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

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

         </bean>

        <tx:annotation-driven transaction-manager="dataSourceTransactionManager"/>

</beans>

<?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:context="http://www.springframework.org/schema/context"

         xmlns:mvc="http://www.springframework.org/schema/mvc"

         xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd

                  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-4.0.xsd">

  <!-- 组件扫描 -->

  <context:component-scan base-package="com.atguigu.ssm" use-default-filters="false">

           <context:include-filter type="annotation"

         expression="org.springframework.stereotype.Controller"/>

  </context:component-scan>

   <!--视图解析器 -->

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

         <property name="prefix" value="/WEB-INF/views/"></property>

         <property name="suffix" value=".jsp"></property>

   </bean>

   <mvc:default-servlet-handler/>

   <mvc:annotation-driven/>

</beans>

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE configuration

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

         <!--  Spring 整合 MyBatis 后， MyBatis中配置数据源，事务等一些配置都可以

         迁移到Spring的整合配置中。MyBatis配置文件中只需要配置与MyBatis相关

         的即可。

          -->

          <!-- settings: 包含很多重要的设置项      -->

            <settings>

                 <!-- 映射下划线到驼峰命名 -->

                 <setting name="mapUnderscoreToCamelCase" value="true"/>

                 <!-- 设置Mybatis对null值的默认处理 -->

                 <setting name="jdbcTypeForNull" value="NULL"/>

                 <!-- 开启延迟加载 -->

                 <setting name="lazyLoadingEnabled" value="true"/>

                 <!-- 设置加载的数据是按需还是全部 -->

                 <setting name="aggressiveLazyLoading" value="false"/>

                 <!-- 配置开启二级缓存 -->

                 <setting name="cacheEnabled" value="true"/>

          </settings>

</configuration>

<?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="com.atguigu.ssm.mapper.EmployeeMapper">

         <!-- public List<Employee> getAllEmps(); -->

         <select id="getAllEmps" resultMap="myEmpsAndDept" >

                  select e.id eid, e.last_name,e.email,e.gender, d.id did, d.dept_name

                  from tbl_employee e ,tbl_dept d

                  where e.d_id = d.id

         </select>

         <resultMap type="com.atguigu.ssm.beans.Employee" id="myEmpsAndDept">

                  <id column="eid" property="id"/>

                  <result column="last_name" property="lastName"/>

                  <result column="email" property="email"/>

                  <result column="gender" property="gender"/>

                  <association property="dept" javaType="com.atguigu.ssm.beans.Department">

                          <id column="did" property="id"/>

                          <result column="dept_name" property="departmentName"/>

                  </association>

         </resultMap>

</mapper>

<!-- Spring 整合 Mybatis -->

         <!--1. SqlSession  -->

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

                  <!-- 指定数据源 -->

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

                  <!-- MyBatis的配置文件 -->

                  <property name="configLocation"

                 value="classpath:mybatis-config.xml"></property>

                  <!-- MyBatis的SQL映射文件 -->

                  <property name="mapperLocations"

                 value="classpath:mybatis/mapper/*.xml"></property>

                  <property name="typeAliasesPackage"

                 value="com.atguigu.ssm.beans"></property>

         </bean>

         <!-- Mapper接口

                  MapperScannerConfigurer 为指定包下的Mapper接口批量生成代理实现类.bean的默认id是接口名首字母小写.

          -->

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

                  <property name="basePackage" value="com.atguigu.ssm.mapper"></property>

         </bean>

         <!-- <mybatis-spring:scan base-package="com.atguigu.ssm.mapper"/> -->