mngleechdom.java

医疗管理系统

package cliniquemanager;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dbswing.JdbTable;
import javax.swing.border.TitledBorder;
import java.awt.Rectangle;
import com.borland.dx.dataset.Column;
import java.awt.Font;

/**
 * <p>Title: CliniqueManager</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: shine</p>
 *
 * @author robin
 * @version 1.0
 */
public class MngLeechdom extends JPanel {
    MyDatabase db;
    JScrollPane jScrollPane1 = new JScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    JButton btnAdd = new JButton();
    JButton btnFresh = new JButton();
    JButton btnModify = new JButton();
    JButton btnDel = new JButton();
    TitledBorder titledBorder1 = new TitledBorder("药品信息");
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    Column lch_id = new Column();
    Column name = new Column();
    Column factory = new Column();
    Column price = new Column();
    Column count = new Column();
    JButton btnExit = new JButton();
    JEditorPane jEditorPane1 = new JEditorPane();
    TitledBorder titledBorder2 = new TitledBorder("基本操作");
    JLabel jLable1 = new JLabel();

    public MngLeechdom() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setSize(new Dimension(1000, 600));
        jScrollPane1.setBorder(titledBorder1);
        btnAdd.setText("添加");
        btnAdd.addActionListener(new MngLeechdom_btnAdd_actionAdapter(this));
        btnFresh.setText("刷新");
        btnFresh.addActionListener(new MngLeechdom_btnFresh_actionAdapter(this));
        btnModify.setText("修改");
        btnModify.addActionListener(new MngLeechdom_btnModify_actionAdapter(this));
        btnDel.setText("删除");
        btnDel.addActionListener(new MngLeechdom_btnDel_actionAdapter(this));
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Clinique",
                "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select * from leechdom", null, true, Load.ALL));
        jdbTable1.setDataSet(queryDataSet1);
        jdbTable1.setEditable(false);
        lch_id.setCaption("编号");
        lch_id.setColumnName("lch_id");
        lch_id.setDataType(com.borland.dx.dataset.Variant.INT);
        lch_id.setExportDisplayMask("");
        lch_id.setRowId(true);
        lch_id.setTableName("leechdom");
        lch_id.setServerColumnName("lch_id");
        lch_id.setSqlType(4);
        name.setCaption("名称");
        name.setColumnName("name");
        name.setDataType(com.borland.dx.dataset.Variant.STRING);
        name.setPrecision(50);
        name.setTableName("leechdom");
        name.setServerColumnName("name");
        name.setSqlType(12);
        factory.setCaption("生产商");
        factory.setColumnName("factory");
        factory.setDataType(com.borland.dx.dataset.Variant.STRING);
        factory.setPrecision(50);
        factory.setTableName("leechdom");
        factory.setServerColumnName("factory");
        factory.setSqlType(12);
        price.setCaption("价格");
        price.setColumnName("price");
        price.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
        price.setPrecision(5);
        price.setScale(2);
        price.setTableName("leechdom");
        price.setServerColumnName("price");
        price.setSqlType(2);
        count.setCaption("库存");
        count.setColumnName("count");
        count.setDataType(com.borland.dx.dataset.Variant.INT);
        count.setTableName("leechdom");
        count.setServerColumnName("COUNT");
        count.setSqlType(4);
        btnExit.setText("关闭");
        jEditorPane1.setBackground(SystemColor.control);
        jEditorPane1.setBorder(titledBorder2);
        jEditorPane1.setEditable(false);

        jEditorPane1.setBounds(new Rectangle(73, 400, 172, 56));
        jLable1.setBounds(new Rectangle(430, 0, 140, 24));
        btnAdd.setBounds(new Rectangle(200, 550, 100, 30));
        btnDel.setBounds(new Rectangle(327, 550, 100, 30));
        btnModify.setBounds(new Rectangle(453, 550, 100, 30));
        btnFresh.setBounds(new Rectangle(579, 550, 100, 30));
        btnExit.setBounds(new Rectangle(700, 550, 100, 30));
        jEditorPane1.setBounds(new Rectangle(30, 525, 950, 76));
        jScrollPane1.setBounds(new Rectangle(30, 30, 950, 490));
        btnExit.setText("关闭");
        btnExit.addActionListener(new MngLeechdom_btnExit_actionAdapter(this));
        jLable1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLable1.setToolTipText("");
        jLable1.setText("药品信息管理");

        this.add(jScrollPane1);
        this.add(btnAdd);
        this.add(btnFresh);
        this.add(btnModify);
        this.add(btnDel);
        this.add(btnExit);
        this.add(jEditorPane1);
        this.add(jLable1);
        jScrollPane1.getViewport().add(jdbTable1);
        queryDataSet1.setColumns(new Column[] {name, factory, price, count,
                                 lch_id});
    }


    public void btnAdd_actionPerformed(ActionEvent e) {
        AddLeechdomInfo ali=new AddLeechdomInfo();
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = ali.getPreferredSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        ali.setLocation((screenSize.width - frameSize.width) / 2,(screenSize.height - frameSize.height) / 2);
        ali.setModal(true);
        ali.setVisible(true);

    }

    public void btnModify_actionPerformed(ActionEvent e) {
        String strID=new String();
        int row=jdbTable1.getSelectedRow();
        if(jdbTable1.getSelectedRow()<0){
            JOptionPane.showMessageDialog(null, "请选择你要修改的数据！", "系统提示", JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        strID=""+jdbTable1.getValueAt(row,0);
        ModifyLeechdomInfo mli=new ModifyLeechdomInfo(strID);
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
       Dimension frameSize = mli.getPreferredSize();
       if (frameSize.height > screenSize.height) {
           frameSize.height = screenSize.height;
       }
       if (frameSize.width > screenSize.width) {
           frameSize.width = screenSize.width;
       }
       mli.setLocation((screenSize.width - frameSize.width) / 2,
                         (screenSize.height - frameSize.height) / 2);
       mli.setModal(true);
       mli.pack();
       mli.setVisible(true);

    }

    public void btnDel_actionPerformed(ActionEvent e) {
        String strID=new String();
        int row=jdbTable1.getSelectedRow();
        if(jdbTable1.getSelectedRow()<0){
          JOptionPane.showMessageDialog(null, "请选择你要删除的数据！", "系统提示", JOptionPane.INFORMATION_MESSAGE);
          return;
        }
        strID=""+jdbTable1.getValueAt(row,0);
        if(JOptionPane.showConfirmDialog(null,"确定要删除所选药品吗？","系统提示",JOptionPane.OK_CANCEL_OPTION)==JOptionPane.OK_OPTION){
            db=new MyDatabase();
            Statement stm=db.getStatement();
            try{
                stm.executeUpdate("DELETE  FROM leechdom WHERE lch_id='" +strID + "'");
                JOptionPane.showMessageDialog(null,"删除成功！","系统提示",JOptionPane.INFORMATION_MESSAGE);
            }catch(SQLException se){
                 JOptionPane.showMessageDialog(null,se.toString(),"系统提示",JOptionPane.INFORMATION_MESSAGE);
            }
        }

    }

    public void btnFresh_actionPerformed(ActionEvent e) {
       queryDataSet1.close();
       queryDataSet1.setQuery(new QueryDescriptor(database1,"select  *  from leechdom",   null,   true,   Load.ALL));
       queryDataSet1.refresh();
       jdbTable1.setDataSet(queryDataSet1);
    }

    public void btnExit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
}


class MngLeechdom_btnExit_actionAdapter implements ActionListener {
    private MngLeechdom adaptee;
    MngLeechdom_btnExit_actionAdapter(MngLeechdom adaptee) {
        this.adaptee = adaptee;
    }

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


class MngLeechdom_btnFresh_actionAdapter implements ActionListener {
    private MngLeechdom adaptee;
    MngLeechdom_btnFresh_actionAdapter(MngLeechdom adaptee) {
        this.adaptee = adaptee;
    }

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


class MngLeechdom_btnDel_actionAdapter implements ActionListener {
    private MngLeechdom adaptee;
    MngLeechdom_btnDel_actionAdapter(MngLeechdom adaptee) {
        this.adaptee = adaptee;
    }

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


class MngLeechdom_btnModify_actionAdapter implements ActionListener {
    private MngLeechdom adaptee;
    MngLeechdom_btnModify_actionAdapter(MngLeechdom adaptee) {
        this.adaptee = adaptee;
    }

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


class MngLeechdom_btnAdd_actionAdapter implements ActionListener {
    private MngLeechdom adaptee;
    MngLeechdom_btnAdd_actionAdapter(MngLeechdom adaptee) {
        this.adaptee = adaptee;
    }

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