txb.java

一个个人信息管理系统

package soft1;

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
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.dbswing.TableScrollPane;
import com.borland.dbswing.JdbTable;
import java.awt.Rectangle;
import java.awt.Font;
import com.borland.dx.dataset.MetaDataUpdate;
import com.borland.dbswing.JdbTextField;
import com.borland.dbswing.JdbComboBox;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.border.TitledBorder;
import com.borland.dbswing.JdbTextArea;
import com.borland.dx.dataset.Column;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.FocusEvent;
import java.sql.ResultSet;
import soft1Method.*;
import java.awt.event.FocusAdapter;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Txb extends JPanel {
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    TableScrollPane tableScrollPane1 = new TableScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JLabel jLabel15 = new JLabel();
    JLabel jLabel16 = new JLabel();
    JdbTextField jdbTextField1 = new JdbTextField();
    JdbComboBox jdbComboBox1 = new JdbComboBox();
    TitledBorder titledBorder1 = new TitledBorder("");
    public  JdbComboBox jdbComboBox2 = new JdbComboBox();
    JButton jButton1 = new JButton();
    JdbTextField jdbTextField2 = new JdbTextField();
    JdbTextField jdbTextField3 = new JdbTextField();
    JdbTextField jdbTextField4 = new JdbTextField();
    JdbTextField jdbTextField5 = new JdbTextField();
    JdbTextField jdbTextField6 = new JdbTextField();
    JdbTextField jdbTextField7 = new JdbTextField();
    JdbTextField jdbTextField8 = new JdbTextField();
    JdbTextArea jdbTextArea1 = new JdbTextArea();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    Column column1 = new Column();
    Column column2 = new Column();
    Column column3 = new Column();
    Column column4 = new Column();
    Column column5 = new Column();
    Column column6 = new Column();
    Column column7 = new Column();
    Column column8 = new Column();
    Column column9 = new Column();
    Column column10 = new Column();
    Column column11 = new Column();
    JdbTextField jdbTextField9 = new JdbTextField();
     GetValue gv=new GetValue();     MiddleLoc mid=new MiddleLoc();
    Dataset2 dt=new Dataset2();
    JButton jButton5 = new JButton();
    TitledBorder titledBorder2 = new TitledBorder("");
    TitledBorder titledBorder3 = new TitledBorder("");
    public static String sc;
    public Txb() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        setSize(new Dimension(562, 391));

        database1.setConnection(new ConnectionDescriptor("jdbc:odbc:PersonalDB",
                "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
        queryDataSet1.setMetaDataUpdate(MetaDataUpdate.TABLENAME +
                                        MetaDataUpdate.PRECISION +
                                        MetaDataUpdate.SCALE +
                                        MetaDataUpdate.SEARCHABLE);
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "Select * from AddrBook where UserName='"+gv.Getvalue()+"'", null, true, Load.ALL));
        tableScrollPane1.setBorder(BorderFactory.createLineBorder(Color.black));
        tableScrollPane1.setBounds(new Rectangle(1, 27, 152, 356));
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel1.setText("通讯簿");
        jLabel1.setBounds(new Rectangle(14, 0, 105, 26));
        jLabel2.setText("详细资料：");
        jLabel2.setBounds(new Rectangle(152, 1, 79, 23));
        jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable1.setDataSet(queryDataSet1);
        jLabel3.setBorder(titledBorder1);
        jLabel3.setText("类型");
        jLabel3.setBounds(new Rectangle(155, 67, 71, 25));
        jLabel4.setBorder(titledBorder1);
        jLabel4.setText("备注");
        jLabel4.setBounds(new Rectangle(381, 149, 71, 25));
        jLabel5.setBorder(titledBorder1);
        jLabel5.setText("家庭电话");
        jLabel5.setBounds(new Rectangle(155, 107, 71, 25));
        jLabel6.setBorder(titledBorder1);
        jLabel6.setText("移动电话");
        jLabel6.setBounds(new Rectangle(155, 149, 71, 25));
        jLabel7.setBorder(titledBorder1);
        jLabel7.setText("EMail");
        jLabel7.setBounds(new Rectangle(155, 311, 71, 25));
        jLabel8.setBorder(titledBorder1);
        jLabel8.setText("办公电话");
        jLabel8.setBounds(new Rectangle(155, 188, 71, 25));
        jLabel12.setBorder(titledBorder1);
        jLabel12.setToolTipText("");
        jLabel12.setText("公司");
        jLabel12.setBounds(new Rectangle(155, 229, 71, 25));
        jLabel13.setBorder(titledBorder1);
        jLabel13.setText("住址");
        jLabel13.setBounds(new Rectangle(155, 269, 71, 25));
        jLabel14.setBorder(titledBorder1);
        jLabel14.setText("QQ");
        jLabel14.setBounds(new Rectangle(381, 107, 38, 25));
        jLabel15.setBorder(titledBorder1);
        jLabel15.setText("姓名");
        jLabel15.setBounds(new Rectangle(155, 26, 71, 25));
        jLabel16.setBorder(titledBorder1);
        jLabel16.setText("性别");
        jLabel16.setBounds(new Rectangle(372, 26, 71, 25));
        jdbTextField1.setColumnName("Name");
        jdbTextField1.setDataSet(queryDataSet1);
        jdbTextField1.setBounds(new Rectangle(225, 26, 134, 25));
        jdbComboBox1.setColumnName("Sex");
        jdbComboBox1.setDataSet(queryDataSet1);
        jdbComboBox1.setBounds(new Rectangle(444, 26, 89, 25));
        jdbComboBox1.addItem("男");
        jdbComboBox1.addItem("女");
        jdbComboBox2.addFocusListener(new Txb_jComboBox2_focusAdapter(this));
        jdbComboBox2.setBorder(BorderFactory.createLineBorder(Color.black));
        jdbComboBox2.setColumnName("Type");
        jdbComboBox2.setDataSet(queryDataSet1);
        jdbComboBox2.setItems(null);
        jdbComboBox2.setSelectedItem(null);
        jdbComboBox2.setBounds(new Rectangle(232, 67, 73, 25));
        jButton1.setBounds(new Rectangle(313, 67, 220, 25));
        jButton1.setText("找不到你要的类型？新建一个吧");
        jButton1.addActionListener(new Txb_jButton1_actionAdapter(this));
        jdbTextField2.setColumnName("HomePho");
        jdbTextField2.setDataSet(queryDataSet1);
        jdbTextField2.setBounds(new Rectangle(227, 107, 146, 25));
        jdbTextField3.setColumnName("MobilePho");
        jdbTextField3.setDataSet(queryDataSet1);
        jdbTextField3.setBounds(new Rectangle(227, 149, 146, 25));
        jdbTextField4.setColumnName("OfficePho");
        jdbTextField4.setDataSet(queryDataSet1);
        jdbTextField4.setBounds(new Rectangle(227, 188, 146, 25));
        jdbTextField5.setColumnName("Company");
        jdbTextField5.setDataSet(queryDataSet1);
        jdbTextField5.setBounds(new Rectangle(227, 229, 146, 25));
        jdbTextField6.setColumnName("Address");
        jdbTextField6.setDataSet(queryDataSet1);
        jdbTextField6.setBounds(new Rectangle(227, 269, 146, 25));
        jdbTextField7.setColumnName("Email");
        jdbTextField7.setDataSet(queryDataSet1);
        jdbTextField7.setBounds(new Rectangle(227, 311, 146, 25));
        jdbTextField8.setColumnName("QQ");
        jdbTextField8.setDataSet(queryDataSet1);
        jdbTextField8.setBounds(new Rectangle(422, 107, 111, 25));
        jdbTextArea1.setBorder(titledBorder1);
        jdbTextArea1.setColumnName("Remarks");
        jdbTextArea1.setDataSet(queryDataSet1);
        jdbTextArea1.setBounds(new Rectangle(385, 188, 147, 148));
        jButton2.setBounds(new Rectangle(180, 352, 85, 31));
        jButton2.setBorder(titledBorder1);
        jButton2.setText("新建");
        jButton2.addActionListener(new Txb_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(319, 352, 85, 31));
        jButton3.setBorder(titledBorder1);
        jButton3.setText("修改");
        jButton3.addActionListener(new Txb_jButton3_actionAdapter(this));
        jButton4.setBounds(new Rectangle(458, 352, 85, 31));
        jButton4.setBorder(titledBorder1);
        jButton4.setText("删除");
        jButton4.addActionListener(new Txb_jButton4_actionAdapter(this));
        column1.setColumnName("ID");
        column1.setDataType(com.borland.dx.dataset.Variant.INT);
        column1.setRowId(true);
        column1.setTableName("AddrBook");
        column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column1.setServerColumnName("ID");
        column1.setSqlType(4);
        column2.setColumnName("Sex");
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setPrecision(50);
        column2.setTableName("AddrBook");
        column2.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column2.setServerColumnName("SEX");
        column2.setSqlType(12);
        column3.setColumnName("HomePho");
        column3.setDataType(com.borland.dx.dataset.Variant.STRING);
        column3.setPrecision(50);
        column3.setTableName("AddrBook");
        column3.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column3.setServerColumnName("HOMEPHO");
        column3.setSqlType(12);
        column4.setColumnName("OfficePho");
        column4.setDataType(com.borland.dx.dataset.Variant.STRING);
        column4.setPrecision(50);
        column4.setTableName("AddrBook");
        column4.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column4.setServerColumnName("OFFICEPHO");
        column4.setSqlType(12);
        column5.setColumnName("MobilePho");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);