mngpatient.java~3~

医疗管理系统

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 MngPatient extends JPanel {
    MyDatabase db = new MyDatabase();
    int ID=0;
    String PID=new String();
    String PName = new String();
    String doctorname= new String();
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    JScrollPane jScrollPane1 = new JScrollPane();
    JdbTable jdbPatient = new JdbTable();
    JButton jbtnExit = new JButton();
    JButton jbtnDel = new JButton();
    JButton jbtnModify = new JButton();
    JButton jbtnAdd = new JButton();
    JButton jbtnFresh = new JButton();
    Column column1 = new Column();
    Column column2 = new Column();
    Column column3 = new Column();
    Column column4 = new Column();
    Column column5 = new Column();
    Column column6 = new Column();
    Column column7 = new Column();
    Column column8 = new Column();
    Column column9 = new Column();
    Column column10 = new Column();
    JEditorPane jEditorPane1 = new JEditorPane();
    TitledBorder titledBorder1 = new TitledBorder("基本操作");
    TitledBorder titledBorder2 = new TitledBorder("病人信息");
    JLabel jLabel1 = new JLabel();
    Column column11 = new Column();
    public MngPatient() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setSize(new Dimension(1000, 600));
        doctorname =MyDatabase.username;
        this.setLayout(null);
        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 patient", null, true, Load.ALL));
        jbtnExit.setText("退出");
        jbtnExit.addActionListener(new MngPatient_jbtnExit_actionAdapter(this));
        jbtnDel.setText("删除");
        jbtnDel.addActionListener(new MngPatient_jbtnDel_actionAdapter(this));
        jbtnModify.setText("修改");
        jbtnModify.addActionListener(new MngPatient_jbtnModify_actionAdapter(this));
        jbtnAdd.setText("添加");
        jbtnAdd.addActionListener(new MngPatient_jbtnAdd_actionAdapter(this));
        jdbPatient.setDataSet(queryDataSet1);
        jdbPatient.addMouseListener(new MngPatient_jdbPatient_mouseAdapter(this));
        jbtnFresh.setText("刷新");
        jbtnFresh.addActionListener(new MngPatient_jbtnFresh_actionAdapter(this));
        column1.setColumnName("ptnt_id");
        column1.setDataType(com.borland.dx.dataset.Variant.INT);
        column1.setRowId(true);
        column1.setTableName("patient");
        column1.setServerColumnName("ptnt_id");
        column1.setSqlType(4);
        column2.setCaption("病人编号");
        column2.setColumnName("ptnt_id");
        column2.setDataType(com.borland.dx.dataset.Variant.INT);
        column2.setRowId(true);
        column2.setTableName("patient");
        column2.setServerColumnName("ptnt_id");
        column2.setSqlType(4);
        column3.setCaption("病人姓名");
        column3.setColumnName("name");
        column3.setDataType(com.borland.dx.dataset.Variant.STRING);
        column3.setPrecision(50);
        column3.setTableName("patient");
        column3.setServerColumnName("name");
        column3.setSqlType(12);
        column4.setCaption("主治医生");
        column4.setColumnName("dname");
        column4.setDataType(com.borland.dx.dataset.Variant.STRING);
        column4.setPrecision(50);
        column4.setTableName("patient");
        column4.setServerColumnName("dname");
        column4.setSqlType(12);
        column5.setCaption("病人性别");
        column5.setColumnName("sex");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        column5.setPrecision(2);
        column5.setTableName("patient");
        column5.setServerColumnName("sex");
        column5.setSqlType(1);
        column6.setCaption("出生日期");
        column6.setColumnName("birth");
        column6.setDataType(com.borland.dx.dataset.Variant.DATE);
        column6.setTableName("patient");
        column6.setServerColumnName("birth");
        column6.setSqlType(93);
        column7.setCaption("病人血型");
        column7.setColumnName("blood");
        column7.setDataType(com.borland.dx.dataset.Variant.STRING);
        column7.setPrecision(2);
        column7.setTableName("patient");
        column7.setServerColumnName("blood");
        column7.setSqlType(12);
        column8.setCaption("病人身高");
        column8.setColumnName("height");
        column8.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
        column8.setTableName("patient");
        column8.setServerColumnName("height");
        column8.setSqlType(6);
        column9.setCaption("病人体重");
        column9.setColumnName("weight");
        column9.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
        column9.setTableName("patient");
        column9.setServerColumnName("weight");
        column9.setSqlType(6);
        column10.setCaption("病人用药");
        column10.setColumnName("leechdom");
        column10.setDataType(com.borland.dx.dataset.Variant.STRING);
        column10.setPrecision(100);
        column10.setTableName("patient");
        column10.setServerColumnName("leechdom");
        column10.setSqlType(12);
        jScrollPane1.setBorder(titledBorder2);
        jEditorPane1.setBackground(SystemColor.control);
        jEditorPane1.setEnabled(false);
        jEditorPane1.setBorder(titledBorder1);
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel1.setText("病人信息管理");
        column11.setCaption("消费总价");
        column11.setColumnName("price");
        column11.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
        column11.setTableName("patient");
        column11.setServerColumnName("price");
        column11.setSqlType(6);
        this.add(jScrollPane1, null);
        jScrollPane1.getViewport().add(jdbPatient);

        jLabel1.setBounds(new Rectangle(430, 0, 140, 24));
        jbtnAdd.setBounds(new Rectangle(200, 550, 100, 30));
        jbtnDel.setBounds(new Rectangle(327, 550, 100, 30));
        jbtnFresh.setBounds(new Rectangle(453, 550, 100, 30));
        jbtnModify.setBounds(new Rectangle(579, 550, 100, 30));
        jbtnExit.setBounds(new Rectangle(700, 550, 100, 30));
        jEditorPane1.setBounds(new Rectangle(30, 525, 950, 76));
        jScrollPane1.setBounds(new Rectangle(30, 30, 950, 490));

        this.add(jbtnModify);
        this.add(jbtnAdd);
        this.add(jbtnExit);
        this.add(jLabel1);
        this.add(jbtnFresh);
        this.add(jbtnDel);
        this.add(jEditorPane1);
        queryDataSet1.setColumns(new Column[] {column2, column3, column4,
                                 column5, column6, column7, column8, column9,
                                 column10, column11});
    }
