67,513
社区成员
发帖
与我相关
我的任务
分享
public List<Program> getUnCheckProgram(Long userId) {
String sql="select * from program where pid not in (select pid from t_user_program where userId like ?)";
SQLQuery sqlQuery=session.createSQLQuery(sql);
Query query=sqlQuery.addEntity(Program.class);
query.setParameter(0,userId);
List<Program> programList=query.list();
return programList;
}