hql语句
select a from Attendance as a where 1=1 and substring(CONVERT(varchar(10),a.beginTime,111),0,11) ='2009/07/31'Hibernate 生成的sql语句为什么“substring(CONVERT(varchar(10), attendance0_.begin_time, 111))='2009/07/31'”少了两个参数Hibernate: select attendance0_.attendance_id as attendance1_7_, attendance0_.attendance_user as attendance2_7_, attendance0_.statu_id as statu3_7_, attendance0_.employee_id as employee4_7_, attendance0_.begin_time as begin5_7_, attendance0_.end_time as end6_7_, attendance0_.re as re7_ from Seedling.dbo.Attendance attendance0_ where 1=1 and substring(CONVERT(varchar(10), attendance0_.begin_time, 111))='2009/07/31' order by attendance0_.begin_time desc
select a from Attendance as a where 1=1 and substring(CONVERT(varchar(10),a.beginTime,111),0,11) ='2009/07/31'Hibernate 生成的sql语句为什么“substring(CONVERT(varchar(10), attendance0_.begin_time, 111))='2009/07/31'”少了两个参数Hibernate: select attendance0_.attendance_id as attendance1_7_, attendance0_.attendance_user as attendance2_7_, attendance0_.statu_id as statu3_7_, attendance0_.employee_id as employee4_7_, attendance0_.begin_time as begin5_7_, attendance0_.end_time as end6_7_, attendance0_.re as re7_ from Seedling.dbo.Attendance attendance0_ where 1=1 and substring(CONVERT(varchar(10), attendance0_.begin_time, 111))='2009/07/31' order by attendance0_.begin_time desc
解决方案 »
- ajax
- 可以从客户端读取图片吗?
- Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 3.
- 本人新人。但对B/S有着强烈的兴趣。现碰到几个很小的问题…………
- 求助呀,急,flash单独可以显示,放在服务器上无法显示了
- 一个servlet调用另一个servlet编译问题
- 100分就给你了!我的一个JSP文件目录下有一个XML文件,JSP文件要从XML文件读出记录要怎么做?
- 菜鸟问题:如何修改entity bean中的纪录。
- 关于用户验证的问题
- 两个servlet之间如何通讯?
- 在IE中 错误'ScreenSize' 未定义 腾讯TT中 错误'main_height' 未定义 怎么解决啊 是不是浏览器有问题啊
- 怎样自动设置每个文件的备注信息?
但是用Hibernate生成就不行了少两个参数
但是用Hibernate生成就不行了少两个参数
sql语句执行结果