searchmanagerinfo.java~94~

医疗管理系统

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;
import javax.swing.JScrollBar;
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 SearchManagerInfo extends JDialog {
    Database db;
    ResultSet rs;
    DefaultTableModel tableModel;
    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.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));
        lblName.setText("管理员姓名：");
        lblName.setBounds(new Rectangle(15, 414, 74, 30)); //db.close();
        this.add(btnSearch2);
        this.add(btnExit);
        this.add(btnSearch1);
        this.add(btnAll);
        this.add(jLabel1);
        this.add(lblName);
        this.add(txtName);
    }

    JTable tblManager ;
    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();
    JScrollPane jsp ;

    public void search(String sql){
        Vector cell;
        Vector row=new Vector();
        tableModel = new DefaultTableModel();
        tableModel = new DefaultTableModel();
        db=new Database();
        try{

         String[] tableHeads = {"用户名","真实姓名", "电话号码", "Email"};
         Vector tableHeadName = new Vector();
         for (int i = 0; i < tableHeads.length; i++) {
             tableHeadName.add(tableHeads[i]);
        }

         db=new Database();
         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);
        //设置行的选择模式，一次只能选择一行
         tblManager.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
         jsp=new JScrollPane(tblManager);
         jsp.setBounds(new Rectangle(8, 5, 766, 395));
         this.add(jsp);
         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);
    }
}