Java教程

where in 删除

本文主要是介绍where in 删除,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

/// <summary>
/// 删除
/// </summary>
/// <param name="ids"></param>
public int Delete(string ids)
{
try
{
string[] id = ids.Split(',');
string str = "";
for (int i = 0; i < id.Length; i++)
{
str += "'" + id[i] + "',";
}
str = str.TrimEnd(',');

string sql = "delete from [dbo].[DM_DeviceInfo] where Id in (" + str + ")";
return DbHelperSQL.ExecuteSql(sql);
}
catch (Exception ex)
{
return -1;
}
}

这篇关于where in 删除的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!