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

[yinzheziju]

这个是原始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

[yinzheziju]

没有人知道吗？

[你妹挤地铁]

好东西，收藏了

[芒果]

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

[yinzheziju]

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

[JavaMan]

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

[只是_曾经]

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