neworkmenu.java

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

/*
 * Created on 2004-11-3
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.icbcsdc.ddlexp.ui.popMenu;

import java.awt.Dimension;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JMenuItem;
import javax.swing.JOptionPane;
import javax.swing.JPopupMenu;

import com.icbcsdc.ddlexp.pub.staticLog.Logger;
import com.icbcsdc.ddlexp.pub.util.ConfigFile;
import com.icbcsdc.ddlexp.pub.util.FileDb;
import com.icbcsdc.ddlexp.pub.util.MessageBox;
import com.icbcsdc.ddlexp.pub.xml.nodeinfo.ComparedNode;
import com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLDatabase;
import com.icbcsdc.ddlexp.pub.xml.nodeinfo.XMLNode;
import com.icbcsdc.ddlexp.ui.GlobalParameters;
import com.icbcsdc.ddlexp.ui.TreeFrame;
import com.icbcsdc.ddlexp.ui.dialog.AddDatabaseDlg;

/**
 * @author youhx
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public class NeworkMenu extends ParentPopupMenu {

	private boolean isConnected = true;

	public NeworkMenu(TreeFrame parent,XMLNode node) {
		super(parent,node);
	}

	public JPopupMenu getJPopupMenu() {
		JPopupMenu popup = new JPopupMenu();
		
		JMenuItem addDbItem = new JMenuItem("Add Database");

		popup.add(addDbItem);
		
		addDbItem.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				try {
					addDB();
				} catch (Exception e1) {
					//e1.printStackTrace();
					Logger.log(Logger.ERROR,e1.getMessage());
					MessageBox.showErr(getTreeFrame(),"添加数据库失败,错误信息见日志");
				}
			}
		});

		return popup;
	}


	private void addDB() throws Exception{
		AddDatabaseDlg frame = new AddDatabaseDlg(parent);
		frame.pack();
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		Dimension dlgSize = frame.getPreferredSize();
		if (dlgSize.height > screenSize.height) 
		  dlgSize.height = screenSize.height;
		if (dlgSize.width > screenSize.width) 
		  dlgSize.width = screenSize.width;
		frame.setLocation((screenSize.width - dlgSize.width) / 2, (screenSize.height - dlgSize.height) / 2);
		frame.setModal(true);
		frame.show();
		
		if(frame.result == 1){
			String dbName = frame.dbName;
			String IP = frame.IP;
			String userName = frame.UserName;
			String Port = frame.Port;
			String Psw = frame.Psw;
			if((dbName.length() > 0)&&(IP.length() > 0)&&(userName.length() > 0)&&(Psw.length() > 0)){
				if(Port.length() == 0) Port = "1521";
				

				ConfigFile file=null;
				if(parent.getSelectedTree().getCompareStatus()==ComparedNode.NO_COMPARED){
					file = new ConfigFile(GlobalParameters.ddlDBConfig);		
				}else{
					file = new ConfigFile(GlobalParameters.compareDBConfig);				
				}
		
				Object[] sections = file.getAllSection();
				for(int i = 0;i < sections.length;i++){
					if(file.hasSection(sections[i].toString())){
						FileDb filedb = file.getFileDb(sections[i].toString());
						if((filedb.getDbName().equals(dbName.toLowerCase()))&&(filedb.getIP().equals(IP.toLowerCase()))&&(filedb.getUserName().equals(userName.toLowerCase()))){
							Logger.log(Logger.DEBUG,"添加数据库失败：数据库、用户名已存在!");		
							JOptionPane.showMessageDialog(null,"数据库已存在!","添加数据库失败",JOptionPane.WARNING_MESSAGE);
							return;					
						}
					}
				}
				
				XMLDatabase db=new XMLDatabase(IP,Integer.parseInt(Port),dbName,userName,Psw);
				db.getStatus();
				parent.addDatabase(db);

				String nextsection = "Database"+(Integer.parseInt(sections[sections.length-1].toString().replaceAll("Database",""))+1);
				file.setString(nextsection,"DbName",dbName);
				file.setString(nextsection,"IP",IP);
				file.setString(nextsection,"UserName",userName);
				file.setString(nextsection,"Port",Port);
				file.setString(nextsection,"Password",Psw);
				file.save();
				Logger.log(Logger.DEBUG,"添加数据库:"+dbName);
				
			}else{
				Logger.log(Logger.DEBUG,"添加数据库失败：关键数值不能为空!");
				JOptionPane.showMessageDialog(null,"关键数值不能为空！","添加数据库失败",JOptionPane.WARNING_MESSAGE);
				return;
			}
		}else{
			Logger.log(Logger.DEBUG,"用户取消添加数据库");
			return;
		}
	}

	void jbInit() {
	};

}