xmleditwindow.java

基于XML的Oracle的数据导出导入工具,实现从数据库表与XML文档之间的导入与导出 二：设计实现: 1. 开发语言:Java 2. 数据库选用：MySql(特别说明：由于没有安装Oracle

/*
 * 创建日期 2006-12-12
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package com.sxw.xml;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;

import javax.swing.ImageIcon;
import javax.swing.JFileChooser;
import javax.swing.JFrame;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.event.DocumentEvent;
import javax.swing.event.DocumentListener;

/**
 * @author sxwailyc
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class XmlEditWindow extends JFrame implements ActionListener,DocumentListener{
    private static final String FILE_MENU ="文件(F)";
    private static final String OPEN_MENUITEM ="打开(O)";
    private static final String SAVE_MENUITEM ="保存(S)";
    private static final String SAVE_AS_MENUITEM ="另存为(A)";
    private static final String EXIT_MENUITEM ="退出(E)";
    
    private static final String DATABASE_MENU ="数据库(D)";
    private static final String DATABASE_CONFIG_MENUITEM ="数据库配置";
    private static final String DATABASE_VIEW_MENUITEM ="查看数据库";
    
    private static final String DATA_CHANGE_FOR_MENU ="数据交换(C)";
    private static final String DATA_TO_XMLDOUMENT_MENUITEM ="数据库->XML文档(T)";
    private static final String XML_DOUMENT_TO_DATA_MENUITEM ="XML文档->数据库(O)";
	
    private static final String HELP_MENU ="帮助(H)";
    private static final String ABOUT_MENUITEM ="关于(A)";
    
	private JScrollPane jscrollpane;
	private JTextArea jtextarea;

	private JMenuBar jmenubar;
	private JMenu file ;
	private JMenuItem openfile;
	private JMenuItem savefile;
	private JMenuItem saveasfile;
	private JMenuItem exit;
	
	private JMenu database;
	private JMenuItem databaseconf;
	private JMenuItem databaseviwe;
	
	private JMenu datachangefor;
	private JMenuItem databasetoxml;
	private JMenuItem xmltodatabase;
	
	private JMenu help;
	private JMenuItem about;
	
	private String filepath;
	private CreateXml createxml;
	public XmlEditWindow(String name) {
	  
	  super(name);
	  
	  createxml = new CreateXml();
		
	  this.setSize(500,400);
   	  this.setVisible(true);
   	  
   	  file = new JMenu(FILE_MENU);
   	  ImageIcon openicon =new ImageIcon(this.getClass().getResource("icon\\open.gif"));
   	  openfile = new JMenuItem(OPEN_MENUITEM,openicon);
   	  openfile.addActionListener(this);
   	
   	  ImageIcon saveicon =new ImageIcon(this.getClass().getResource("icon\\save.gif"));
   	  savefile = new JMenuItem(SAVE_MENUITEM,saveicon);
   	  savefile.addActionListener(this);
   	  saveasfile =new JMenuItem(SAVE_AS_MENUITEM);
	  saveasfile.addActionListener(this);
	  
	  exit =new JMenuItem(EXIT_MENUITEM);
	  exit.addActionListener(this);
   	  file.add(openfile) ;
   	  file.add(savefile) ;
   	  file.add(saveasfile);
   	  file.addSeparator();
   	  file.add(exit);
   	  
   	  database = new JMenu(DATABASE_MENU);
   	  databaseconf = new JMenuItem(DATABASE_CONFIG_MENUITEM);
   	  databaseconf.addActionListener(this);
   	  databaseviwe =new JMenuItem(DATABASE_VIEW_MENUITEM);
   	  databaseviwe.addActionListener(this);
 
   	  database.add(databaseconf);
   	  database.add(databaseviwe);
   	  
   	  datachangefor = new JMenu(DATA_CHANGE_FOR_MENU);
   	  databasetoxml = new JMenuItem(DATA_TO_XMLDOUMENT_MENUITEM);
   	  databasetoxml.addActionListener(this);
   	  xmltodatabase = new JMenuItem(XML_DOUMENT_TO_DATA_MENUITEM);
   	  xmltodatabase.addActionListener(this);
   	  
  	  datachangefor.add(databasetoxml);
  	  datachangefor.add(xmltodatabase);
  	  
  	  help =new JMenu(HELP_MENU);  
      about =new JMenuItem(ABOUT_MENUITEM);
      about.addActionListener(this);
      help.add(about);
   	  
   	  jmenubar =new JMenuBar();
   	  jmenubar.add(file);
   	  jmenubar.add(database);
   	  jmenubar.add(datachangefor);
   	  jmenubar.add(help);
   	  this.setJMenuBar(jmenubar);
   	  
   	  jtextarea = new JTextArea();
   	  jtextarea.getDocument().addDocumentListener(this);
   	  //jtextpane = new JTextPane();
   	  jscrollpane =new JScrollPane(jtextarea);
   	  //jscrollpane =new JScrollPane(jtextpane);
   	  this.add(jscrollpane);
   	  this.setVisible(true);
   }
   public void addText(String str){
   	  jtextarea.append(str);
   	   
   }
   public void setAttribute(String databasename,String username,String password,String tablename){
   	 createxml.setDatabasename(databasename);
   	 createxml.setUsername(username);
   	 createxml.setPassword(password);
   	 createxml.setTablename(tablename);
   }
   public void connect() {
   	  createxml.connect();
   }
   public void actionPerformed(ActionEvent action) {
   	System.out.println("1-1");
	if(action.getActionCommand()==OPEN_MENUITEM){
   	    
		 JFileChooser chooser = new JFileChooser();
		 ExampleFileFilter filefilter = new ExampleFileFilter();
	     filefilter.addExtension("xml");
	     filefilter.setDescription("XML");
	     chooser.setFileFilter(filefilter);
	    int status = chooser.showOpenDialog(this);
	         
	      if(status ==JFileChooser.APPROVE_OPTION){
		     jtextarea.setText("");
		     createxml.setFilePath(chooser.getSelectedFile().getPath()) ;
		     System.out.println("经过这之后为"+createxml.getFilePath());
		     createxml.showToWindow(this);
	      }
    }
	else if(action.getActionCommand()==SAVE_MENUITEM){
		
	}
	else if(action.getActionCommand()==SAVE_AS_MENUITEM){
		JFileChooser chooser = new JFileChooser();
		//chooser.setApproveButtonText("adfasdf");
		ExampleFileFilter filefilter = new ExampleFileFilter();
	    filefilter.addExtension("xml");
	    filefilter.setDescription("XML");
	    chooser.setFileFilter(filefilter);
	    
	    chooser.setSelectedFile(new File(createxml.getFilePath()));
		int status = chooser.showSaveDialog(this);
		if(status ==JFileChooser.APPROVE_OPTION){
			createxml.setFilePath(chooser.getSelectedFile().getPath());
			System.out.println(createxml.getFilePath());
			createxml.saveXmlFile(jtextarea.getText());
		}
		
	}
	else if(action.getActionCommand()==EXIT_MENUITEM){
		System.exit(0);
	}
	else if(action.getActionCommand()==DATABASE_CONFIG_MENUITEM){
		
		System.out.println("数据库配置(F)");
		MyDialog dialog = new MyDialog(this,"数据库配置",true);
		dialog.setVisible(true);
	}
	else if(action.getActionCommand()==DATABASE_VIEW_MENUITEM) {
		String[] columnname ={"Column Name","DataType","NOT NULL","Default Value"};
		TableShowWindow tableshowwindow =new TableShowWindow(columnname,30);
		tableshowwindow.setTitle(createxml.getDB().getTableName());
		String[] rowname = createxml.getDB().getColumnNmae();
		tableshowwindow.setValuesAt(rowname,0);
		String[] columntypename=createxml.getDB().getColumnTypeName();
		tableshowwindow.setValuesAt(columntypename,1);
		 
		
	}
	else if(action.getActionCommand()==DATA_TO_XMLDOUMENT_MENUITEM){
		createxml.create();
	    jtextarea.setText("");
		createxml.showToWindow(this);
	}
	else if(action.getActionCommand()== XML_DOUMENT_TO_DATA_MENUITEM){
		System.out.println(XML_DOUMENT_TO_DATA_MENUITEM);
		createxml.insertToDatabase();
	}
	
  }
   public void removeUpdate(DocumentEvent e){
   	 System.out.println("removeUpdate");
   }
   public void changedUpdate(DocumentEvent e){
   	 System.out.println("changeUpdate");
   }
   public void insertUpdate(DocumentEvent e){
   	System.out.println("inserUpdate");
   }

}