List list= this.getHibernateTemplate().find(hql.toString());
发出SQL语句select leg.destcode from Leg leg left join leg.flight flt where leg.destcode='HAK' and leg.tmatd <= to_date('2011-10-19 13:30','yyyy-MM-dd HH24:mi') and leg.tmatd >= to_date('2011-10-19 10:30','yyyy-MM-dd HH24:mi') order by leg.tmatd desc
14:16:59,718 INFO [STDOUT] Hibernate:
/* select
leg.destcode
from
Leg leg
left join
leg.flight flt
where
leg.destcode='HAK'
and leg.tmatd <= to_date('2011-10-19 13:30','yyyy-MM-dd HH24:mi')
and leg.tmatd >= to_date('2011-10-19 10:30','yyyy-MM-dd HH24:mi')
order by
leg.tmatd desc */ select
leg0_.LEG_DESTCITY as col_0_0_
from
VIEW_TA_LEG leg0_
left outer join
TA_FLIGHT flight1_
on leg0_.FLT_ID=flight1_.FLT_ID
where
leg0_.LEG_DESTCITY='HAK'
and leg0_.LEG_TMATD<=to_date('2011-10-19 13:30', 'yyyy-MM-dd HH24:mi')
and leg0_.LEG_TMATD>=to_date('2011-10-19 10:30', 'yyyy-MM-dd HH24:mi')
order by
leg0_.LEG_TMATD desc
然后用这句SQL语句到数据库中执行可以得到数据,但现在list里面却是“”空串,求大侠帮忙
发出SQL语句select leg.destcode from Leg leg left join leg.flight flt where leg.destcode='HAK' and leg.tmatd <= to_date('2011-10-19 13:30','yyyy-MM-dd HH24:mi') and leg.tmatd >= to_date('2011-10-19 10:30','yyyy-MM-dd HH24:mi') order by leg.tmatd desc
14:16:59,718 INFO [STDOUT] Hibernate:
/* select
leg.destcode
from
Leg leg
left join
leg.flight flt
where
leg.destcode='HAK'
and leg.tmatd <= to_date('2011-10-19 13:30','yyyy-MM-dd HH24:mi')
and leg.tmatd >= to_date('2011-10-19 10:30','yyyy-MM-dd HH24:mi')
order by
leg.tmatd desc */ select
leg0_.LEG_DESTCITY as col_0_0_
from
VIEW_TA_LEG leg0_
left outer join
TA_FLIGHT flight1_
on leg0_.FLT_ID=flight1_.FLT_ID
where
leg0_.LEG_DESTCITY='HAK'
and leg0_.LEG_TMATD<=to_date('2011-10-19 13:30', 'yyyy-MM-dd HH24:mi')
and leg0_.LEG_TMATD>=to_date('2011-10-19 10:30', 'yyyy-MM-dd HH24:mi')
order by
leg0_.LEG_TMATD desc
然后用这句SQL语句到数据库中执行可以得到数据,但现在list里面却是“”空串,求大侠帮忙
解决方案 »
- 字符串数组转化为字符串类型,如下代码错误求解
- action 对应struts
- Struts2 Hibernate 一对多保存问题
- 大家进行讨论下,接口怎么使用才真正合理
- 向A发送请求,同时传送用户名给A,A根据用户名返回密码,并显示在页面上,怎么实现(已知A的url和接口协议)
- 除了head first java外,我还改看什么书?
- JdbcTemplate 的问题!! 非常着急
- 如何做到不重启JBoss重新载入web-inf中的类
- 请问Struts-config.XML文件中能否实现动态地从Session中取得值赋给<forward>
- 急Message Driven Bean 错误
- 有人用过HornetQ么?求助
- 关于struts.xml配置的问题
new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createQuery(hsql);
query.setFirstResult(start);
query.setMaxResults(size);
List<SmsResp> list = query.list();
return list;
} });这样看看行不行呢?还有你上面那句
不知道这句是打出来的是sql语句 还是你的hql语句?如果是hql语句 那可能有问题
如果是控制台打出来的sql 那你就用这句去数据库执行看有没数据
这句是我的打印的SQL语句 ,后面这些是控制台输出的/* select
leg.destcode
from
Leg leg
left join
leg.flight flt
where
leg.destcode='HAK'
and leg.tmatd <= to_date('2011-10-19 13:30','yyyy-MM-dd HH24:mi')
and leg.tmatd >= to_date('2011-10-19 10:30','yyyy-MM-dd HH24:mi')
order by
leg.tmatd desc */ select
leg0_.LEG_DESTCITY as col_0_0_
from
VIEW_TA_LEG leg0_
left outer join
TA_FLIGHT flight1_
on leg0_.FLT_ID=flight1_.FLT_ID
where
leg0_.LEG_DESTCITY='HAK'
and leg0_.LEG_TMATD<=to_date('2011-10-19 13:30', 'yyyy-MM-dd HH24:mi')
and leg0_.LEG_TMATD>=to_date('2011-10-19 10:30', 'yyyy-MM-dd HH24:mi')
order by
leg0_.LEG_TMATD desc
14:41:44,343 INFO [STDOUT] Hibernate:
/* select
leg.tmatd
from
Leg leg
left join
leg.flight flt
where
leg.destcode='HAK'
and leg.tmatd <= to_date('2011-10-19 13:30','yyyy-MM-dd HH24:mi')
and leg.tmatd >= to_date('2011-10-19 10:30','yyyy-MM-dd HH24:mi')
order by
leg.tmatd desc */ select
*
from
( select
leg0_.LEG_TMATD as col_0_0_
from
VIEW_TA_LEG leg0_
left outer join
TA_FLIGHT flight1_
on leg0_.FLT_ID=flight1_.FLT_ID
where
leg0_.LEG_DESTCITY='HAK'
and leg0_.LEG_TMATD<=to_date('2011-10-19 13:30', 'yyyy-MM-dd HH24:mi')
and leg0_.LEG_TMATD>=to_date('2011-10-19 10:30', 'yyyy-MM-dd HH24:mi')
order by
leg0_.LEG_TMATD desc )
where
rownum <= ?
结果集list也是空串
debug一下看看返回的list是否真是空啊。
@192.168.9.8:1521:orcl和
@192.168.9.9:1521:orcl的数据库表都是一样的
192.168.9.9:1521:orcl这个库有数据,
192.168.9.8:1521:orcl这个库没有数据,
配置连接的是192.168.9.8:1521:orcl这个 所以就一直郁闷找不到数据。
再次谢谢大家