642704
NativeSQLOrder
427395
2007-12-11T12:14:29Z
http://kwon37xi.springnote.com/pages/642704
2007-12-11T12:07:10Z
<h1>Native SQL Order</h1>
<p>Hibernate의 Criteria에서 Native SQL로 된 Order 구문을 사용하고자 할 때, 아래의 Order의 서브클래스를 사용하면된다.</p>
<p> </p>
<p>원래 코드는 <a href="http://lists.jboss.org/pipermail/hibernate-issues/2007-August/006747.html" title="http://lists.jboss.org/pipermail/hibernate-issues/2007-August/006747.html" class="external">http://lists.jboss.org/pipermail/hibernate-issues/2007-August/006747.html</a> 에서 가져온 것인데, 원래 코드를 좀 더 깔끔해보이게 했고, desc(), asc() 메소드를 추가해 두었다.</p>
<p> </p>
<ol class="code">
<li>import org.hibernate.Criteria;<br />
import org.hibernate.HibernateException;<br />
import org.hibernate.criterion.CriteriaQuery;<br />
import org.hibernate.criterion.Order;<br />
import org.hibernate.util.StringHelper;<br />
<br />
/**<br />
* Hibernate Native SQL 지원 Order 클래스<br />
*<br />
* <strong>criteria.addOrder(NativeSQLOrder.desc("{alias}.itemCount + {alias}.commentCount"))</strong> 와 같은 형태로<br />
* 사용하며 {alias}는 Criteria에서 값을 가져오는 클래스의 테이블 alias로 자동 변경된다.<br />
*/<br />
public class NativeSQLOrder extends Order {<br />
private static final long serialVersionUID = 1L;<br />
<br />
/** 어차피 쓸데 없는 값이다. */<br />
private final static String USELESS_PROPERTY_NAME = "uselessAnyways";<br />
<br />
/** asc 여부 */<br />
private boolean ascending;<br />
<br />
/** order by 절에 들어갈 Native SQL */<br />
private String nativeSql;<br />
<br />
protected NativeSQLOrder(String nativeSql, boolean ascending) {<br />
super(USELESS_PROPERTY_NAME, ascending);<br />
this.nativeSql = nativeSql;<br />
this.ascending = ascending;<br />
}<br />
<br />
@Override<br />
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery)<br />
throws HibernateException {<br />
StringBuilder fragment = new StringBuilder();<br />
fragment.append("(");<br />
fragment.append(nativeSql);<br />
fragment.append(")");<br />
fragment.append(ascending ? " asc" : " desc");<br />
return StringHelper.replace(fragment.toString(), "{alias}",<br />
criteriaQuery.getSQLAlias(criteria));<br />
}<br />
<br />
public static Order asc(String sql) {<br />
return new NativeSQLOrder(sql, true);<br />
}<br />
<br />
public static Order desc(String sql) {<br />
return new NativeSQLOrder(sql, false);<br />
}<br />
}</li>
</ol>
<p> </p>
http://kwon37xi.myid.net/
http://kwon37xi.myid.net/
10
hibernate,native,sql