ingresdialect.java

人力资源管理系统主要包括：人员管理、招聘管理、培训管理、奖惩管理和薪金管理五大管理模块。

//$Id: IngresDialect.java,v 1.3.2.2 2003/09/29 12:06:28 oneovthafew Exp $
package net.sf.hibernate.dialect;

import java.sql.Types;


/**
 * An Ingres SQL dialect
 * @author Ian Booth
 */
public class IngresDialect extends Dialect {

	public IngresDialect() {
		super();
		registerColumnType( Types.BIT, "BYTE" );
		registerColumnType( Types.BIGINT, "INTEGER4" );
		registerColumnType( Types.SMALLINT, "INTEGER2" );
		registerColumnType( Types.TINYINT, "INTEGER1" );
		registerColumnType( Types.INTEGER, "INTEGER4" );
		registerColumnType( Types.CHAR, "CHAR(1)" );
		registerColumnType( Types.CHAR, "CHAR($1)" );
		registerColumnType( Types.VARCHAR, "VARCHAR($l)" );
		registerColumnType( Types.FLOAT, "FLOAT" );
		registerColumnType( Types.DOUBLE, "DOUBLE PRECISION" );
		registerColumnType( Types.DATE, "DATE" );
		registerColumnType( Types.TIME, "DATE" );
		registerColumnType( Types.TIMESTAMP, "DATE" );
		registerColumnType( Types.VARBINARY, "VARBINARY($l)" );
		registerColumnType( Types.NUMERIC, "NUMERIC(19, $l)" );
		registerColumnType( Types.BLOB, "LONG VARCHAR" );
		registerColumnType( Types.CLOB, "LONG VARCHAR" );
		registerColumnType( Types.VARBINARY, "LONG VARCHAR" );
	}

	public String getAddColumnString() {
		return "add column";
	}

 	/**
	 * Do we need to drop constraints before dropping tables in this dialect?
	 * @return boolean
	 */
	public boolean dropConstraints() {
		return false;
	}

	public String getLowercaseFunction() {
		return "lowercase";
	}

}