如何实现Mybatis与Spring的集成
1、首先引入spring和mybatis相关依赖jar文件，如果使用maven可以在pom.xml文件里添加，这里不做列举重点介绍下mybatis-spring依赖，这个是mybatis和spring集成一起的关键桥梁<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.2.3</version></dependency>
3、添加generatorConfig.xml文件，mybatis逆向配置，可以根据数据库表结构生成dao文件<?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> <properties resource="jdbc.properties" /> <context id="managementTables" targetRuntime="MyBatis3"> <property name="javaFileEncoding" value="UTF-8"/> <commentGenerator> <property name="suppressAllComments" value="false" /> <property name="suppressDate" value="true" /> </commentGenerator> <jdbcConnection driverClass="${jdbc.driver}" connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}" /> <!-- 下面的都不用修改 --> <javaTypeResolver> <property name="forceBigDecimals" value="false" /> </javaTypeResolver> <!-- generate Model --> <javaModelGenerator targetPackage="cn.sw.study.web.model" targetProject="src/main/java"> <property name="enableSubPackages" value="true" /> <property name="trimStrings" value="true" /> </javaModelGenerator> <!-- generate xml --> <sqlMapGenerator targetPackage="sqlmap" targetProject="src/main/resources"> <property name="enableSubPackages" value="true" /> </sqlMapGenerator> <!-- generate Mapper --> <javaClientGenerator type="XMLMAPPER" targetPackage="cn.sw.study.web.dao" targetProject="src/main/java"> <property name="enableSubPackages" value="true" /> </javaClientGenerator> <!-- 规则信息表 --> <table schema="" tableName="t_user" domainObjectName="User"> <generatedKey column="id" sqlStatement="JDBC" identity="true"/> </table> </context></generatorConfiguration>
5、然后在idea的maven对话框中选择对应项目模块的mybatis-generator任务，双击运行生成dao、model、sqlmap文件
7、上面一步是mybatis和spring集成的关键，分成三个部分第一：定义数据源dataSource第二：定义sqlSessionFactory，mapperLocations对应之前生成的sqlmap目录配置第三：org.mybatis.spring.mapper.MapperScannerConfigurer，自动扫描生成的dao接口文件