mngreckoning.java~2~

医疗管理系统

package cliniquemanager;

import javax.swing.JPanel;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import javax.swing.JScrollPane;
import java.awt.Rectangle;
import com.borland.dbswing.JdbTable;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Toolkit;
import java.awt.Dimension;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.Font;
import com.borland.dx.dataset.Column;
import javax.swing.border.TitledBorder;


/**
 * <p>Title: CliniqueManager</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: shine</p>
 *
 * @author robin
 * @version 1.0
 */
public class MngReckoning extends JPanel {
    MyDatabase db = new MyDatabase();
    int ID = 0;
    String pname = new String();
    String RID = new String();
    JScrollPane jScrollPane1 = new JScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    JButton jbtnExit = new JButton();
    JButton jbtnDel = new JButton();
    JButton jbtnOK = new JButton();
    Database database1 = new Database();
    JButton jbtnFresh = new JButton();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    Column column11 = new Column();
    Column column12 = new Column();
    Column column13 = new Column();
    Column column14 = new Column();
    Column column15 = new Column();
    Column column16 = new Column();
    Column column17 = new Column();
    Column column18 = new Column();
    TitledBorder titledBorder1 = new TitledBorder("帐单信息");
    TitledBorder titledBorder2 = new TitledBorder("基本操作");
    JLabel jLabel1 = new JLabel();
    JEditorPane jEditorPane1 = new JEditorPane();
    JButton jbtnPrint = new JButton();
    public MngReckoning() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setSize(new Dimension(1000,600));
        jbtnExit.setText("退出");
        jbtnExit.addActionListener(new MngReckoning_jbtnExit_actionAdapter(this));
        jbtnDel.setText("删除");
        jbtnDel.addActionListener(new MngReckoning_jbtnDel_actionAdapter(this));
        jbtnOK.setText("添加");
        jbtnOK.addActionListener(new MngReckoning_jbtnOK_actionAdapter(this));
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Clinique",
                "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
        jdbTable1.addMouseListener(new MngReckoning_jdbTable1_mouseAdapter(this));
        jbtnFresh.setText("刷新");
        jbtnFresh.addActionListener(new MngReckoning_jbtnFresh_actionAdapter(this));
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select * from reckoning", null, true, Load.ALL));
        jdbTable1.setDataSet(queryDataSet1);
        column11.setCaption("帐单编号");
        column11.setColumnName("rckn_id");
        column11.setDataType(com.borland.dx.dataset.Variant.INT);
        column11.setRowId(true);
        column11.setTableName("reckoning");
        column11.setServerColumnName("rckn_id");
        column11.setSqlType(4);
        column12.setCaption("病人编号");
        column12.setColumnName("ptnt_id");
        column12.setDataType(com.borland.dx.dataset.Variant.INT);
        column12.setTableName("reckoning");
        column12.setServerColumnName("ptnt_id");
        column12.setSqlType(4);
        column13.setCaption("病人姓名");
        column13.setColumnName("pname");
        column13.setDataType(com.borland.dx.dataset.Variant.STRING);
        column13.setPrecision(50);
        column13.setTableName("reckoning");
        column13.setServerColumnName("pname");
        column13.setSqlType(12);
        column14.setCaption("医生姓名");
        column14.setColumnName("dname");
        column14.setDataType(com.borland.dx.dataset.Variant.STRING);
        column14.setPrecision(50);
        column14.setTableName("reckoning");
        column14.setServerColumnName("dname");
        column14.setSqlType(12);
        column15.setCaption("消费总价");
        column15.setColumnName("price");
        column15.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
        column15.setTableName("reckoning");
        column15.setServerColumnName("price");
        column15.setSqlType(6);
        column16.setCaption("操作人员");
        column16.setColumnName("mname");
        column16.setDataType(com.borland.dx.dataset.Variant.STRING);
        column16.setPrecision(50);
        column16.setTableName("reckoning");
        column16.setServerColumnName("mname");
        column16.setSqlType(12);
        column17.setCaption("结帐日期");
        column17.setColumnName("date");
        column17.setDataType(com.borland.dx.dataset.Variant.DATE);
        column17.setTableName("reckoning");
        column17.setServerColumnName("date");
        column17.setSqlType(93);
        column18.setCaption("病人用药");
        column18.setColumnName("leechdom");
        column18.setDataType(com.borland.dx.dataset.Variant.STRING);
        column18.setPrecision(100);
        column18.setTableName("reckoning");
        column18.setServerColumnName("leechdom");
        column18.setSqlType(12);
        jScrollPane1.setBorder(titledBorder1);
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel1.setText("帐单信息管理");
        jEditorPane1.setBackground(SystemColor.control);
        jEditorPane1.setEnabled(false);
        jEditorPane1.setBorder(titledBorder2);
        jbtnPrint.setText("打印");
        jbtnPrint.addActionListener(new MngReckoning_jbtnPrint_actionAdapter(this));
        this.add(jScrollPane1, null);
        jScrollPane1.getViewport().add(jdbTable1);

