定做sql语句的方法

hibernate 定制sql语句的方法：

?

1. sql 中column的顺序非常重要，不然就会出错，一个字段的value到另外一个字段上去。
2. 取得默认的hibernate 生成的sql语句，设置org.hibernate.persister.entity.AbstractEntityPersister log级别为debug,下面是打印代码
   

   protected void logStaticSQL() {		if ( log.isDebugEnabled() ) {			log.debug( "Static SQL for entity: " + getEntityName() );			if ( sqlLazySelectString != null ) {				log.debug( " Lazy select: " + sqlLazySelectString );			}			if ( sqlVersionSelectString != null ) {				log.debug( " Version select: " + sqlVersionSelectString );			}			if ( sqlSnapshotSelectString != null ) {				log.debug( " Snapshot select: " + sqlSnapshotSelectString );			}			for ( int j = 0; j < getTableSpan(); j++ ) {				log.debug( " Insert " + j + ": " + getSQLInsertStrings()[j] );				log.debug( " Update " + j + ": " + getSQLUpdateStrings()[j] );				log.debug( " Delete " + j + ": " + getSQLDeleteStrings()[j] );			}			if ( sqlIdentityInsertString != null ) {				log.debug( " Identity insert: " + sqlIdentityInsertString );			}			if ( sqlUpdateByRowIdString != null ) {				log.debug( " Update by row id (all fields): " + sqlUpdateByRowIdString );			}			if ( sqlLazyUpdateByRowIdString != null ) {				log.debug( " Update by row id (non-lazy fields): " + sqlLazyUpdateByRowIdString );			}			if ( sqlInsertGeneratedValuesSelectString != null ) {				log.debug( "Insert-generated property select: " + sqlInsertGeneratedValuesSelectString );			}			if ( sqlUpdateGeneratedValuesSelectString != null ) {				log.debug( "Update-generated property select: " + sqlUpdateGeneratedValuesSelectString );			}		}	}

???? 3. 根据默认的sql语句定制你自己的sql语句，记住一点要遵守column的顺序。