读书人

求HQL语句 急

发布时间: 2012-06-03 16:59:40 作者: rapoo

求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});

读书人网 >Java Web开发

热点推荐