代码自动生成器mybatis-generator

Mybatis-generator有什么用？

答：可以根据我们已经设计好的数据库表帮助我们自动生成实体类（pojo）、接口（dao）、映射文件（mapper）

 

Mybatis-generator怎么用？

1.导入generator插件：

将插件导入到idea中的D:\idea\dropins\文件夹下

 

2.修改配置文件

#是否不生成注释

suppressAllComments=true

driverClass=com.mysql.jdbc.Driver

url=jdbc:mysql://localhost:3306/jtdb?characterEncoding=utf-8

username=root

password=root

#表示为哪个项目生成代码

targetProject=jt-jsoup

#pojo所在的包路径

modeltargetPackage=com.jt.project.pojo

#映射文件所在的路径

sqltargetPackage=com.jt.project.mapper

#mapper接口文件的路径

clienttargetPackage=com.jt.project.mapper

 

3.编辑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>   

    <!--导入配置文件  -->

    <properties resource="generatorConfig.properties"/>

    <!--导入数据库驱动包  -->

<classPathEntry location="E:\WorkJarSource\connDriver\mysql-connector-java-5.1.10-bin.jar" />

<context id="tarena">

<commentGenerator>

<property name="suppressAllComments" value="${suppressAllComments}"/>

        </commentGenerator>

        <jdbcConnection driverClass="${driverClass}" connectionURL="${url}" userId="${username}" password="${password}" />

        <javaModelGenerator targetPackage="${modeltargetPackage}" targetProject="${targetProject}" />

        <sqlMapGenerator targetPackage="${sqltargetPackage}" targetProject="${targetProject}" />

        <javaClientGenerator targetPackage="${clienttargetPackage}" targetProject="${targetProject}" type="XMLMAPPER" />

        <table schema="" tableName="tb_project_item" />

        <table schema="" tableName="tb_project_shipping"/>

        <!--����ж��ű�д���table��ǩ-->

        <!--

            <table schema="" tableName="project_c" />

            <table schema="" tableName="project_c" />

        -->

    </context>

</generatorConfiguration>