mngmanager.java~186~

医疗管理系统

package cliniquemanager;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dbswing.JdbTable;
import javax.swing.border.TitledBorder;
import java.awt.Rectangle;
import com.borland.dx.dataset.Column;
import java.awt.Font;


/**
 * <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 JPanel {
    MyDatabase db;
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    JScrollPane jsp = new JScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    JButton btnAdd = new JButton();
    JButton btnModify = new JButton();
    JButton btnDel = new JButton();
    JButton btnFresh = new JButton();
    TitledBorder titledBorder1 = new TitledBorder("管理员信息");
    Column username = new Column();
    Column name = new Column();
    Column phone = new Column();
    Column email = new Column();
    JLabel jLabel1 = new JLabel();
    JEditorPane jEditorPane1 = new JEditorPane();
    TitledBorder titledBorder2 = new TitledBorder("基本操作");
    JButton btnExit = new JButton();
    public MngManager() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(SystemColor.control);
        this.setBorder(null);
       // this.setPreferredSize(new Dimension(800, 600));
        this.setSize(new Dimension(1000, 600));
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Clinique",
                "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
        database1.setDatabaseName("");

        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "SELECT username,name,phone,email FROM manager", null, true,
                Load.ALL));
        jsp.getViewport().setBackground(SystemColor.control);
        jsp.setBorder(titledBorder1);
        jdbTable1.setDataSet(queryDataSet1);
        queryDataSet1.close();
        jdbTable1.setEditable(false);
        btnAdd.setText("添加");
        btnAdd.addActionListener(new MngManager_btnAdd_actionAdapter(this));
        btnModify.setText("修改");
        btnModify.addActionListener(new MngManager_btnModify_actionAdapter(this));
        btnDel.setText("删除");
        btnDel.addActionListener(new MngManager_btnDel_actionAdapter(this));
        btnFresh.setText("刷新");
        btnFresh.addActionListener(new MngManager_btnFresh_actionAdapter(this));
        btnExit.setText("关闭");
        btnExit.addActionListener(new MngManager_btnExit_actionAdapter(this));
        username.setCaption("用户名");
        username.setColumnName("username");
        username.setDataType(com.borland.dx.dataset.Variant.STRING);
        username.setPrecision(20);
        username.setRowId(true);
        username.setTableName("manager");
        username.setServerColumnName("USERNAME");
        username.setSqlType(12);
        name.setCaption("真实姓名");
        name.setColumnName("name");
        name.setDataType(com.borland.dx.dataset.Variant.STRING);
        name.setPrecision(50);
        name.setTableName("manager");
        name.setServerColumnName("NAME");
        name.setSqlType(12);
        phone.setCaption("电话号码");
        phone.setColumnName("phone");
        phone.setDataType(com.borland.dx.dataset.Variant.INT);
        phone.setTableName("manager");
        phone.setServerColumnName("PHONE");
        phone.setSqlType(4);
        email.setCaption("Email");
        email.setColumnName("email");
        email.setDataType(com.borland.dx.dataset.Variant.STRING);
        email.setPrecision(50);
        email.setTableName("manager");
        email.setServerColumnName("EMAIL");
        email.setSqlType(12);
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel1.setText("管理员信息管理");
        jEditorPane1.setBackground(SystemColor.control);
        jEditorPane1.setBorder(titledBorder2);
        jEditorPane1.setEditable(false);

        jLabel1.setBounds(new Rectangle(430, 0, 140, 24));
        btnAdd.setBounds(new Rectangle(200, 505, 100, 30));
        btnDel.setBounds(new Rectangle(327, 505, 100, 30));
        btnModify.setBounds(new Rectangle(453, 505, 100, 30));
        btnFresh.setBounds(new Rectangle(579, 505, 100, 30));
        btnExit.setBounds(new Rectangle(700, 505, 100, 30));
        jEditorPane1.setBounds(new Rectangle(30, 479, 950, 76));
        jsp.setBounds(new Rectangle(30, 30, 950, 450));

        this.add(jsp);
        this.add(btnFresh);
        this.add(btnDel);
        this.add(btnModify);
        this.add(btnAdd);
        this.add(jLabel1);
        this.add(btnExit);
        this.add(jEditorPane1);
        jsp.getViewport().add(jdbTable1);
        queryDataSet1.setColumns(new Column[] {username, name, phone, email});
    }

    public void btnAdd_actionPerformed(ActionEvent e) {
        AddManagerInfo ami=new AddManagerInfo();
       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 btnModify_actionPerformed(ActionEvent e) {
        String strUsername=new String();
        int row=jdbTable1.getSelectedRow();
        if(row<0){
            JOptionPane.showMessageDialog(null, "请选择你要修改的数据！", "系统提示", JOptionPane.INFORMATION_MESSAGE);
            return;
        }
        strUsername=""+jdbTable1.getValueAt(row,0);
        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 btnDel_actionPerformed(ActionEvent e) {
        String strUsername=new String();
        int row=jdbTable1.getSelectedRow();
        if(jdbTable1.getSelectedRow()<0){
         JOptionPane.showMessageDialog(null, "请选择你要删除的数据！", "系统提示", JOptionPane.INFORMATION_MESSAGE);
         return;
       }
       strUsername=""+jdbTable1.getValueAt(row,0);
       if(JOptionPane.showConfirmDialog(null,"确定要删除用户"+strUsername+"吗？","系统提示",JOptionPane.OK_CANCEL_OPTION)==JOptionPane.OK_OPTION){
           db=new MyDatabase();
           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 btnFresh_actionPerformed(ActionEvent e) {
        queryDataSet1.close();
        queryDataSet1.setQuery(new QueryDescriptor(database1,"select  *  from manager",   null,   true,   Load.ALL));
        queryDataSet1.refresh();
        jdbTable1.setDataSet(queryDataSet1);
    }

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


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

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


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

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


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

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


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

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


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

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


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

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