首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > Java Web开发 >

求HQL语句 急

2012-06-03 
求HQL语句 急啊在线等sql select * from Data where adddate between +addDate+ and +endDate+ and f

求HQL语句 急啊 在线等
sql = select * from Data where adddate between "+addDate+" and "+endDate+" and fkpiname = "+name+""
  这句话 怎么写成HQL语句

[解决办法]
return this.getHibernateTemplate().find("select * from Data where adddate between ?and ? and fkpiname = ?",
new Object[] {name,addDate,endDate});

[解决办法]
sql = select * from Data where adddate between "+addDate+" and "+endDate+" and fkpiname = "+name+""
 
换成 sql="from Data where adddate between "+addDate+" and "+endDate+" and fkpiname = "+name+""
 

[解决办法]
hql="from Data where adddate >="+addDate+" and adddate<="+endDate+" and fkpiname = "+name;
[解决办法]

Java code
hql = "from Data where adddate between '"+addDate+"' and '"+endDate+"' and fkpiname = '"+name+"'";
[解决办法]
不需要进行日期转换吗
[解决办法]
hql和sql没有区别呀
sql怎么写,hql就怎么写
[解决办法]
探讨

return this.getHibernateTemplate().find("select * from Data where adddate between ?and ? and fkpiname = ?",
new Object[] {name,addDate,endDate});

热点排行