edit_doctor.java

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

package clinique;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dbswing.JdbTable;
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;
import java.awt.Color;
import javax.swing.border.TitledBorder;

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

    private void jbInit() throws Exception {
        this.setLayout(null);
        jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
        jScrollPane1.setBounds(new Rectangle(9, 16, 620, 235));
        column1.setColumnName("name");
        column1.setDataType(com.borland.dx.dataset.Variant.STRING);
        column1.setPrecision(50);
        column1.setTableName("doctor");
        column1.setWidth(13);
        column1.setServerColumnName("name");
        column1.setSqlType(1);
        column2.setColumnName("password");
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setPrecision(50);
        column2.setTableName("doctor");
        column2.setWidth(13);
        column2.setServerColumnName("password");
        column2.setSqlType(1);
        column3.setColumnName("profession");
        column3.setDataType(com.borland.dx.dataset.Variant.STRING);
        column3.setPrecision(50);
        column3.setTableName("doctor");
        column3.setWidth(13);
        column3.setServerColumnName("profession");
        column3.setSqlType(1);
        column4.setColumnName("phonenumber");
        column4.setDataType(com.borland.dx.dataset.Variant.LONG);
        column4.setTableName("doctor");
        column4.setWidth(13);
        column4.setServerColumnName("phonenumber");
        column4.setSqlType(1);
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=clinique",
                "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
        jdbTable1.setDataSet(queryDataSet1);
        jdbTable1.setEditable(false);
        jdbTable1.addMouseListener(new edit_doctor_jdbTable1_mouseAdapter(this));
        jTname.setBounds(new Rectangle(100, 13, 114, 21));
        jTphonenumber.setBounds(new Rectangle(100, 77, 114, 20));
        jTemail.setBounds(new Rectangle(314, 76, 116, 20));
        jLabel1.setText("医生姓名：");
        jLabel1.setBounds(new Rectangle(8, 14, 78, 15));
        jLabel2.setText("医生职业：");
        jLabel2.setBounds(new Rectangle(237, 12, 69, 15));
        jLabel4.setText("电话号码：");
        jLabel4.setBounds(new Rectangle(8, 78, 74, 15));
        jLabel5.setText("确认密码：");
        jLabel5.setBounds(new Rectangle(237, 48, 71, 15));
        jLabel6.setText("电子邮件：");
        jLabel6.setBounds(new Rectangle(237, 81, 72, 15));
        jBorder.setBounds(new Rectangle(110, 111, 96, 23));
        jBorder.setText("提交修改");
        jBorder.addActionListener(new edit_doctor_jBorder_actionAdapter(this));
        jButton2.setBounds(new Rectangle(236, 111, 96, 23));
        jButton2.setText("取消修改");
        jButton2.addActionListener(new edit_doctor_jButton2_actionAdapter(this));
        jPasswordField1.setBounds(new Rectangle(100, 45, 114, 20));
        jPasswordField2.setBounds(new Rectangle(314, 44, 116, 20));
        column5.setColumnName("doctor_id");
        column5.setDataType(com.borland.dx.dataset.Variant.INT);
        column5.setRowId(true);
        column5.setTableName("doctor");
        column5.setWidth(10);
        column5.setServerColumnName("DOCTOR_ID");
        column5.setSqlType(4);
        column6.setColumnName("name");
        column6.setDataType(com.borland.dx.dataset.Variant.STRING);
        column6.setPrecision(50);
        column6.setTableName("doctor");
        column6.setWidth(10);
        column6.setServerColumnName("NAME");
        column6.setSqlType(1);
        column7.setColumnName("password");
        column7.setDataType(com.borland.dx.dataset.Variant.STRING);
        column7.setPrecision(50);
        column7.setTableName("doctor");
        column7.setWidth(10);
        column7.setServerColumnName("PASSWORD");
        column7.setSqlType(1);
        column8.setColumnName("profession");
        column8.setDataType(com.borland.dx.dataset.Variant.STRING);
        column8.setPrecision(50);
        column8.setTableName("doctor");
        column8.setWidth(10);
        column8.setServerColumnName("PROFESSION");
        column8.setSqlType(1);
        column10.setColumnName("email");
        column10.setDataType(com.borland.dx.dataset.Variant.STRING);
        column10.setPrecision(50);
        column10.setTableName("doctor");
        column10.setWidth(12);
        column10.setServerColumnName("EMAIL");
        column10.setSqlType(1);
        jComboBox1.setBounds(new Rectangle(314, 13, 116, 20));
        jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel3.setText("医生信息修改");
        jLabel3.setBounds(new Rectangle(22, 13, 127, 22));
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select doctor_id,name,profession,phonenumber,email from doctor ", null, true,
                Load.ALL));
        column11.setColumnName("doctor_id");
        column11.setDataType(com.borland.dx.dataset.Variant.INT);
        column11.setRowId(true);
        column11.setTableName("doctor");
        column11.setWidth(12);
        column11.setServerColumnName("doctor_id");
        column11.setSqlType(4);
        column12.setColumnName("name");
        column12.setDataType(com.borland.dx.dataset.Variant.STRING);
        column12.setPrecision(50);
        column12.setTableName("doctor");
        column12.setWidth(14);
        column12.setServerColumnName("name");
        column12.setSqlType(1);
        column13.setColumnName("profession");
        column13.setDataType(com.borland.dx.dataset.Variant.STRING);
        column13.setPrecision(50);
        column13.setTableName("doctor");
        column13.setServerColumnName("profession");
        column14.setColumnName("profession");
        column14.setDataType(com.borland.dx.dataset.Variant.STRING);
        column14.setPrecision(50);
        column14.setTableName("doctor");
        column14.setWidth(14);
        column14.setServerColumnName("profession");
        column14.setSqlType(1);
        column15.setColumnName("email");
        column15.setDataType(com.borland.dx.dataset.Variant.STRING);
        column15.setPrecision(50);
        column15.setTableName("doctor");
        column15.setWidth(14);
        column15.setServerColumnName("email");
        column15.setSqlType(1);
        column16.setColumnName("phonenumber");
        column16.setDataType(com.borland.dx.dataset.Variant.LONG);
        column16.setTableName("doctor");
        column16.setServerColumnName("phonenumber");
        jLabel7.setText("输入密码：");
        jLabel7.setBounds(new Rectangle(8, 45, 73, 15));
        jch.setBounds(new Rectangle(10, 108, 60, 23));
        jch.setText("查询");
        jch.addActionListener(new edit_doctor_jch_actionAdapter(this));
        jLabel8.setText("姓名查询：");
        jLabel8.setBounds(new Rectangle(11, 21, 68, 15));
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setToolTipText("");
        jPanel1.setBounds(new Rectangle(9, 262, 174, 148));
        jPanel1.setLayout(null);
        cdoctor.setBounds(new Rectangle(86, 19, 73, 20));
        show.setBounds(new Rectangle(77, 108, 90, 23));
        show.setText("显示全部");
        show.addActionListener(new edit_doctor_jButton1_actionAdapter(this));
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(188, 262, 441, 148));
        jPanel2.setLayout(null);
        jLabel9.setText("职业查询：");
        jLabel9.setBounds(new Rectangle(12, 69, 66, 15));
        jComboBox2.setBounds(new Rectangle(87, 62, 73, 23));
        jPanel3.setBorder(BorderFactory.createEtchedBorder());
        jPanel3.setBounds(new Rectangle(77, 34, 638, 418));
        jPanel3.setLayout(null);
        this.add(jLabel3);
        this.add(jPanel3);
        jPanel1.add(cdoctor);
        jPanel1.add(jLabel8);
        jPanel1.add(jComboBox2);
        jPanel1.add(jLabel9);
        jPanel1.add(jch);
        jPanel1.add(show);
        jPanel3.add(jPanel2);
        jPanel2.add(jComboBox1);
        jPanel2.add(jLabel2);
        jPanel2.add(jTname);
        jPanel2.add(jLabel1);
        jPanel2.add(jPasswordField2);
        jPanel2.add(jPasswordField1);
        jPanel2.add(jLabel7);
        jPanel2.add(jLabel5);
        jPanel2.add(jTemail);
        jPanel2.add(jLabel4);
        jPanel2.add(jTphonenumber);
        jPanel2.add(jLabel6);
        jPanel2.add(jBorder);
        jPanel2.add(jButton2);
        jPanel3.add(jScrollPane1);
        jScrollPane1.getViewport().add(jdbTable1);
        jPanel3.add(jPanel1);

        jComboBox1.addItem("");
        jComboBox1.addItem("牙科");
        jComboBox1.addItem("内科");
        jComboBox1.addItem("外科");
        jComboBox1.addItem("骨科");
        jComboBox1.addItem("妇科");

        jComboBox2.addItem("");
        jComboBox2.addItem("牙科");
        jComboBox2.addItem("内科");
        jComboBox2.addItem("外科");
        jComboBox2.addItem("骨科");
        jComboBox2.addItem("妇科");
        queryDataSet1.setColumns(new Column[] {column11, column12, column14,
                                 column15});
    }

    JScrollPane jScrollPane1 = new JScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    Column column1 = new Column();
    Column column2 = new Column();
    Column column3 = new Column();
    Column column4 = new Column();
    Database database1 = new Database();
    JTextField jTname = new JTextField();
    JTextField jTphonenumber = new JTextField();
    JTextField jTemail = new JTextField();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JButton jBorder = new JButton();
    JButton jButton2 = new JButton();
    JPasswordField jPasswordField1 = new JPasswordField();
    JPasswordField jPasswordField2 = new JPasswordField();
    Column column5 = new Column();
    Column column6 = new Column();
    Column column7 = new Column();
    Column column8 = new Column();
    Column column9 = new Column();