Hibernate的原生SQL查询
折腾了我半天终于搞定了
参考了这个文章：http://doc.javanb.com/hibernate-reference-3-2-0-zh/ch16.html
final static String querySql = "select {enterprise.*}, {dict.*} ,{balancd.*}, {weightinfo.*} "
+ "from weight_info weightinfo left outer join t_dict dict on {weightinfo}.productcode={dict}.code join "
+ "t_balancecode {balancd} on {weightinfo}.balancecode={balancd}.balancecode join t_enterprise enterprise "
+ "on {enterprise}.id={balancd}.enterpriseid where "
+ " {weightinfo}.operdate>TO_TIMESTAMP('2009-11-2 04:12:32.0', 'yyyy-mm-dd hh24:mi:ssxff')";
public List loadByQuerySql(final String querySql, final Map params) {
try {
return (List) getHibernateTemplate().execute(
new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
// Connection c= session.connection();
Query query = session.createSQLQuery(querySql)
.addEntity("weightinfo",WeightInfo.class)
.addEntity("dict",Dict.class)
.addEntity("balancd",BalanceCode.class)
.addEntity("enterprise",Enterprise.class);
// fillParams(query,params);
return query.list();
}
});
} catch (HibernateException e) {
e.printStackTrace();
}
return new ArrayList();
}
如果不是全部参与的table都返回值，那么
public Object doInHibern
相关文档：
Sql语句
1. 说明：复制表(只复制结构，源表名：a，新表名：b) SQL:select * into bfrom awhere 1<>1;
2. 说明：拷贝� ......
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GETDATE(), 4): 16.05.06
Select CONVERT ......
应用示例：
-- 创建2个测试表
CREATE TABLE [dbo].[Table_2019]([Data] [nchar](2019) NOT NULL)
CREATE TABLE [dbo].[Table_2020]([Data] [nchar](2020) NOT NULL)
go
-- 填充数据
declare @i int
set @i = 0
while(@i < 20)
begin
insert Table_2019(Data) values('')
......
<?xml version="1.0" encoding="UTF-8"?>
<mdx>
<sets>
<set>
<name>[promomonths] </name>
&n ......
