判断sql中有没有重复项

来源:互联网 发布:苹果电脑性能测评软件 编辑:程序博客网 时间:2024/04/28 04:46

   sql = "if not exists(select * from Sw_Shopping where Name='" + name + "') insert into Sw_Shopping(UserIP,SelectId,Name,Pic,Dec,Sw_Price,Carriage,GoodsNum) values ('" + UserIP + "','" + Id + "','" + name + "','" + pic + "','" + dec + "','" + Sw_Price + "','" + Carriage + "',1)";