SQLQuery查询结果为空，这是怎么回事？

这个是原始sql语句
String sql = "select u.id, u.sid , u.name , a.approveNum , a.approveNumTotal , a.id " +
" from tbl_user as u " +
" left join tbl_apply as a on u.id=a.userId AND a.sid like '%" + verifyIdS + "%' " +
" AND a.sure=2 "+
" where u.sid like '%D%' OR u.sid like '%H%' " +
" ORDER BY u.id ASC ";
SQLQuery sqlQuery = sessionFactory.getCurrentSession().createSQLQuery(sql);
List listT = sqlQuery.list();

return listT;

以下是控制台的信息

11:46:43,598 DEBUG JDBCTransaction:54 - begin
11:46:43,599 DEBUG ConnectionManager:421 - opening JDBC connection
11:46:43,600 DEBUG JDBCTransaction:59 - current autocommit status: true
11:46:43,602 DEBUG JDBCTransaction:62 - disabling autocommit
11:46:49,866 DEBUG AbstractBatcher:366 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
11:46:49,878 DEBUG SQL:401 -
    select
        u.id,
        u.sid ,
        u.name ,
        a.approveNum ,
        a.approveNumTotal ,
        a.id
    from
        tbl_user as u
    left join
        tbl_apply as a
            on u.id=a.userId
            AND a.sid like '%201101%'
            AND a.sure=2
    where
        u.sid like '%D%'
        OR u.sid like '%H%'
    ORDER BY
        u.id ASC
Hibernate:
    select
        u.id,
        u.sid ,
        u.name ,
        a.approveNum ,
        a.approveNumTotal ,
        a.id
    from
        tbl_user as u
    left join
        tbl_apply as a
            on u.id=a.userId
            AND a.sid like '%201101%'
            AND a.sure=2
    where
        u.sid like '%D%'
        OR u.sid like '%H%'
    ORDER BY
        u.id ASC
11:46:49,896 DEBUG AbstractBatcher:382 - about to open ResultSet (open ResultSets: 0, globally: 0)
11:46:49,934 DEBUG AbstractBatcher:389 - about to close ResultSet (open ResultSets: 1, globally: 1)
11:46:49,943 DEBUG AbstractBatcher:374 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
11:46:49,954 DEBUG StatefulPersistenceContext:787 - initializing non-lazy collections

6 个解决方案

#1

你最好把你这段SQL语句在工具软件下跑一下看是不正确
如果你SQL语句在如:plsql下都无法跑出数据那就当然没有数据。

#2

我的sql语句没有问题能查出数据来。在sqlserver2005数据库里有数据的

#3

如果在数据库里执行可以查出结果。那应该是组装Sql时有问题了。

#4

没有人知道吗？

#5

好东西，收藏了

#6

不知道楼主解决了没有？网上没找到解决办法。

#1