hql语句怎样修改
public List<TUser> getAllUsersByPage(TUser user, Pager pager) {
String sql = "from TUser where groupId != 0";
if (user != null){
if (user.getUserName() != null && !user.getUserName().equals("")){
sql += " and userName like '%" + user.getUserName() +"%'";
}
}
if(user !=null){
if(user.getGroupId() !=null && !user.getGroupId().equals("")){
sql +=" and groupId = "+ user.getGroupId() +" ";
}
}
所报异常如下:
unexpected token: 2 near line 1, column 70 [from com.tcs.sysmanager.pojo.TUser where groupId != 0 and groupId in 2 ]