delete_patient.java

在个一个诊所系统,实现数据的查询和删除等的操作.

package clinique;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import com.borland.dbswing.JdbTable;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.Load;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.dataset.Column;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.SQLException;
import java.awt.Font;
import javax.swing.BorderFactory;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class delete_patient extends JPanel {
    int n;
    String id;
    int x=-1;
    public delete_patient() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        jScrollPane1.setBounds(new Rectangle(13, 13, 661, 276));
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=clinique",
                "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select * from patient", null, true, Load.ALL));
        jdbTable1.setDataSet(queryDataSet1);
        jdbTable1.setEditable(false);
        jdbTable1.addMouseListener(new delete_patient_jdbTable1_mouseAdapter(this));
        column1.setColumnName("patient_id");
        column1.setDataType(com.borland.dx.dataset.Variant.INT);
        column1.setRowId(true);
        column1.setTableName("patient");
        column1.setWidth(6);
        column1.setServerColumnName("patient_id");
        column1.setSqlType(4);
        column2.setColumnName("name");
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setPrecision(50);
        column2.setTableName("patient");
        column2.setWidth(6);
        column2.setServerColumnName("name");
        column2.setSqlType(1);
        column3.setColumnName("birthday");
        column3.setDataType(com.borland.dx.dataset.Variant.DATE);
        column3.setDefault("");
        column3.setTableName("patient");
        column3.setWidth(6);
        column3.setServerColumnName("birthday");
        column3.setSqlType(93);
        column4.setColumnName("stature");
        column4.setDataType(com.borland.dx.dataset.Variant.INT);
        column4.setTableName("patient");
        column4.setWidth(6);
        column4.setServerColumnName("stature");
        column4.setSqlType(4);
        jBdelete.setBounds(new Rectangle(499, 25, 90, 23));
        jBdelete.setText("数据删除");
        jBdelete.addActionListener(new delete_patient_jBdelete_actionAdapter(this));
        look.setBounds(new Rectangle(250, 25, 70, 23));
        look.setText("查询");
        look.addActionListener(new delete_patient_look_actionAdapter(this));
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel1.setText("病人信息删除");
        jLabel1.setBounds(new Rectangle(24, 16, 117, 31));
        column5.setColumnName("sex");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        column5.setDefault("");
        column5.setPrecision(4);
        column5.setTableName("patient");
        column5.setWidth(4);
        column5.setServerColumnName("SEX");
        column5.setSqlType(1);
        column6.setColumnName("bloodtype");
        column6.setDataType(com.borland.dx.dataset.Variant.STRING);
        column6.setPrecision(4);
        column6.setTableName("patient");
        column6.setWidth(4);
        column6.setServerColumnName("BLOODTYPE");
        column6.setSqlType(1);
        column7.setColumnName("avoirdupois");
        column7.setDataType(com.borland.dx.dataset.Variant.INT);
        column7.setTableName("patient");
        column7.setWidth(6);
        column7.setServerColumnName("AVOIRDUPOIS");
        column7.setSqlType(4);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(55, 49, 688, 385));
        jPanel1.setLayout(null);
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(13, 303, 661, 71));
        jPanel2.setLayout(null);
        lookname.setBounds(new Rectangle(124, 28, 77, 20));
        jLabel2.setText("姓名查询：");
        jLabel2.setBounds(new Rectangle(45, 29, 75, 15));
        column8.setColumnName("doctor");
        column8.setDataType(com.borland.dx.dataset.Variant.STRING);
        column8.setPrecision(50);
        column8.setTableName("patient");
        column8.setWidth(6);
        column8.setServerColumnName("DOCTOR");
        column8.setSqlType(1);
        column9.setColumnName("medname");
        column9.setDataType(com.borland.dx.dataset.Variant.STRING);
        column9.setPrecision(50);
        column9.setTableName("patient");
        column9.setWidth(6);
        column9.setServerColumnName("MEDNAME");
        column9.setSqlType(1);
        column10.setColumnName("nenumber");
        column10.setDataType(com.borland.dx.dataset.Variant.INT);
        column10.setTableName("patient");
        column10.setWidth(6);
        column10.setServerColumnName("NENUMBER");
        column10.setSqlType(4);
        column11.setColumnName("date");
        column11.setDataType(com.borland.dx.dataset.Variant.DATE);
        column11.setTableName("patient");
        column11.setWidth(6);
        column11.setServerColumnName("DATE");
        column11.setSqlType(93);
        column12.setColumnName("price");
        column12.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
        column12.setPrecision(10);
        column12.setScale(2);
        column12.setTableName("patient");
        column12.setWidth(6);
        column12.setServerColumnName("PRICE");
        column12.setSqlType(3);
        show.setBounds(new Rectangle(368, 25, 86, 23));
        show.setText("显示全部");
        show.addActionListener(new delete_patient_show_actionAdapter(this));
        jPanel2.add(jBdelete);
        jPanel2.add(jLabel2);
        jPanel2.add(lookname);
        jPanel2.add(look);
        jPanel2.add(show);
        jPanel1.add(jScrollPane1);
        jPanel1.add(jPanel2);
        jScrollPane1.getViewport().add(jdbTable1);

        this.add(jLabel1);
        this.add(jPanel1);
        queryDataSet1.setColumns(new Column[] {column1, column2, column5,
                                 column3, column6, column4, column7, column8,
                                 column9, column10, column12, column11});
    }

    JScrollPane jScrollPane1 = new JScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    Column column1 = new Column();
    Column column2 = new Column();
    Column column3 = new Column();
    Column column4 = new Column();
    JButton jBdelete = new JButton();
    JButton look = new JButton();
    JLabel jLabel1 = new JLabel();
    Column column5 = new Column();
    Column column6 = new Column();
    Column column7 = new Column();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JTextField lookname = new JTextField();
    JLabel jLabel2 = new JLabel();
    Column column8 = new Column();
    Column column9 = new Column();
    Column column10 = new Column();
    Column column11 = new Column();
    Column column12 = new Column();
    JButton show = new JButton();
    public void jdbTable1_mouseClicked(MouseEvent e) {

        n=jdbTable1.getSelectedRow();
        id=""+jdbTable1.getValueAt(n,0);
        x=1;
    }

    public void jBdelete_actionPerformed(ActionEvent e) {

        if(x==-1)
        {
            JOptionPane.showMessageDialog(null,"请选择你要删除的一条数据！");
        }
        else
        {
            int i=JOptionPane.showConfirmDialog(null,"确定真的要删除这条数据么？","信息提示",JOptionPane.YES_NO_OPTION);
            if(i==JOptionPane.YES_OPTION)
            {
                delete_pat();
            }
            else
            {
                JOptionPane.showMessageDialog(null,"你所选的数据没用删除！");
            }

        }




    }

    private void delete_pat()
    {
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException ce) {
            System.out.println(ce);
        }
        try {
            String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=clinique";
            Connection con = DriverManager.getConnection(url,"sa","");
            String sqlStr;
            sqlStr="delete from patient where patient_id=\'"+id+"\'";
            Statement s = con.createStatement();
            s.executeUpdate(sqlStr);
            JOptionPane.showMessageDialog(null,"删除数据成功!");
            queryDataSet1.refresh();

            s.close();
            con.close();
            x=-1;
        } catch (SQLException ce) {
            System.out.println(ce);
        }

}

    public void look_actionPerformed(ActionEvent e) {
        if(lookname.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请输入你要查询的关键字！");
            lookname.requestFocus();
        }
        else if(!lookname.getText().equals(""))
        {
            queryDataSet1.close();
            queryDataSet1.setQuery(new QueryDescriptor(database1,
                    "select * from patient where name=\'" +
                    lookname.getText() + "\'", null, true,
                    Load.ALL));
            jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();
            if(queryDataSet1.getRowCount()==0)
            {
                JOptionPane.showMessageDialog(null,"你要查询的病人信息不存在");
            }
        }
    }

    public void show_actionPerformed(ActionEvent e) {
        queryDataSet1.close();
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select * from patient" , null, true,Load.ALL));
        jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();
    }

}


class delete_patient_show_actionAdapter implements ActionListener {
    private delete_patient adaptee;
    delete_patient_show_actionAdapter(delete_patient adaptee) {
        this.adaptee = adaptee;
    }

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


class delete_patient_look_actionAdapter implements ActionListener {
    private delete_patient adaptee;
    delete_patient_look_actionAdapter(delete_patient adaptee) {
        this.adaptee = adaptee;
    }

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


class delete_patient_jdbTable1_mouseAdapter extends MouseAdapter {
    private delete_patient adaptee;
    delete_patient_jdbTable1_mouseAdapter(delete_patient adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jdbTable1_mouseClicked(e);
    }
}


class delete_patient_jBdelete_actionAdapter implements ActionListener {
    private delete_patient adaptee;
    delete_patient_jBdelete_actionAdapter(delete_patient adaptee) {
        this.adaptee = adaptee;
    }

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