MyBatis Code Generator Configuration (MyBatis reverse engineering) _mybatis

1.pom.xml, add MyBatis plugin

<plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId> mybatis-generator-maven-plugin</artifactid>
                <version>1.3.2</version>
                < Configuration>
                    <configurationfile>src/main/resources/generatorconfig.xml</configurationfile >
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </ Configuration>
            </plugin>

2.generatorconfig.xml

<?xml version= "1.0" encoding= "UTF-8"?> <! DOCTYPE generatorconfiguration Public "-//mybatis.org//dtd mybatis generator Configuration" "1.0//en    G/dtd/mybatis-generator-config_1_0.dtd "> <generatorConfiguration> <!--database driver--> <classpathentry location= "D:/.m2/repository/mysql/mysql-connector-java/5.1.39/mysql-connector-java-5.1.39.jar"/> <context Id= "Db2tables" targetruntime= "MyBatis3" > <commentGenerator> <property name= "Suppressdat" E "value=" true "/> <property name=" suppressallcomments "value=" true "/>
        T <!--database link Address account password--> <jdbcconnection driverclass= "Com.mysql.jdbc.Driver" connectionurl= "Jdbc:mysql" ://127.0.0.1:3306/crm "userid=" "Root" password= "123456" > </jdbcConnection> <javatyperesolver&gt
            ; <property name= "Forcebigdecimals" value= "false"/> </javatyPeresolver> <!--generate model class storage location--> <javamodelgenerator targetpackage= "Com.keving.vo" Targetprojec t= "E:/eclipseworkspace/mybatis_code_generator/src/main/java" > <property name= "enableSubPackages" True '/> <property name= ' trimstrings value= ' true '/> </javaModelGenerator> <! --Generate Map file storage location--> <sqlmapgenerator targetpackage= "Com.keving.mapper" targetproject= "E:/eclipseworkspace/mybat" Is_code_generator/src/main/java "> <property name=" enablesubpackages "value=" true "/> </sqlM apgenerator> <!--generate DAO class storage location--> <javaclientgenerator type= "Xmlmapper" targetpackage= . Dao "targetproject=" E:/eclipseworkspace/mybatis_code_generator/src/main/java "> <property name=" enableSu Bpackages "value=" true "/> </javaClientGenerator> <table tablename=" T_user "domainobjectname= "CustomerOrder" EnablecouNtbyexample= "false" enableupdatebyexample= "false" enabledeletebyexample= "false" enableselectbyexample= "false"

 Selectbyexamplequeryid= "false" ></table> </context> </generatorConfiguration>

3. Configure Run Command parameters
Window->preferences–>java–>installed Jres->edit in the pop-up dialog box to modify
JRE Run parameters-dmaven.multimoduleprojectdirectory= $MAVEN _home

Maven_home configuration for environment variable names and Java_home

Run As–>maven Build
Command Mybatis-generator:generate

Run command to show code generation success

Select item, right-click to refresh

===============================
The effect of automatic code generation:

======================
Customerorder.java

Package com.keving.vo;

