Mybatis Generator自动生成工具

a13698822086

最近在网上发现一个比较好用的自动生成的工具，特来分享
数据库配置如下：
create table t_user(
pk_userid int(10) primary key,
username varchar(10),
password varchar(20)
);
insert into  t_user values(1,'user1','pwd1');
insert into  t_user values(2,'user2','pwd2');
insert into  t_user values(3,'user3','pwd3');
insert into  t_user values(4,'user4','pwd4');
insert into  t_user values(5,'user5','pwd5');
insert into  t_user values(6,'user6','pwd6');
insert into  t_user values(7,'user7','pwd7');
insert into  t_user values(8,'user8','pwd8');
insert into  t_user values(9,'user9','pwd9');
insert into  t_user values(10,'user10','pwd10');
insert into  t_user values(11,'user11','pwd11');
insert into  t_user values(12,'user12','pwd12');


新建maven工程，新建mybatisGeneratorConfig.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>
<!--classPathEntry:数据库的JDBC驱动-->
<!-- <classPathEntry location="src/main/webapp/WEB-INF/lib/mysql-connector-java-5.1.24.jar" /> -->
<classPathEntry location="E:\MavenTest\respo\mysql\mysql-connector-java\5.1.24\mysql-connector-java-5.1.24.jar" />
<context id="MysqlTables" targetRuntime="MyBatis3">
<!-- 注意这里面的顺序确定的，不能随变更改 -->
<!--  自定义的分页插件
<plugin type="com.deppon.foss.module.helloworld.shared.PaginationPlugin"/>
-->
<!-- 可选的（0 or 1） -->
<!-- 注释生成器 -->
<commentGenerator>
<!-- 是否去掉注释 -->
<property name="suppressAllComments" value="true" />
</commentGenerator>
<!-- 必须的（1 required） -->
<!-- 数据库连接 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost/test" userId="root" password="root">
</jdbcConnection>
<!-- 可选的（0 or 1） -->
<!-- 类型转换器或者加类型解析器 -->
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>

<!-- 必须的（1 required） -->
<!-- java模型生成器 -->
<!-- targetProject:自动生成代码的位置 -->
<javaModelGenerator targetPackage="com.deppon.cms.module.generators.shared.domain"
targetProject="src/main/java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>

<!-- 必须的（1 required） -->
<!-- map xml 生成器 -->
<sqlMapGenerator targetPackage="com.deppon.cms.module.generators.server.META-INF.ibatis"
targetProject="src/main/resources">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- 可选的（0 or 1） -->
<!-- mapper  或者就是dao接口生成器-->
<javaClientGenerator type="XMLMAPPER"
targetPackage="com.deppon.cms.module.generators.server.dao"
targetProject="src/main/java">
<property name="enableSubPackages" value="true" />
<property name="methodNameCalculator" value="extended"/>
</javaClientGenerator>
<!-- 必须的（1...N） -->
<!-- pojo 实体生成器 -->
<!-- tableName:用于自动生成代码的数据库表;-->
<!-- domainObjectName:对应于数据库表的javaBean类名-->
<table tableName="t_user" domainObjectName="User" enableInsert="false" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
</table>
</context>
</generatorConfiguration>

引入相关jar文件：
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.0.5</version>
</dependency>
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.24</version>
</dependency>

用java程序执行如下程序：
List<String> warnings = new ArrayList<String>();
boolean overwrite = true;
File configFile = new File("src/main/resources/com/deppon/cms/module/generators/server/META-INF/ibatis/mybatisGeneratorConfig.xml");
ConfigurationParser cp = new ConfigurationParser(warnings);
try {
Configuration config = cp.parseConfiguration(configFile);
DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
myBatisGenerator.generate(null);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (InterruptedException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (XMLParserException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (InvalidConfigurationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("finished");
}

刷新工程，结果如下相关文件出现了
现在测试是否通过
public class MybatisGeneratorTest {
@Test
public void test1(){
String resource = "com/deppon/cms/module/generators/server/META-INF/ibatis/mybatisConfig.xml";
Reader reader = null;
SqlSessionFactory sqlMapper = null;
SqlSession sqlSession = null;
try {
//读取配置文件
reader = Resources.getResourceAsReader(resource);
sqlMapper = new SqlSessionFactoryBuilder().build(reader);
sqlSession = sqlMapper.openSession();
//获取User里面的值
UserMapper mappers = sqlSession.getMapper(UserMapper.class);
User user = mappers.selectByPrimaryKey(1);
System.out.println(user.getUsername());
} catch (IOException e) {
e.printStackTrace();
}
}
}