poolspec.java

导出ORACLE数据库对象DDL语句的程序

package com.icbcsdc.ddlexp.pub.connectionpool;

import com.icbcsdc.ddlexp.pub.staticLog.Logger;

/**
 * @author zhangyc
 * 连接池规范类，用于指定连接池的各种属性
 */
public class PoolSpec {
	String poolName = "";
	String driver = "";
	String url = "";
	String dbUser = "";
	String dbPassword = "";
	String backDir="/usr/local/mysql";
	//String osPassword="";
	int poolMaxSize = 4;
	int poolMinSize = 1;
	int increaseStep = 1;
	int scanCount = 4;
   	int scanInterval=300000;		
//	int scanInterval=400;		//for test
	/**
	 * Constructor for PoolAttr.
	 * @Precondition 各个参数不能为空
	 * @Postcondition 
	 * @param poolname JDBC连接池名称
	 * @param driver JDBC driver类型
	 * @param url	jdbc连接字符串
	 * @param user 连接数据库时使用的用户名
	 * @param password 连接数据库时使用的密码
	 */
	public PoolSpec(
		String poolname,
		String driver,
		String url,
		String user,
		String password) {
		if (poolname==null||poolname.trim().equals("")) {
			Logger.log(Logger.WARN, JDBCCnnMgrConstants.NULL_POOLNAME);
			//throw new Exception(JDBCCnnMgrConstants.NULL_POOLNAME);
		}
		if (driver==null||driver.trim().equals("")) {
			Logger.log(Logger.WARN, JDBCCnnMgrConstants.NULL_DRIVER);
			//throw new Exception(JDBCCnnMgrConstants.NULL_DRIVER);
		}
		if (url==null||url.trim().equals("")) {
			Logger.log(Logger.WARN, JDBCCnnMgrConstants.NULL_URL);
			//throw new Exception(JDBCCnnMgrConstants.NULL_URL);
		}
		if (user==null||user.trim().equals("")) {
			Logger.log(Logger.WARN, JDBCCnnMgrConstants.NULL_USER);
		}
		if (password == null) {
			Logger.log(Logger.WARN, JDBCCnnMgrConstants.NULL_PASSWORD);
		}
		this.poolName = poolname;
		this.driver = driver;
		this.url = url;
		this.dbUser = user;
		this.dbPassword = password;
		this.poolMaxSize=JDBCPoolManager.getInstance().getPoolMaxSize();
		this.poolMinSize=JDBCPoolManager.getInstance().getPoolMinSize();
		this.increaseStep=JDBCPoolManager.getInstance().getIncreaseStep();
		this.scanCount=JDBCPoolManager.getInstance().getScanCount();
		this.scanInterval=JDBCPoolManager.getInstance().getScanInterval();
		
	}
	
	/**
	 * Constructor for PoolAttr.
	 * @Precondition 各个参数不能为空
	 * @Postcondition 
	 * @param poolname JDBC连接池名称
	 * @param driver jdbc驱动名称
	 * @param url	jdbc连接字符串
	 * @param user 连接数据库时使用的用户名
	 * @param backDir 数据备份的目录
	 * @param osUser 登录mysql服务器的用户
	 */
	public PoolSpec(
		String poolname,
		String driver,
		String url,
		String user,
		String password,
		String backDir) {
		if (poolname==null||poolname.trim().equals("")) {
			Logger.log(Logger.WARN, JDBCCnnMgrConstants.NULL_POOLNAME);
			//throw new Exception(JDBCCnnMgrConstants.NULL_POOLNAME);
		}
		if (driver==null||driver.trim().equals("")) {
			Logger.log(Logger.WARN, JDBCCnnMgrConstants.NULL_DRIVER);
			//throw new Exception(JDBCCnnMgrConstants.NULL_DRIVER);
		}
		if (url==null||url.trim().equals("")) {
			Logger.log(Logger.WARN, JDBCCnnMgrConstants.NULL_URL);
			//throw new Exception(JDBCCnnMgrConstants.NULL_URL);
		}
		if (user==null||user.trim().equals("")) {
			Logger.log(Logger.WARN, JDBCCnnMgrConstants.NULL_USER);
		}
		if (password == null) {
			Logger.log(Logger.WARN, JDBCCnnMgrConstants.NULL_PASSWORD);
		}
		if(backDir==null){
			Logger.log(Logger.WARN,JDBCCnnMgrConstants.NULL_BACKDIR);
		}
		
		this.poolName = poolname;
		this.driver = driver;
		this.url = url;
		this.dbUser = user;
		this.dbPassword = password;
		this.backDir=backDir;

		this.poolMaxSize=JDBCPoolManager.getInstance().getPoolMaxSize();
		this.poolMinSize=JDBCPoolManager.getInstance().getPoolMinSize();
		this.increaseStep=JDBCPoolManager.getInstance().getIncreaseStep();
		this.scanCount=JDBCPoolManager.getInstance().getScanCount();
		this.scanInterval=JDBCPoolManager.getInstance().getScanInterval();
	}

