dbmanage.java

我做的第一个java MIS项目

package client;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import com.borland.dbswing.TableScrollPane;
import com.borland.dbswing.JdbTable;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.Column;
import javax.swing.event.AncestorEvent;
import javax.swing.event.AncestorListener;
import com.borland.dbswing.JdbStatusLabel;
import com.borland.dbswing.JdbNavList;
import com.borland.dbswing.JdbNavField;
import client.dbdialog.*;
import client.dbdialog.dialogtemp;
import com.borland.dbswing.JdbTextField;
import server.dao.RunSQL;
import java.util.*;


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

    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setSize(795,550);
        TabPnl.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        TabPnl.setBounds(new Rectangle(40, 24, 710, 426));
        pnldbcd.setLayout(null);
        db.setConnection(new ConnectionDescriptor("jdbc:odbc:mrs", "", "", false,"sun.jdbc.odbc.JdbcOdbcDriver"));
        db.setDatabaseName("");
        pnldbcd.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        column1.setColumnName("光碟id");
        column1.setDataType(com.borland.dx.dataset.Variant.STRING);
        column1.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        column1.setMax("");
        column1.setMin("");
        column1.setPrecision(50);
        column1.setServerColumnName("光碟id");
        column1.setSqlType(12);
        dbcdbtnadd.setBounds(new Rectangle(159, 359, 81, 27));
        dbcdbtnadd.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbcdbtnadd.setToolTipText("增加一条新的碟片记录");
        dbcdbtnadd.setText("增 加");
        dbcdbtnadd.addActionListener(new Dbmanage_dbcdbtnadd_actionAdapter(this));
        dbtablecd.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbtablecd.setToolTipText("双击编辑当前选定记录");
        dbtablecd.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        dbtablecd.setDataSet(qdbcd);
        dbtablecd.setEditable(false);
        dbtablecd.addMouseListener(new Dbmanage_dbtablecd_mouseAdapter(this));
        spnlcd.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        spnlcd.setBorder(BorderFactory.createEtchedBorder());
        spnlcd.setBounds(new Rectangle(26, 31, 657, 315));
        dbcdbtnmdf.setBounds(new Rectangle(300, 359, 81, 27));
        dbcdbtnmdf.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbcdbtnmdf.setToolTipText("编辑当前选定记录");
        dbcdbtnmdf.setText("修 改");
        dbcdbtnmdf.addActionListener(new Dbmanage_dbcdbtnmdf_actionAdapter(this));
        dbcdbtndel.setBounds(new Rectangle(441, 359, 81, 27));
        dbcdbtndel.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbcdbtndel.setToolTipText("删除当前选定记录");
        dbcdbtndel.setText("删 除");
        dbcdbtndel.addActionListener(new Dbmanage_dbcdbtndel_actionAdapter(this));
        mdfcdid.setVisible(false);
        mdfcdid.setText("jdbTextField1");
        mdfcdid.setColumnName("光碟id");
        mdfcdid.setDataSet(qdbcd);
        mdfcdid.setBounds(new Rectangle(12, 4, 95, 29));
        mdfcdusername.setVisible(false);
        mdfcdusername.setText("jdbTextField2");
        mdfcdusername.setColumnName("电影名称");
        mdfcdusername.setDataSet(qdbcd);
        mdfcdusername.setBounds(new Rectangle(398, 4, 95, 29));
        mdfcdtype.setVisible(false);
        mdfcdtype.setText("jdbTextField3");
        mdfcdtype.setColumnName("载体类型");
        mdfcdtype.setDataSet(qdbcd);
        mdfcdtype.setBounds(new Rectangle(205, 4, 95, 29));
        mdfcdmtype.setVisible(false);
        mdfcdmtype.setText("jdbTextField4");
        mdfcdmtype.setColumnName("电影种类");
        mdfcdmtype.setDataSet(qdbcd);
        mdfcdmtype.setBounds(new Rectangle(302, 4, 95, 29));
        mdfcdactor.setVisible(false);
        mdfcdactor.setText("jdbTextField5");
        mdfcdactor.setColumnName("主演");
        mdfcdactor.setDataSet(qdbcd);
        mdfcdactor.setBounds(new Rectangle(495, 4, 95, 29));
        mdfcdnote.setVisible(false);
        mdfcdnote.setText("jdbTextField6");
        mdfcdnote.setColumnName("备注");
        mdfcdnote.setDataSet(qdbcd);
        mdfcdnote.setBounds(new Rectangle(591, 4, 95, 29));
        qdbcd.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db,
                "select cdid as \'光碟id\' ,cdexist as \'是否在库\',cdname as \'电影名称\',cdtype " +
                "as \'载体类型\', cdmtype as \'电影种类\', cdactor as \'主演\',cdnotes as \'备注\' from " +
                "cd", null, true, Load.ALL));
        mdfcdexist.setVisible(false);
        mdfcdexist.setText("jdbTextField1");
        mdfcdexist.setColumnName("是否在库");
        mdfcdexist.setDataSet(qdbcd);
        mdfcdexist.setBounds(new Rectangle(109, 4, 95, 29));
        dbtablecard.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbtablecard.setToolTipText("双击编辑当前选定记录");
        dbtablecard.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        dbtablecard.setDataSet(qdbcard);
        dbtablecard.setEditable(false);
        dbtablecard.addMouseListener(new Dbmanage_dbtablecard_mouseAdapter(this));
        spnlcard.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        spnlcard.setBorder(BorderFactory.createEtchedBorder());
        spnlcard.setBounds(new Rectangle(26, 31, 657, 315));
        pnldbcard.setLayout(null);
        //备份SQL:select cardid as '卡号',cardpwd as '密码',cardusername as '客户名',cardbalance as '余款',cardrestnum as '可借碟数' from card
        qdbcard.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db,
                "select cardid as \'卡号\',cardpwd as \'密码\',cardusername as \'客户名\',cardbalance " +
                "as \'余款\',cardrestnum as \'可借碟数\' from card", null, true,
                Load.ALL));
        mdfcardid.setVisible(false);
        mdfcardid.setToolTipText("");
        mdfcardid.setText("jdbTextField1");
        mdfcardid.setColumnName("卡号");
        mdfcardid.setDataSet(qdbcard);
        mdfcardid.setBounds(new Rectangle(53, 3, 83, 27));
        mdfcardpwd.setVisible(false);
        mdfcardpwd.setText("jdbTextField2");
        mdfcardpwd.setColumnName("密码");
        mdfcardpwd.setDataSet(qdbcard);
        mdfcardpwd.setBounds(new Rectangle(181, 3, 83, 27));
        mdfcardusername.setVisible(false);
        mdfcardusername.setText("jdbTextField3");
        mdfcardusername.setColumnName("客户名");
        mdfcardusername.setDataSet(qdbcard);
        mdfcardusername.setBounds(new Rectangle(308, 3, 83, 27));
        mdfcardbalance.setVisible(false);
        mdfcardbalance.setText("jdbTextField4");
        mdfcardbalance.setColumnName("余款");
        mdfcardbalance.setDataSet(qdbcard);
        mdfcardbalance.setBounds(new Rectangle(436, 3, 83, 27));
        mdfcardrestnum.setVisible(false);
        mdfcardrestnum.setText("jdbTextField5");
        mdfcardrestnum.setColumnName("可借碟数");
        mdfcardrestnum.setDataSet(qdbcard);
        mdfcardrestnum.setBounds(new Rectangle(563, 3, 83, 27));
        dbcardbtnadd.setBounds(new Rectangle(159, 359, 81, 27));
        dbcardbtnadd.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbcardbtnadd.setToolTipText("增加一条新的会员卡记录");
        dbcardbtnadd.setText("增 加");
        dbcardbtnadd.addActionListener(new Dbmanage_dbcardbtnadd_actionAdapter(this));
        dbcardbtndel.setBounds(new Rectangle(441, 359, 81, 27));
        dbcardbtndel.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbcardbtndel.setToolTipText("删除当前选定记录");
        dbcardbtndel.setText("删 除");
        dbcardbtndel.addActionListener(new Dbmanage_dbcardbtndel_actionAdapter(this));
        dbcardbtnmdf.setBounds(new Rectangle(300, 359, 81, 27));
        dbcardbtnmdf.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbcardbtnmdf.setToolTipText("编辑当前选定记录");
        dbcardbtnmdf.setText("修 改");
        dbcardbtnmdf.addActionListener(new Dbmanage_dbcardbtnmdf_actionAdapter(this));
        pnldrec.setLayout(null);
        spnlrec.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        spnlrec.setBorder(BorderFactory.createEtchedBorder());
        spnlrec.setBounds(new Rectangle(26, 31, 657, 315));
        dbtablerec.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbtablerec.setToolTipText("双击编辑当前选定记录");
        dbtablerec.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        dbtablerec.setDataSet(qdbrec);
        dbtablerec.setEditable(false);
        dbtablerec.addMouseListener(new Dbmanage_dbtablerec_mouseAdapter(this));
        //sql备份：select recid as '记录号', reccardid as '卡号',reccdid as '碟片号',recstarttime as '借出时间', recendtime as '归还时间' from record
        qdbrec.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db,
                "select recid as \'记录号\', reccardid as \'卡号\',reccdid as \'碟片号\',recstarttime " +
                "as \'借出时间\', recendtime as \'归还时间\' from record", null, true,
                Load.ALL));
        dbrecbtnadd.setBounds(new Rectangle(159, 359, 81, 27));
        dbrecbtnadd.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbrecbtnadd.setToolTipText("增加一条新的借还记录");
        dbrecbtnadd.setText("增 加");
        dbrecbtnadd.addActionListener(new Dbmanage_dbrecbtnadd_actionAdapter(this));
        dbrecbtndel.setBounds(new Rectangle(441, 359, 81, 27));
        dbrecbtndel.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbrecbtndel.setToolTipText("删除当前选定记录");
        dbrecbtndel.setText("删 除");
        dbrecbtndel.addActionListener(new Dbmanage_dbrecbtndel_actionAdapter(this));
        dbrecbtnmdf.setBounds(new Rectangle(300, 359, 81, 27));
        dbrecbtnmdf.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        dbrecbtnmdf.setToolTipText("编辑当前选定记录");
        dbrecbtnmdf.setText("修 改");
        dbrecbtnmdf.addActionListener(new Dbmanage_dbrecbtnmdf_actionAdapter(this));
        mdfrecid.setVisible(false);
        mdfrecid.setText("jdbTextField1");
        mdfrecid.setColumnName("记录号");
        mdfrecid.setDataSet(qdbrec);
        mdfrecid.setBounds(new Rectangle(46, 7, 91, 23));
        mdfreccardid.setVisible(false);
        mdfreccardid.setText("jdbTextField2");
        mdfreccardid.setColumnName("卡号");
        mdfreccardid.setDataSet(qdbrec);
        mdfreccardid.setBounds(new Rectangle(178, 7, 91, 23));
        mdfrecstarttime.setVisible(false);
        mdfrecstarttime.setText("jdbTextField3");
        mdfrecstarttime.setColumnName("借出时间");
        mdfrecstarttime.setDataSet(qdbrec);
        mdfrecstarttime.setBounds(new Rectangle(441, 7, 91, 23));
        mdfreccdid.setVisible(false);
        mdfreccdid.setText("jdbTextField4");
        mdfreccdid.setColumnName("碟片号");
        mdfreccdid.setDataSet(qdbrec);
        mdfreccdid.setBounds(new Rectangle(309, 7, 91, 23));
        mdfrecendtime.setVisible(false);
        mdfrecendtime.setText("jdbTextField5");
        mdfrecendtime.setColumnName("归还时间");
        mdfrecendtime.setDataSet(qdbrec);
        mdfrecendtime.setBounds(new Rectangle(572, 7, 91, 23));
        pnldrec.add(spnlrec);
        pnldrec.add(dbrecbtnadd);
        pnldrec.add(dbrecbtndel);
        pnldrec.add(dbrecbtnmdf);
        pnldrec.add(mdfrecid);
        pnldrec.add(mdfreccardid);
        pnldrec.add(mdfrecstarttime);
        pnldrec.add(mdfreccdid);
        pnldrec.add(mdfrecendtime);
        spnlrec.getViewport().add(dbtablerec);
        pnldbcard.add(spnlcard);
        pnldbcard.add(mdfcardrestnum);
        pnldbcard.add(mdfcardid);
        pnldbcard.add(mdfcardpwd);
        pnldbcard.add(mdfcardusername);
        pnldbcard.add(mdfcardbalance);
        pnldbcard.add(dbcardbtnadd);
        pnldbcard.add(dbcardbtndel);
        pnldbcard.add(dbcardbtnmdf);
        spnlcard.getViewport().add(dbtablecard);
        pnldbcd.add(spnlcd);
        pnldbcd.add(dbcdbtndel);
        pnldbcd.add(dbcdbtnadd);
        pnldbcd.add(dbcdbtnmdf);
        pnldbcd.add(mdfcdid);
        pnldbcd.add(mdfcdexist);
        pnldbcd.add(mdfcdtype);
        pnldbcd.add(mdfcdmtype);
        pnldbcd.add(mdfcdusername);
        pnldbcd.add(mdfcdactor);
        pnldbcd.add(mdfcdnote);
        spnlcd.getViewport().add(dbtablecd);
        qdbcd.setColumns(new Column[] {column1});
        this.add(TabPnl);
        backpic.setBounds(new Rectangle(0, 0, 796, 476));
        this.add(backpic);
        TabPnl.add(pnldbcd, "碟片管理");
        TabPnl.add(pnldbcard,"卡管理");
        TabPnl.add(pnldrec, "记录管理");

    }

    JTabbedPane TabPnl = new JTabbedPane();
    JPanel pnldbcd = new JPanel();
    JPanel pnldbcard=new JPanel();
    JPanel pnldrec=new JPanel();
    Database db = new Database();
    QueryDataSet qdbcd = new QueryDataSet();
    Column column1 = new Column();
    JButton dbcdbtnadd = new JButton();
    JdbTable dbtablecd = new JdbTable();
    TableScrollPane spnlcd = new TableScrollPane();
    JButton dbcdbtnmdf = new JButton();
    JButton dbcdbtndel = new JButton();
    JdbTextField mdfcdid = new JdbTextField();
    JdbTextField mdfcdusername = new JdbTextField();
    JdbTextField mdfcdtype = new JdbTextField();
    JdbTextField mdfcdmtype = new JdbTextField();
    JdbTextField mdfcdactor = new JdbTextField();
    JdbTextField mdfcdnote = new JdbTextField();
    JdbTextField mdfcdexist = new JdbTextField();
    JdbTable dbtablecard = new JdbTable();
    TableScrollPane spnlcard = new TableScrollPane();
    QueryDataSet qdbcard = new QueryDataSet(); //添加按钮动作

    JdbTextField mdfcardid = new JdbTextField();
    JdbTextField mdfcardpwd = new JdbTextField();
    JdbTextField mdfcardusername = new JdbTextField();
    JdbTextField mdfcardbalance = new JdbTextField();
    JdbTextField mdfcardrestnum = new JdbTextField();
    JButton dbcardbtnadd = new JButton();
    JButton dbcardbtndel = new JButton();
    JButton dbcardbtnmdf = new JButton();
    TableScrollPane spnlrec = new TableScrollPane();
    JdbTable dbtablerec = new JdbTable();
    QueryDataSet qdbrec = new QueryDataSet();
    JButton dbrecbtnadd = new JButton();
    JButton dbrecbtndel = new JButton();
    JButton dbrecbtnmdf = new JButton();
    JdbTextField mdfrecid = new JdbTextField();
    JdbTextField mdfreccardid = new JdbTextField();
    JdbTextField mdfrecstarttime = new JdbTextField();
    JdbTextField mdfreccdid = new JdbTextField();
    JdbTextField mdfrecendtime = new JdbTextField();
    JLabel backpic = new JLabel(new ImageIcon(".\\pic\\mainback.jpg"));