mybatis****



Maven方法

1.加入相应的pom的jar包

1. <dependency>
2. <groupId>org.mybatis.generator</groupId>
3. <artifactId>mybatis-generator-core</artifactId>
4. </dependency>

2.idea****插件

1. <build>
2. <finalName>noodle-mybatis</finalName>
3. <plugins>
4. <plugin>
5. <groupId>org.mybatis.generator</groupId>
6. <artifactId>mybatis-generator-maven-plugin</artifactId>
7. <version>1.3.2</version>
8. <configuration>
9. <configurationFile>src/main/resources/mybatis/mybatis-generator.xml</configurationFile>
10. <verbose>true</verbose>
11. <overwrite>true</overwrite>
12. </configuration>
13. </plugin>
14. </plugins>
15. </build>

3.属性文件

1. jdbc.driverClass=com.mysql.jdbc.Driver
2. jdbc.connectionURL=jdbc:mysql://127.0.0.1:3306/websocket?useUnicode=true&characterEncoding=utf8
3. jdbc.userId=root
4. jdbc.password=welcome
5. jdbc.driverLocation=E:\\coding\\flxlib\\mysql-connector-java-5.1.35.jar

4.配置文件

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. <generatorConfiguration>
6. <!--导入属性配置-->
7. <properties resource="mybatis/generator.properties"/>
8. <!--数据库驱动,最好不要有中文字符,不然会找不到-->
9. <classPathEntry location="${jdbc.driverLocation}"/>
11. <context id="testTables" targetRuntime="MyBatis3">
13. <commentGenerator>
14. <!-- 是否去除自动生成的注释 true：是 ： false:否-->
15. <property name="suppressDate" value="true"/>
16. <property name="suppressAllComments" value="true"/>
17. </commentGenerator>
18. <!--数据库链接地址账号密码-->
19. <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->
20. <jdbcConnection driverClass="${jdbc.driverClass}"
21. connectionURL="${jdbc.connectionURL}"
22. userId="${jdbc.userId}"
23. password="${jdbc.password}">
24. </jdbcConnection>
25. <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和
26. NUMERIC 类型解析为java.math.BigDecimal -->
27. <javaTypeResolver>
28. <property name="forceBigDecimals" value="false"/>
29. </javaTypeResolver>
30. <!-- targetProject:生成PO类的位置 -->
31. <javaModelGenerator targetPackage="com.flx.noodle.mybatis.entity" targetProject="src/main/java">
32. <!-- enableSubPackages:是否让schema作为包的后缀 -->
33. <property name="enableSubPackages" value="false"/>
34. <!-- 从数据库返回的值被清理前后的空格 -->
35. <property name="trimStrings" value="true"/>
36. </javaModelGenerator>
37. <!-- targetProject:mapper映射文件生成的位置 -->
38. <sqlMapGenerator targetPackage="com.flx.noodle.mybatis.entity" targetProject="src/main/java">
39. <property name="enableSubPackages" value="false"/>
40. </sqlMapGenerator>
41. <!-- targetPackage：mapper接口生成的位置 -->
42. <javaClientGenerator type="XMLMAPPER" targetPackage="com.flx.noodle.mybatis.dao" targetProject="src/main/java">
43. <property name="enableSubPackages" value="true"/>
44. </javaClientGenerator>
45. <!--生成对应表及类名,需要记住的一点是****无法生成关联关系,只能生成单表操作-->
46. <table tableName="ws_user" domainObjectName="WsUser"/>
47. <table tableName="ws_room" domainObjectName="WsRoom"/>
49. </context>
50. </generatorConfiguration>

5.生成主文件

1. package com.flx.noodle.mybatis.generator;
3. import org.mybatis.generator.api.MyBatisGenerator;
4. import org.mybatis.generator.config.Configuration;
5. import org.mybatis.generator.config.xml.ConfigurationParser;
6. import org.mybatis.generator.internal.DefaultShellCallback;
8. import java.io.File;
9. import java.util.ArrayList;
10. import java.util.List;
12. /**
13. * Created by fenglixiong on 2017/10/22.
14. */
15. public class GeneratorMain {
17. public static void main(String[] args) {
18. try {
19. generator();
20. System.out.println("successful!!!");
21. } catch (Exception e) {
22. // TODO Auto-generated catch block
23. e.printStackTrace();
24. }
25. }
27. public static void generator() throws Exception{
28. List<String> warnings = new ArrayList<String>();
29. boolean overwrite = true;
30. //项目根路径不要有中文,我的有中文,所以使用绝对路径
31. File configFile = new File("E:\\coding\\BeefNoodle\\noodle-mybatis\\src\\main\\resources\\mybatis\\mybatis-generator.xml");
32. ConfigurationParser cp = new ConfigurationParser(warnings);
33. Configuration config = cp.parseConfiguration(configFile);
34. DefaultShellCallback callback = new DefaultShellCallback(overwrite);
35. MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
36. myBatisGenerator.generate(null);
37. }
39. }

6.tomcat配置

java工程

github地址

https://github.com/zhangwei2github/MybatisGenerator.git