db2columninfosql.java

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

// $Id: DB2ColumnInfoSQL.java $Date: 2007-10-22 上午09:00:32 $ 
// $Id: DB2ColumnInfoSQL.java $Date: 2007-10-22 上午09:00:32 $ 
package org.speedframework.sql.db2;

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

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

	public String getSQL() {
		String tableName = StringUtils.getExcuteTableName(this.tableObject
				.getClass());
		return "select tabschema tableschem,colname field,char(keyseq) pk,typename data_type,identity autoincrement from syscat.columns where tabname=upper('"
				+ tableName + "')";
	}

}