public UserRole getUserRoleByUserIdAndRoleId(String userId,String roleId){
Session session = sessionFactory.openSession();
Transaction tx = null;
UserRole userRole = null;
try{
tx = session.beginTransaction();
Query query = session.createQuery( "from UserRole ur where ur.userId:=userId " +
"and ur.roleId:=roleId ");
query.setString( "userId ", userId);
query.setString( "roleId ", roleId);
userRole = (UserRole)query.uniqueResult();
}catch(Exception e){
if(tx != null){
tx.rollback();
}
}finally{
session.close();
}
return userRole;
}没看见你事务的提交,是不是漏了提交事务呢。
应该不关参数绑定的事情,你可以先不用绑定的方法查询看看行不行。
Session session = sessionFactory.openSession();
Transaction tx = null;
UserRole userRole = null;
try{
tx = session.beginTransaction();
Query query = session.createQuery( "from UserRole ur where ur.userId:=userId " +
"and ur.roleId:=roleId ");
query.setString( "userId ", userId);
query.setString( "roleId ", roleId);
userRole = (UserRole)query.uniqueResult();
}catch(Exception e){
if(tx != null){
tx.rollback();
}
}finally{
session.close();
}
return userRole;
}没看见你事务的提交,是不是漏了提交事务呢。
应该不关参数绑定的事情,你可以先不用绑定的方法查询看看行不行。
早日结贴!