61,115
社区成员
发帖
与我相关
我的任务
分享
public int insert(Opers stu){
String sql="INSERT INTO oper(infoid,postuser,postdate)SELECT id,pch,NOW() FROM info WHERE NOT EXISTS (SELECT * FROM oper WHERE oper.infoid=info.id)";
manager.getConn();
try{
return manager.insert(sql, stu);
}catch (Exception e) {
// TODO: handle exception
return 0;
}
}