searchmanagerinfo.java~58~

医疗管理系统

package cliniquemanager;

import java.awt.BorderLayout;
import java.awt.Frame;

import javax.swing.JDialog;
import javax.swing.JPanel;
import java.awt.Dimension;
import javax.swing.JScrollPane;
import javax.swing.JPopupMenu;
import java.awt.Rectangle;
import javax.swing.JTable;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.table.DefaultTableModel;
import javax.swing.ListSelectionModel;
import javax.swing.JOptionPane;
import javax.swing.event.ListSelectionEvent;
import java.util.Vector;
import java.sql.ResultSet;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

/**
 * <p>Title: CliniqueManager</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: shine</p>
 *
 * @author robin
 * @version 1.0
 */
public class SearchManagerInfo extends JDialog {
    Database db;
    ResultSet rs;
    DefaultTableModel tableModel;
    /*表格列向量*/
    Vector cell;
    /*表格行向量*/
     Vector row = new Vector();
     String sql;

    public SearchManagerInfo(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public SearchManagerInfo() {
        this(new Frame(), "SearchManagerInfo", false);
    }

    private void jbInit() throws Exception {
        this.setSize(new Dimension(800, 600));
        this.setPreferredSize(new Dimension(800, 600));
        this.getContentPane().setLayout(null);
        btnAll.setBounds(new Rectangle(382, 479, 104, 29));
        btnAll.setText("显示全部");
        btnExit.setBounds(new Rectangle(506, 479, 104, 29));
        btnExit.setText("退出");
        btnExit.addActionListener(new SearchManagerInfo_btnExit_actionAdapter(this));
        btnSearch1.setBounds(new Rectangle(128, 479, 104, 29));
        btnSearch1.setText("精确查询");
        btnSearch1.addActionListener(new
                                     SearchManagerInfo_btnSearch1_actionAdapter(this));
        btnSearch2.setBounds(new Rectangle(257, 479, 103, 29));
        btnSearch2.setText("模糊查询");
        jLabel1.setText("提示：若知道管理员的姓名，则输入后点按钮“精确查询”，若只知道姓名中的部分，则输入后点按钮“模糊查询”");
        jLabel1.setBounds(new Rectangle(11, 513, 667, 40));
        tblManager.setCellSelectionEnabled(true);
        txtName.setBounds(new Rectangle(100, 417, 163, 26));
        this.getContentPane().add(btnSearch2);
        this.getContentPane().add(btnExit);
        this.getContentPane().add(btnSearch1);
        this.getContentPane().add(btnAll);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(lblName);
        this.getContentPane().add(txtName);
        lblName.setText("管理员姓名：");
        lblName.setBounds(new Rectangle(15, 414, 74, 30));
        JScrollPane jsp = new JScrollPane(tblManager);
        this.add(jsp);
        jsp.getViewport().add(tblManager);
        jsp.setBounds(new Rectangle(13, 9, 765, 380));

        tableModel = new DefaultTableModel();
        String[] tableHeads = {"用户名", "真实姓名", "电话号码", "Email"};
        Vector tableHeadName = new Vector();
        for (int i = 0; i < tableHeads.length; i++) {
            tableHeadName.add(tableHeads[i]);
        }
        db = new Database();
        tableModel.setDataVector(row, tableHeadName);
        /*表格使用模型*/

        tblManager = new JTable(tableModel) {
            public void valueChanged(ListSelectionEvent e) {
                super.valueChanged(e);
                if (!this.isVisible()) {
                    return;
                }
                ListSelectionModel sm = (ListSelectionModel) e.getSource();
                int row = sm.getLeadSelectionIndex();
                int colCount = this.getColumnCount();
            }
        };
        //设置行的选择模式，一次只能选择一行
        tblManager.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
        // db.close();

        sql="SELECT * FROM manager";
        search(sql);
    }

    JTable tblManager = new JTable();
    JLabel lblName = new JLabel();
    JTextField txtName = new JTextField();
    JButton btnSearch1 = new JButton();
    JButton btnExit = new JButton();
    JButton btnAll = new JButton();
    JButton btnSearch2 = new JButton();
    JLabel jLabel1 = new JLabel();

    public void search(String sql){
        try{
           /*声明表格模型*/
          /* tableModel = new DefaultTableModel();
           String[] tableHeads = {"用户名", "真实姓名", "电话号码", "Email"};
           Vector tableHeadName = new Vector();
           for (int i = 0; i < tableHeads.length; i++) {
               tableHeadName.add(tableHeads[i]);
           }
           db = new Database();*/
          // sql="SELECT * FROM manager";
           rs = db.getResultSet(sql);
           while (rs.next()) {
               cell = new Vector();
               cell.add(rs.getString("username"));
               cell.add(rs.getString("name"));
               cell.add("" + rs.getInt("phone"));
               cell.add(rs.getString("email"));
               row.add(cell);
           }
           /*设置表格模型*/
           //tableModel.setDataVector(row, tableHeadName);
           /*表格使用模型*/

           /*tblManager = new JTable(tableModel) {
               public void valueChanged(ListSelectionEvent e) {
                   super.valueChanged(e);
                   if (!this.isVisible()) {
                       return;
                   }
                   ListSelectionModel sm = (ListSelectionModel) e.getSource();
                   int row = sm.getLeadSelectionIndex();
                   int colCount = this.getColumnCount();
               }
           };
           //设置行的选择模式，一次只能选择一行
           tblManager.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
           JScrollPane jsp = new JScrollPane(tblManager);
           this.add(jsp);
           jsp.setBounds(new Rectangle(13, 9,765, 380));*/
          // db.close();
      }catch(Exception e1){
          JOptionPane.showMessageDialog(null,e1,"系统提示",JOptionPane.ERROR_MESSAGE);
      }

    }

    public void btnExit_actionPerformed(ActionEvent e) {
        if(e.getActionCommand()=="退出"){
            this.dispose();
        }
    }

    public void btnSearch1_actionPerformed(ActionEvent e) {
        sql = "select * from manager";
        search(sql);
        tblManager.repaint();
    }
}


class SearchManagerInfo_btnSearch1_actionAdapter implements ActionListener {
    private SearchManagerInfo adaptee;
    SearchManagerInfo_btnSearch1_actionAdapter(SearchManagerInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class SearchManagerInfo_btnExit_actionAdapter implements ActionListener {
    private SearchManagerInfo adaptee;
    SearchManagerInfo_btnExit_actionAdapter(SearchManagerInfo adaptee) {
        this.adaptee = adaptee;
    }

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