tablecolumninfo.java

DBExplorer 强烈推荐的一个JAVA项目 数据导出功能 支持的格式HTML PDF XLS等 支持的数据库有MYSQL ORACLE MSSQLSERVER等

package cn.com.qimingx.dbe;

import cn.com.qimingx.utils.ExtTypeInfo;


/**
 * @author inc062805
 * 
 * 描述Table的列信息
 */
public class TableColumnInfo {
	// 最大列宽度
	public static final int MAX_COLUMN_WIDTH = 300;
	// 最小列宽度
	public static final int MIN_COLUMN_WIDTH = 100;

	// 外键列信息
	public static class FKColumnInfo {
		private String table;
		private String column;

		public FKColumnInfo(String table, String column) {
			this.table = table;
			this.column = column;
		}

		public String getTable() {
			return table;
		}

		public void setTable(String table) {
			this.table = table;
		}

		public String getColumn() {
			return column;
		}

		public void setColumn(String column) {
			this.column = column;
		}
	}

	// 列名称
	private String name;
	// 列类型
	private int type;
	// 列大小
	private int size;
	// 列是否可以为kong
	private boolean nullable;
	// 列默认值
	private String defaultValue;
	// 对应 ext 的相关信息
	private ExtTypeInfo extType;
	// 是否是主键列
	private boolean pkColumn = false;
	// 是否外键列
	private boolean fkColumn = false;
	// 外键列信息
	private FKColumnInfo fkInfo = null;

	public boolean isPkColumn() {
		return pkColumn;
	}

	public void setPkColumn(boolean pkColumn) {
		this.pkColumn = pkColumn;
	}

	public boolean isFkColumn() {
		return fkColumn;
	}

	public void setFkColumn(boolean fkColumn) {
		this.fkColumn = fkColumn;
	}

	public String getDefaultValue() {
		return defaultValue;
	}

	public void setDefaultValue(String defaultValue) {
		this.defaultValue = defaultValue;
	}

	public TableColumnInfo() {
	}

	public TableColumnInfo(String name, int type, int size, boolean nullable) {
		this.name = name;
		this.type = type;
		this.size = size;
		this.nullable = nullable;
		extType = new ExtTypeInfo(type);
	}

	// 取得列的显示宽度
	public int getDisplayWidth() {
		int width = size > MAX_COLUMN_WIDTH ? MAX_COLUMN_WIDTH : size;
		width = width < MIN_COLUMN_WIDTH ? MIN_COLUMN_WIDTH : width;

		return width;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public int getType() {
		return type;
	}

	public void setType(int type) {
		this.type = type;
	}

	public int getSize() {
		return size;
	}

	public void setSize(int size) {
		this.size = size;
	}

	public ExtTypeInfo getExtType() {
		if (extType == null) {
			extType = new ExtTypeInfo(type);
		}
		return extType;
	}

	public void setExtType(ExtTypeInfo extType) {
		this.extType = extType;
	}

	public boolean isNullable() {
		return nullable;
	}

	public void setNullable(boolean nullable) {
		this.nullable = nullable;
	}

	public FKColumnInfo getFkInfo() {
		return fkInfo;
	}

	public void setFkInfo(FKColumnInfo fkInfo) {
		this.fkInfo = fkInfo;
	}
}