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 --------------------编程问答-------------------- 你最好把你这段SQL语句 在工具软件下跑一下 看是不正确
如果你SQL语句在如:plsql下都无法跑出数据那就当然没有数据。 --------------------编程问答-------------------- 我的sql语句没有问题能查出数据来。在sqlserver2005数据库里有数据的 --------------------编程问答-------------------- 如果 在数据库里执行可以查出结果。那应该是组装Sql时有问题了。 --------------------编程问答-------------------- 没有人知道吗? --------------------编程问答-------------------- 好东西,收藏了 --------------------编程问答-------------------- 不知道楼主解决了没有?网上没找到解决办法。
补充:Java , Java EE