mybatis代码自动生成Demo(maven项目)

来源:互联网 发布:微信浏览器打开淘宝 编辑:程序博客网 时间:2024/06/06 17:41

1、在mysql上创建数据库mytest,并新建user表;建表语句如下:

CREATE TABLE `user` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(100) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

2、在exlipse上新建一个maven项目;
1
3、项目名称:
2
4、建成的项目结构如下:
3
5、打开pom.xml文件导包:

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">  <modelVersion>4.0.0</modelVersion>  <groupId>com.test</groupId>  <artifactId>mybatis_generator</artifactId>  <version>0.0.1-SNAPSHOT</version>  <name>mybatis_generator</name><properties>      <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>  </properties>  <dependencies>      <dependency>          <groupId>mysql</groupId>          <artifactId>mysql-connector-java</artifactId>          <version>5.1.35</version>      </dependency>      <dependency>          <groupId>org.mybatis.generator</groupId>          <artifactId>mybatis-generator-core</artifactId>          <version>1.3.2</version>      </dependency>  </dependencies>  <build>      <pluginManagement>          <plugins>              <plugin>                  <groupId>org.apache.maven.plugins</groupId>                  <artifactId>maven-compiler-plugin</artifactId>                  <configuration>                      <source>1.7</source>                      <target>1.7</target>                  </configuration>                  <version>3.3</version>              </plugin>              <plugin>                  <groupId>org.mybatis.generator</groupId>                  <artifactId>mybatis-generator-maven-plugin</artifactId>                  <version>1.3.2</version>                  <dependencies>                      <dependency>                          <groupId>mysql</groupId>                          <artifactId>mysql-connector-java</artifactId>                          <version>5.1.35</version>                      </dependency>                  </dependencies>                  <configuration>                       <!--配置文件的路径-->                       <configurationFile>${basedir}/src/main/resources/generatorConfig.xml</configurationFile>                       <overwrite>true</overwrite>                  </configuration>              </plugin>          </plugins>      </pluginManagement>    </build>  </project>

6、在resources目录下新建自动生成用的generatorConfig.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>    <context id="test" targetRuntime="MyBatis3">        <plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin"></plugin>          <plugin type="org.mybatis.generator.plugins.SerializablePlugin"></plugin>          <plugin type="org.mybatis.generator.plugins.ToStringPlugin"></plugin>         <commentGenerator>            <!-- 这个元素用来去除指定生成的注释中是否包含生成的日期 false:表示保护 -->            <!-- 如果生成日期,会造成即使修改一个字段,整个实体类所有属性都会发生变化,不利于版本控制,所以设置为true -->            <property name="suppressDate" value="true" />            <!-- 是否去除自动生成的注释 true:是 : false:否 -->            <property name="suppressAllComments" value="false" />        </commentGenerator>        <!--数据库链接URL,用户名、密码 -->        <jdbcConnection driverClass="com.mysql.jdbc.Driver"            connectionURL="jdbc:mysql://localhost/mytest" userId="root" password="root">            </jdbcConnection>        <javaTypeResolver>            <!-- This property is used to specify whether MyBatis Generator should                 force the use of java.math.BigDecimal for DECIMAL and NUMERIC fields, -->            <property name="forceBigDecimals" value="false" />        </javaTypeResolver>        <!-- 生成模型的包名和位置 -->        <javaModelGenerator targetPackage="com.test.pojo" targetProject="target">            <property name="enableSubPackages" value="true" />            <property name="trimStrings" value="true" />        </javaModelGenerator>        <!-- 生成映射文件的包名和位置 -->        <sqlMapGenerator targetPackage="com.test.mapper"            targetProject="target">            <property name="enableSubPackages" value="true" />        </sqlMapGenerator>        <!-- 生成DAO的包名和位置 -->        <javaClientGenerator type="XMLMAPPER"            targetPackage="com.test.dao" implementationPackage="com.test.dao.impl"  targetProject="target">            <property name="enableSubPackages" value="true" />        </javaClientGenerator>        <!-- 要生成哪些表 -->        <table tableName="user" domainObjectName="user"            enableCountByExample="false" enableUpdateByExample="false"            enableDeleteByExample="false" enableSelectByExample="false"            selectByExampleQueryId="false"></table>    </context></generatorConfiguration>

7、下载maven依赖包。右键项目–》选择 Maven –》选择 Update Project ;下载jar包需要等待一段时间
8、运行命令语句。右键项目 –》 选择 Run As –》选择第一个“Maven build”选项 –》输入如下命令:mybatis-generator:generate 运行;
9、运行成功的提示!
4
和结果!
5