Hibernate createSQLQuery分页模糊查询

1:hibernate 占位符 :name 或者 ? 都可以.

org.hibernate.PropertyNotFoundException: Could not find setter for emp_name on class pojo.Employee
    at org.hibernate.property.ChainedPropertyAccessor.getSetter(ChainedPropertyAccessor.java:66)
    at org.hibernate.transform.AliasToBeanResultTransformer.initialize(AliasToBeanResultTransformer.java:121)
    at org.hibernate.transform.AliasToBeanResultTransformer.transformTuple(AliasToBeanResultTransformer.java:84)
    at org.hibernate.hql.internal.HolderInstantiator.instantiate(HolderInstantiator.java:95)
    at org.hibernate.loader.custom.CustomLoader.getResultList(CustomLoader.java:446)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
    at org.hibernate.loader.Loader.list(Loader.java:2365)
    at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:353)
    at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1909)
    at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311)
    at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141)
    at dao.UserDao.queryPageEmpByName(UserDao.java:72)
    at serviceimpl.UserServiceImpl.queryPageEmpByName(UserServiceImpl.java:54)
    at controller.IndexServlet.doPost(IndexServlet.java:44)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:652)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1317)
    at filter.LoginFilter.doFilter(LoginFilter.java:40)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1288)
    at filter.EncodingUtf8Filter.doFilter(EncodingUtf8Filter.java:26)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1288)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:443)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
    at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:556)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1044)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:372)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:189)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:978)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
    at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255)
    at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
    at org.eclipse.jetty.server.Server.handle(Server.java:369)
    at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:486)
    at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:944)
    at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1005)
    at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865)
    at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
    at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667)
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
    at java.lang.Thread.run(Thread.java:745)

解决方式:查看实体类的属性名称 是否和 表的字段名一致,不一致的要取别名.
query.setParameter(“name”: string); 要设置两次

public Page<Employee> queryPageEmpByName(Session session, String name, int pageIndex, int pageSize) {
        Transaction ts = session.beginTransaction();
        if(name == null || name=="") {
          name="";
        }
        String sql = "select emp_name empName,emp_no empNo,hire_date hireDate,job,salary from employee where emp_name like :emp_name";
        String sql2 = "select count(*) from employee where emp_name like :emp_name";
        Query query= session.createSQLQuery(sql);

        query.setFirstResult((pageIndex-1)*pageSize);
        query.setMaxResults(pageSize);
        query.setParameter("emp_name", "%"+name+"%");
        //查询用户列表数据
        List<Employee> emplist = query.setResultTransformer(Transformers.aliasToBean(Employee.class)).list();
        //查询用户数量        
        query =session.createSQLQuery(sql2);
        query.setParameter("emp_name", "%"+name+"%");
        BigInteger count = (BigInteger) query.uniqueResult();

        //封装成Page 类型
        Page< Employee> emPage = new Page<>();
        emPage.setList(emplist);
        emPage.setPageIndex(pageIndex);
        emPage.setPageSize(pageSize);
        emPage.setPageTotal(count.intValue(), pageSize);
        ts.commit();
        return emPage;
    }