xmlundosegs.java

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

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

import java.io.InputStream;
import java.sql.CallableStatement;
import java.sql.ResultSet;

import com.icbcsdc.ddlexp.pub.staticLog.Logger;
import com.icbcsdc.ddlexp.pub.connectionpool.JDBCCnn;
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 XMLUndoSegs extends XMLNode {
	public static String NAME="UndoSegs";
	private String sqlUndoSegs="SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,STATUS FROM DBA_ROLLBACK_SEGS WHERE SEGMENT_NAME NOT LIKE '_SYSSMU%'";
	//private String sqlUndoSegs="SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME FROM DBA_ROLLBACK_SEGS WHERE OWNER = 'PUBLIC'";
	
	/**
	 * Constructor for XMLManager.
	 */
	public XMLUndoSegs() {
		super();
		this.name=NAME;
	}


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

	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#refresh()
	 */
	public void refreshDDLInfo() throws Exception{
		//System.out.println("XMLSchemas 1");
		//this.clear();
		JDBCPool cnn=null;
		//try {
		//XMLManager.getInstance().
		XMLDatabase db=this.getDatabase();
		if(db!=null) cnn = db.getConnPool();
		else return;

		if(db.getVersion() == XMLDatabase.VERSION_ORACLE8I){
			String sqlGenDDL = "BEGIN GEN_ROLSEG_DDL; END;";
			CallableStatement cStmt = cnn.prepareCall(sqlGenDDL);
			cStmt.execute();
		}

		//获取schema列表
		//System.out.println(sqlUndoSegs);
		//System.out.println(cnn.toString());
		ResultSet rsUndoSegs=cnn.executeQuery(sqlUndoSegs);

		while(rsUndoSegs.next()){
			XMLUndoSeg undoSeg=new XMLUndoSeg(rsUndoSegs.getString(1),
									rsUndoSegs.getString(2),
									rsUndoSegs.getString(3),
									rsUndoSegs.getString(4));
			this.addChild(undoSeg);
		}
		rsUndoSegs.close();
					
		/**
		} catch (Exception e) {
			Logger.log(Logger.ERROR,e.getMessage());

		}
		**/
		//super.refresh();
	}

	/**从数据库中获取数据对象比较后的结果*/
	public void refreshChangedProperties(){
	}
	

	/**
	 * @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_UNDO_SEG) 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;
	}

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