解决myBatis generator逆向生成没有根据主键的select,update和delete问题_Java教程

解决myBatis generator逆向生成没有根据主键的select,update和delete问题

2020-09-27 14:47華府小書童 Java教程

这篇文章主要介绍了解决myBatis generator逆向生成没有根据主键的select,update和delete问题，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧

一、配置逆向generatoe.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="DB2Tables" targetRuntime="MyBatis3">

									    <!-- 是否生成注释 -->

									    <commentGenerator>

									      <property name="suppressAllComments" value="true" />

									    </commentGenerator>

									    <!-- 配置数据库连接信息 -->

									    <jdbcConnection driverClass="com.mysql.jdbc.Driver"

									            connectionURL="jdbc:mysql://localhost:3306/ssm_crud?serverTimezone=UTC"

									            userId="root"

									            password="root">

									      <!--<property name="useInformationSchema" value="true"/>-->

									    </jdbcConnection>

									    <javaTypeResolver >

									      <property name="forceBigDecimals" value="false" />

									    </javaTypeResolver>

									    <!-- 指定javaBean生成的位置 -->

									    <javaModelGenerator targetPackage="com.atguigu.crud.bean" targetProject=".\src\main\java">

									      <property name="enableSubPackages" value="true" />

									      <property name="trimStrings" value="true" />

									    </javaModelGenerator>

									    <!-- 指定sql映射文件生成的位置 -->

									    <sqlMapGenerator targetPackage="mapper" targetProject=".\src\main\resources">

									      <property name="enableSubPackages" value="true" />

									    </sqlMapGenerator>

									    <!-- 指定dao接口生成位置，mapper接口 -->

									    <javaClientGenerator type="XMLMAPPER" targetPackage="com.atguigu.crud.dao" targetProject=".\src\main\java">

									      <property name="enableSubPackages" value="true" />

									    </javaClientGenerator>

									    <!-- table指定每个表的生成策略 -->

									    <table tableName="tbl_emp" domainObjectName="Employee" />

									    <table tableName="tbl_dept" domainObjectName="Department" />

									  </context>

									</generatorConfiguration>

二、执行生成代码

				?

									public class MBGTest {

									  public static void main(String[] args) throws Exception{

									    List<String> warnings = new ArrayList<String>();

									    boolean overwrite = true;

									    File configFile = new File("mbg.xml");

									    ConfigurationParser cp = new ConfigurationParser(warnings);

									    Configuration config = cp.parseConfiguration(configFile);

									    DefaultShellCallback callback = new DefaultShellCallback(overwrite);

									    MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);

									    myBatisGenerator.generate(null);

									  }

									}