ibatis

最新推荐文章于 2019-08-26 16:26:10 发布
最新推荐文章于 2019-08-26 16:26:10 发布
阅读量1.5k 收藏
点赞数
分类专栏： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zsw2zkl/article/details/8191714
版权 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="qbt_category">
  <resultMap class="cn.flystone.quubox.foundation.model.QCategory" id="ibatorgenerated_BaseResultMap">
    <!--  [generated on 2012-11-13 13:47:48.530] -->
    <result column="UUID" jdbcType="VARCHAR" property="uuid" />
    <result column="PARENT_UUID" jdbcType="VARCHAR" property="parentUuid" />
    <result column="NAME" jdbcType="VARCHAR" property="name" />
    <result column="COMMENT" jdbcType="VARCHAR" property="comment" />
    <result column="RECOMMEND" jdbcType="INTEGER" property="recommend" />
    <result column="ORD" jdbcType="INTEGER" property="ord" />
    <result column="CREATE_TIME" jdbcType="TIMESTAMP" property="createTime" />
    <result column="UPDATE_TIME" jdbcType="TIMESTAMP" property="updateTime" />
  </resultMap>
  <sql id="ibatorgenerated_Example_Where_Clause">
    <!--  [generated on 2012-11-13 13:47:48.530] -->
    <iterate conjunction="or" prepend="where" property="oredCriteria" removeFirstPrepend="iterate">
      <isEqual compareValue="true" property="oredCriteria[].valid">
        (
        <iterate conjunction="and" prepend="and" property="oredCriteria[].criteriaWithoutValue">
          $oredCriteria[].criteriaWithoutValue[]$
        </iterate>
        <iterate conjunction="and" prepend="and" property="oredCriteria[].criteriaWithSingleValue">
          $oredCriteria[].criteriaWithSingleValue[].condition$
            #oredCriteria[].criteriaWithSingleValue[].value#
        </iterate>
        <iterate conjunction="and" prepend="and" property="oredCriteria[].criteriaWithListValue">
          $oredCriteria[].criteriaWithListValue[].condition$
          <iterate close=")" conjunction="," open="(" property="oredCriteria[].criteriaWithListValue[].values">
            #oredCriteria[].criteriaWithListValue[].values[]#
          </iterate>
        </iterate>
        <iterate conjunction="and" prepend="and" property="oredCriteria[].criteriaWithBetweenValue">
          $oredCriteria[].criteriaWithBetweenValue[].condition$
          #oredCriteria[].criteriaWithBetweenValue[].values[0]# and
          #oredCriteria[].criteriaWithBetweenValue[].values[1]#
        </iterate>
        )
      </isEqual>
    </iterate>
  </sql>
  <sql id="ibatorgenerated_Example_Page_Clause">
    <dynamic prepend="LIMIT">
      <isNotNull property="_startNum">
        #_startNum#
      </isNotNull>
      <isNotNull property="_offsetNum">
        ,#_offsetNum#
      </isNotNull>
    </dynamic>
  </sql>
  <select id="ibatorgenerated_selectByExample" parameterClass="cn.flystone.quubox.foundation.model.QCategoryExample" resultMap="ibatorgenerated_BaseResultMap">
    <!--  [generated on 2012-11-13 13:47:48.530] -->
    select UUID, PARENT_UUID, NAME, COMMENT, RECOMMEND, ORD, CREATE_TIME, UPDATE_TIME
    from qbt_category
    <isParameterPresent>
      <include refid="qbt_category.ibatorgenerated_Example_Where_Clause" />
      <isNotNull property="orderByClause">
        order by $orderByClause$
      </isNotNull>
      <include refid="qbt_category.ibatorgenerated_Example_Page_Clause" />
    </isParameterPresent>
  </select>
  <select id="ibatorgenerated_selectByPrimaryKey" parameterClass="cn.flystone.quubox.foundation.model.QCategory" resultMap="ibatorgenerated_BaseResultMap">
    <!--  [generated on 2012-11-13 13:47:48.531] -->
    select UUID, PARENT_UUID, NAME, COMMENT, RECOMMEND, ORD, CREATE_TIME, UPDATE_TIME
    from qbt_category
    where UUID = #uuid:VARCHAR#
  </select>
  <delete id="ibatorgenerated_deleteByPrimaryKey" parameterClass="cn.flystone.quubox.foundation.model.QCategory">
    <!--  [generated on 2012-11-13 13:47:48.531] -->
    delete from qbt_category
    where UUID = #uuid:VARCHAR#
  </delete>
  <delete id="ibatorgenerated_deleteByExample" parameterClass="cn.flystone.quubox.foundation.model.QCategoryExample">
    <!--  [generated on 2012-11-13 13:47:48.531] -->
    delete from qbt_category
    <include refid="qbt_category.ibatorgenerated_Example_Where_Clause" />
  </delete>
  <insert id="ibatorgenerated_insert" parameterClass="cn.flystone.quubox.foundation.model.QCategory">
    <!--  [generated on 2012-11-13 13:47:48.531] -->
    insert into qbt_category (UUID, PARENT_UUID, NAME, COMMENT, RECOMMEND, ORD, CREATE_TIME,
      UPDATE_TIME)
    values (#uuid:VARCHAR#, #parentUuid:VARCHAR#, #name:VARCHAR#, #comment:VARCHAR#,
      #recommend:INTEGER#, #ord:INTEGER#, #createTime:TIMESTAMP#, #updateTime:TIMESTAMP#)
  </insert>
  <insert id="ibatorgenerated_insertSelective" parameterClass="cn.flystone.quubox.foundation.model.QCategory">
    <!--  [generated on 2012-11-13 13:47:48.532] -->
    insert into qbt_category
    <dynamic prepend="(">
      <isNotNull prepend="," property="uuid">
        UUID
      </isNotNull>
      <isNotNull prepend="," property="parentUuid">
        PARENT_UUID
      </isNotNull>
      <isNotNull prepend="," property="name">
        NAME
      </isNotNull>
      <isNotNull prepend="," property="comment">
        COMMENT
      </isNotNull>
      <isNotNull prepend="," property="recommend">
        RECOMMEND
      </isNotNull>
      <isNotNull prepend="," property="ord">
        ORD
      </isNotNull>
      <isNotNull prepend="," property="createTime">
        CREATE_TIME
      </isNotNull>
      <isNotNull prepend="," property="updateTime">
        UPDATE_TIME
      </isNotNull>
      )
    </dynamic>
    values
    <dynamic prepend="(">
      <isNotNull prepend="," property="uuid">
        #uuid:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="parentUuid">
        #parentUuid:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="name">
        #name:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="comment">
        #comment:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="recommend">
        #recommend:INTEGER#
      </isNotNull>
      <isNotNull prepend="," property="ord">
        #ord:INTEGER#
      </isNotNull>
      <isNotNull prepend="," property="createTime">
        #createTime:TIMESTAMP#
      </isNotNull>
      <isNotNull prepend="," property="updateTime">
        #updateTime:TIMESTAMP#
      </isNotNull>
      )
    </dynamic>
  </insert>
  <select id="ibatorgenerated_countByExample" parameterClass="cn.flystone.quubox.foundation.model.QCategoryExample" resultClass="java.lang.Integer">
    <!--  [generated on 2012-11-13 13:47:48.532] -->
    select count(*) from qbt_category
    <include refid="qbt_category.ibatorgenerated_Example_Where_Clause" />
  </select>
  <update id="ibatorgenerated_updateByExampleSelective">
    <!--  [generated on 2012-11-13 13:47:48.532] -->
    update qbt_category
    <dynamic prepend="set">
      <isNotNull prepend="," property="record.uuid">
        UUID = #record.uuid:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="record.parentUuid">
        PARENT_UUID = #record.parentUuid:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="record.name">
        NAME = #record.name:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="record.comment">
        COMMENT = #record.comment:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="record.recommend">
        RECOMMEND = #record.recommend:INTEGER#
      </isNotNull>
      <isNotNull prepend="," property="record.ord">
        ORD = #record.ord:INTEGER#
      </isNotNull>
      <isNotNull prepend="," property="record.createTime">
        CREATE_TIME = #record.createTime:TIMESTAMP#
      </isNotNull>
      <isNotNull prepend="," property="record.updateTime">
        UPDATE_TIME = #record.updateTime:TIMESTAMP#
      </isNotNull>
    </dynamic>
    <isParameterPresent>
      <include refid="qbt_category.ibatorgenerated_Example_Where_Clause" />
    </isParameterPresent>
  </update>
  <update id="ibatorgenerated_updateByExample">
    <!--  [generated on 2012-11-13 13:47:48.532] -->
    update qbt_category
    set UUID = #record.uuid:VARCHAR#,
      PARENT_UUID = #record.parentUuid:VARCHAR#,
      NAME = #record.name:VARCHAR#,
      COMMENT = #record.comment:VARCHAR#,
      RECOMMEND = #record.recommend:INTEGER#,
      ORD = #record.ord:INTEGER#,
      CREATE_TIME = #record.createTime:TIMESTAMP#,
      UPDATE_TIME = #record.updateTime:TIMESTAMP#
    <isParameterPresent>
      <include refid="qbt_category.ibatorgenerated_Example_Where_Clause" />
    </isParameterPresent>
  </update>
  <update id="ibatorgenerated_updateByPrimaryKeySelective" parameterClass="cn.flystone.quubox.foundation.model.QCategory">
    <!--  [generated on 2012-11-13 13:47:48.532] -->
    update qbt_category
    <dynamic prepend="set">
      <isNotNull prepend="," property="parentUuid">
        PARENT_UUID = #parentUuid:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="name">
        NAME = #name:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="comment">
        COMMENT = #comment:VARCHAR#
      </isNotNull>
      <isNotNull prepend="," property="recommend">
        RECOMMEND = #recommend:INTEGER#
      </isNotNull>
      <isNotNull prepend="," property="ord">
        ORD = #ord:INTEGER#
      </isNotNull>
      <isNotNull prepend="," property="createTime">
        CREATE_TIME = #createTime:TIMESTAMP#
      </isNotNull>
      <isNotNull prepend="," property="updateTime">
        UPDATE_TIME = #updateTime:TIMESTAMP#
      </isNotNull>
    </dynamic>
    where UUID = #uuid:VARCHAR#
  </update>
  <update id="ibatorgenerated_updateByPrimaryKey" parameterClass="cn.flystone.quubox.foundation.model.QCategory">
    <!--  [generated on 2012-11-13 13:47:48.532] -->
    update qbt_category
    set PARENT_UUID = #parentUuid:VARCHAR#,
      NAME = #name:VARCHAR#,
      COMMENT = #comment:VARCHAR#,
      RECOMMEND = #recommend:INTEGER#,
      ORD = #ord:INTEGER#,
      CREATE_TIME = #createTime:TIMESTAMP#,
      UPDATE_TIME = #updateTime:TIMESTAMP#
    where UUID = #uuid:VARCHAR#
  </update>
