mybatis根据数据库生成mapper

来源：互联网发布：银行家算法解题过程编辑：程序博客网时间：2024/05/12 08:08
命令行：mvn mybatis-generator:generate
<?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="/Users/develop/mavenjar-landz/com/oracle/ojdbc6/11.2.0.3/ojdbc6-11.2.0.3.jar" /><!-- <classPathEntry location="/Users/Downloads/sqljdbc4-4.0.jar"/> --><!-- <classPathEntry location="/Users/develop/mavenjars/mysql/mysql-connector-java/5.1.34/mysql-connector-java-5.1.34.jar" /> --><context id="DB2Tables" targetRuntime="MyBatis3"><plugin type="tk.mybatis.mapper.generator.MapperPlugin">          <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/>        </plugin>        <commentGenerator><property name="suppressAllComments" value="true" /></commentGenerator><jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"connectionURL="jdbc:oracle:thin:@10.10.124.17:1521/dg1"userId="lzhdic" password="test123"></jdbcConnection> <!-- <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"connectionURL="jdbc:oracle:thin:@ip:1521/lzhse"userId="" password=""></jdbcConnection>  --><!-- <jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver"connectionURL="jdbc:sqlserver://ip:1433;databaseName=landzshr"userId="" password=""></jdbcConnection> --><!--  <jdbcConnection driverClass="com.mysql.jdbc.Driver"connectionURL="jdbc:mysql://127.0.0.1:3306/landzmydb?zeroDateTimeBehavior=convertToNull&characterEncoding=utf-8"userId="root" password=""></jdbcConnection> --><javaTypeResolver><property name="forceBigDecimals" value="false" /></javaTypeResolver>        <!-- targetPackage="com.mybatis.model" model包名 --><javaModelGenerator targetPackage="com.landz.owner.model.entity" targetProject="src/main/java"><property name="enableSubPackages" value="true" /><!-- <property name="trimStrings" value="true" /> --><!-- 去除空格 --></javaModelGenerator><sqlMapGenerator targetPackage="com.landz.owner.mapper.mapping" targetProject="src/main/java"><property name="enableSubPackages" value="true" /></sqlMapGenerator><!-- targetPackage="com.mybatis.mapper" mapper包名 --><javaClientGenerator type="XMLMAPPER"       targetPackage="com.landz.owner.mapper"       targetProject="src/main/java"><property name="enableSubPackages" value="true" /></javaClientGenerator><!-- 要生成得表  注意 会覆盖前面生成的 文件 --><table tableName="%" modelType="flat" schema="OWNER" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" >    <!-- <generatedKey column="pkid" sqlStatement="SELECT LAST_INSERT_ID()" type="post" identity="true"/> -->    <!-- <ignoreColumn column="creattime"/> --></table><!-- <generatedKey column="pkid" sqlStatement="SELECT LAST_INSERT_ID()" type="post" identity="true"/>    <ignoreColumn column="creattime"/></table> --><!--enableDeleteByPrimaryKey="false"  enableUpdateByPrimaryKey="false" enableInsert="false" delimitAllColumns="false" delimitIdentifiers="false"  --> </context></generatorConfiguration>
0 0