Import Java.util.Date;

    public class CustomerOrder {private Integer ID;

    Private String UserName;

    Private String userpwd;

    Private String Truename;

    Private String Email;

    Private String phone;

    Private Integer IsValid;

    Private Date CreateDate;

    Private Date updatedate;
    Public Integer GetId () {return id;
    The public void SetId (Integer id) {this.id = ID;
    Public String GetUserName () {return userName;
    } public void Setusername (String userName) {this.username = UserName = = null? Null:userName.trim ();
    Public String getuserpwd () {return userpwd;
    } public void Setuserpwd (String userpwd) {this.userpwd = Userpwd = = null? Null:userPwd.trim ();
    Public String Gettruename () {return truename; } public void Settruename (String truename) {this.truename = Truename = = null? Null:trueName.trim ();
    Public String Getemail () {return email;
    } public void Setemail (String email) {this.email = email = null Null:email.trim ();
    Public String Getphone () {return phone;
    public void Setphone (String phone) {this.phone = phone = null Null:phone.trim ();
    Public Integer Getisvalid () {return isValid;
    The public void Setisvalid (Integer isValid) {this.isvalid = IsValid;
    Public Date Getcreatedate () {return createdate;
    The public void Setcreatedate (Date createdate) {this.createdate = CreateDate;
    Public Date Getupdatedate () {return updatedate;
    The public void Setupdatedate (Date updatedate) {this.updatedate = updatedate; }
}

=====================================
Customerordermapper.java

Package Com.keving.dao;

Import Com.keving.vo.CustomerOrder;

Public interface Customerordermapper {
    int deletebyprimarykey (Integer ID);

    int Insert (CustomerOrder record);

    int insertselective (CustomerOrder record);

    CustomerOrder Selectbyprimarykey (Integer ID);

    int updatebyprimarykeyselective (CustomerOrder record);

    int Updatebyprimarykey (CustomerOrder record);
}

==================================

Customerordermapper.xml

<?xml version= "1.0" encoding= "UTF-8"?> <! DOCTYPE Mapper Public "-//mybatis.org//dtd mapper 3.0//en" "Http://mybatis.org/dtd/mybatis-3-mapper.dtd" > < Mapper namespace= "Com.keving.dao.CustomerOrderMapper" > <resultmap id= "Baseresultmap" Com.keving.vo.CustomerOrder "> <id column=" id "property=" id "jdbctype=" INTEGER "/> <result column=" use R_name "property=" UserName "jdbctype=" VARCHAR "/> <result column=" user_pwd "property=" Userpwd "jdbctype=" VARCHA R "/> <result column=" true_name "property=" Truename "jdbctype=" VARCHAR "/> <result" email column= " erty= "Email" jdbctype= "VARCHAR"/> <result column= "Phone" property= "Phone" jdbctype= "VARCHAR"/> <resu Lt column= "Is_valid" property= "IsValid" jdbctype= "INTEGER"/> <result column= "create_date" property= "CreateDate" "Jdbctype=" TIMESTAMP "/> <result column=" update_date "property=" Updatedate "jdbctype=" TIMESTAMP "/> </r Esultmap> <sql id= "base_column_list" > ID, user_name, user_pwd, true_name, email, phone, is_valid, Create_date, Update_date </sql> <select id= "Selectbyprimarykey" resultmap= "Baseresultmap" parametertype= " Java.lang.Integer "> select <include refid=" Base_column_list "/> from t_user where id = #{id,jdb Ctype=integer} </select> <delete id= "Deletebyprimarykey" parametertype= "Java.lang.Integer" > Delete fr Om t_user where id = #{id,jdbctype=integer} </delete> <insert id= "Insert" parametertype= "Com.keving.vo.Cu" Stomerorder "> INSERT into T_user (ID, user_name, user_pwd, true_name, email, phone, is_valid, create 
      _date, Update_date) VALUES (#{id,jdbctype=integer}, #{username,jdbctype=varchar}, #{userpwd,jdbctype=varchar}, #{truename,jdbctype=varchar}, #{email,jdbctype=varchar}, #{phone,jdbctype=varchar}, #{isValid,jdbcType=INTEG ER}, #{createdate,jdbctype=timestamp}, #{Updatedate,jdbctype=timestamp}) </insert> <insert id= "insertselective" parametertype= "Com.keving.vo.Cu"  Stomerorder "> INSERT INTO T_user <trim prefix=" ("suffix=") "suffixoverrides=", "> <if test=" id != NULL "> ID, </if> <if test=" userName!= null "> User_name, </if&gt
      ; <if test= "userpwd!= null" > User_pwd, </if> <if test= "truename!= null" > t Rue_name, </if> <if test= "email!= null" > email, </if> <if test= "Pho NE!= null "> Phone, </if> <if test=" isValid!= null "> Is_valid, </if > <if test= "createdate!= null" > Create_date, </if> <if test= "Updatedate!= N Ull "> Update_date </if> </trim> <trim prefix=" VALUES ("suffix=") "Suffixoverrid
    Es= "," >  <if test= "id!= null" > #{id,jdbctype=integer}, </if> <if test= "userName!= null"
        ; #{username,jdbctype=varchar}, </if> <if test= "userpwd!= null" > #{userpwd,jdbctype=varcha
      R}, </if> <if test= "truename!= null" > #{truename,jdbctype=varchar}, </if> <if test= "email!= null" > #{email,jdbctype=varchar}, </if> <if test= "phone!= null "> #{phone,jdbctype=varchar}, </if> <if test=" isValid!= null "> #{isvalid,jdb
      Ctype=integer}, </if> <if test= "createdate!= null" > #{createdate,jdbctype=timestamp},
    </if> <if test= "updatedate!= null" > #{updatedate,jdbctype=timestamp}, </if> </trim> </insert> <update id= "updatebyprimarykeyselective" parametertype= " Com.keving.vo.CustomerOrder "> UpdAte t_user <set > <if test= "userName!= null" > user_name = #{username,jdbctype=varchar}, 
      </if> <if test= "userpwd!= null" > User_pwd = #{userpwd,jdbctype=varchar}, </if> <if test= "truename!= null" > True_name = #{truename,jdbctype=varchar}, </if> <i  F test= "email!= null" > Email = #{email,jdbctype=varchar}, </if> <if test= "phone!= null" > Phone = #{phone,jdbctype=varchar}, </if> <if test= "isValid!= null" > Is_val id = #{isvalid,jdbctype=integer}, </if> <if test= "createdate!= null" > create_date = #{cr Eatedate,jdbctype=timestamp}, </if> <if test= "updatedate!= null" > update_date = #{update Date,jdbctype=timestamp}, </if> </set> where id = #{id,jdbctype=integer} </update> ; Update Id= "UpdatebyprimArykey "parametertype=" Com.keving.vo.CustomerOrder "> Update t_user set user_name = #{username,jdbctype=varchar }, User_pwd = #{userpwd,jdbctype=varchar}, True_name = #{truename,jdbctype=varchar}, email = #{email,jdb  Ctype=varchar}, phone = #{phone,jdbctype=varchar}, Is_valid = #{isvalid,jdbctype=integer}, create_date = #{createdate,jdbctype=timestamp}, update_date = #{updatedate,jdbctype=timestamp} where id = #{id,jdbctype=integ ER} </update> </mapper>

Related content connection:
Automatically generate DAO, Model, mapping related files using Mybatis-generator
Http://www.cnblogs.com/lichenwei/p/4145696.html

Generate code automatically using Mybatis-generator
Http://www.cnblogs.com/yjmyzz/p/4210554.html

"MyBatis Frame" MyBatis Reverse engineering automatic generation code
http://blog.csdn.net/acmman/article/details/46906871