hibernate sql 操作

@SuppressWarnings("unchecked")
    public List<ZxFunction> selectFunctionParentByUserId(final int userId) {
        try {
            final String sql = "select *  from zx_function where f_id in ( select distinct f.f_parent_id from zx_function f,zx_permission p where p.f_id = f.f_id and p.u_id = ?)";

            return (List<ZxFunction>) getHibernateTemplate().execute(new HibernateCallback(){
                public Object doInHibernate(Session session)
                    throws HibernateException, SQLException {
                SQLQuery query = session.createSQLQuery(sql).addEntity(ZxFunction.class);
                query.setInteger(0, 1);
                return query.list();
            }});
        } catch (Exception e) {
            CommonsLog4jUtil.printToConsole(e);
            CommonsLog4jUtil.error("FunctionDaoImpl public List<UserFunction> selectFunctionParentByUserId() Error:", e);
            return null;
        }
    }

 

 

 

@SuppressWarnings("unchecked")
    public List<UserFunction> selectFunction(final int userId) {
        try {
            final String sql = "select f.f_id as FId," +
                    " f.f_name  as FName," +
                    " f.f_link as FLink," +
                    " f.f_img as FImg, " +
                    " f.f_parent_id as FParentId," +
                    " p.up_id as upId," +
                    " p.u_id as UId ," +
                    " p.up_permission as upPermission from zx_function f,zx_permission p where p.f_id = f.f_id and p.u_id = ?";

            List<UserFunction> resultList = (List<UserFunction>) getHibernateTemplate().execute(new HibernateCallback(){
                public Object doInHibernate(Session session) throws HibernateException, SQLException {
                SQLQuery query = session.createSQLQuery(sql);
                query.setResultTransformer(Transformers.aliasToBean(UserFunction.class));
                query.setInteger(0, 1);
                return query.list();
            }});
           
           
            return resultList;
        } catch (Exception e) {
            CommonsLog4jUtil.printToConsole(e);
            CommonsLog4jUtil.error("FunctionDaoImpl public List<UserFunction> selectFunctionParentByUserId() Error:", e);
            return null;
        }
    }