dbmanager.java

这是和数据库连接有关的程序.如果有兴趣可以

/*
 * DBManager.java
 *
 * Created on 2007年11月14日, 上午11:37
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package jdbcjframe;

/**
 *
 * @author user
 */
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;

public class DBManager extends JFrame {
    /** Creates a new instance of DBManager */
           JMenuBar menuBar=new JMenuBar();
           JDesktopPane desktop=new JDesktopPane();
           String database=null;
           String tableName=null;
           String menuSelection=null;
           TableBuilderFrame tableMaker=null;
           DatabaseUtilities dbUtils=null;
           TableMenu tableMenu=new TableMenu();
           MenuListener menuListener=new MenuListener();
    
               public DBManager() {
                    setJMenuBar(menuBar);
                    setTitle("JDBC Database Boble");
                    getContentPane().setLayout(new BorderLayout());
                    getContentPane().add(desktop,BorderLayout.CENTER);
                    setSize(new Dimension(640,480));
                    menuBar.add(tableMenu);
                    tableMenu.setMenuListener(menuListener);
                    setVisible(true);
               }
               private void displayTableBuilderFrame(){
                     tableName=JOptionPane.showInputDialog(this,"Table;","Select table",JOptionPane.QUESTION_MESSAGE);
                     tableMaker=new TableBuilderFrame(tableName);
                     tableMaker.setCommandListener(new CommandListener());
                     desktop.add(tableMaker);
                     tableMaker.setVisible(true);   
              }
              private void selectDatabase(){
                    database=JOptionPane.showInputDialog(this,"Database;","Select database",JOptionPane.QUESTION_MESSAGE);
                     dbUtils=new DatabaseUtilities();
                     dbUtils.setExceptionListener(new ExceptionListener());
                     tableMenu.enableMenuItem("New Table",true);
                     tableMenu.enableMenuItem("Drop Table",true);
                  
              }
              private void executeSQLCommand(String SQLCommand){
              dbUtils.execute(SQLCommand);
              }
              private void dropTable(){
                    tableName=JOptionPane.showInputDialog(this,"Table;","Select table",JOptionPane.QUESTION_MESSAGE);
                    int option=JOptionPane.showConfirmDialog(null,
                            "Dropping table"+tableName,"Database"+database,JOptionPane.OK_CANCEL_OPTION);
                    if(option==0){
                    executeSQLCommand("DROP TABLE"+tableName);
                    }
              }
               class MenuListener implements ActionListener{
                   public void actionPerformed(ActionEvent event){
                   
                   String menuSelection=event.getActionCommand();
                   if(menuSelection.equals("Database")){
                   selectDatabase();
                   }else if(menuSelection.equals("New Table")){
                      displayTableBuilderFrame();
                   }
                   else if(menuSelection.equals("Drop Table")){
                      dropTable();
                   }else if(menuSelection.equals("Exit")){
                      System.exit(0);
                   }
                   }
               }
               class ExceptionListener implements ActionListener{
               public void actionPerformed(ActionEvent event){
               String exception=event.getActionCommand();
               JOptionPane.showMessageDialog(null,exception,"SQL Error",JOptionPane.ERROR_MESSAGE);
               }
               }
                class CommandListener implements ActionListener{
                 public void actionPerformed(ActionEvent event){
                 String SQLCommand=event.getActionCommand();
                 executeSQLCommand(SQLCommand);
                 }
                 }
                public static void main(String args[]){
                DBManager dbm=new DBManager();
                }
}