</sqlMap>

zsw2zkl
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Ibatis中容易让人混淆的property
蜗牛的轨迹
12-28 652
很长时间没有使用ibatis，刚上手易激动写了一个in语句，结果调试了半天没搞定 究其原因原来是     &lt;select id="ItemDao.queryItemByIds" resultMap="itemResult"&gt; select * from t_item where id in &lt;isNotNull property="id"&gt;...
在ibatis中使用Dynamic SQL时property属性的用法
lywybo的专栏
06-13 6121
--- Cause: com.ibatis.common.beans.ProbeException: Error getting ordinal list from JavaBean. Cause java.lang.StringIndexOutOfBoundsException: String index out of range: -1 at com.ibatis.sqlmap.engine
ibatis 使用文档 （下篇）
爱.NET
11-12 155
====================================================================================第5章 使用高级查询技术 一：用已映射语句关联对象 问题：如果你用过Hibernate或JPA，会想到entity（实体对象 -- 数据库对应JavaBean）之间可能存在关联关系。如一对一、多对多等。伴随就出现了关联获取技术，...
ibatis 的语句中 isEqual、property、compareValue，prepend 都代表什么意思
热门推荐
XuJiangDong
04-07 1万+
isequal：作比较用相当于String 里的equal方法， property：指定比较属性的名称， compareValue：表示要比较的参数， prepend：表示追加比较条件
AbatorForEclipse插件使用总结
weixin_33884611的博客
08-14 121
AbatorForEclipse是IbatorForEclipse之前的一个老版插件。插件装好后，我们来使用看看：1，新建一个工程AbatorTest，点击右键，新建一个abatorConfig.xml，如图：建好后如下图：2，我这里是用的mysql，修改abatisconfig.xml文件如下：&lt;?xml version="1.0" encoding="UTF-8" ?&gt;&lt...
ibatis jar
02-23
标题 "ibatis jar" 指的是与MyBatis框架相关的Java Archive (JAR) 文件集合。MyBatis是一个优秀的持久层框架，它允许开发者将SQL语句直接映射到Java代码中，从而简化了数据库操作。这个压缩包很可能是包含MyBatis...
iBATIS SQLMap
01-03
iBATIS SQLMap是一款在Java应用中广泛使用的持久层框架，它将SQL语句与Java代码分离，使得数据库操作更加灵活、易于维护。这个框架的主要目的是简化数据访问层的开发，减少开发人员编写大量重复的JDBC代码。下面将...
ibatis入门
09-15
**Ibatis 入门教程** Ibatis 是一个优秀的 Java ORM（对象关系映射）框架，它允许程序员将数据库操作与业务逻辑分离，提供灵活的 SQL 配置和映射机制，使得开发人员能够自由地编写 SQL 而不被 ORM 的复杂性所束缚。...
ibatis联表查询
lqy_2019
11-12 275
修改ibator代码生成的代码，实现多表关联查询（实现方法） 1. public static class Criteria{}静态内部类的修改 增加属性criteriaJoinTableName、criteriaJoinTableColumn 修改isValid方法 增加方法：public void addJoinTable(String tableNa...
iBATIS的配置文件sqlmapconfig.xml详细说明。
看不过的黑工坊
09-27 6209
转自：http://blog.csdn.net/xwygn/article/details/8145372 >>>>>>sqlMapConfig.xml文件详解" href="http://blog.csdn.net/kardelpeng/article/details/6276643" style="color:rgb(202,0,0); text-decoration:none">i
ibatis学习笔记(三)>>>>>>>java实体跟表映射.xml文件详解
kardelpeng的专栏
03-25 6856
     在项目中使用Ibatis难免会使用到java实体跟表映射.xml.
mybatis中的Example_Where_Clause
lgq2016的博客
08-26 1万+
1.初学mybatis时的疑惑 mybatis中的generatorConfig.xml在生成entity时会生成每个POJO(例如User.java)对应的example POJO: UserExample.java。UserExample可以帮助我们更容易的完成一些数据库操作，在sql定义文件(UserMapper.xml)中会有相应的sql定义语句(例如selectByExample)，它...
com.ibatis.sqlmap.client.SqlMapExceptionThere is no statement named XIU_ITEM_INFO.ibatorgenerated_in
yasuuu.taobao.com
03-22 1642
查看XIU_ITEM_INFO_SqlMap.xml  两个statement都有  ，就是找不到问题，后来发现先前为了做测试 --> --> 查看我的sqlmap.xml文件 把注释去掉ok啦 com.ibatis.sqlmap.client.SqlMapException: There is no statement named XIU_ITEM_INFO.ib
Mybatis重置Criteria的正确姿势
明明如月的技术博客
08-25 1万+
开发中遇到Mybatis生成的Example通过调用createCriteria()来创建Criteria并设置查询条件的情况。 但是需要换一个查询条件再次查询时发现再次调用该方法“无效果"。 看到大多数的做法是通过new一个新的Example来查询，考虑到可能不是最好的或者最合理的做法，对此进行了简单研究。 发现问题原因如下，我们看下生成的Exmaple的源码： public ...
关于Ibatis的isNotEmptyproperty的理解
天才小熊猫的博客
07-03 2945
select* from menu                                                 parentId= #parentId#                          如果传入的parentId不是null或者空字符串，那么prepend就加在你执行的  parentId = #parentId# 之前，也就是 and
eclipse ibatis
最新发布
01-06
Eclipse是一个流行的集成开发环境（IDE），而iBatis是一个持久层框架，用于简化Java应用程序的数据库访问。Eclipse iBatis是通过Eclipse插件来支持iBatis框架的开发工具。它提供了一系列的功能和工具，帮助开发人员...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值