本文介绍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();
在模型定义一个 public Array SDSALES_IDs {get;set;}
XML:
DELETE FROM T_LABEL_SDSALES WHERE
SDSALES_ID IN
#SDSALES_IDs[]#
复制代码 代码如下:
string SDSALES_IDString = 1,2,3,4,5,6,7
//转成Array
Array array = SDSALES_IDString.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray
在模型定义一个 public Array SDSALES_IDs {get;set;}
XML:
复制代码 代码如下:
DELETE FROM T_LABEL_SDSALES WHERE
SDSALES_ID IN
#SDSALES_IDs[]#
以上就是Ibatis.net结合oracle批量删除实现代码的详细内容,更多请关注0133技术站其它相关文章!