xmlrolegrantedobjprivs.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.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 XMLRoleGrantedObjPrivs extends XMLNode {
	String sqlTblPrivs="SELECT PRIVILEGE||' ON '||OWNER||'.'||TABLE_NAME,GRANTABLE FROM ROLE_TAB_PRIVS WHERE ROLE=?";

	ArrayList objectPrivs=new ArrayList();
	private static final String NAME="Granted object Privileges";
	
	public XMLRoleGrantedObjPrivs(){
		this.name=NAME;
		//this.refresh();
	}

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

	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#refresh()
	 */
	public void refreshDDLInfo() throws Exception{
		this.objectPrivs.clear();
		JDBCPool cnn=null;
		//try {
		XMLDatabase db=this.getDatabase();
			
		if(db!=null)
			cnn = db.getConnPool();
		else return;
		
		PreparedStatement pStmt=cnn.prepareStatement(sqlTblPrivs);
		pStmt.setString(1,this.getParent().getName());
		ResultSet rsObjPrivs=pStmt.executeQuery();
		
		while(rsObjPrivs.next()){
			OracleObjPrivs objPriv=new OracleObjPrivs(rsObjPrivs.getString(1),
									rsObjPrivs.getString(2));
			this.objectPrivs.add(objPriv);
		}
		
		rsObjPrivs.close();
		pStmt.close();

	}

	/**从数据库中获取数据对象比较后的结果*/
	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) {
		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() {
		String sqldll=this.getGrantedDDLStr(this.getRole().getName());
		if(sqldll!=null) return sqldll.replaceAll("\n",";\n");
		else return null;
	}

	public static void main(String[] args) {
	}
	/**
	 * Returns the objectPrivs.
	 * @return ArrayList
	 */
	public ArrayList getObjectPrivs() {
		return objectPrivs;
	}

}