Mybatis：代码生成器（Maven版）&集成Spring

野性酷女 2022-09-26 12:57 191阅读 0赞

一、生成器（Maven）   
1、配置maven

Xml代码   ![收藏代码][icon_star.png]

1.  **<****plugin****>**  
2.                  **<****groupId****>**org.mybatis.generator**</****groupId****>**  
3.                  **<****artifactId****>**mybatis-generator-maven-plugin**</****artifactId****>**  
4.                  **<****version****>**1.3.1**</****version****>**  
5.                  **<****configuration****>**  
6.                      **<****verbose****>**true**</****verbose****>**  
7.                      **<****overwrite****>**true**</****overwrite****>**  
8.                  **</****configuration****>**  
9.              **</****plugin****>**

2、编写生成器所需要的配置文件：src\\main\\resources\\generatorConfig.xml（这是默认的路径）

Xml代码   ![收藏代码][icon_star.png]

1.  **<?****xml** version="1.0" encoding="UTF-8"**?>**  
2.  <!DOCTYPE generatorConfiguration  
3.        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"  
4.        "http://mybatis.org/dtd/mybatis-generator-config\_1\_0.dtd"**>**  
5.    
6.  **<****generatorConfiguration****>**  
7.      **<****classPathEntry** location="F:\\work\\platform\\platform-demo\\target\\talent-platform-demo\\WEB-INF\\lib\\mysql-connector-java-5.1.11.jar" **/>**  
8.    
9.      **<****context** id="DB2Tables" targetRuntime="MyBatis3"**>**  
10.         **<****jdbcConnection** driverClass="com.mysql.jdbc.Driver"  
11.             connectionURL="jdbc:mysql://localhost:3306/tan?generateSimpleParameterMetadata=true"  
12.             userId="root"  
13.             password="xxxx"**>**  
14.         **</****jdbcConnection****>**  
15.   
16.         **<****javaTypeResolver** **>**  
17.             **<****property** name="forceBigDecimals" value="false" **/>**  
18.         **</****javaTypeResolver****>**  
19.   
20.           
21.         **<****javaModelGenerator** targetPackage="com.talent.platform.demo.book.model" targetProject="c:\\mybatis-generated\\java"**>**  
22.             **<****property** name="enableSubPackages" value="true" **/>**  
23.             **<****property** name="trimStrings" value="true" **/>**  
24.         **</****javaModelGenerator****>**  
25.           
26.           
27.   
28.           
29.         **<****sqlMapGenerator** targetPackage="com.talent.platform.demo.book.dao"  targetProject="c:\\mybatis-generated\\resources"**>**  
30.             **<****property** name="enableSubPackages" value="true" **/>**  
31.         **</****sqlMapGenerator****>**  
32.           
33.           
34.         **<****javaClientGenerator** type="XMLMAPPER" targetPackage="com.talent.platform.demo.book.dao"  targetProject="c:\\mybatis-generated\\java"**>**  
35.             **<****property** name="enableSubPackages" value="true" **/>**  
36.         **</****javaClientGenerator****>**  
37.   
38.           
39.   
40.         **<****table** schema="" tableName="book" domainObjectName="Book"**>****</****table****>**  
41.         **<****table** schema="" tableName="leavemessage" domainObjectName="Leavemessage"**>****</****table****>**  
42.   
43.     **</****context****>**  
44. **</****generatorConfiguration****>**

这个生成器很不智能：不会为你创建目录、需要你指定要生成的表   
3、运行命令：mvn org.mybatis.generator:mybatis-generator-maven-plugin:1.3.1:generate。这时候会在c:盘生成相应的代码和xml配置文件，我们需要做的就是把这些东西拷到我们的项目中   
  
二、集成Spring   
1、定义你的bean

Xml代码   ![收藏代码][icon_star.png]

1.  **<****bean** id="talent-ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"**>**  
2.          **<****property** name="driverClassName" value="$\{talent.jdbc.driverClassName\}"**/>**  
3.          **<****property** name="url" value="$\{talent.jdbc.url\}"**/>**  
4.          **<****property** name="username" value="$\{talent.jdbc.username\}"**/>**  
5.          **<****property** name="password" value="$\{talent.jdbc.password\}"**/>**  
6.          **<****property** name="initialSize" value="$\{talent.jdbc.pool.initialSize\}" **/>**  
7.          **<****property** name="maxActive" value="$\{talent.jdbc.pool.maxActive\}" **/>**  
8.          **<****property** name="maxIdle" value="$\{talent.jdbc.pool.maxIdle\}" **/>**  
9.          **<****property** name="minIdle" value="$\{talent.jdbc.pool.minIdle\}" **/>**  
10.     **</****bean****>**  
11.         
12.     **<****bean** id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"**>**    
13.     
14.         **<****property** name="dataSource" ref="talent-ds" **/>**  
15.         **<****property** name="mapperLocations" value="classpath\*:com/talent/platform/demo/book/dao/\*.xml" **/>**  
16.     **</****bean****>**  
17.       
18.     **<****bean** id="BookMapper1" class="org.mybatis.spring.mapper.MapperFactoryBean"**>**    
19.             
20.         **<****property** name="mapperInterface" value="com.talent.platform.demo.book.dao.BookMapper" **/>**  
21.         **<****property** name="sqlSessionFactory" ref="sqlSessionFactory" **/>**   
22.     **</****bean****>**

2、编写测试类

Java代码   ![收藏代码][icon_star.png]

1.  BookMapper mapper = (BookMapper) SpringManager.getApplicationContext().getBean("BookMapper1");  
2.              Book book1 = mapper.selectByPrimaryKey(1);  
3.              System.out.println(book1);

[icon_star.png]: /images/20220717/0b620fbc32934d07ba2aca8dff4339b6.png