[1].[代码] HQL2SQL.java 跳至 [1]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
/**
* HQL2SQL.java of DLOG4J_E40
* 作者: Winter Lau
* 时间: 2008-1-30
* 项目主页: <a href="http://www.dlog4j.com/">http://www.dlog4j.com</a>
*/
package
com.dlog4j.tester;
import
org.hibernate.hql.FilterTranslator;
import
org.hibernate.hql.QueryTranslatorFactory;
import
org.hibernate.impl.SessionFactoryImpl;
import
com.dlog4j.dbaccess.HibernateUtils;
/**
* HSQL to SQL
* -Djava.ext.dirs=webapp/WEB-INF/lib;packages -cp webapp/WEB-INF/classes
* @author Winter Lau
*/
public
class
HQL2SQL {
/**
* @param args
*/
public
static
void
main(String[] args) {
SessionFactoryImpl sfi = (SessionFactoryImpl) HibernateUtils.getSessionFactory();
String hql =
"FROM UserBean ORDER BY convert_gbk(name)"
;
QueryTranslatorFactory qtf = sfi.getSettings().getQueryTranslatorFactory();
FilterTranslator qt = qtf.createFilterTranslator(hql, hql,
null
, sfi);
qt.compile(
null
,
false
);
System.out.println(qt.getSQLString());
}
}
|