mngmanager.java~177~

医疗管理系统

package cliniquemanager;

import java.awt.*;
import javax.swing.table.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.event.*;

/**
 * <p>Title: CliniqueManager</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: shine</p>
 *
 * @author robin
 * @version 1.0
 */
public class MngManager extends JDialog {
    JTable jTable1 ;
    Database db;
    ResultSet rs;
    DefaultTableModel tableModel;
    JButton jButton1 = new JButton("添加");
    JButton jButton2 = new JButton("修改");
    JButton jButton3 = new JButton("删除");
    JButton jButton4 = new JButton("刷新");
    String strUsername=new String();//保存要修改的管理员的用户名
    public MngManager(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    public MngManager() {
         this(new Frame(), "管理管理员信息", false);
     }


    private void jbInit() throws Exception {
         try{
        /*表格列向量*/
        Vector cell ;
        /*表格行向量*/
        Vector row = new Vector();
        /*声明表格模型*/
        tableModel = new DefaultTableModel();
        String[] tableHeads = {"用户名","真实姓名", "电话号码", "Email"};
        Vector tableHeadName = new Vector();
        for (int i = 0; i < tableHeads.length; i++) {
            tableHeadName.add(tableHeads[i]);
       }
        this.setLayout(new BorderLayout());
        this.setPreferredSize(new Dimension(800, 600));
        db=new Database();
        rs=db.getResultSet("SELECT * FROM manager");
        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);
        /*表格使用模型*/

       jTable1 = 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();
                //String[] sa = new String[colCount];
                for (int col=0; col<colCount; col++) {
                    strUsername=(String)(this.getValueAt(row,0));
                   // sa[col] = (String)this.getValueAt(row, col);
                }
               // String s = "";
               // for (int i=0; i<sa.length; i++) {
                //    s += sa[i] + "\t";
               // }
            }
       };
       //设置行的选择模式，一次只能选择一行
        jTable1.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
      //  jTable1.setBounds(50,50,500,400);
         JScrollPane jsp=new JScrollPane(jTable1);
        this.add(jsp,BorderLayout.CENTER );
        db.close();
        }catch(Exception e){
            JOptionPane.showMessageDialog(null,e,"系统提示",JOptionPane.ERROR_MESSAGE);
        }
        ///jButton1.setBounds(new Rectangle(270, 461, 90, 30));
        jButton1.addActionListener(new MngManager_jButton1_actionAdapter(this));
        //jButton2.setBounds(new Rectangle(380, 461, 90, 30));
        jButton2.addActionListener(new MngManager_jButton2_actionAdapter(this));
        //jButton3.setBounds(new Rectangle(490, 461, 90, 30));
        jButton3.addActionListener(new MngManager_jButton3_actionAdapter(this));
        JPanel pnlButton=new JPanel();
        pnlButton.setLayout(new FlowLayout());
        jButton4.addActionListener(new MngManager_jButton4_actionAdapter(this));
        pnlButton.add(jButton1);
        pnlButton.add(jButton2);
        pnlButton.add(jButton3);
        pnlButton.add(jButton4);
        this.add(pnlButton,BorderLayout.SOUTH);
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        AddManagerInfo ami=new AddManagerInfo();
        //ami.setSize(new Dimension(350, 400));
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
       Dimension frameSize = ami.getPreferredSize();
       if (frameSize.height > screenSize.height) {
           frameSize.height = screenSize.height;
       }
       if (frameSize.width > screenSize.width) {
           frameSize.width = screenSize.width;
       }
       ami.setLocation((screenSize.width - frameSize.width) / 2,
                         (screenSize.height - frameSize.height) / 2);
       ami.setModal(true);
       ami.pack();
        ami.setVisible(true);
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        if(jTable1.getSelectedRow()<0){
            JOptionPane.showMessageDialog(null, "请选择你要修改的数据！", "系统提示", JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        ModifyManagerInfo mmi=new ModifyManagerInfo(strUsername);
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
       Dimension frameSize = mmi.getPreferredSize();
       if (frameSize.height > screenSize.height) {
           frameSize.height = screenSize.height;
       }
       if (frameSize.width > screenSize.width) {
           frameSize.width = screenSize.width;
       }
       mmi.setLocation((screenSize.width - frameSize.width) / 2,
                         (screenSize.height - frameSize.height) / 2);
       mmi.setModal(true);
       mmi.pack();
        mmi.setVisible(true);
    }

    public void jButton3_actionPerformed(ActionEvent e) {
        if(jTable1.getSelectedRow()<0){
          JOptionPane.showMessageDialog(null, "请选择你要删除的数据！", "系统提示", JOptionPane.INFORMATION_MESSAGE);
          return;
        }
        if(JOptionPane.showConfirmDialog(null,"确定要删除用户"+strUsername+"吗？","系统提示",JOptionPane.OK_CANCEL_OPTION)==JOptionPane.OK_OPTION){
            db=new Database();
            Statement stm=db.getStatement();
            try{
                stm.executeUpdate("DELETE  FROM manager WHERE username='" +strUsername + "'");
                JOptionPane.showMessageDialog(null,"删除成功！","系统提示",JOptionPane.INFORMATION_MESSAGE);
            }catch(SQLException se){
                 JOptionPane.showMessageDialog(null,se.toString(),"系统提示",JOptionPane.INFORMATION_MESSAGE);
            }
        }

    }

    public void jButton4_actionPerformed(ActionEvent e) {
        tableModel.fireTableDataChanged();
        //jTable1.repaint();
        //jTable1.updateUI();
       // this.validate();
    }
}


class MngManager_jButton4_actionAdapter implements ActionListener {
    private MngManager adaptee;
    MngManager_jButton4_actionAdapter(MngManager adaptee) {
        this.adaptee = adaptee;
    }

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


class MngManager_jButton3_actionAdapter implements ActionListener {
    private MngManager adaptee;
    MngManager_jButton3_actionAdapter(MngManager adaptee) {
        this.adaptee = adaptee;
    }

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


class MngManager_jButton1_actionAdapter implements ActionListener {
    private MngManager adaptee;
    MngManager_jButton1_actionAdapter(MngManager adaptee) {
        this.adaptee = adaptee;
    }

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


class MngManager_jButton2_actionAdapter implements ActionListener {
    private MngManager adaptee;
    MngManager_jButton2_actionAdapter(MngManager adaptee) {
        this.adaptee = adaptee;
    }

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