add_doctor.java

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

package clinique;

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import com.borland.dbswing.JdbTable;
import javax.swing.border.Border;
import javax.swing.border.TitledBorder;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
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.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.event.*;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.SQLException;
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 add_doctor extends JPanel {
    String Phostr;
    String a;
    String b;
    public add_doctor() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        border2 = new TitledBorder("");
        this.setLayout(null);
        jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
        jScrollPane1.setBounds(new Rectangle(8, 11, 652, 218));
        jdbTable1.setToolTipText("");
        jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable1.setDataSet(queryDataSet1);
        jdbTable1.setEditable(false);
        jBAdd.setBounds(new Rectangle(187, 129, 103, 23));
        jBAdd.setText("添加信息");
        jBAdd.addActionListener(new add_doctor_jBAdd_actionAdapter(this));
        jBExit.setBounds(new Rectangle(352, 129, 114, 23));
        jBExit.setText("取消添加");
        jBExit.addActionListener(new add_doctor_jBExit_actionAdapter(this));
        jTextName.setBounds(new Rectangle(141, 10, 155, 28));

        jTNumber.setBounds(new Rectangle(141, 84, 155, 29));
        jTEmail.setBounds(new Rectangle(443, 84, 154, 29));
        jPassword1.setBounds(new Rectangle(140, 50, 155, 24));
        jPassword2.setBounds(new Rectangle(442, 50, 154, 24));
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel1.setText("医生姓名:");
        jLabel1.setBounds(new Rectangle(59, 11, 68, 22));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel2.setText("医生职业:");
        jLabel2.setBounds(new Rectangle(367, 14, 83, 18));

        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel3.setText("输入密码:");
        jLabel3.setBounds(new Rectangle(58, 56, 75, 17));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel4.setText("确认密码:");
        jLabel4.setBounds(new Rectangle(366, 55, 62, 19));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel5.setText("电话号码:");
        jLabel5.setBounds(new Rectangle(59, 97, 62, 15));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel6.setText("电子邮件:");
        jLabel6.setBounds(new Rectangle(367, 98, 65, 15));
        column1.setColumnName("name");
        column1.setDataType(com.borland.dx.dataset.Variant.STRING);
        column1.setPrecision(50);
        column1.setTableName("doctor");
        column1.setWidth(80);
        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(80);
        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(80);
        column3.setServerColumnName("profession");
        column3.setSqlType(1);
        column4.setColumnName("phonenumber");
        column4.setDataType(com.borland.dx.dataset.Variant.LONG);
        column4.setTableName("doctor");
        column4.setWidth(80);
        column4.setServerColumnName("phonenumber");
        column4.setSqlType(80);
        column5.setAlignment(com.borland.dx.text.Alignment.CENTER |
                             com.borland.dx.text.Alignment.MIDDLE);
        column5.setColumnName("name");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        column5.setPrecision(50);
        column5.setTableName("doctor");
        column5.setServerColumnName("name");
        column5.setSqlType(1);
        column6.setAlignment(com.borland.dx.text.Alignment.CENTER |
                             com.borland.dx.text.Alignment.MIDDLE);
        column6.setColumnName("password");
        column6.setDataType(com.borland.dx.dataset.Variant.STRING);
        column6.setPrecision(50);
        column6.setSqlType(1);
        column6.setTableName("doctor");
        column6.setServerColumnName("password");
        column7.setAlignment(com.borland.dx.text.Alignment.CENTER |
                             com.borland.dx.text.Alignment.MIDDLE);
        column7.setColumnName("profession");
        column7.setDataType(com.borland.dx.dataset.Variant.STRING);
        column7.setPrecision(50);
        column7.setTableName("doctor");
        column7.setServerColumnName("profession");
        column7.setSqlType(1);
        column8.setAlignment(com.borland.dx.text.Alignment.CENTER |
                             com.borland.dx.text.Alignment.MIDDLE);
        column8.setColumnName("phonenumber");
        column8.setDataType(com.borland.dx.dataset.Variant.LONG);
        column8.setTableName("doctor");
        column8.setServerColumnName("phonenumber");
        column8.setSqlType(1);
        column9.setAlignment(com.borland.dx.text.Alignment.CENTER |
                             com.borland.dx.text.Alignment.MIDDLE);
        column9.setColumnName("email");
        column9.setDataType(com.borland.dx.dataset.Variant.STRING);
        column9.setPrecision(50);
        column9.setTableName("doctor");
        column9.setServerColumnName("email");
        column9.setSqlType(1);
        column10.setAlignment(com.borland.dx.text.Alignment.CENTER |
                              com.borland.dx.text.Alignment.MIDDLE);
        column10.setColumnName("name");
        column10.setDataType(com.borland.dx.dataset.Variant.STRING);
        column10.setPrecision(50);
        column10.setTableName("doctor");
        column10.setServerColumnName("name");
        column10.setSqlType(1);
        column11.setAlignment(com.borland.dx.text.Alignment.CENTER |
                              com.borland.dx.text.Alignment.MIDDLE);
        column11.setColumnName("password");
        column11.setDataType(com.borland.dx.dataset.Variant.STRING);
        column11.setPrecision(50);
        column11.setTableName("doctor");
        column11.setServerColumnName("password");
        column11.setSqlType(1);
        column12.setAlignment(com.borland.dx.text.Alignment.CENTER |
                              com.borland.dx.text.Alignment.MIDDLE);
        column12.setColumnName("profession");
        column12.setDataType(com.borland.dx.dataset.Variant.STRING);
        column12.setPrecision(50);
        column12.setTableName("doctor");
        column12.setServerColumnName("profession");
        column12.setSqlType(1);
        column13.setAlignment(com.borland.dx.text.Alignment.CENTER |
                              com.borland.dx.text.Alignment.MIDDLE);
        column13.setColumnName("phonenumber");
        column13.setDataType(com.borland.dx.dataset.Variant.LONG);
        column13.setTableName("doctor");
        column13.setServerColumnName("phonenumber");
        column13.setSqlType(1);
        column14.setColumnName("name");
        column14.setDataType(com.borland.dx.dataset.Variant.STRING);
        column14.setPrecision(50);
        column14.setTableName("doctor");
        column14.setWidth(50);
        column14.setServerColumnName("NAME");
        column14.setSqlType(1);
        column15.setColumnName("password");
        column15.setDataType(com.borland.dx.dataset.Variant.STRING);
        column15.setPrecision(50);
        column15.setTableName("doctor");
        column15.setWidth(50);
        column15.setServerColumnName("PASSWORD");
        column15.setSqlType(1);
        column16.setColumnName("profession");
        column16.setDataType(com.borland.dx.dataset.Variant.STRING);
        column16.setPrecision(50);
        column16.setTableName("doctor");
        column16.setWidth(50);
        column16.setServerColumnName("PROFESSION");
        column16.setSqlType(1);
        column17.setColumnName("phonenumber");
        column17.setDataType(com.borland.dx.dataset.Variant.LONG);
        column17.setTableName("doctor");
        column17.setWidth(50);
        column17.setServerColumnName("PHONENUMBER");
        column17.setSqlType(1);
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=clinique",
                "sa", "", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
        jComboBox1.setBorder(null);
        jComboBox1.setBounds(new Rectangle(443, 10, 154, 28));
        jLabel7.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel7.setText("医生信息添加");
        jLabel7.setBounds(new Rectangle(24, 18, 101, 23));
        column18.setColumnName("email");
        column18.setDataType(com.borland.dx.dataset.Variant.STRING);
        column18.setPrecision(50);
        column18.setPreferredOrdinal(6);
        column18.setTableName("doctor");
        column18.setServerColumnName("email");
        column18.setSqlType(1);
        column19.setColumnName("DOCTOR_ID");
        column19.setDataType(com.borland.dx.dataset.Variant.INT);
        column19.setRowId(true);
        column19.setTableName("doctor");
        column19.setWidth(10);
        column19.setServerColumnName("DOCTOR_ID");
        column19.setSqlType(4);
        column19.setHidden(true);
        column21.setColumnName("name");
        column21.setDataType(com.borland.dx.dataset.Variant.STRING);
        column21.setPrecision(50);
        column21.setTableName("doctor");
        column21.setWidth(14);
        column21.setServerColumnName("name");
        column21.setSqlType(1);
        column22.setColumnName("profession");
        column22.setDataType(com.borland.dx.dataset.Variant.STRING);
        column22.setPrecision(50);
        column22.setTableName("doctor");
        column22.setServerColumnName("profession");
        column22.setSqlType(1);
        column23.setColumnName("profession");
        column23.setDataType(com.borland.dx.dataset.Variant.STRING);
        column23.setPrecision(50);
        column23.setTableName("doctor");
        column23.setWidth(14);
        column23.setServerColumnName("profession");
        column23.setSqlType(1);
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select doctor_id,name,profession,phonenumber,email from doctor ", null, true,
                Load.ALL));
        column20.setColumnName("doctor_id");
        column20.setDataType(com.borland.dx.dataset.Variant.INT);
        column20.setRowId(true);
        column20.setTableName("doctor");
        column20.setWidth(10);
        column20.setServerColumnName("doctor_id");
        column20.setSqlType(4);
        column24.setColumnName("name");
        column24.setDataType(com.borland.dx.dataset.Variant.STRING);
        column24.setPrecision(50);
        column24.setTableName("doctor");
        column24.setWidth(14);
        column24.setServerColumnName("name");
        column24.setSqlType(1);
        column25.setColumnName("profession");
        column25.setDataType(com.borland.dx.dataset.Variant.STRING);
        column25.setPrecision(50);
        column25.setTableName("doctor");
        column25.setWidth(14);
        column25.setServerColumnName("profession");
        column25.setSqlType(1);
        column27.setColumnName("email");
        column27.setDataType(com.borland.dx.dataset.Variant.STRING);
        column27.setPrecision(50);