db2400dialect.java

来自「JSP+SQL编写的人力资源管理系统」· Java 代码 · 共 48 行

package net.sf.hibernate.dialect;

/** 
* An SQL dialect for DB2/400 
* @author Peter DeGregorio (pdegregorio) 
* This class provides support for DB2 Universal Database for iSeries, 
* also known as DB2/400. 
*/
public class DB2400Dialect extends DB2Dialect {

   public DB2400Dialect() {
      super();
   }

   public boolean supportsIdentityColumns() {
      return false;
   }

   public boolean supportsSequences() {
      return false;
   }

   public boolean supportsLimit() {
      return true;
   }

   public boolean supportsLimitOffset() {
      return false;
   }

   public String getLimitString(String sql, boolean hasOffset, int limit) {
      return new StringBuffer(sql.length() + 40)
         .append(sql)
         .append(" fetch first ")
         .append(limit)
         .append(" rows only ")
         .toString();
   }

   public boolean useMaxForLimit() {
      return true;
   }

   public boolean supportsVariableLimit() {
      return false;
   }

}