srchdoctorinfo.java~15~

医疗管理系统

package cliniquemanager;

import java.awt.BorderLayout;

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 javax.swing.JScrollPane;
import com.borland.dbswing.JdbTable;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.awt.GridLayout;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.dataset.Column;
import java.awt.Dimension;
import java.awt.Font;
import javax.swing.JOptionPane;
import javax.swing.JComboBox;

/**
 * <p>Title: CliniqueManager</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: shine</p>
 *
 * @author robin
 * @version 1.0
 */
public class SrchDoctorInfo extends JPanel {
    BorderLayout borderLayout1 = new BorderLayout();
    Database database1 = new Database();
    JPanel pnlButton = new JPanel();
    JPanel pnlInfo = new JPanel();
    JPanel pnlSouth = new JPanel();
    JPanel pnlNorth = new JPanel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JdbTable dbtblDoctor = new JdbTable();
    JButton btnExit = new JButton();
    JButton btnAll = new JButton();
    JButton btnSearch2 = new JButton();
    JButton btnSearch1 = new JButton();
    JLabel lblName = new JLabel();
    JTextField txtName = new JTextField();
    QueryDataSet rsSearchDoctor = new QueryDataSet();
    JLabel lblTip = new JLabel();
    GridLayout gridLayout3 = new GridLayout();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    GridLayout gridLayout1 = new GridLayout();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel lblTop = new JLabel();
    String sql;
    String tsql="select username as '用户名',name as '真实姓名',profession as '专业',phone as '电话',email as '邮箱' from doctor ";
    JLabel jLabel1 = new JLabel();
    JComboBox cmbProfession = new JComboBox();
    GridLayout gridLayout2 = new GridLayout();
    JLabel lblProfession = new JLabel();
    public SrchDoctorInfo() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        Dimension dimen = new Dimension(90,30);
        this.setLayout(borderLayout1);
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Clinique",
                "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
        btnExit.setText("退      出");
        btnExit.addActionListener(new SrchDoctorInfo_btnExit_actionAdapter(this));
        btnAll.setText("全部显示");
        btnAll.addActionListener(new SrchDoctorInfo_btnAll_actionAdapter(this));
        btnSearch2.setText("模糊查找");
        btnSearch2.addActionListener(new
                                     SrchDoctorInfo_btnSearch2_actionAdapter(this));
        btnSearch1.setText("精确查找");
        btnSearch1.addActionListener(new
                                     SrchDoctorInfo_btnSearch1_actionAdapter(this));
        lblName.setToolTipText("");
        lblName.setText("医生姓名：");
        pnlSouth.setLayout(gridLayout1);
        pnlInfo.setLayout(gridLayout2);
        search(tsql);
        lblTip.setToolTipText("");
        lblTip.setText("提示：若知道医生姓名或专业，则输入后点按钮“精确查询”，若只知道其中的部分，则输入后点按钮“模糊查询”");
        pnlButton.setLayout(gridLayout3);
        gridLayout3.setColumns(6);
        gridLayout1.setColumns(1);
        gridLayout1.setRows(8);
        lblTop.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        lblTop.setText("医生信息查询");

        cmbProfession.setToolTipText("");
        cmbProfession.addItem("内科");
        cmbProfession.addItem("外科");
        cmbProfession.addItem("妇科");
        cmbProfession.addItem("儿科");
        cmbProfession.addItem("牙科");
        cmbProfession.addItem("骨科");
        cmbProfession.addItem("精神科");
        cmbProfession.setSelectedItem(null);
        lblProfession.setText("医生专业：");
        rsSearchDoctor.setReadOnly(true);

        pnlButton.add(jLabel3);
        pnlButton.add(btnSearch1);
        pnlButton.add(btnSearch2);
        pnlButton.add(btnAll);
        pnlButton.add(btnExit);
        pnlButton.add(jLabel4);
        pnlSouth.add(jLabel6);

        this.add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jScrollPane1.getViewport().add(dbtblDoctor);
        pnlInfo.add(lblName);
        pnlInfo.add(txtName);
        pnlInfo.add(jLabel1);
        pnlInfo.add(lblProfession);
        pnlInfo.add(cmbProfession);
        pnlSouth.add(pnlInfo, null);
        pnlSouth.add(jLabel5);
        pnlSouth.add(pnlButton, null);
        pnlSouth.add(jLabel7);
        pnlSouth.add(lblTip, null);

        pnlNorth.add(lblTop);
        this.add(pnlSouth, java.awt.BorderLayout.SOUTH);
        this.add(pnlNorth, java.awt.BorderLayout.NORTH);
    }

    public void search(String sql){
        rsSearchDoctor.closeStatement();
        rsSearchDoctor.setQuery(new QueryDescriptor(database1,
                sql, null, true,
                Load.ALL));
        dbtblDoctor.setDataSet(rsSearchDoctor);
        rsSearchDoctor.refresh();
    }

    public void btnSearch1_actionPerformed(ActionEvent e) {
        if (txtName.getText().equals("") && cmbProfession.getSelectedItem()==null) {
            JOptionPane.showMessageDialog(null, "请输入查询信息");
            return;
        }
        if(txtName.getText().equals(""))
            sql = tsql + "where profession='" + cmbProfession.getSelectedItem() + "'";
        else if(cmbProfession.getSelectedItem().equals(""))
            sql = tsql + "where name='" + txtName.getText() + "'";
        else
            sql = tsql + "where name='" + txtName.getText() + "'and profession='" + cmbProfession.getSelectedItem() + "'";
        search(sql);
        txtName.setText("");
        cmbProfession.setSelectedItem(null);
    }

    public void btnSearch2_actionPerformed(ActionEvent e) {
        if (txtName.getText().equals("") && cmbProfession.getSelectedItem()==null) {
            JOptionPane.showMessageDialog(null, "请输入查询信息");
            return;
        }
        if(txtName.getText().equals(""))
            sql = tsql + "where profession like '%" + cmbProfession.getSelectedItem() + "%'";
        else if(cmbProfession.getSelectedItem().equals(""))
            sql = tsql + "where name like '%" + txtName.getText() + "%'";
        else
            sql = tsql + "where name like '%" + txtName.getText() + "%'and profession like '%" + cmbProfession.getSelectedItem() + "%'";
        search(sql);
        txtName.setText("");
        cmbProfession.setSelectedItem(null);
    }

    public void btnAll_actionPerformed(ActionEvent e) {
        search(tsql);
    }

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

}


class SrchDoctorInfo_btnExit_actionAdapter implements ActionListener {
    private SrchDoctorInfo adaptee;
    SrchDoctorInfo_btnExit_actionAdapter(SrchDoctorInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class SrchDoctorInfo_btnAll_actionAdapter implements ActionListener {
    private SrchDoctorInfo adaptee;
    SrchDoctorInfo_btnAll_actionAdapter(SrchDoctorInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class SrchDoctorInfo_btnSearch2_actionAdapter implements ActionListener {
    private SrchDoctorInfo adaptee;
    SrchDoctorInfo_btnSearch2_actionAdapter(SrchDoctorInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class SrchDoctorInfo_btnSearch1_actionAdapter implements ActionListener {
    private SrchDoctorInfo adaptee;
    SrchDoctorInfo_btnSearch1_actionAdapter(SrchDoctorInfo adaptee) {
        this.adaptee = adaptee;
    }

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