importdb.java

一个可以存储和打印成绩单的系统

package org.wuhang.cjsjk.OldDbToNewDb;

import java.awt.BorderLayout;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JButton;
import javax.swing.JFileChooser;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;

public class ImportDB extends JFrame {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
    private JPanel jpanel_title,jpanel_export,jpanel_button;
	private JLabel jlabel_export; 
	private JTextField choose_text;
	private JButton button_choose,button_yes,button_no;
	private JFileChooser chooser;
	private String db_path;
	private String file_name;
    private JProgressBarDemo progress = null;
    private JFrame f = new JFrame();
    public ImportDB(){
        jpanel_title = new JPanel();
    	jlabel_export = new JLabel("请选择要导入的数据库:");
        jpanel_title.add(jlabel_export);
    	
    	jpanel_export = new JPanel();
    	
    	choose_text = new JTextField("你选择所选的数据库的绝对路径.............");
    	button_choose = new JButton("选择..");
    	jpanel_export.setLayout(new FlowLayout(FlowLayout.RIGHT));
        jpanel_export.add(choose_text);
        jpanel_export.add(button_choose);
        
        jpanel_button = new JPanel();
        button_yes = new JButton("确定");
        button_no = new JButton("取消");
        jpanel_button.setLayout(new FlowLayout(FlowLayout.RIGHT));
        jpanel_button.add(button_yes);
        jpanel_button.add(button_no);
        
        button_choose.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		chooser = new JFileChooser();
        		chooser.setDialogTitle("选择数据库");
        		int returnVal = chooser.showOpenDialog(null);
        		if(returnVal == JFileChooser.APPROVE_OPTION) {
        			db_path = chooser.getSelectedFile().getAbsolutePath();
        			choose_text.setText(db_path);
        			file_name = chooser.getSelectedFile().getName();
        			db_path = db_path.replace('\\', '/');
        		}
        		else
        			return;
        	}
        });
        
        button_yes.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		if(judge(file_name)){
        			progress = new JProgressBarDemo(f);
        			new AccessToJavaDB(db_path,progress);
        		    setVisible(false);
        			
        		}else{
        			JOptionPane.showMessageDialog(null, "请选择正确的数据库文件", "提示", 
        					JOptionPane.ERROR_MESSAGE);
        			choose_text.setText("要导出的数据库.....");
        		}
        	}
        });
        
        button_no.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		System.exit(0);
        	}
        });
        
        
        this.getContentPane().add(jpanel_title,BorderLayout.NORTH);
        this.getContentPane().add(jpanel_export,BorderLayout.CENTER);
        this.getContentPane().add(jpanel_button,BorderLayout.SOUTH);
        this.setSize(300, 150);
        this.setLocation(this.getToolkit().getScreenSize().width/2 -
        		this.getWidth()/2, this.getToolkit().getScreenSize().height/2 -
        		this.getHeight()/2);
        
        this.setTitle("小工具");
        this.setVisible(true);
        this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    }
    
    public boolean judge(String file_name){
    	String t_file_name = file_name;
		if (t_file_name == null)
			return false;
		else {
			t_file_name = t_file_name.substring(
					t_file_name.lastIndexOf(".") + 1, t_file_name.length());
			if ("jar".equalsIgnoreCase(t_file_name)
					|| "mdb".equalsIgnoreCase(t_file_name)) {
				return true;
			} else
				return false;
		}
    }
    
    public static void main(String args[]){
    	new ImportDB();
    }
}