ArrayList al = new ArrayList(); foreach() { //这里是遍历一个XML取出ProdId的值加到数组里面 al.add(prodID); }我想实现的功能是从表中取出prodId看看它在不在这个数组里,如果不在的话就把表中的这条数据删除,就是类似于 delete from product where prodId not in(...); 请问如何实现呢?谢谢!
我是想写成这样的SQL语句: delete from product where prodId not in al(数组)就是这样类似的写法, php里好像可以这样写: DELETE FROM products WHERE prodId NOT IN ('.substr($al, 1).') 如果按照楼上几位兄弟那样,我还要用循环,逐条取ID然后再与数组中的值比较,会不会太慢了?
if(!al.Contains("你从表中取出的ID"))
{
//执行删除
}
{
执行数据库的delete语句
}
删除该条数据
}
delete from product where prodId not in al(数组)就是这样类似的写法,
php里好像可以这样写:
DELETE FROM products WHERE prodId NOT IN ('.substr($al, 1).')
如果按照楼上几位兄弟那样,我还要用循环,逐条取ID然后再与数组中的值比较,会不会太慢了?
http://www.cnblogs.com/blusehuang/archive/2007/07/08/810485.html
{
//执行删除
}