com.centit.support.database.ddl.DB2DDLOperations Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of centit-database Show documentation

数据库操作通用方法和函数，从以前的util包中分离出来，并且整合了部分sys-module中的函数

There is a newer version: 5.3.2302

package com.centit.support.database.ddl;

import java.sql.Connection;

import com.centit.support.database.QueryUtils;
import com.centit.support.database.metadata.TableField;

public class DB2DDLOperations extends GeneralDDLOperations implements DDLOperations {

	public DB2DDLOperations() {

	}
	
	public DB2DDLOperations(Connection conn) {
		super(conn);
	}
	
	@Override
	public String makeCreateSequenceSql(final String sequenceName){
		return "CREATE SEQUENCE " + QueryUtils.cleanSqlStatement(sequenceName) +
				"  AS INTEGER START WITH 1 INCREMENT BY 1";
	}	

	@Override
	public String makeModifyColumnSql(final String tableCode, final TableField column){
		StringBuilder sbsql = new StringBuilder("alter table ");
		sbsql.append(tableCode);
		sbsql.append(" alter column ");
		sbsql.append(column.getColumnName());
		sbsql.append(" set data type ");
		sbsql.append(column.getColumnType());
		if (column.getMaxLength() > 0)
			sbsql.append("(").append(column.getMaxLength()).append(")");
		else if (column.getPrecision() > 0) {
			sbsql.append("(").append(column.getPrecision());
			if (column.getScale() > 0)
				sbsql.append(",").append(column.getScale());
			sbsql.append(")");
		}
		return sbsql.toString();
	}
}