mainframe.java

网上找的

package studentinfosystem.zhouzijie;

import java.awt.*;

import javax.swing.*;
import com.borland.dbswing.TableScrollPane;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import com.borland.dbswing.JdbTable;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.dataset.Column;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.dataset.MetaDataUpdate;
import com.borland.dbswing.DBDisposeMonitor;
import com.borland.dbswing.JdbStatusLabel;
import javax.swing.border.BevelBorder;
import javax.swing.border.Border;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.text.VariantFormatter;
import com.borland.dx.dataset.ReadRow;
import com.borland.dx.dataset.RowFilterResponse;
import com.borland.dx.dataset.RowFilterListener;

/**
 * <p>Title: 学生管理信息系统</p>
 *
 * <p>Description: 学生管理信息系统数据版本</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: 广东工业大学</p>
 *
 * @author 周子杰
 * @version 1.0
 */
public class MainFrame extends JFrame {
    int choice;
    String sno;
    VariantFormatter formatter;
    static MainFrame mainframe;
    TableScrollPane tableScrollPane1 = new TableScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    Database database1 = new Database();
    static QueryDataSet queryDataSet1 = new QueryDataSet();

    Column column2 = new Column();
    Column column3 = new Column();
    Column column4 = new Column();
    Column column5 = new Column();
    Column column6 = new Column();
    DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenu1 = new JMenu();
    JMenu jMenu4 = new JMenu();
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenuItem jMenuItem5 = new JMenuItem();
    JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();
    Border border1 = BorderFactory.createBevelBorder(BevelBorder.RAISED,
            Color.white, Color.white, new Color(115, 114, 105),
            new Color(165, 163, 151));
    JLabel jLabel1 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    public MainFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {


        tableScrollPane1.setBounds(new Rectangle(7, 52, 670, 300));


        database1.setConnection(new ConnectionDescriptor(ConnectionFrame.URL,
                ConnectionFrame.name, ConnectionFrame.password, false, ConnectionFrame.driver));
        String SQL="select * from "+ConnectionFrame.table;
        queryDataSet1.setQuery(new QueryDescriptor(database1,
               SQL, null, true, Load.ALL));
        tableScrollPane1.setHorizontalScrollBarPolicy(JScrollPane.
                HORIZONTAL_SCROLLBAR_ALWAYS);
        getContentPane().setLayout(null);
        jButton3.setBounds(new Rectangle(556, 372, 92, 23));
        jButton3.setText("查看");
        jButton3.addActionListener(new MainFrame_jButton3_actionAdapter(this));
        jButton4.setBounds(new Rectangle(267, 14, 81, 23));
        jButton4.setText("删除");
        jButton4.addActionListener(new MainFrame_jButton4_actionAdapter(this));
        jButton5.setBounds(new Rectangle(368, 14, 81, 23));
        jButton5.setText("插入");
        jButton5.addActionListener(new MainFrame_jButton5_actionAdapter(this));
        this.setResizable(false);
        tableScrollPane1.getViewport().add(jdbTable1);



        queryDataSet1.setMetaDataUpdate(MetaDataUpdate.NONE);
        queryDataSet1.setTableName(ConnectionFrame.table);

        column6.setColumnName("department");
        column6.setDataType(com.borland.dx.dataset.Variant.STRING);
        column6.setWidth(14);
        column6.setPrecision(255);
        column6.setSqlType(12);

        column5.setColumnName("birthday");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        column5.setWidth(14);
        column5.setPrecision(255);
        column5.setSqlType(12);

        column4.setColumnName("sex");
        column4.setDataType(com.borland.dx.dataset.Variant.STRING);
        column4.setWidth(14);
        column4.setPrecision(255);
        column4.setSqlType(12);


        column3.setColumnName("name");
        column3.setDataType(com.borland.dx.dataset.Variant.STRING);
        column3.setWidth(14);
        column3.setPrecision(255);
        column3.setSqlType(12);

        column2.setColumnName("sno");
        column2.setRowId(true);
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setWidth(14);
        column2.setPrecision(255);
        column2.setSqlType(12);

        jdbTable1.setDataSet(queryDataSet1);

        queryDataSet1.setColumns(new Column[] {column2, column3, column4,
                                 column5, column6});

        dBDisposeMonitor1.setDataAwareComponentContainer(this);
        this.setJMenuBar(jMenuBar1);
        jMenu1.setText("文件");
        jMenu4.setText("帮助");
        jMenuItem1.setText("作者");
        jMenuItem1.addActionListener(new MainFrame_jMenuItem1_actionAdapter(this));
        jMenuItem2.setText("退出");
        jMenuItem2.addActionListener(new MainFrame_jMenuItem2_actionAdapter(this));
        jMenuItem5.setText("关于系统");
        jMenuItem5.addActionListener(new MainFrame_jMenuItem5_actionAdapter(this));
        jdbStatusLabel1.setBorder(border1);
        jdbStatusLabel1.setDebugGraphicsOptions(DebugGraphics.LOG_OPTION);
        jdbStatusLabel1.setDisplayedMnemonic('0');
        jdbStatusLabel1.setText("jdbStatusLabel1");
        jdbStatusLabel1.setDataSet(queryDataSet1);
        jdbStatusLabel1.setBounds(new Rectangle(7, 382, 100, 25));
        jLabel1.setText("学号：");
        jLabel1.setBounds(new Rectangle(7, 18, 53, 15));
        jTextField1.setBounds(new Rectangle(56, 15, 96, 20));
        jButton1.setBounds(new Rectangle(164, 14, 81, 23));
        jButton1.setText("查询");
        jButton1.addActionListener(new MainFrame_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(552, 15, 95, 23));
        jButton2.setText("显示全部");
        jButton2.addActionListener(new MainFrame_jButton2_actionAdapter(this));

        jMenuBar1.add(jMenu1);
        jMenuBar1.add(jMenu4);
        jMenu4.add(jMenuItem1);
        jMenu4.add(jMenuItem5);
        jMenu1.add(jMenuItem2);
        this.getContentPane().add(tableScrollPane1);

        this.getContentPane().add(jdbStatusLabel1);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jButton5);
        this.setTitle("学生信息管理系统");
        this.setSize(690,500);
        Dimension sreenSize=Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize=this.getSize();
        if(frameSize.height>sreenSize.width){
            frameSize.height = sreenSize.height;
        }
        if(frameSize.width>sreenSize.width){
            frameSize.width=sreenSize.width;
        }
        this.setLocation((sreenSize.width-frameSize.width)/2,
                         (sreenSize.height-frameSize.height)/2);
        this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        this.setVisible(true);
        queryDataSet1.addRowFilterListener(new
               MainFrame_queryDataSet1_rowFilterAdapter(this));
    }
    //作者信息
    public void jMenuItem1_actionPerformed(ActionEvent e) {
        JOptionPane.showMessageDialog(null,"学生: 周子杰\n"+
                                            "学院: 计算机学院\n"+
                                            "专业：计算机科学与技术03级02班\n"+
                                            "学号：3103003157\n"+
                                            "指导老师：杨劲涛","作者信息",JOptionPane.INFORMATION_MESSAGE);
    }
    //版本信息
    public void jMenuItem5_actionPerformed(ActionEvent e) {
        JOptionPane.showMessageDialog(null,"学生管理系统数据库版本1.0"
                                            ,"版本信息",JOptionPane.INFORMATION_MESSAGE);
    }

   //退出系统
    public void jMenuItem2_actionPerformed(ActionEvent e) {
        Object ob=JOptionPane.showConfirmDialog(null,"真的要退出本系统吗?","系统提示",JOptionPane.YES_NO_OPTION);
            if(ob.equals(JOptionPane.OK_OPTION))
            {
                this.setVisible(false);
                System.exit(0);
            }
    }
    //按学号查询
    public void jButton1_actionPerformed(ActionEvent e) {
     Column col=queryDataSet1.getColumn("sno");
     sno=jTextField1.getText();
     formatter=col.getFormatter();
     choice=1;
     queryDataSet1.refilter();//表刷新
     }

     public void jButton2_actionPerformed(ActionEvent e) {
     choice=2;
     queryDataSet1.refilter();//表刷新
    }
    //刷新表
    public void queryDataSet1_filterRow(ReadRow readRow,
                                        RowFilterResponse rowFilterResponse) {
    switch(choice)
    {
    case 1:
        if (formatter == null || sno.length() == 0)
            rowFilterResponse.add();
        else {
            String v;
            v = readRow.getString("sno");
            if (v.equals(sno))
                rowFilterResponse.add();
            else
                rowFilterResponse.ignore();
        }
        break;
    case 2:
        rowFilterResponse.add();
        break;
    }
    }

    public void jButton3_actionPerformed(ActionEvent e) {
      new CheckDialog();
    }
    //增加数据
    public void jButton5_actionPerformed(ActionEvent e) {
       queryDataSet1.insertRow(true);
       new InsertDialog();
    }
    //删除一行数据
    public void jButton4_actionPerformed(ActionEvent e) {
      Object ob=JOptionPane.showConfirmDialog(null,"永久性删除数据，真的要删除吗?","警告",JOptionPane.YES_NO_OPTION);
          if(ob.equals(JOptionPane.OK_OPTION))
          {
              queryDataSet1.deleteRow();
              queryDataSet1.saveChanges();
          }
    }


}


class MainFrame_jButton4_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jButton4_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton4_actionPerformed(e);
    }
}


class MainFrame_jButton5_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jButton5_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton5_actionPerformed(e);
    }
}


class MainFrame_jButton3_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jButton3_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton3_actionPerformed(e);
    }
}


class MainFrame_jButton2_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jButton2_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}


class MainFrame_queryDataSet1_rowFilterAdapter implements RowFilterListener {
    private MainFrame adaptee;
    MainFrame_queryDataSet1_rowFilterAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void filterRow(ReadRow readRow, RowFilterResponse rowFilterResponse) {
        adaptee.queryDataSet1_filterRow(readRow, rowFilterResponse);
    }
}


class MainFrame_jButton1_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jButton1_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}


class MainFrame_jMenuItem2_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jMenuItem2_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jMenuItem2_actionPerformed(e);
    }
}


class MainFrame_jMenuItem1_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jMenuItem1_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jMenuItem1_actionPerformed(e);
    }
}


class MainFrame_jMenuItem5_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_jMenuItem5_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jMenuItem5_actionPerformed(e);
    }
}