mngdoctor.java

医疗管理系统

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 com.borland.dx.dataset.Column;
import java.awt.Rectangle;
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 MngDoctor extends JPanel {
    JScrollPane jScrollPane1 = new JScrollPane();
    Database database1 = new Database();
    MyDatabase db;
     JdbTable jdbTable1 = new JdbTable();
    TitledBorder titledBorder1 = new TitledBorder("医生信息");
    JButton btnAdd = new JButton();
    JButton btnModify = new JButton();
    JButton btnDel = new JButton();
    JButton btnFresh = new JButton();
    Column username = new Column();
    Column email = new Column();
    Column password = new Column();
    Column profession = new Column();
    Column phone = new Column();
    Column name = new Column();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    Column column1 = new Column();
    Column column2 = new Column();
    Column column3 = new Column();
    Column column4 = new Column();
    Column column5 = new Column();
    JLabel jLabel1 = new JLabel();
    JEditorPane jEditorPane1 = new JEditorPane();
    TitledBorder titledBorder2 = new TitledBorder("基本操作");
    JButton btnExit = new JButton();
    public MngDoctor() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setSize(new Dimension(1000, 600));
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Clinique",
                "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
        jScrollPane1.setBorder(titledBorder1);
        btnAdd.setText("添加");
        btnAdd.addActionListener(new MngDoctor_btnAdd_actionAdapter(this));
        btnModify.setText("修改");
        btnModify.addActionListener(new MngDoctor_btnModify_actionAdapter(this));
        btnDel.setText("删除");
        btnDel.addActionListener(new MngDoctor_btnDel_actionAdapter(this));
        btnFresh.setText("刷新");
        btnFresh.addActionListener(new MngDoctor_btnFresh_actionAdapter(this));
        username.setCaption("用户名");
        username.setColumnName("username");
        username.setDataType(com.borland.dx.dataset.Variant.STRING);
        username.setPrecision(20);
        username.setRowId(true);
        username.setTableName("doctor");
        username.setServerColumnName("USERNAME");
        username.setSqlType(12);
        email.setCaption("Email");
        email.setColumnName("email");
        email.setDataType(com.borland.dx.dataset.Variant.STRING);
        email.setMin("");
        email.setPrecision(50);
        email.setTableName("doctor");
        email.setServerColumnName("EMAIL");
        email.setSqlType(12);
        password.setCaption("密码");
        password.setColumnName("password");
        password.setDataType(com.borland.dx.dataset.Variant.STRING);
        password.setPrecision(50);
        password.setTableName("doctor");
        password.setServerColumnName("PASSWORD");
        password.setSqlType(12);
        profession.setCaption("专业");
        profession.setColumnName("profession");
        profession.setDataType(com.borland.dx.dataset.Variant.STRING);
        profession.setPrecision(20);
        profession.setTableName("doctor");
        profession.setServerColumnName("PROFESSION");
        profession.setSqlType(12);
        phone.setCaption("电话号码");
        phone.setColumnName("phone");
        phone.setDataType(com.borland.dx.dataset.Variant.INT);
        phone.setTableName("doctor");
        phone.setServerColumnName("PHONE");
        phone.setSqlType(4);
        name.setCaption("真实姓名");
        name.setColumnName("name");
        name.setDataType(com.borland.dx.dataset.Variant.STRING);
        name.setDefault("");
        name.setPrecision(50);
        name.setTableName("doctor");
        name.setServerColumnName("NAME");
        name.setSqlType(12);
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select username,name,profession,phone,email  from doctor", null, true,
                Load.ALL));
        jdbTable1.setDataSet(queryDataSet1);
        jdbTable1.setEditable(false);
        column1.setCaption("用户名");
        column1.setColumnName("username");
        column1.setDataType(com.borland.dx.dataset.Variant.STRING);
        column1.setPrecision(20);
        column1.setTableName("doctor");
        column1.setServerColumnName("username");
        column1.setSqlType(12);
        column2.setCaption("真实姓名");
        column2.setColumnName("name");
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setPrecision(50);
        column2.setTableName("doctor");
        column2.setServerColumnName("name");
        column2.setSqlType(12);
        column3.setCaption("专业");
        column3.setColumnName("profession");
        column3.setDataType(com.borland.dx.dataset.Variant.STRING);
        column3.setPrecision(20);
        column3.setTableName("doctor");
        column3.setServerColumnName("profession");
        column3.setSqlType(12);
        column4.setCaption("电话号码");
        column4.setColumnName("phone");
        column4.setDataType(com.borland.dx.dataset.Variant.INT);
        column4.setTableName("doctor");
        column4.setServerColumnName("phone");
        column4.setSqlType(4);
        column5.setCaption("Email");
        column5.setColumnName("email");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        column5.setPrecision(50);
        column5.setTableName("doctor");
        column5.setServerColumnName("email");
        column5.setSqlType(12);
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
        jLabel1.setText("医生信息管理");
        jEditorPane1.setBackground(SystemColor.control);
        jEditorPane1.setBorder(titledBorder2);
        jEditorPane1.setEditable(false);
        btnExit.setBounds(new Rectangle(39, 543, 164, 29));
        btnExit.setText("关闭");
        btnExit.addActionListener(new MngDoctor_btnExit_actionAdapter(this));
        this.add(jScrollPane1, null);
        jScrollPane1.getViewport().add(jdbTable1);

        jLabel1.setBounds(new Rectangle(430, 0, 140, 24));
        btnAdd.setBounds(new Rectangle(200, 550, 100, 30));
        btnDel.setBounds(new Rectangle(327, 550, 100, 30));
        btnModify.setBounds(new Rectangle(453, 550, 100, 30));
        btnFresh.setBounds(new Rectangle(579, 550, 100, 30));
        btnExit.setBounds(new Rectangle(700, 550, 100, 30));
        jEditorPane1.setBounds(new Rectangle(30, 525, 950, 76));
        jScrollPane1.setBounds(new Rectangle(30, 30, 950, 490));

        this.add(btnAdd);
        this.add(btnModify);
        this.add(btnDel);
        this.add(btnFresh);
        this.add(jLabel1);
        this.add(btnExit);
        this.add(jEditorPane1);
        queryDataSet1.setColumns(new Column[] {column1, column2, column3,column4, column5});
    }

    public void btnFresh_actionPerformed(ActionEvent e) {
    }

    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);
       ModifyDoctorInfo mdi=new ModifyDoctorInfo(strUsername);
       Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
       Dimension frameSize = mdi.getPreferredSize();
       if (frameSize.height > screenSize.height) {
           frameSize.height = screenSize.height;
       }
       if (frameSize.width > screenSize.width) {
           frameSize.width = screenSize.width;
       }
       mdi.setLocation((screenSize.width - frameSize.width) / 2,(screenSize.height - frameSize.height) / 2);
       mdi.setModal(true);
       mdi.pack();
       mdi.setVisible(true);
    }

    public void btnDel_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);
       if(JOptionPane.showConfirmDialog(null,"确定要删除用户"+strUsername+"吗？","系统提示",JOptionPane.OK_CANCEL_OPTION)==JOptionPane.OK_OPTION){
           db=new MyDatabase();
           Statement stm=db.getStatement();
           try{
               stm.executeUpdate("DELETE  FROM doctor WHERE username='" +strUsername + "'");
               JOptionPane.showMessageDialog(null,"删除成功！","系统提示",JOptionPane.INFORMATION_MESSAGE);
           }catch(SQLException se){
                JOptionPane.showMessageDialog(null,se.toString(),"系统提示",JOptionPane.INFORMATION_MESSAGE);
           }
       }

    }

    public void btnAdd_actionPerformed(ActionEvent e) {
        AddDoctorInfo adi=new AddDoctorInfo();
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = adi.getPreferredSize();
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        adi.setLocation((screenSize.width - frameSize.width) / 2,
                        (screenSize.height - frameSize.height) / 2);
        adi.setModal(true);
        adi.setVisible(true);
    }

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


class MngDoctor_btnExit_actionAdapter implements ActionListener {
    private MngDoctor adaptee;
    MngDoctor_btnExit_actionAdapter(MngDoctor adaptee) {
        this.adaptee = adaptee;
    }

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


class MngDoctor_btnFresh_actionAdapter implements ActionListener {
    private MngDoctor adaptee;
    MngDoctor_btnFresh_actionAdapter(MngDoctor adaptee) {
        this.adaptee = adaptee;
    }

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


class MngDoctor_btnDel_actionAdapter implements ActionListener {
    private MngDoctor adaptee;
    MngDoctor_btnDel_actionAdapter(MngDoctor adaptee) {
        this.adaptee = adaptee;
    }

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


class MngDoctor_btnModify_actionAdapter implements ActionListener {
    private MngDoctor adaptee;
    MngDoctor_btnModify_actionAdapter(MngDoctor adaptee) {
        this.adaptee = adaptee;
    }

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


class MngDoctor_btnAdd_actionAdapter implements ActionListener {
    private MngDoctor adaptee;
    MngDoctor_btnAdd_actionAdapter(MngDoctor adaptee) {
        this.adaptee = adaptee;
    }

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