        jLabel1.setBounds(new Rectangle(430, 0, 140, 24));
        jbtnOK.setBounds(new Rectangle(200, 505, 100, 30));
        jbtnDel.setBounds(new Rectangle(327, 505, 100, 30));
        jbtnFresh.setBounds(new Rectangle(453, 505, 100, 30));
        jbtnPrint.setBounds(new Rectangle(579, 505, 100, 30));
        jbtnExit.setBounds(new Rectangle(700, 505, 100, 30));
        jEditorPane1.setBounds(new Rectangle(30, 479, 950, 76));
        jScrollPane1.setBounds(new Rectangle(30, 30, 950, 450));

        this.add(jLabel1);
        this.add(jbtnExit);
        this.add(jbtnDel);
        this.add(jbtnPrint);
        this.add(jbtnFresh);
        this.add(jbtnOK);
        this.add(jEditorPane1);
        queryDataSet1.setColumns(new Column[] {column11, column12, column13,
                                 column14, column18, column15, column16,
                                 column17});
    }
    //为添加按钮添加事件响应，当点击确定后显示新窗体AddReckoningInfo
    public void jbtnOK_actionPerformed(ActionEvent e) {
        AddReckoningInfo ari = new AddReckoningInfo();
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = ari.getPreferredSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        ari.setLocation((screenSize.width - frameSize.width) / 2,
                        (screenSize.height - frameSize.height) / 2);
        ari.setModal(true);
        ari.setVisible(true);
    }
    //为退出按钮添加事件，单击确定后关闭当前窗口
    public void jbtnExit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    //为jdbTable添加事件，当单击其中任何一行，将把当前行的相关信息传递到变量
    public void jdbTable1_mouseClicked(MouseEvent e) {
        ID=jdbTable1.getSelectedRow();
        RID = "" + jdbTable1.getValueAt(ID, 0);
        pname = (String)(jdbTable1.getValueAt(ID,2));
    }
    //为药品删除按钮加事件响应，如果没有选种任何药品就选点此按钮将提示响应信息，否则将选中药品从表和数据库中删除
    public void jbtnDel_actionPerformed(ActionEvent e) {
        if (jdbTable1.getSelectedRow() < 0) {
            JOptionPane.showMessageDialog(null, "请选择你要删除的数据！", "系统提示",
                                          JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        if (JOptionPane.showConfirmDialog(null, "确定要删除帐单" + RID + "吗？",
                                          "系统提示", JOptionPane.OK_CANCEL_OPTION) ==
            JOptionPane.OK_OPTION) {
            Statement stm = db.getStatement();
            try {
                stm.executeUpdate("DELETE  FROM reckoning WHERE rckn_id='" +
                                  RID + "'");
                JOptionPane.showMessageDialog(null, "删除成功！", "系统提示",
                                              JOptionPane.INFORMATION_MESSAGE);
            } catch (SQLException se) {
                JOptionPane.showMessageDialog(null, se.toString(), "系统提示",
                                              JOptionPane.INFORMATION_MESSAGE);
            }
        }
    }
    //为刷新按钮添加事件响应，点击此按钮将重新从数据库读出数据
    public void jbtnFresh_actionPerformed(ActionEvent e) {
        queryDataSet1.close();
        queryDataSet1.setQuery(new QueryDescriptor(database1,"select  *  from reckoning",   null,   true,   Load.ALL));
        queryDataSet1.refresh();
        jdbTable1.setDataSet(queryDataSet1);
    }

    public void jbtnPrint_actionPerformed(ActionEvent e) {
        if (jdbTable1.getSelectedRow() < 0) {
            JOptionPane.showMessageDialog(null, "请选择你要打印的帐单！", "系统提示",
                                          JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        PrintReckoningInfo pri = new PrintReckoningInfo(RID);
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = pri.getPreferredSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        pri.setLocation((screenSize.width - frameSize.width) / 2,
                        (screenSize.height - frameSize.height) / 2);
        pri.setModal(true);
        pri.pack();
        pri.setVisible(true);
}
}

class MngReckoning_jbtnPrint_actionAdapter implements ActionListener {
    private MngReckoning adaptee;
    MngReckoning_jbtnPrint_actionAdapter(MngReckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class MngReckoning_jbtnFresh_actionAdapter implements ActionListener {
    private MngReckoning adaptee;
    MngReckoning_jbtnFresh_actionAdapter(MngReckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class MngReckoning_jdbTable1_mouseAdapter extends MouseAdapter {
    private MngReckoning adaptee;
    MngReckoning_jdbTable1_mouseAdapter(MngReckoning adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jdbTable1_mouseClicked(e);
    }
}


class MngReckoning_jbtnDel_actionAdapter implements ActionListener {
    private MngReckoning adaptee;
    MngReckoning_jbtnDel_actionAdapter(MngReckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class MngReckoning_jbtnExit_actionAdapter implements ActionListener {
    private MngReckoning adaptee;
    MngReckoning_jbtnExit_actionAdapter(MngReckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class MngReckoning_jbtnOK_actionAdapter implements ActionListener {
    private MngReckoning adaptee;
    MngReckoning_jbtnOK_actionAdapter(MngReckoning adaptee) {
        this.adaptee = adaptee;
    }

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