xmlconstraint.java

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

package com.icbcsdc.ddlexp.pub.xml.nodeinfo;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import com.icbcsdc.ddlexp.pub.staticLog.Logger;
import com.icbcsdc.ddlexp.pub.connectionpool.JDBCPool;
import com.icbcsdc.ddlexp.pub.connectionpool.JDBCPoolManager;
import com.icbcsdc.ddlexp.ui.CompareFrame;
import com.icbcsdc.ddlexp.ui.UIException;

/**
 * @author zhangyc
 *
 * To change this generated comment edit the template variable "typecomment":
 * Window>Preferences>Java>Templates.
 * To enable and disable the creation of type comments go to
 * Window>Preferences>Java>Code Generation.
 */
public class XMLConstraint extends XMLNode {

	String consType = null;
	String status = null;
	String validated = null;
	String r_owner = null;
	String r_constraint_name = null;
	String delete_rule = null;
	//String index_name = null;
	
	String sqlConsColumn= "select table_name,column_name,position from dba_cons_columns where constraint_name=? and OWNER=?";
	ArrayList columns=new ArrayList();

	
	public XMLConstraint(String consName,String consType,String status,String validated,String r_owner,String r_constraint_name,String delete_rule) throws NodeException {
		super();
		this.name = consName;
		this.consType = consType;
		this.status = status;
		this.validated =validated;
		this.r_owner =r_owner;
		this.r_constraint_name=r_constraint_name;
		this.delete_rule =delete_rule;
		//this.index_name =index_name;
		
	}	
	
	public XMLConstraint(String consName) throws NodeException {
		super();
		this.name = consName;
		//this.addChild(new XMLConsColumns());
	}	

	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#getType()
	 */
	public int getType() {
		return XMLNode.XML_CONSTRAINT;
	}

	/**从数据库中获取数据对象比较后的结果*/
	public void refreshChangedProperties()throws Exception{
	}
	
	/**从数据库中获取数据对象定义*/
	public void refreshDDLInfo()throws Exception{
		JDBCPool cnn=null;

		XMLDatabase db=this.getDatabase();
		if(db!=null) cnn = db.getConnPool();
		else return;
		
		/**
		this.addChild(new XMLConsColumns());
		PreparedStatement pStmt=cnn.prepareStatement(this.sqlConsColumn);
		pStmt.setString(1,this.getName());
		pStmt.setString(2,this.getSchema().getName());
		ResultSet rsColumns=pStmt.executeQuery();
		this.columns.clear();
		while(rsColumns.next()){
			XMLConsColumn column=new XMLConsColumn(rsColumns.getString(1),
									rsColumns.getString(2),
									rsColumns.getString(3));
			column.setCompareStatus(ComparedNode.NO_COMPARED);
			this.columns.add(column);
		}
		
		rsColumns.close();
		pStmt.close();			
		**/
	}


	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#refresh()
	 */
	public void refresh() throws Exception{
		refreshNodeNeedAccessDB();		
		super.refresh();
	}


	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#chkChildType(XMLNode)
	 */
	public boolean chkChildType(XMLNode node) {
		if(node.getType()==XMLNode.XML_CONSCOLUMNS) return true;
		return false;
	}

	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#getXmlStream()
	public InputStream getXmlStream() {
		return null;
	}
	 */

	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#getSqlDDL()
	 */
	public String getSqlDDL() {
//		return null;
		return this.getSchemaDDLStr();
	}
	
	public String getTablespace(){
		return this.consType;
	}

	public static void main(String[] args) {
	}
	/**
	 * @return Returns the consType.
	 */
	public String getConsType() {
		if(consType.equals("C"))
			return "Check";
		else if(consType.equals("P"))
			return "Primary";
		else if(consType.equals("U"))
			return "Unique";
		else if(consType.equals("R"))
			return "Reference";
		else if(consType.equals("V"))
			return "Check View";
		else if(consType.equals("O"))
			return "Read Only";
		else return 	consType;
	}
	/**
	 * @return Returns the delete_rule.
	 */
	public String getDelete_rule() {
		return delete_rule;
	}

	/**
	 * @return Returns the index_name.
	public String getIndex_name() {
		return index_name;
	}
	 */

	/**
	 * @return Returns the r_constraint_name.
	 */
	public String getR_constraint_name() {
		return r_constraint_name;
	}
	/**
	 * @return Returns the r_owner.
	 */
	public String getR_owner() {
		return r_owner;
	}
	/**
	 * @return Returns the status.
	 */
	public String getStatus() {
		return status;
	}
	/**
	 * @return Returns the validated.
	 */
	public String getValidated() {
		return validated;
	}
	/**
	 * @return Returns the columns.
	 */
	public ArrayList getColumns() {
		return columns;
	}
	/**
	 * @return Returns the sqlConsColumn.
	 */
	public String getSqlConsColumn() {
		return sqlConsColumn;
	}
		

}