list_dialog.java

包含了7个java经典案例

package student;

import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.*;
import java.awt.event.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class List_Dialog extends JDialog {
  JPanel panel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();
  JComboBox jComboBox2 = new JComboBox();
  JComboBox jComboBox3 = new JComboBox();
  JButton jButton1 = new JButton();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JButton jButton5 = new JButton();
  Column column1 = new Column();
  Column column2 = new Column();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  QueryDataSet queryDataSet3 = new QueryDataSet();
  QueryDataSet queryDataSet4 = new QueryDataSet();
  JPanel jPanel1 = new JPanel();
  XYLayout xYLayout2 = new XYLayout();
  JPanel jPanel2 = new JPanel();
  XYLayout xYLayout3 = new XYLayout();
  GridBagLayout gridBagLayout1 = new GridBagLayout();
  QueryDataSet queryDataSet5 = new QueryDataSet();

  public List_Dialog(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {
      jbInit();
     // pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public List_Dialog() {
    this(null, "", false);
  }

  private void jbInit() throws Exception {
    panel1.setLayout(gridBagLayout1);
    jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel1.setText("所在院系：");
    jLabel2.setText("所在专业：");
    jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel3.setText("所在班级：");
    jLabel3.setFont(new java.awt.Font("DialogInput", 0, 12));
    jComboBox1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jComboBox1.addItemListener(new List_Dialog_jComboBox1_itemAdapter(this));
    jComboBox2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jComboBox2.addFocusListener(new List_Dialog_jComboBox2_focusAdapter(this));
    jComboBox2.addMouseListener(new List_Dialog_jComboBox2_mouseAdapter(this));
    jComboBox3.setFont(new java.awt.Font("DialogInput", 0, 12));
    jComboBox3.addFocusListener(new List_Dialog_jComboBox3_focusAdapter(this));
    jButton1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton1.setText("增加");
    jButton1.addActionListener(new List_Dialog_jButton1_actionAdapter(this));
    jButton3.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton3.setText("删除");
    jButton3.addActionListener(new List_Dialog_jButton3_actionAdapter(this));
    jButton4.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton4.setText("退出");
    jButton4.addActionListener(new List_Dialog_jButton4_actionAdapter(this));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:student", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    jButton5.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton5.setText("查询");
    jButton5.addActionListener(new List_Dialog_jButton5_actionAdapter(this));
    queryDataSet1.setMetaDataUpdate(MetaDataUpdate.TABLENAME+MetaDataUpdate.PRECISION+MetaDataUpdate.SCALE+MetaDataUpdate.SEARCHABLE);
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select code , name from student where code = \'000\'", null, true, Load.ALL));
    column1.setCaption("学号");
    column1.setColumnName("code");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setPrecision(14);
    column1.setRowId(true);
    column1.setTableName("student");
    column1.setServerColumnName("code");
    column1.setSqlType(12);
    column2.setCaption("姓名");
    column2.setColumnName("name");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(10);
    column2.setTableName("student");
    column2.setServerColumnName("name");
    column2.setSqlType(12);
    queryDataSet1.setColumns(new Column[] {column1, column2});
    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
    jdbTable1.setDataSet(queryDataSet1);
    jdbTable1.setEditable(false);
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from department;", null, true, Load.ALL));
    this.setResizable(false);
    this.setTitle("名单管理");
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setLayout(xYLayout2);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setLayout(xYLayout3);
    queryDataSet5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from student", null, true, Load.ALL));
    getContentPane().add(panel1);
    panel1.add(jPanel1,  new GridBagConstraints(0, 0, 1, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(8, 16, 0, 21), 12, 4));
    jPanel1.add(jComboBox1, new XYConstraints(82, 8, 171, -1));
    jPanel1.add(jLabel1, new XYConstraints(9, 12, 68, -1));
    jPanel1.add(jLabel2, new XYConstraints(9, 41, 63, -1));
    jPanel1.add(jComboBox2, new XYConstraints(82, 39, 171, 25));
    jPanel1.add(jLabel3, new XYConstraints(10, 71, 63, -1));
    jPanel1.add(jComboBox3, new XYConstraints(82, 67, 171, 25));
    jPanel1.add(jButton5,  new XYConstraints(267, 20, -1, 50));
    panel1.add(jPanel2,  new GridBagConstraints(0, 1, 1, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(7, 16, 18, 21), 11, 12));
    jPanel2.add(jButton1, new XYConstraints(15, 329, -1, -1));
    jPanel2.add(jButton4, new XYConstraints(267, 330, -1, -1));
    jPanel2.add(tableScrollPane1,    new XYConstraints(13, 14, 314, 305));
    jPanel2.add(jButton3, new XYConstraints(138, 330, -1, -1));
    tableScrollPane1.getViewport().add(jdbTable1, null);
    int count = 0;
    try{
      if(!queryDataSet2.isOpen()) queryDataSet2.open();
      count = queryDataSet2.getRowCount();
      queryDataSet2.first();
      for (int i = 0; i < count; i++) {
        jComboBox1.addItem(queryDataSet2.getString("name"));
        queryDataSet2.next();
      }
      queryDataSet2.close();
    }catch(Exception ex){}

  }

  void jComboBox2_mousePressed(MouseEvent e) {

  }

  void jComboBox2_focusGained(FocusEvent e) {
    if(jComboBox1.getSelectedIndex()<0)
       return;

     try{
       String sql = "select  name  from major  where department = \'"
           + jComboBox1.getSelectedItem() + "\'";
       if (queryDataSet3.isOpen()) queryDataSet3.close();
       queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
           database1, sql, null, true, Load.ALL));
       queryDataSet3.open();
     }catch(Exception ex){
       JOptionPane.showMessageDialog(this,ex.toString());
       return;
     }
     jComboBox2.removeAllItems();
     int count = 0;
     try{
       count = queryDataSet3.getRowCount();
       queryDataSet3.first();
       for (int i = 0; i < count; i++) {
         jComboBox2.addItem(queryDataSet3.getString("name"));
         queryDataSet3.next();
       }
       queryDataSet3.close();
     }catch(Exception ex){
       JOptionPane.showMessageDialog(this,ex.toString());
     }

  }

  void jComboBox1_itemStateChanged(ItemEvent e) {
    jComboBox2.removeAllItems();
    jComboBox3.removeAllItems();
  }

  void jComboBox3_focusGained(FocusEvent e) {
    if(jComboBox1.getSelectedIndex()<0)
       return;
    if(jComboBox2.getSelectedIndex()<0)
       return;
     try{
       String sql = "select  code  from class  where department = \'"
           + jComboBox1.getSelectedItem() + "\'and major = \'"
           + jComboBox2.getSelectedItem() + "\'";
       if (queryDataSet4.isOpen()) queryDataSet4.close();
       queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
           database1, sql, null, true, Load.ALL));
       queryDataSet4.open();
     }catch(Exception ex){
       JOptionPane.showMessageDialog(this,ex.toString());
       return;
     }
     jComboBox3.removeAllItems();
     int count = 0;
     try{
       count = queryDataSet4.getRowCount();
       queryDataSet4.first();
       for (int i = 0; i < count; i++) {
         jComboBox3.addItem(queryDataSet4.getString("code"));
         queryDataSet4.next();
       }
       queryDataSet4.close();
     }catch(Exception ex){
       JOptionPane.showMessageDialog(this,ex.toString());
     }

  }

  void jButton5_actionPerformed(ActionEvent e) {
    try{
      String sql = "select  code,name  from student  where department = \'"
          + jComboBox1.getSelectedItem() + "\'and major = \'"
          + jComboBox2.getSelectedItem() + "\'and class = \'"
          + jComboBox3.getSelectedItem() + "\'";


      if (queryDataSet1.isOpen()) queryDataSet1.close();
      queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
          database1, sql, null, true, Load.ALL));
      queryDataSet1.open();
    }catch(Exception ex){
      JOptionPane.showMessageDialog(this,ex.toString());
      return;
    }

  }

  void jButton1_actionPerformed(ActionEvent e) {
    if(jComboBox1.getSelectedIndex()<0){
      JOptionPane.showMessageDialog(this,"请选择院系！","提示",JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    if(jComboBox2.getSelectedIndex()<0){
      JOptionPane.showMessageDialog(this,"请选择专业！","提示",JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    if(jComboBox3.getSelectedIndex()<0){
      JOptionPane.showMessageDialog(this,"请选择班级！","提示",JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    try{
      String sql = "select  code,name  from student  where department = \'"
          + jComboBox1.getSelectedItem() + "\'and major = \'"
          + jComboBox2.getSelectedItem() + "\'and class = \'"
          + jComboBox3.getSelectedItem() + "\'";


      if (queryDataSet1.isOpen()) queryDataSet1.close();
      queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
          database1, sql, null, true, Load.ALL));
      queryDataSet1.open();
    }catch(Exception ex){
      JOptionPane.showMessageDialog(this,ex.toString());
      return;
    }


    New_Student_Dialog  dlg = new New_Student_Dialog();
    Dimension dlgSize = dlg.getPreferredSize();
    Dimension frmSize = getSize();
    Point loc = getLocation();
    dlg.setLocation( (frmSize.width - dlgSize.width) / 2 + loc.x,
                    (frmSize.height - dlgSize.height) / 2 + loc.y);
    dlg.setModal(true);
    dlg.pack();

    try{
      if(!queryDataSet5.isOpen()) queryDataSet5.open();
      while(true){
        dlg.show();
        if(!dlg.isOK) return;
        queryDataSet5.insertRow(false);
        queryDataSet5.setString("code",dlg.jTextField1.getText());
        queryDataSet5.setString("name",dlg.jTextField2.getText());
        queryDataSet5.setString("department",jComboBox1.getSelectedItem().toString());
        queryDataSet5.setString("major",jComboBox2.getSelectedItem().toString());
        queryDataSet5.setString("class",jComboBox3.getSelectedItem().toString());
        queryDataSet5.post();
        queryDataSet5.saveChanges();
        queryDataSet1.refresh();

       }
    }catch(Exception ex){
      JOptionPane.showMessageDialog(this,"该学号已经存在，请重新输入！");
    }finally{
      queryDataSet5.close();
    }



  }

  void jButton3_actionPerformed(ActionEvent e) {
    try{
      queryDataSet1.deleteRow();
      queryDataSet1.post();
      queryDataSet1.saveChanges();
      queryDataSet1.refresh();
    }catch(Exception ex){
      queryDataSet1.refresh();
      JOptionPane.showMessageDialog(this,"删除失败","提示",JOptionPane.ERROR_MESSAGE);
    }

  }

  void jButton4_actionPerformed(ActionEvent e) {
    this.dispose();
  }
}

class List_Dialog_jComboBox2_mouseAdapter extends java.awt.event.MouseAdapter {
  List_Dialog adaptee;

  List_Dialog_jComboBox2_mouseAdapter(List_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void mousePressed(MouseEvent e) {
    adaptee.jComboBox2_mousePressed(e);
  }
}

class List_Dialog_jComboBox2_focusAdapter extends java.awt.event.FocusAdapter {
  List_Dialog adaptee;

  List_Dialog_jComboBox2_focusAdapter(List_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void focusGained(FocusEvent e) {
    adaptee.jComboBox2_focusGained(e);
  }
}

class List_Dialog_jComboBox1_itemAdapter implements java.awt.event.ItemListener {
  List_Dialog adaptee;

  List_Dialog_jComboBox1_itemAdapter(List_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void itemStateChanged(ItemEvent e) {
    adaptee.jComboBox1_itemStateChanged(e);
  }
}

class List_Dialog_jComboBox3_focusAdapter extends java.awt.event.FocusAdapter {
  List_Dialog adaptee;

  List_Dialog_jComboBox3_focusAdapter(List_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void focusGained(FocusEvent e) {
    adaptee.jComboBox3_focusGained(e);
  }
}

class List_Dialog_jButton5_actionAdapter implements java.awt.event.ActionListener {
  List_Dialog adaptee;

  List_Dialog_jButton5_actionAdapter(List_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class List_Dialog_jButton1_actionAdapter implements java.awt.event.ActionListener {
  List_Dialog adaptee;

  List_Dialog_jButton1_actionAdapter(List_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class List_Dialog_jButton3_actionAdapter implements java.awt.event.ActionListener {
  List_Dialog adaptee;

  List_Dialog_jButton3_actionAdapter(List_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class List_Dialog_jButton4_actionAdapter implements java.awt.event.ActionListener {
  List_Dialog adaptee;

  List_Dialog_jButton4_actionAdapter(List_Dialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}