Mybatis代码生成器配置（mybatis逆向工程）

来源：互联网发布：网络统计直报平台编辑：程序博客网时间：2024/04/29 20:41

1.pom.xml，添加mybatis插件

<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"  "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"><generatorConfiguration>    <!--数据库驱动-->    <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="suppressDate" value="true"/>            <property name="suppressAllComments" value="true"/>        </commentGenerator>        <!--数据库链接地址账号密码-->        <jdbcConnection driverClass="com.mysql.jdbc.Driver"         connectionURL="jdbc:mysql://127.0.0.1:3306/crm" userId="root" password="123456">        </jdbcConnection>        <javaTypeResolver>            <property name="forceBigDecimals" value="false"/>        </javaTypeResolver>        <!--生成Model类存放位置-->        <javaModelGenerator targetPackage="com.keving.vo" targetProject="E:/EclipseWorkspace/mybatis_code_generator/src/main/java">            <property name="enableSubPackages" value="true"/>            <property name="trimStrings" value="true"/>        </javaModelGenerator>        <!--生成映射文件存放位置-->        <sqlMapGenerator targetPackage="com.keving.mapper" targetProject="E:/EclipseWorkspace/mybatis_code_generator/src/main/java">            <property name="enableSubPackages" value="true"/>        </sqlMapGenerator>        <!--生成Dao类存放位置-->        <javaClientGenerator type="XMLMAPPER" targetPackage="com.keving.dao" targetProject="E:/EclipseWorkspace/mybatis_code_generator/src/main/java">            <property name="enableSubPackages" value="true"/>        </javaClientGenerator>        <table tableName="t_user" domainObjectName="CustomerOrder" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>    </context></generatorConfiguration>

这里写图片描述

3.配置运行命令参数
window—>preferences–>java–>installed jres—>edit 在弹出的对话框中修改
jre 运行参数 -Dmaven.multiModuleProjectDirectory=$MAVEN_HOME

这里写图片描述

MAVEN_HOME 为环境变量名和JAVA_HOME一样配置
这里写图片描述

run as –>maven build
命令 mybatis-generator:generate
这里写图片描述
运行命令，显示代码生成成功

选中项目，右键刷新

===============================
代码自动生成后的效果：
这里写图片描述

======================
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;    }    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;    }    public void setIsValid(Integer isValid) {        this.isValid = isValid;    }    public Date getCreateDate() {        return createDate;    }    public void setCreateDate(Date createDate) {        this.createDate = createDate;    }    public Date getUpdateDate() {        return updateDate;    }    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" type="com.keving.vo.CustomerOrder" >    <id column="id" property="id" jdbcType="INTEGER" />    <result column="user_name" property="userName" jdbcType="VARCHAR" />    <result column="user_pwd" property="userPwd" jdbcType="VARCHAR" />    <result column="true_name" property="trueName" jdbcType="VARCHAR" />    <result column="email" property="email" jdbcType="VARCHAR" />    <result column="phone" property="phone" jdbcType="VARCHAR" />    <result column="is_valid" property="isValid" jdbcType="INTEGER" />    <result column="create_date" property="createDate" jdbcType="TIMESTAMP" />    <result column="update_date" property="updateDate" jdbcType="TIMESTAMP" />  </resultMap>  <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,jdbcType=INTEGER}  </select>  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >    delete from t_user    where id = #{id,jdbcType=INTEGER}  </delete>  <insert id="insert" parameterType="com.keving.vo.CustomerOrder" >    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=INTEGER}, #{createDate,jdbcType=TIMESTAMP}, #{updateDate,jdbcType=TIMESTAMP}      )  </insert>  <insert id="insertSelective" parameterType="com.keving.vo.CustomerOrder" >    insert into t_user    <trim prefix="(" suffix=")" suffixOverrides="," >      <if test="id != null" >        id,      </if>      <if test="userName != null" >        user_name,      </if>      <if test="userPwd != null" >        user_pwd,      </if>      <if test="trueName != null" >        true_name,      </if>      <if test="email != null" >        email,      </if>      <if test="phone != null" >        phone,      </if>      <if test="isValid != null" >        is_valid,      </if>      <if test="createDate != null" >        create_date,      </if>      <if test="updateDate != null" >        update_date,      </if>    </trim>    <trim prefix="values (" suffix=")" suffixOverrides="," >      <if test="id != null" >        #{id,jdbcType=INTEGER},      </if>      <if test="userName != null" >        #{userName,jdbcType=VARCHAR},      </if>      <if test="userPwd != null" >        #{userPwd,jdbcType=VARCHAR},      </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,jdbcType=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>      <if test="email != null" >        email = #{email,jdbcType=VARCHAR},      </if>      <if test="phone != null" >        phone = #{phone,jdbcType=VARCHAR},      </if>      <if test="isValid != null" >        is_valid = #{isValid,jdbcType=INTEGER},      </if>      <if test="createDate != null" >        create_date = #{createDate,jdbcType=TIMESTAMP},      </if>      <if test="updateDate != null" >        update_date = #{updateDate,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,jdbcType=VARCHAR},      phone = #{phone,jdbcType=VARCHAR},      is_valid = #{isValid,jdbcType=INTEGER},      create_date = #{createDate,jdbcType=TIMESTAMP},      update_date = #{updateDate,jdbcType=TIMESTAMP}    where id = #{id,jdbcType=INTEGER}  </update></mapper>

相关内容连接：
使用Mybatis-Generator自动生成Dao、Model、Mapping相关文件
http://www.cnblogs.com/lichenwei/p/4145696.html

利用mybatis-generator自动生成代码
http://www.cnblogs.com/yjmyzz/p/4210554.html

【MyBatis框架】mybatis逆向工程自动生成代码
http://blog.csdn.net/acmman/article/details/46906871

阅读全文

0 0