ibatis xml特别的用法
来源:互联网 发布:淘宝店铺买卖 安全吗 编辑:程序博客网 时间:2024/04/30 04:35
1)xml中使用In
Long[] cdcids;
params.put("cdcid", cdcids);
<selectid="queryWare"resultClass="Ware"parameterClass="Map">
select
storeid as storeId,
wid,
fdcid as fdcId
from ware
where 1=1
<isNotNull prepend="and" property="cdcid">
fdcid in
<iterate open="(" close=")" conjunction="," property="cdcid">
#cdcid[]#
</iterate>
</isNotNull>
orderby fdcid
<isNotNull property="startRow">
limit $startRow$,$pageSize$
</isNotNull>
</select>
2)
<deleteid="deleteWareStockSetting"parameterClass="Map">
deletefrom ware_stock_setting where fdcid in($fdcId$)
</delete>
fdcId 是map中的KEY value是String,”,”间隔
3) xml中日期格式转化,比较大小
<selectid="getBannedWareList" resultClass="BannedWare">
selectbw.id,bw.wid, bw.wname,bw.src_id as srcId,
bw.src_name as srcName,bw.tgt_id as tgtId
from banned_ware bw
where date_format(now(),'%Y-%m-%d')<![CDATA[>=]]> date_format(effective_date,'%Y-%m-%d')
and date_format(now(),'%Y-%m-%d') <![CDATA[<=]]> date_format(release_date,'%Y-%m-%d')
</select>
4)
<isEqual property="sortType" compareValue="0">
orderby convert(w.wnameusing gbk) asc
</isEqual>
<isEqual property="sortType" compareValue="1">
orderby item.fdcStock/(item.forecasting/7) asc
</isEqual>
5)
<sqlid="Base_Column_List">
id,product_code, product_name, wpid1, wpid1_name, wpid2, wpid2_name, wpid3,wpid3_name, purc_user_code, purc_user_name, vendor_code, vendor_name,create_date
</sql>
<!--查詢商品信息表所有sku -->
<selectid="queryProductListBySku"resultMap="product.BaseResultMap"parameterClass="java.util.List">
SELECTDISTINCT
<include refid="Base_Column_List"/>
FROM
product_info
WHERE
product_code
IN
<iterateclose=")"open="(" conjunction=",">
<![CDATA[
#[]#
]]>
</iterate>
</select>
6)
<selectid="queryStablityFactor"parameterClass="java.util.Map"resultClass="StabilityFactor">
SELECT fdcid,wpid2,(SUM(stability_factor)/#weeks#) stabilityFactor
FROM stability_factor WHERE create_time BETWEEN(CURDATE() - INTERVAL 22 DAY) AND (CURDATE() + INTERVAL 1 DAY)
<isNotEmptyproperty="wpid2">
and wpid2 = #wpid2#
</isNotEmpty>
<isNotEmptyproperty="fdcid">
and fdcid=#fdcid#
</isNotEmpty>
GROUP BY fdcid, wpid2
</select>
7)<insertid="insertFilterRateAndWrongRate"parameterClass="Map">
insertinto filter_rate_and_wrong_rate
(fdcid,filter_rate,wrong_rate,WEEK,creator,create_time,total,year,orgid)
values(#fdcid#,#filter_rate#,#wrong_rate#, WEEKOFYEAR(CURDATE()),0,now(),#total#,YEAR(CURDATE()),#orgid#)
</insert>
8)<deleteid="deleteWareStockSetting"parameterClass="Map">
deletefrom ware_stock_setting where fdcid in($fdcId$)
</delete>
fdcId是map中的KEY value是String,”,”间隔
- ibatis xml特别的用法
- xml(ibatis配置)中CDATA的用法
- NULL的特别用法
- #define 的特别用法
- ibatis配置xml文件中CDATA的用法
- ibatis配置xml文件中CDATA的用法
- XML没有什么特别的
- Ibatis的sqlMapConfig.xml
- ibatis#和$的用法
- Ibatis-dynamic的用法
- Ibatis-dynamic的用法
- ibatis的用法简介
- ibatis dynamic的用法
- ibatis-dynamic的用法
- ibatis-dynamic的用法
- ibatis-dynamic的用法
- Ibatis-dynamic的用法
- ibatis dynamic的用法
- mipmap和drawable一个使用的区别
- Objective-C单例模式的正确写法
- Script入门篇
- 大蒟蒻的1557
- 最少步数 OJ 58
- ibatis xml特别的用法
- Android系统权限和root权限
- RecyclerView的基本用法 (三)
- metero 常用命令 合集
- java不用循环语句打印数组元素
- Thinkphp 下的关联模型的使用
- 分享一些优秀有趣的博客
- 自己对多线程的一点思考
- win10问题集——打不开左下角