public int deleteGoodsOne(String goodid,int status) {
int i = 0;
String sql = "";
if(status == 1 || status == 2)
{
sql = "update goods set status = 0 where goodid = ?";
//这里想增加update record set status = 0 where goodid = ?
}else{
sql = "update goods set status = 1 where goodid = ?";
//这里想增加update record set status = 0 where goodid = ?
}
conn = db.getConn();
try {
ps = conn.prepareStatement(sql);
ps.setString(1,goodid);
i=ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
db.closeDB(conn);
}
return i;
}
请问怎么实现?
还是不行啊,能在我的代码基础上改吗?