2010.01.13——hql 的时间问题弄了一下午郁闷

最新推荐文章于 2021-09-02 11:36:28 发布

cody123

最新推荐文章于 2021-09-02 11:36:28 发布

阅读量142

点赞数

文章标签： DAO

本文链接：https://blog.csdn.net/cody123/article/details/83529541

版权

2010.01.13——hql 的时间问题弄了一下午郁闷
Dao的方法如下

public Double getYuliang(String stcd, Date startTime, Date endTime) {   
        CustomerContextHolder.setCustomerType("query_su9921");   
        String hql = "select sum(s.DYP) from ST_PPTN_R s where s.STCD=? " +   
        "and s.TM>to_date(?,'yyyy-MM-dd HH24:mi:ss') " +   
        "and s.TM<to_date(?,'yyyy-MM-dd HH24:mi:ss')";   
        System.out.println(startTime);   
        System.out.println(endTime);   
        String s = FormatDate.formatDate(startTime, "yyyy-MM-dd HH:mm:ss");   
        String e = FormatDate.formatDate(endTime, "yyyy-MM-dd HH:mm:ss");   
        System.out.println(s);   
        System.out.println(e);   
        Object[] values = {stcd,s,e};   

        log.info(hql);   
        return (Double)this.template.find(hql,values).get(0);   
    }

测试的方法：

@Test  
    public void testGetYuliang() throws ParseException {   
        String stcd = "62518600";   
        YuliangDao yuliangDao = (YuliangDao) ctx.getBean("yuliangDao");   
        Date startTime = new Date();   
        System.out.println(startTime);   
        Calendar endTime = Calendar.getInstance();   
        endTime.setTime(startTime);   
        endTime.add(Calendar.YEAR, 1);   
        System.out.println(endTime.getTime());   

        Double num = yuliangDao.getYuliang(stcd, startTime, endTime.getTime());   
        System.out.println(num);   
        Assert.assertNotNull(num);   
    }

junit的主要错误信息如下：

org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: TM of: com.pojo.rthi.ST_PPTN_R [select sum(s.DYP) from com.pojo.rthi.ST_PPTN_R s where s.STCD=? and s.TM>to_date(?,'yyyy-MM-dd HH24:mi:ss') and s.TM<to_date(?,'yyyy-MM-dd HH24:mi:ss')]; nested exception is org.hibernate.QueryException: could not resolve property: TM of: com.pojo.rthi.ST_PPTN_R [select sum(s.DYP) from com.pojo.rthi.ST_PPTN_R s where s.STCD=? and s.TM>to_date(?,'yyyy-MM-dd HH24:mi:ss') and s.TM<to_date(?,'yyyy-MM-dd HH24:mi:ss')]

竟然说找不到TM 郁闷我的映射肯定是没错，这个问题弄了一个下午，到最后原因竟然是：
把s.TM 改为TM就对了原因不明终于解决了我是内牛满面啊

ps：另外那个dao的方法可以简单化为：

public Double getYuliang(String stcd, Date startTime, Date endTime) {
		CustomerContextHolder.setCustomerType("query_su9921");
		String hql = "select sum(s.DYP) from ST_PPTN_R s where s.STCD= ? and TM between ? and ?";
		log.info(startTime);
		log.info(endTime);
		Object[] values = {stcd,startTime,endTime};
		log.info(hql);
		return (Double)getHibernateTemplate().find(hql,values).get(0);
	}

就是说可以直接用Date对象来注入