hsqlcolumninfosql.java

来自「羽量级数据持久层开发框架」· Java 代码 · 共 34 行

package org.speedframework.sql.hsql;

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

/**
 * Class HSQLColumnInfoSql use sql show tables info ：
 * INFORMATION_SCHEMA.system_tables INFORMATION_SCHEMA.system_columns
 * system_indexinfo system_connectioninfo SYSTEM_PRIMARYKEYS
 * 
 * @author <a href="mailto:[e-mail]"> lizf </a>
 * @version $Revision:1.0.0, $Date: 2007-10-4 上午12:01:18 $
 */
public class HSQLColumnInfoSql extends AbstractTableInfoSQL {

	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.type_name data_type,null autoincrement ");
		sql.append(" from information_schema.system_columns a ");
		sql
				.append(" left outer join information_schema.system_primarykeys  b on ");
		sql
				.append(" b.table_name=a.table_name and a.column_name=b.column_name ");
		sql.append(" where table_name=upper('");
		sql.append(tableName);
		sql.append("')");
		return sql.toString();
	}
}