xmluser.java

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

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

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

import com.icbcsdc.ddlexp.pub.connectionpool.JDBCCnn;
import com.icbcsdc.ddlexp.pub.connectionpool.JDBCPoolManager;

/**
 * @author zhangyc
 *
 */
public class XMLUser extends XMLNode {
	private String defaultTbs=null;
	private String tmpTbs=null;
	private String accStatus=null;
	
	public XMLUser(String user,String defaulttbs,String tmptbs,String accstatus) throws NodeException{
		this.name=user;
		this.defaultTbs=defaulttbs;
		this.tmpTbs=tmptbs;
		this.accStatus=accstatus;	
	}
	
	public XMLUser(String user) throws NodeException{
		this.name=user;

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

	/**从数据库中获取数据对象比较后的结果*/
	public void refreshChangedProperties(){
	}
	
	/**从数据库中获取数据对象定义*/
	public void refreshDDLInfo()throws Exception{
		XMLUserGrantedRoles roles=new XMLUserGrantedRoles();
		XMLUserGrantedObjPrivs objPrivs=new XMLUserGrantedObjPrivs();
		XMLUserGrantedSysPrivs sysPrivs=new XMLUserGrantedSysPrivs();
		//try {
		this.addChild(roles);
		this.addChild(objPrivs);
		this.addChild(sysPrivs);
		/**	
		} catch (NodeException e) {
			e.printStackTrace();
		}
		**/
	}


	/**
	 * @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_USER_GRANTED_ROLE) return true;
		if(node.getType()==XMLNode.XML_USER_GRANTED_SYS_PRIVS) return true;
		if(node.getType()==XMLNode.XML_USER_GRANTED_OBJ_PRIVS) 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 this.getNoSchemaDDLStr();
	}

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

	/**
	 * Returns the defaultTbs.
	 * @return String
	 */
	public String getDefaultTbs() {
		return defaultTbs;
	}

	/**
	 * Returns the tmpTbs.
	 * @return String
	 */
	public String getTmpTbs() {
		return tmpTbs;
	}

}