usermanager.java~1~

我做的第一个java MIS项目

package client;


import java.awt.*;
import javax.swing.*;
import com.borland.dbswing.TableScrollPane;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.JdbTable;
import com.borland.dx.dataset.Column;
import com.borland.dbswing.JdbTextField;
import com.borland.dbswing.JdbEditorPane;
import com.borland.dbswing.JdbComboBox;
import com.borland.dbswing.JdbTextArea;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import server.dao.RunSQL;
import com.borland.dx.dataset.*;
import com.borland.dbswing.JdbNavToolBar;

public class Usermanager extends JPanel{
    public Usermanager() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        umpanel.setBorder(BorderFactory.createRaisedBevelBorder());
        umpanel.setBounds(new Rectangle(49, 37, 699, 381));
        umpanel.setLayout(null);
        database1.setConnection(new ConnectionDescriptor("jdbc:odbc:mrs", "",
                "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
        database1.setTransactionIsolation(java.sql.Connection.
                                          TRANSACTION_READ_UNCOMMITTED);
        database1.setDatabaseName("");
        jdbTable1.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_LAST_COLUMN);
        jdbTable1.setDataSet(queryDataSet1);
        jdbTable1.setEditable(false);
        jScrollPane1.getViewport().setBackground(Color.white);
        jScrollPane1.setBorder(null);
        jScrollPane1.setToolTipText("");
        jScrollPane1.setBounds(new Rectangle(62, 78, 559, 152));
        column1.setColumnName("卡号");
        column1.setDataType(com.borland.dx.dataset.Variant.STRING);
        column1.setDefault("");
        column1.setPrecision(50);
        column1.setServerColumnName("卡号");
        column1.setSqlType(12);
        column2.setColumnName("NewColumn1");
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setPreferredOrdinal(0);
        column2.setServerColumnName("NewColumn1");
        column2.setSqlType(0);
        queryDataSet1.setMetaDataUpdate(MetaDataUpdate.TABLENAME +
                                        MetaDataUpdate.PRECISION +
                                        MetaDataUpdate.SCALE +
                                        MetaDataUpdate.SEARCHABLE);
        queryDataSet1.setSchemaName("");
        queryDataSet1.setSort(new com.borland.dx.dataset.SortDescriptor("",
                new String[] {"卡号"}, new boolean[] {false, }, null, 0));
        queryDataSet1.setStoreName("");
        queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select cardid as \'卡号\',cardusername as \'帐户名\',cardpwd as \'帐户密码\',cardbalance " +
                "as \'帐户余额\', cardrestnum as \'可借碟数\' from card\n", null, true,
                Load.ALL));
        column3.setAlignment(com.borland.dx.text.Alignment.CENTER |
                             com.borland.dx.text.Alignment.MIDDLE);
        column3.setColumnName("可借碟数");
        column3.setDataType(com.borland.dx.dataset.Variant.INT);
        column3.setAutoIncrement(true);
        column3.setServerColumnName("可借碟数");
        column3.setSqlType(4);
        column4.setAlignment(com.borland.dx.text.Alignment.CENTER |
                             com.borland.dx.text.Alignment.MIDDLE);
        column4.setColumnName("卡号");
        column4.setDataType(com.borland.dx.dataset.Variant.STRING);
        column4.setExportDisplayMask("");
        column4.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        column4.setDefault("");
        column4.setPrecision(50);
        column4.setTableName("");
        column4.setAutoIncrement(true);
        column4.setServerColumnName("卡号");
        column4.setSqlType(12);
        column5.setAlignment(com.borland.dx.text.Alignment.CENTER |
                             com.borland.dx.text.Alignment.MIDDLE);
        column5.setColumnName("帐户名");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        column5.setPrecision(100);
        column5.setServerColumnName("帐户名");
        column5.setSqlType(12);
        column6.setAlignment(com.borland.dx.text.Alignment.CENTER |
                             com.borland.dx.text.Alignment.MIDDLE);
        column6.setColumnName("帐户密码");
        column6.setDataType(com.borland.dx.dataset.Variant.STRING);
        column6.setPrecision(50);
        column6.setServerColumnName("帐户密码");
        column6.setSqlType(12);
        column7.setAlignment(com.borland.dx.text.Alignment.CENTER |
                             com.borland.dx.text.Alignment.MIDDLE);
        column7.setColumnName("帐户余额");
        column7.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
        column7.setServerColumnName("帐户余额");
        column7.setSqlType(6);
        jdbtxfcardid.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jdbtxfcardid.setEditable(false);
        jdbtxfcardid.setText("");
        jdbtxfcardid.setColumnName("卡号");
        jdbtxfcardid.setDataSet(queryDataSet1);
        jdbtxfcardid.setBounds(new Rectangle(88, 264, 44, 29));
        jdbtxfcardusername.setBackground(Color.white);
        jdbtxfcardusername.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jdbtxfcardusername.setText("");
        jdbtxfcardusername.setColumnName("帐户名");
        jdbtxfcardusername.setDataSet(queryDataSet1);
        jdbtxfcardusername.setBounds(new Rectangle(191, 264, 71, 29));
        jdbtxfcardpwd.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jdbtxfcardpwd.setText("");
        jdbtxfcardpwd.setColumnName("帐户密码");
        jdbtxfcardpwd.setDataSet(queryDataSet1);
        jdbtxfcardpwd.setBounds(new Rectangle(313, 264, 71, 29));
        jdbtxfcardbalance.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jdbtxfcardbalance.setText("");
        jdbtxfcardbalance.setColumnName("帐户余额");
        jdbtxfcardbalance.setDataSet(queryDataSet1);
        jdbtxfcardbalance.setBounds(new Rectangle(443, 264, 71, 29));
        jdbtxfcardrestnum.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jdbtxfcardrestnum.setText("");
        jdbtxfcardrestnum.setColumnName("可借碟数");
        jdbtxfcardrestnum.setDataSet(queryDataSet1);
        jdbtxfcardrestnum.setBounds(new Rectangle(567, 264, 44, 29));
        column8.setColumnName("卡号");
        column8.setDataType(com.borland.dx.dataset.Variant.STRING);
        column8.setPrecision( -1);
        column8.setServerColumnName("卡号");
        column8.setSqlType(12);
        column9.setColumnName("帐户名");
        column9.setDataType(com.borland.dx.dataset.Variant.STRING);
        column9.setPrecision( -1);
        column9.setServerColumnName("帐户名");
        column9.setSqlType(12);
        column10.setColumnName("可借碟数");
        column10.setDataType(com.borland.dx.dataset.Variant.INT);
        column10.setPrecision(50);
        column10.setServerColumnName("可借碟数");
        column10.setSqlType(4);
        column11.setColumnName("帐户余额");
        column11.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
        column11.setWidth(40);
        column11.setServerColumnName("帐户余额");
        column11.setSqlType(6);
        jButton1.setBounds(new Rectangle(82, 321, 86, 31));
        jButton1.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jButton1.setText("更  新");
        jButton1.addActionListener(new Usermanager_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(199, 321, 86, 31));
        jButton2.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jButton2.setToolTipText("");
        jButton2.setText("删  除");
        jButton2.addActionListener(new Usermanager_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(315, 321, 86, 31));
        jButton3.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jButton3.setToolTipText("");
        jButton3.setText("刷  新");
        jButton3.addActionListener(new Usermanager_jButton3_actionAdapter(this));
        jdbNavToolBar1.setBounds(new Rectangle(69, 13, 367, 57));
        umpanel.add(jScrollPane1);
        jScrollPane1.getViewport().add(jdbTable1);
        umpanel.add(jdbtxfcardpwd);
        umpanel.add(jdbtxfcardid);
        umpanel.add(jdbtxfcardusername);
        umpanel.add(jdbtxfcardbalance);
        umpanel.add(jdbtxfcardrestnum);
        umpanel.add(jButton1);
        umpanel.add(jButton3);
        umpanel.add(jButton2);
        umpanel.add(jdbNavToolBar1);
        this.add(umpanel);
        queryDataSet1.setColumns(new Column[] {column4, column5, column6,
                                 column7, column3});
        queryDataSet1.setColumns(new Column[] {column8, column9, column11,
                                 column10});

    }

    JPanel umpanel=new JPanel();
    Database database1 = new Database();
    JdbTable jdbTable1 = new JdbTable();
    JScrollPane jScrollPane1 = new JScrollPane();
    Column column1 = new Column();
    Column column2 = new Column();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    Column column3 = new Column();
    Column column4 = new Column();
    Column column5 = new Column();
    Column column6 = new Column();
    Column column7 = new Column();
    JdbTextField jdbtxfcardid = new JdbTextField();
    JdbTextField jdbtxfcardusername = new JdbTextField();
    JdbTextField jdbtxfcardpwd = new JdbTextField();
    JdbTextField jdbtxfcardbalance = new JdbTextField();
    JdbTextField jdbtxfcardrestnum = new JdbTextField();
    Column column8 = new Column();
    Column column9 = new Column();
    Column column10 = new Column();
    Column column11 = new Column();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    int confirm=0;
    JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
    //刷新按钮动作
    public void jButton3_actionPerformed(ActionEvent e) {
        queryDataSet1.refresh();
    }
    //删除按钮动作
    public void jButton2_actionPerformed(ActionEvent e) {
        //再次确定
        confirm=JOptionPane.showConfirmDialog(this,"是否删除选定的记录？","删除确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
        if(confirm==0)
        {
            new RunSQL().runsql("delete from card where cardid='"+jdbtxfcardid.getText()+"'");
            queryDataSet1.refresh();
        }
    }
    //更新按钮动作
    public void jButton1_actionPerformed(ActionEvent e) {
        //再次确定
        confirm=JOptionPane.showConfirmDialog(this,"是否更新选定的记录？","更新确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
        if(confirm==0)
        {
            new RunSQL().runsql("delete from card where cardid='"+jdbtxfcardid.getText()+"'");
            queryDataSet1.refresh();
        }
    }
}


class Usermanager_jButton1_actionAdapter implements ActionListener {
    private Usermanager adaptee;
    Usermanager_jButton1_actionAdapter(Usermanager adaptee) {
        this.adaptee = adaptee;
    }

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


class Usermanager_jButton2_actionAdapter implements ActionListener {
    private Usermanager adaptee;
    Usermanager_jButton2_actionAdapter(Usermanager adaptee) {
        this.adaptee = adaptee;
    }

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


class Usermanager_jButton3_actionAdapter implements ActionListener {
    private Usermanager adaptee;
    Usermanager_jButton3_actionAdapter(Usermanager adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton3_actionPerformed(e);
    }
}