oraclecolumninfosql.java

羽量级数据持久层开发框架

package org.speedframework.sql.oracle;

import org.speedframework.sql.AbstractTableInfoSQL;
import org.speedframework.utilities.StringUtils;

/**
 * Class OracleColumnInfoSql
 * 
 * @author <a href="mailto:[e-mail]"> lizf </a>
 * @version $Revision:1.0.0, $Date: 2007-10-22 上午09:11:17 $
 */
public class OracleColumnInfoSql extends AbstractTableInfoSQL {

	/*
	 * (non-Javadoc)
	 * 
	 * @see org.speedframework.sql.ICommonSQL#getSQL()
	 */
	public String getSQL() {
		StringBuffer sql = new StringBuffer(50);
		String tableName = StringUtils.getExcuteTableName(this.tableObject
				.getClass());

		sql
				.append(" select b.COLUMN_NAME pk, a.COLUMN_NAME field , a.DATA_TYPE, a.DATA_PRECISION, a.DATA_SCALE, a.NULLABLE ,null autoincrement  ");
		sql.append(" from user_tab_columns a,(select col.column_name  ");
		sql.append(" from user_constraints con, user_cons_columns col ");
		sql.append(" where con.constraint_name = col.constraint_name  ");
		sql.append(" and con.constraint_type = 'P'  ");
		sql.append(" and col.table_name =  upper('" + tableName + "') )b  ");
		sql.append(" where a.table_name = upper('" + tableName
				+ "') and a.COLUMN_NAME = b.column_name(+)  ");

		return sql.toString();
	}
}