txb.java

一个个人信息管理系统

        column5.setPrecision(50);
        column5.setTableName("AddrBook");
        column5.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column5.setServerColumnName("MOBILEPHO");
        column5.setSqlType(12);
        column6.setColumnName("Email");
        column6.setDataType(com.borland.dx.dataset.Variant.STRING);
        column6.setPrecision(50);
        column6.setTableName("AddrBook");
        column6.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column6.setServerColumnName("EMAIL");
        column6.setSqlType(12);
        column7.setColumnName("QQ");
        column7.setDataType(com.borland.dx.dataset.Variant.STRING);
        column7.setPrecision(50);
        column7.setTableName("AddrBook");
        column7.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column7.setServerColumnName("QQ");
        column7.setSqlType(12);
        column8.setColumnName("Company");
        column8.setDataType(com.borland.dx.dataset.Variant.STRING);
        column8.setPrecision(50);
        column8.setTableName("AddrBook");
        column8.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column8.setServerColumnName("COMPANY");
        column8.setSqlType(12);
        column9.setColumnName("Address");
        column9.setDataType(com.borland.dx.dataset.Variant.STRING);
        column9.setPrecision(50);
        column9.setTableName("AddrBook");
        column9.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column9.setServerColumnName("ADDRESS");
        column9.setSqlType(12);
        column10.setColumnName("Remarks");
        column10.setDataType(com.borland.dx.dataset.Variant.STRING);
        column10.setSearchable(false);
        column10.setTableName("AddrBook");
        column10.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column10.setServerColumnName("REMARKS");
        column11.setColumnName("UserName");
        column11.setDataType(com.borland.dx.dataset.Variant.STRING);
        column11.setPrecision(50);
        column11.setTableName("AddrBook");
        column11.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
        column11.setServerColumnName("USERNAME");
        column11.setSqlType(12);
        jdbTextField9.setVisible(false);
        jdbTextField9.setText("jdbTextField9");
        jdbTextField9.setColumnName("UserName");
        jdbTextField9.setDataSet(queryDataSet1);
        jdbTextField9.setBounds(new Rectangle(464, 159, 93, 20));
        jButton5.setBounds(new Rectangle(422, 0, 111, 23));
        jButton5.setBorder(titledBorder2);
        jButton5.setText("整理类型");
        jButton5.addActionListener(new Txb_jButton5_actionAdapter(this));
        this.add(tableScrollPane1, null);
        this.add(jLabel1);
        this.add(jLabel2);
        this.add(jLabel15);
        this.add(jdbTextField1);
        this.add(jLabel5);
        this.add(jLabel8);
        this.add(jLabel12);
        this.add(jLabel13);
        this.add(jLabel16);
        this.add(jLabel3);
        this.add(jButton1);
        this.add(jdbTextField2);
        this.add(jLabel6);
        this.add(jdbTextField3);
        this.add(jdbTextField4);
        this.add(jdbTextField5);
        this.add(jdbTextField6);
        this.add(jLabel7);
        this.add(jdbTextField7);
        this.add(jLabel14);
        this.add(jdbTextField8);
        this.add(jLabel4);
        this.add(jdbTextArea1);
        this.add(jButton3);
        this.add(jButton4);
        this.add(jButton2);
        this.add(jdbTextField9);
        this.add(jdbComboBox2);
        this.add(jdbComboBox1);
        this.add(jButton5);
        tableScrollPane1.getViewport().add(jdbTable1);
        queryDataSet1.setColumns(new Column[] {column1, column2, column3,
                                 column4, column5, column6, column7, column8,
                                 column9, column10, column11});
       String s="select * from AddrBook where ID is not null and UserName='"+gv.Getvalue()+"'";
       ResultSet rs=dt.Rs(s);
       rs.next();
       sc=rs.getString("Type");

    }



    public void jdbComboBox2_focusGained(FocusEvent e) {
           try{
            jdbComboBox2.setSelectedItem(null);
            jdbComboBox2.removeAllItems();
            String sqlQuery="select Kind  from AddrKind";
            Dataset2 dataset2=new Dataset2();
            jdbComboBox2.addItem("");
         ResultSet rs2=dataset2.Rs(sqlQuery);
         while (rs2.next()) {
                jdbComboBox2.addItem(rs2.getString(1));
         }
       // System.out.print(queryDataSet1.getString("Type")+"23");
      jdbComboBox2.setSelectedItem(queryDataSet1.getString("Type"));
       }
       catch (Exception exception) {
         exception.printStackTrace();
       }
     }

     public void jButton2_actionPerformed(ActionEvent e) {
         System.out.println(sc);
     queryDataSet1.insertRow(false);

    }

    public void jButton4_actionPerformed(ActionEvent e) {
        try{
           queryDataSet1.deleteRow();
           queryDataSet1.post();
           queryDataSet1.saveChanges();
           queryDataSet1.refresh();
           JOptionPane.showMessageDialog(this,"删除成功！","提示",JOptionPane.PLAIN_MESSAGE);
         }catch(Exception ex){
           queryDataSet1.refresh();
           JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.ERROR_MESSAGE);
         }

    }

    public void jButton3_actionPerformed(ActionEvent e) {
      if(jdbTextField1.getText().equals("")){
       JOptionPane.showMessageDialog(this,"请先输入姓名！","提示",JOptionPane.PLAIN_MESSAGE);
     }
      else if(jdbComboBox2.getSelectedIndex()==0){
       JOptionPane.showMessageDialog(this,"请输入类型！","提示",JOptionPane.PLAIN_MESSAGE);
      }
        else{
        jdbTextField9.setText(gv.Getvalue());
        queryDataSet1.post();
        queryDataSet1.saveChanges();
        queryDataSet1.refresh();
        JOptionPane.showMessageDialog(this,"修改成功！","提示",JOptionPane.PLAIN_MESSAGE);
        queryDataSet1.refresh();
        }
    }

    public void jButton1_actionPerformed(ActionEvent e) {
     AddKind ak=new AddKind();

     mid.setLocation2(ak);
    }

    public void jButton5_actionPerformed(ActionEvent e) {
        CleanTxb ct=new CleanTxb();
        mid.setLocation2(ct);
    }


}


class Txb_jButton5_actionAdapter implements ActionListener {
    private Txb adaptee;
    Txb_jButton5_actionAdapter(Txb adaptee) {
        this.adaptee = adaptee;
    }

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


class Txb_jButton1_actionAdapter implements ActionListener {
    private Txb adaptee;
    Txb_jButton1_actionAdapter(Txb adaptee) {
        this.adaptee = adaptee;
    }

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


class Txb_jButton3_actionAdapter implements ActionListener {
    private Txb adaptee;
    Txb_jButton3_actionAdapter(Txb adaptee) {
        this.adaptee = adaptee;
    }

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


class Txb_jButton4_actionAdapter implements ActionListener {
    private Txb adaptee;
    Txb_jButton4_actionAdapter(Txb adaptee) {
        this.adaptee = adaptee;
    }

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


class Txb_jButton2_actionAdapter implements ActionListener {
    private Txb adaptee;
    Txb_jButton2_actionAdapter(Txb adaptee) {
        this.adaptee = adaptee;
    }

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


class Txb_jComboBox2_focusAdapter extends FocusAdapter {
     private Txb adaptee;
     Txb_jComboBox2_focusAdapter(Txb adaptee) {
         this.adaptee = adaptee;
     }

     public void focusGained(FocusEvent e) {
         adaptee.jdbComboBox2_focusGained(e);
     }
}