xmlindex.java

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

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

import java.io.InputStream;
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.JDBCCnn;
import com.icbcsdc.ddlexp.pub.connectionpool.JDBCException;
import com.icbcsdc.ddlexp.pub.connectionpool.JDBCPool;
import com.icbcsdc.ddlexp.pub.connectionpool.JDBCPoolManager;


/**
 * @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 XMLIndex extends XMLNode {

	String tableSpace=null;
	
	String sqlIndColumn= "select column_name,column_position,descend,table_name from dba_ind_columns where index_owner=? and index_name=? order by column_position";
	ArrayList columns=new ArrayList();
	String upComparedColIndexs="SELECT ATTR_NAME,SRC_ATTR_VALUE,DST_ATTR_VALUE FROM COMPARE_IND_COLUMNS WHERE SRC_INDEX_OWNER=? AND SRC_TABLE_NAME=? AND SRC_INDEX_NAME=? AND ATTR_NAME<>'MYSTYLE'";

	
	public XMLIndex(String indexName,String indTablespace) throws NodeException {
		super();
		this.name=indexName;
		this.tableSpace = indTablespace;
		
		//this.addChild(new XMLIndColumns());

	}	
	
	public XMLIndex(String indexName) throws NodeException {
		super();
		this.name=indexName;
		
	}	
	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#getType()
	 */
	public int getType() {
		return XMLNode.XML_INDEX;
	}

	/**从数据库中获取数据对象比较后的结果*/
	public void refreshChangedProperties() throws Exception{
		if(this.getCompareStatus()==XMLNode.SRC_DST_DIFF){
			/**compare_procedure_lines相关的信息放到容器changedProperties中*/
			JDBCPool cnn=null;
			//try {
			//XMLManager.getInstance().
			XMLDatabase db=this.getDatabase();
			if(db!=null) cnn = db.getConnPool();
			else return;

			//再修改比较节点
			PreparedStatement pStmt=cnn.prepareStatement(upComparedColIndexs);
			pStmt.setString(1,this.getSchema().getName().toUpperCase());
			pStmt.setString(2,this.getParent().getParent().getName().toUpperCase());
			pStmt.setString(3,this.getName().toUpperCase());
			ResultSet rsUpColIndexs=pStmt.executeQuery();

			while(rsUpColIndexs.next()){
				//XMLColIndex procedure1=(XMLColIndex)this.getDirectChildren(XMLNode.XML_PROCEDURE,rsUpColIndexs.getString("SRC_PROCEDURE_NAME"));
				this.putChangedProperty(rsUpColIndexs.getString("ATTR_NAME"),rsUpColIndexs.getString("SRC_ATTR_VALUE"),rsUpColIndexs.getString("DST_ATTR_VALUE"));				
			}
			rsUpColIndexs.close();
			pStmt.close();						
			/**	
			} catch (Exception e) {
				e.printStackTrace();
				Logger.log(Logger.ERROR,e.getMessage());
			}	
			*/				
		}
		
	}
	
	/**从数据库中获取数据对象定义*/
	public void refreshDDLInfo()throws Exception{
		JDBCPool cnn=null;
		
		//try {
		XMLDatabase db=this.getDatabase();
		if(JDBCPoolManager.getInstance().isDebug()) 
			System.out.println(this.getClass().toString());
			
		if(db!=null) cnn = db.getConnPool();
		else return;
			
		/**	
		this.addChild(new XMLIndColumns());
		PreparedStatement pStmt=cnn.prepareStatement(this.sqlIndColumn);
		pStmt.setString(1,this.getParent().getParent().getParent().getParent().getName().toUpperCase());
		pStmt.setString(2,this.getName());
		ResultSet rsColumns=pStmt.executeQuery();
		this.columns.clear();
		while(rsColumns.next()){
			XMLIndColumn column=new XMLIndColumn(rsColumns.getString(1),
									rsColumns.getString(2),
									rsColumns.getString(3),
									rsColumns.getString(4));
			column.setCompareStatus(ComparedNode.NO_COMPARED);
			this.columns.add(column);
		}
		
		pStmt.close();
		rsColumns.close();
		**/
	}


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


	public ArrayList getColumns(){
		return this.columns;
	}

	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#chkChildType(XMLNode)
	 */
	public boolean chkChildType(XMLNode node) {
		if(node.getType()==XMLNode.XML_INDCOLUMNS) 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 this.getSchemaDDLStr();
	}
	
	public String getTablespace(){
		return this.tableSpace;
	}

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