Ibatis.net结合oracle批量删除实现代码
来源:懂视网
责编:小采
时间:2020-11-27 22:42:14
Ibatis.net结合oracle批量删除实现代码
Ibatis.net结合oracle批量删除实现代码:要删除的字符串ID为 代码如下:string SDSALES_IDString = 1,2,3,4,5,6,7 //转成Array Array array = SDSALES_IDString.Split(new string[] { , }, StringSplitOptions.RemoveEmptyEntries).ToArray&
导读Ibatis.net结合oracle批量删除实现代码:要删除的字符串ID为 代码如下:string SDSALES_IDString = 1,2,3,4,5,6,7 //转成Array Array array = SDSALES_IDString.Split(new string[] { , }, StringSplitOptions.RemoveEmptyEntries).ToArray&
要删除的字符串ID为
代码如下:
string SDSALES_IDString = 1,2,3,4,5,6,7
//转成Array
Array array = SDSALES_IDString.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray<string>();
在模型定义一个 public Array SDSALES_IDs {get;set;}
XML:
代码如下:
<delete id="DeleteManyT_LABEL_SDSALES" parameterClass="T_LABEL_SDSALES">
DELETE FROM T_LABEL_SDSALES WHERE
<isNotNull property="SDSALES_IDs">
SDSALES_ID IN
<iterate property="SDSALES_IDs" conjunction="," open="(" close=")">
#SDSALES_IDs[]#
</iterate>
</isNotNull>
</delete>
声明:本网页内容旨在传播知识,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
Ibatis.net结合oracle批量删除实现代码
Ibatis.net结合oracle批量删除实现代码:要删除的字符串ID为 代码如下:string SDSALES_IDString = 1,2,3,4,5,6,7 //转成Array Array array = SDSALES_IDString.Split(new string[] { , }, StringSplitOptions.RemoveEmptyEntries).ToArray&