spring整合mybatis

 

1.maven依赖

 <dependency>  

            <groupId>org.mybatis.generator</groupId>  

            <artifactId>mybatis-generator-core</artifactId>  

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

 

2.建立 spring-mybatis.xml

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

<beans xmlns="http://www.springframework.org/schema/beans"

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

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

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

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

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

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

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

xmlns:jpa="http://www.springframework.org/schema/data/jpa"

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

http://www.springframework.org/schema/cache 

http://www.springframework.org/schema/cache/spring-cache-4.0.xsd

http://www.springframework.org/schema/aop 

http://www.springframework.org/schema/aop/spring-aop-4.0.xsd

http://www.springframework.org/schema/jdbc 

http://www.springframework.org/schema/jdbc/spring-jdbc-4.0.xsd

http://www.springframework.org/schema/tx 

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

http://www.springframework.org/schema/data/jpa 

http://www.springframework.org/schema/data/jpa/spring-jpa.xsd"

default-lazy-init="true">

<description>mybatis</description>

<!-- mybatis -->

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

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

<property name="configLocation" value="classpath:mybatis/mybatis.xml"></property>  

<!-- 自动扫描entity目录, 省掉Configuration.xml里的手工配置 -->

<property name="typeAliasesPackage" value="com.springdemo.entity.mybatis" />

<!-- 显式指定Mapper文件位置 -->

<property name="mapperLocations" value="classpath:com/springdemo/mybatis/mapper/*Mapper.xml" />

</bean>

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

<property name="basePackage" value="com.springdemo.mybatis.mapper"></property>

<!-- <property name="annotationClass" value="com.springdemo.dao.util.Mapper" /> -->

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

</bean>

</beans>

 

3.配置mybatis-generator.xml

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

<!DOCTYPE generatorConfiguration  

  PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"  

  "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

 

<generatorConfiguration>

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

<!-- <properties resource="jdbc.properties"/>  

 -->

<classPathEntrylocation="C:\Users\user\.m2\repository\mysql\mysql-connector-java\5.1.36\mysql-connector-java-5.1.36.jar" />

 

<context id="DB2Tables" targetRuntime="MyBatis3">

 

<plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin" />

 

<commentGenerator>

<property name="suppressDate" value="true" />

<property name="suppressAllComments" value="true" />

</commentGenerator>

 <jdbcConnection driverClass="com.mysql.jdbc.Driver"

connectionURL="jdbc:mysql://172.18.11.37:3306/tracker_test" 

userId="tracker"

password="tracker">

</jdbcConnection>

 

<!-- 类型转换 -->  

<javaTypeResolver>

  <!-- 是否使用bigDecimal， false可自动转化以下类型（Long, Integer, Short, etc.） -->  

<property name="forceBigDecimals" value="false" />

</javaTypeResolver>

 

        <!-- 生成实体类地址 -->    

<javaModelGenerator targetPackage="com.springdemo.entity.mybatis"

targetProject="myorg/src/main/java">

<!-- 是否在当前路径下新加一层schema,eg：fase路径com.springdemo.entity.mybatis， true:com.springdemo.entity.mybatis.[schemaName] -->  

<property name="enableSubPackages" value="true" />

<!-- 是否针对string类型的字段在set的时候进行trim调用 -->  

<property name="trimStrings" value="true" />

</javaModelGenerator>

 

        <!-- 生成mapxml文件 -->  

<sqlMapGenerator targetPackage="com.springdemo.mybatis.mapper"

targetProject="myorg/src/main/java">

<property name="enableSubPackages" value="true" />

</sqlMapGenerator>

 

        <!-- 生成mapxml对应client，也就是接口dao -->      

<javaClientGenerator type="XMLMAPPER"

targetPackage="com.springdemo.mybatis.mapper" targetProject="myorg/src/main/java">

<property name="enableSubPackages" value="true" />

</javaClientGenerator>

 

 

 <!--<table tableName="TDevice" domainObjectName="Tdevice"></table> --> 

 <table tableName="TDevice" domainObjectName="Tdevice"></table> 

</context>

</generatorConfiguration>