	public static void main(String[] args) {
	}

	/**
	 * 返回JDBC driver类型.
	 * @return String
	 */
	public String getDriver() {
		return driver;
	}

	/**
	 * 返回  连接池每次增加的连接个数
	 * @return int
	 */
	public int getIncreaseStep() {
		return increaseStep;
	}

	/**
	 * 返回 口令
	 * @return String
	 */
	/*public String getPassword() {
		return password;
	}*/

	/**
	 * 返回 连接对象的上限
	 * @return int
	 */
	public int getPoolMaxSize() {
		return poolMaxSize;
	}

	/**
	 * 返回 连接对象的下限
	 * @return int
	 */
	public int getPoolMinSize() {
		return poolMinSize;
	}

	/**
	 * 返回 连接池名称
	 * @return String
	 */
	public String getPoolName() {
		return poolName;
	}

	/**
	 * 返回 释放空闲连接的扫描次数
	 * @return int
	 */
	public int getScanCount() {
		return scanCount;
	}

	/**
	 * 返回 释放空闲连接的扫描时间间隔
	 * @return int
	 */
	public int getScanInterval() {
		return scanInterval;
	}

	/**
	 * 返回jdbc连接字符串
	 * @return String
	 */
	public String getUrl() {
		return url;
	}

	/**
	 * 返回用户名
	 * @return String

	public String getUser() {
		return dbUser;
	}	 */

	/**
	 * 设置JDBC driver类型
	 * @param driver The driver to set
	 */
	public void setDriver(String driver) {
		this.driver = driver;
	}

	/**
	 * 设置  连接池每次增加的连接个数
	 * @param increaseStep The increaseStep to set
	 */
	public void setIncreaseStep(int increaseStep) {
		this.increaseStep = increaseStep;
	}

	/**
	 * 设置 口令
	 * @param password The password to set
	 */
	public void setPassword(String password) {
		this.dbPassword = password;
	}

	/**
	 * 设置 连接对象的上限
	 * @param poolMaxSize The poolMaxSize to set
	 */
	public void setPoolMaxSize(int poolMaxSize) {
		this.poolMaxSize = poolMaxSize;
	}

	/**
	 * 设置 连接对象的下限
	 * @param poolMinSize The poolMinSize to set
	 */
	public void setPoolMinSize(int poolMinSize) {
		this.poolMinSize = poolMinSize;
	}

	/**
	 * 设置 连接池名称
	 * @param poolName The poolName to set
	 */
	public void setPoolName(String poolName) {
		this.poolName = poolName;
	}

	/**
	 * 设置 释放空闲连接的扫描次数
	 * @param scanCount The scanCount to set
	 */
	public void setScanCount(int scanCount) {
		this.scanCount = scanCount;
	}

	/**
	 * 设置 释放空闲连接的扫描时间间隔
	 * @param scanInterval The scanInterval to set
	 */
	public void setScanInterval(int scanInterval) {
		this.scanInterval = scanInterval;
	}

	/**
	 * 设置jdbc连接字符串
	 * @param url The url to set
	 */
	public void setUrl(String url) {
		this.url = url;
	}

	/**
	 * Returns the backDir.
	 * @return String
	 */
	public String getBackDir() {
		return backDir;
	}

	/**
	 * Sets the backDir.
	 * @param backDir The backDir to set
	 */
	public void setBackDir(String backDir) {
		this.backDir = backDir;
	}

	/**
	 * Sets the osPassword.
	 * @param osPassword The osPassword to set
	 
	public void setOsPassword(String osPassword) {
		this.osPassword = osPassword;
	}*/

	/**
	 * Sets the osUser.
	 * @param osUser The osUser to set
	 
	public void setOsUser(String osUser) {
		this.osUser = osUser;
	}*/

	/**
	 * Returns the dbUser.
	 * @return String
	 */
	public String getDbUser() {
		return dbUser;
	}

	/**
	 * Sets the dbUser.
	 * @param dbUser The dbUser to set
	 */
	public void setDbUser(String dbUser) {
		this.dbUser = dbUser;
	}

	/**
	 * Returns the dbPassword.
	 * @return String
	 */
	public String getDbPassword() {
		return dbPassword;
	}

	/**
	 * Sets the dbPassword.
	 * @param dbPassword The dbPassword to set
	 */
	public void setDbPassword(String dbPassword) {
		this.dbPassword = dbPassword;
	}

}