//为添加按钮添加事件响应，当点击确定后显示新窗体AddPatientInfo
    public void jbtnAdd_actionPerformed(ActionEvent e) {
        AddPatientInfo adi = new AddPatientInfo(doctorname);
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = adi.getPreferredSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        adi.setLocation((screenSize.width - frameSize.width) / 2,
                        (screenSize.height - frameSize.height) / 2);
        adi.setModal(true);
        adi.setVisible(true);

    }
//为退出按钮添加事件，单击确定后关闭当前窗口
    public void jbtnExit_actionPerformed(ActionEvent e) {
         this.setVisible(false);
    }
//为修改按钮添加事件，点击修改过后，显示新窗口ModifyPatientInfo
    public void jbtnModify_actionPerformed(ActionEvent e) {
        if (jdbPatient.getSelectedRow() < 0) {
            JOptionPane.showMessageDialog(null, "请选择你要修改的数据！", "系统提示",
                                          JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        ModifyPatientInfo mpi = new ModifyPatientInfo(PID);
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = mpi.getPreferredSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        mpi.setLocation((screenSize.width - frameSize.width) / 2,
                        (screenSize.height - frameSize.height) / 2);
        mpi.setModal(true);
        mpi.pack();
        mpi.setVisible(true);
    }
//为jdbTable添加事件，当单击其中任何一行，将把当前行的相关信息传递到变量
    public void jdbPatient_mouseClicked(MouseEvent e) {
        ID=jdbPatient.getSelectedRow();
        PID = ""+jdbPatient.getValueAt(ID, 0);
        PName = (String)(jdbPatient.getValueAt(ID,1));
    }
//为药品删除按钮加事件响应，如果没有选种任何药品就选点此按钮将提示响应信息，否则将选中药品从表和数据库中删除
    public void jbtnDel_actionPerformed(ActionEvent e) {
        if (jdbPatient.getSelectedRow() < 0) {
            JOptionPane.showMessageDialog(null, "请选择你要删除的数据！", "系统提示",
                                          JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        if (JOptionPane.showConfirmDialog(null, "确定要删除用户" + PName + "吗？",
                                          "系统提示", JOptionPane.OK_CANCEL_OPTION) ==
            JOptionPane.OK_OPTION) {
            Statement stm = db.getStatement();
            try {
                stm.executeUpdate("DELETE  FROM patient WHERE ptnt_id='" +
                                  PID + "'");
                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 patient",   null,   true,   Load.ALL));
        queryDataSet1.refresh();
        jdbPatient.setDataSet(queryDataSet1);
    }
}


class MngPatient_jbtnFresh_actionAdapter implements ActionListener {
    private MngPatient adaptee;
    MngPatient_jbtnFresh_actionAdapter(MngPatient adaptee) {
        this.adaptee = adaptee;
    }

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


class MngPatient_jdbPatient_mouseAdapter extends MouseAdapter {
    private MngPatient adaptee;
    MngPatient_jdbPatient_mouseAdapter(MngPatient adaptee) {
        this.adaptee = adaptee;
    }

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


class MngPatient_jbtnDel_actionAdapter implements ActionListener {
    private MngPatient adaptee;
    MngPatient_jbtnDel_actionAdapter(MngPatient adaptee) {
        this.adaptee = adaptee;
    }

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


class MngPatient_jbtnModify_actionAdapter implements ActionListener {
    private MngPatient adaptee;
    MngPatient_jbtnModify_actionAdapter(MngPatient adaptee) {
        this.adaptee = adaptee;
    }

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


class MngPatient_jbtnExit_actionAdapter implements ActionListener {
    private MngPatient adaptee;
    MngPatient_jbtnExit_actionAdapter(MngPatient adaptee) {
        this.adaptee = adaptee;
    }

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


class MngPatient_jbtnAdd_actionAdapter implements ActionListener {
    private MngPatient adaptee;
    MngPatient_jbtnAdd_actionAdapter(MngPatient adaptee) {
        this.adaptee = adaptee;
    }

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