xmlrolegrantedsysprivs.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 XMLRoleGrantedSysPrivs extends XMLNode {

	String sqlSysPrivs="SELECT PRIVILEGE,ADMIN_OPTION FROM ROLE_SYS_PRIVS WHERE ROLE=?";

	ArrayList sysPrivs=new ArrayList();
	private static final String NAME="Granted system privileges";

	public XMLRoleGrantedSysPrivs(){
		this.name=NAME;
		//this.refresh();
	}
	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#getType()
	 */
	public int getType() {
		return XMLNode.XML_ROLE_GRANTED_SYS_PRIVS;
	}

	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#refresh()
	 */
	public void refreshDDLInfo() throws Exception{
		this.sysPrivs.clear();
		JDBCPool cnn=null;
		//try {

		XMLDatabase db=this.getDatabase();

		if(db!=null)	cnn = db.getConnPool();
		else return;
		
		PreparedStatement pStmt=cnn.prepareStatement(sqlSysPrivs);
		pStmt.setString(1,this.getParent().getName());
		ResultSet rsSysPrivs=pStmt.executeQuery();
		
		while(rsSysPrivs.next()){
			OracleSysPrivs sysPriv=new OracleSysPrivs(rsSysPrivs.getString(1),
									rsSysPrivs.getString(2));
			this.sysPrivs.add(sysPriv);
		}
		
		rsSysPrivs.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 sysPrivs.
	 * @return ArrayList
	 */
	public ArrayList getSysPrivs() {
		return sysPrivs;
	}

}