xmltriggers.java

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

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

import java.io.InputStream;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
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 XMLTriggers extends XMLNode {
	
	String sqlTriggers = "select trigger_name,trigger_body from dba_triggers where table_owner = ? and table_name = ?";
	//String sqlTriggers = "select name, MAX(LINE)  from DBA_SOURCE where type='PROCEDURE' and owner=? group by name";
	//String sqlTriggersWrapped = "select name from DBA_SOURCE where type='PROCEDURE' and line=1 and owner=? and text like '% wrapped%'";


	String crComparedTriggers="SELECT SRC_TRIGGER_NAME,ATTR_NAME,SRC_ATTR_VALUE,DST_TRIGGER_NAME FROM COMPARE_TRIGGERS WHERE SRC_OWNER=? AND SRC_TABLE_NAME=? AND ATTR_NAME='MYSTYLE'";
	String upComparedTriggers="SELECT SRC_TRIGGER_NAME,ATTR_NAME,SRC_ATTR_VALUE,DST_ATTR_VALUE FROM COMPARE_TRIGGERS WHERE SRC_OWNER=? AND SRC_TABLE_NAME=? AND ATTR_NAME<>'MYSTYLE'";

	public static String NAME="Triggers";
	
	public XMLTriggers(){
		this.name=NAME;
		
	}
	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#getType()
	 */
	public int getType() {
		return XMLNode.XML_TRIGGERS;
	}

	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#refresh()
	 */
	public void refreshDDLInfo() throws Exception{
		//this.clear();
		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;
		
		/**
		if(db.getVersion() == XMLDatabase.VERSION_ORACLE8I){
			String sqlGenDDL = "BEGIN GEN_TRIG_DDL(?); END;";
			CallableStatement cStmt = cnn.prepareCall(sqlGenDDL);
			cStmt.setString(1,this.getSchema().name);
			cStmt.execute();
		}**/

		//获取Trigger列表
		PreparedStatement pStmt=cnn.prepareStatement(sqlTriggers);
		
		pStmt.setString(1,this.getParent().getParent().getParent().getName().toUpperCase());
		pStmt.setString(2,this.getParent().getName().toUpperCase());
		ResultSet rsTriggers=pStmt.executeQuery();

		while(rsTriggers.next()){
			XMLTrigger trigger=new XMLTrigger(rsTriggers.getString(1),rsTriggers.getString(2));
			this.addChild(trigger);
			//trigger.refresh();
		}
		
		pStmt.close();
		rsTriggers.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_TRIGGER) 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) {
	}
}