myBatis Generator - 如何仅生成选择/更新/插入/删除 SQL?

发布于 2024-11-01 02:48:44 字数 2022 浏览 0 评论 0原文

我的配置文件是:

<?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="context1" >
    <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:xe" userId="system" password="system" ></jdbcConnection>
    <javaModelGenerator targetPackage="pl.domain.model" targetProject="mailsender2" />
    <sqlMapGenerator targetPackage="pl.domain.model" targetProject="mailsender2" ></sqlMapGenerator>
    <javaClientGenerator targetPackage="???" targetProject="???" type="XMLMAPPER" />
    <table schema="SYSTEM" tableName="user" domainObjectName="User" enableSelectByExample="false" enableDeleteByExample="false"
                        enableCountByExample="false" enableUpdateByExample="false"  >

    </table>
  </context>
</generatorConfiguration>

How can I generated only simple select/update/insert/delete SQLs?下面没有这个吗?

映射器.xml

<insert id="insertSelective" parameterType="pl.domain.model.User" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Thu Apr 14 13:40:15 CEST 2011.
    -->
    insert into SYSTEM.USER
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="userId != null" >
        USER_ID,
      </if>
      <if test="created != null" >
        CREATED,
      </if>
      <if test="firstName != null" >
        FIRST_NAME,
      </if>
      <if test="hash != null" >
        HASH,
      </if>
      <if test="language != null" >
        LANGUAGE,
      </if>
      <if test="lastName != null" >
        LAST_NAME,

My config file is:

<?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="context1" >
    <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:xe" userId="system" password="system" ></jdbcConnection>
    <javaModelGenerator targetPackage="pl.domain.model" targetProject="mailsender2" />
    <sqlMapGenerator targetPackage="pl.domain.model" targetProject="mailsender2" ></sqlMapGenerator>
    <javaClientGenerator targetPackage="???" targetProject="???" type="XMLMAPPER" />
    <table schema="SYSTEM" tableName="user" domainObjectName="User" enableSelectByExample="false" enableDeleteByExample="false"
                        enableCountByExample="false" enableUpdateByExample="false"  >

    </table>
  </context>
</generatorConfiguration>

How can I generate only simple select/update/insert/delete SQLs? whitout this below?

Mapper.xml

<insert id="insertSelective" parameterType="pl.domain.model.User" >
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Thu Apr 14 13:40:15 CEST 2011.
    -->
    insert into SYSTEM.USER
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="userId != null" >
        USER_ID,
      </if>
      <if test="created != null" >
        CREATED,
      </if>
      <if test="firstName != null" >
        FIRST_NAME,
      </if>
      <if test="hash != null" >
        HASH,
      </if>
      <if test="language != null" >
        LANGUAGE,
      </if>
      <if test="lastName != null" >
        LAST_NAME,

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

九八野马 2024-11-08 02:48:44

为了压制评论,您是否尝试过以下操作:

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

您是否也尝试过以下操作:

<table tableName="your_table_name_here" domainObjectName="domain_bject_name_here" enableSelectByExample="false" enableDeleteByExample="false" enableCountByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false" selectByPrimaryKeyQueryId="false" modelType="flat">
 </table>

For supressing the comments, did you try this :

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

Also did you try this:

<table tableName="your_table_name_here" domainObjectName="domain_bject_name_here" enableSelectByExample="false" enableDeleteByExample="false" enableCountByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false" selectByPrimaryKeyQueryId="false" modelType="flat">
 </table>
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文