67,513
社区成员
发帖
与我相关
我的任务
分享
public Map getUserQuery(Session session , Long userId ,Long companyId)throws Exception{
StringBuffer sql = new StringBuffer()
.append(" select id \"id\",company_id \"companyId\",user_id \"userId\",create_date \"createDate\",mail_sent \"mailSent\", ")
.append(" mail_open \"mailOpen\",result \"result\",last_date \"lastDate\",del_flag \"delFlag\" ")
.append(" from r3_user_query uq where uq.user_id = :userId and uq.company_id = :companyId ");
Query query = session.createSQLQuery(sql.toString());
query.setParameter("userId", userId).setParameter("companyId", companyId);
return (Map)query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).uniqueResult();
}