add_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.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 add_patient extends JPanel {
    String Phostr1;
    String Phostr2;
    public add_patient() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        jScrollPane1.setBounds(new Rectangle(11, 13, 661, 203));
        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.setBorder(BorderFactory.createEtchedBorder());
        jdbTable1.setDataSet(queryDataSet1);
        jdbTable1.setEditable(false);
        column1.setColumnName("name");
        column1.setDataType(com.borland.dx.dataset.Variant.STRING);
        column1.setPrecision(50);
        column1.setTableName("patient");
        column1.setWidth(6);
        column1.setServerColumnName("name");
        column1.setSqlType(1);
        column2.setColumnName("birthday");
        column2.setDataType(com.borland.dx.dataset.Variant.DATE);
        column2.setTableName("patient");
        column2.setWidth(6);
        column2.setServerColumnName("birthday");
        column2.setSqlType(93);
        column3.setColumnName("stature");
        column3.setDataType(com.borland.dx.dataset.Variant.INT);
        column3.setDefault("");
        column3.setTableName("patient");
        column3.setWidth(4);
        column3.setServerColumnName("stature");
        column3.setSqlType(4);
        column4.setColumnName("avoirdupois");
        column4.setDataType(com.borland.dx.dataset.Variant.INT);
        column4.setTableName("patient");
        column4.setWidth(6);
        column4.setServerColumnName("avoirdupois");
        column4.setSqlType(4);
        jTpname.setBounds(new Rectangle(97, 24, 88, 20));
        jTpstature.setBounds(new Rectangle(97, 101, 72, 20));
        jTpavo.setBounds(new Rectangle(278, 100, 69, 20));
        jLabel1.setToolTipText("");
        jLabel1.setText("病人姓名：");
        jLabel1.setBounds(new Rectangle(24, 29, 65, 15));
        jLabel2.setText("出生日期：");
        jLabel2.setBounds(new Rectangle(23, 67, 68, 15));
        jLabel3.setText("身高：");
        jLabel3.setBounds(new Rectangle(48, 104, 42, 15));
        jLabel4.setText("性别：");
        jLabel4.setBounds(new Rectangle(227, 29, 42, 15));
        jLabel5.setText("血型：");
        jLabel5.setBounds(new Rectangle(225, 68, 42, 15));
        jLabel6.setText("体重：");
        jLabel6.setBounds(new Rectangle(226, 105, 42, 15));
        jBorder.setBounds(new Rectangle(221, 373, 86, 23));
        jBorder.setText("确认提交");
        jBorder.addActionListener(new add_patient_jButton1_actionAdapter(this));
        jBexit.setBounds(new Rectangle(402, 372, 88, 23));
        jBexit.setText("取消");
        jBexit.addActionListener(new add_patient_jBexit_actionAdapter(this));
        jComboBox1.setBounds(new Rectangle(278, 22, 87, 20));
        jComboBox2.setBounds(new Rectangle(278, 61, 87, 20));
        column5.setColumnName("sex");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        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);
        jLabel7.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel7.setText("病人信息添加");
        jLabel7.setBounds(new Rectangle(23, 13, 126, 28));
        column7.setColumnName("patient_id");
        column7.setDataType(com.borland.dx.dataset.Variant.INT);
        column7.setRowId(true);
        column7.setTableName("patient");
        column7.setWidth(6);
        column7.setServerColumnName("PATIENT_ID");
        column7.setSqlType(4);
        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);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(11, 226, 397, 140));
        jPanel1.setLayout(null);
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(415, 226, 257, 140));
        jPanel2.setLayout(null);
        jLabel8.setText("所用药品：");
        jLabel8.setBounds(new Rectangle(41, 16, 67, 15));
        jLabel9.setText("药品数量：");
        jLabel9.setBounds(new Rectangle(41, 48, 65, 15));
        jLabel10.setText("主治医生：");
        jLabel10.setBounds(new Rectangle(41, 108, 68, 15));
        jLabel11.setText("药品价格：");
        jLabel11.setBounds(new Rectangle(41, 78, 72, 15));
        mname.setBounds(new Rectangle(130, 14, 77, 20));
        mnumber.setBounds(new Rectangle(130, 44, 77, 20));
        pdoctor.setBounds(new Rectangle(130, 105, 77, 20));
        jPanel3.setBorder(BorderFactory.createEtchedBorder());
        jPanel3.setBounds(new Rectangle(53, 42, 684, 405));
        jPanel3.setLayout(null);
        column11.setColumnName("date");
        column11.setDataType(com.borland.dx.dataset.Variant.DATE);
        column11.setDefault("");
        column11.setTableName("patient");
        column11.setWidth(6);
        column11.setServerColumnName("DATE");
        column11.setSqlType(93);
        column12.setColumnName("nenumber");
        column12.setDataType(com.borland.dx.dataset.Variant.INT);
        column12.setDefault("");
        column12.setTableName("patient");
        column12.setWidth(6);
        column12.setServerColumnName("NENUMBER");
        column12.setSqlType(4);
        column13.setColumnName("medname");
        column13.setDataType(com.borland.dx.dataset.Variant.STRING);
        column13.setPrecision(50);
        column13.setTableName("patient");
        column13.setWidth(8);
        column13.setServerColumnName("MEDNAME");
        column13.setSqlType(1);
        cyear.setBounds(new Rectangle(97, 63, 34, 20));
        cmonth.setBounds(new Rectangle(144, 63, 22, 20));
        cday.setBounds(new Rectangle(178, 63, 21, 20));
        jLabel12.setText("年");
        jLabel12.setBounds(new Rectangle(131, 66, 18, 15));
        jLabel13.setText("月");
        jLabel13.setBounds(new Rectangle(167, 65, 17, 15));
        jLabel14.setText("日");
        jLabel14.setBounds(new Rectangle(200, 66, 18, 15));
        price.setBounds(new Rectangle(130, 76, 60, 20));
        jLabel18.setText("cm");
        jLabel18.setBounds(new Rectangle(173, 103, 20, 15));
        jLabel19.setText("kg");
        jLabel19.setBounds(new Rectangle(352, 102, 21, 15));
        jLabel20.setText("元");
        jLabel20.setBounds(new Rectangle(194, 79, 20, 15));
        column9.setColumnName("price");
        column9.setDataType(com.borland.dx.dataset.Variant.BIGDECIMAL);
        column9.setDefault("");
        column9.setPrecision(10);
        column9.setScale(2);
        column9.setTableName("patient");
        column9.setWidth(6);
        column9.setServerColumnName("PRICE");
        column9.setSqlType(3);
        jPanel1.add(jTpname);
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel3);
        jPanel1.add(jTpstature);
        jPanel1.add(jLabel12);
        jPanel1.add(cmonth);
        jPanel1.add(jLabel13);
        jPanel1.add(jTpavo);
        jPanel1.add(jComboBox1);
        jPanel1.add(jLabel4);
        jPanel1.add(jLabel5);
        jPanel1.add(jComboBox2);
        jPanel1.add(jLabel6);
        jPanel1.add(jLabel14);
        jPanel1.add(cyear);
        jPanel1.add(cday);
        jPanel1.add(jLabel19);
        jPanel1.add(jLabel18);
        jPanel3.add(jScrollPane1);
        jScrollPane1.getViewport().add(jdbTable1);
        jPanel3.add(jBexit);
        jPanel3.add(jBorder);
        jPanel3.add(jPanel2);
        jPanel3.add(jPanel1);
        jPanel2.add(mname);
        jPanel2.add(jLabel9);
        jPanel2.add(jLabel8);
        jPanel2.add(mnumber);
        jPanel2.add(jLabel10);
        jPanel2.add(jLabel11);
        jPanel2.add(pdoctor);
        jPanel2.add(price);
        jPanel2.add(jLabel20);
        this.add(jLabel7);
        this.add(jPanel3);
        jComboBox1.addItem("");
        jComboBox1.addItem("男");
        jComboBox1.addItem("女");
        jComboBox2.addItem("");
        jComboBox2.addItem("A");
        jComboBox2.addItem("B");
        jComboBox2.addItem("O");
        jComboBox2.addItem("AB");
        queryDataSet1.setColumns(new Column[] {column7, column1, column5,
                                 column2, column6, column3, column4, column8,
                                 column13, column12, column9, 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();
    JTextField jTpname = new JTextField();
    JTextField jTpstature = new JTextField();
    JTextField jTpavo = new JTextField();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();