xmlusergrantedroles.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.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 XMLUserGrantedRoles extends XMLNode {
	String sqlRoles="SELECT GRANTED_ROLE,ADMIN_OPTION,DEFAULT_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE=?";

	ArrayList grantedRoles=new ArrayList();
	private static final String NAME="Granted roles";
	
	public XMLUserGrantedRoles(){
		this.name=NAME;
		//this.refresh();
	}
	
	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#getType()
	 */
	public int getType() {
		return XMLNode.XML_USER_GRANTED_ROLE;
	}

	/**
	 * @see com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode#refresh()
	 */
	public void refreshDDLInfo() throws Exception{
		this.grantedRoles.clear();
		JDBCPool cnn=null;
		//try {
		XMLDatabase db=this.getDatabase();
		
		if(db!=null)
		 	cnn = db.getConnPool();
		else return;
		
		PreparedStatement pStmt=cnn.prepareStatement(sqlRoles);
		pStmt.setString(1,this.getParent().getName());
		ResultSet rsRoles=pStmt.executeQuery();
		
		while(rsRoles.next()){
			OracleRole role=new OracleRole(rsRoles.getString(1),
									rsRoles.getString(2),
									rsRoles.getString(3));
			this.grantedRoles.add(role);
		}
		pStmt.close();
		rsRoles.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) {
		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.getUser().getName());
		if(sqldll!=null) return sqldll.replaceAll("\n",";\n");
		else return null;
	}

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

}