createcarddialog.java~39~

基于数据库组件的系统开发的实例

    //向jComboBox1中添加条目
    for(int i=1;i<=12;i++){
      jComboBox1.addItem(i+"");
    }
  }


  void jRadioButton2_itemStateChanged(ItemEvent e) {
     jComboBox1.setEnabled(false);
     jTextField3.setEditable(false);
     jTextField4.setEditable(false);
     jTextField5.setEditable(false);
  }

  void jRadioButton1_itemStateChanged(ItemEvent e) {
     jComboBox1.setEnabled(true);
     jTextField3.setEditable(true);
     jTextField4.setEditable(true);
     jTextField5.setEditable(true);

  }

  void jButton2_actionPerformed(ActionEvent e) {
    jTextField1.setText("");
    jPasswordField1.setText("");
    jTextField2.setText("");
    jTextField3.setText("");
    jTextField4.setText("");
    jTextField5.setText("");
  }

  void jButton1_actionPerformed(ActionEvent e) {
    /*int cardID=Integer.parseInt(jTextField1.getText().trim());
    String password=jPasswordField1.getText();
    String carNum="";
    int month=0;
    String owerName="";
    String telephone="";
    String address="";
    if(jRadioButton1.isSelected()){
      carNum=jTextField2.getText();
      month=Integer.parseInt(jComboBox1.getSelectedItem().toString());
      owerName=jTextField3.getText();
      telephone=jTextField4.getText();
      address=jTextField5.getText();


      //插入一条记录
      queryDataSet1.last();//定位到数据集的最后一行

      queryDataSet1.insertRow(false);//在最后添加一条记录
      queryDataSet1.setInt("CardID",cardID);

      queryDataSet1.setString("Password",password);
      queryDataSet1.setString("CardType","长期卡");
      queryDataSet1.setString("CarNum",carNum);

      java.util.Date now=new java.util.Date();
      Timestamp t=new Timestamp(now.getTime());
      t.setMonth(t.getMonth()+Integer.parseInt(jComboBox1.getSelectedItem().toString()));
      queryDataSet1.setTimestamp("TimeLimit",t);


      queryDataSet2.insertRow(false);
      queryDataSet2.setString("OwerName",owerName);
      queryDataSet2.setString("Telephone",telephone);
      queryDataSet2.setString("Address",address);
      queryDataSet2.setInt("CardID",cardID);

      QueryDataSet q[]={queryDataSet1,queryDataSet2};
      database.saveChanges(queryDataSet1);
      database.saveChanges(queryDataSet2);
     // database.saveChanges(q,true);

//database.saveChanges(queryDataSet2);

      JOptionPane.showMessageDialog(this,"成功插入记录！");


    }*/

      queryDataSet2.insertRow(false);
      queryDataSet2.setString("OwerName","胡");
      queryDataSet2.setString("Telephone","137");
      queryDataSet2.setString("Address","gg");
      queryDataSet2.setInt("CardID",11111111);

      QueryDataSet q[]={queryDataSet1,queryDataSet2};
      database.saveChanges(queryDataSet1);
      database.saveChanges(queryDataSet2);





 //   int cardID=Integer.parseInt(jTextField1.getText().trim());
   // String password=jPasswordField1.getText();
   // String carNum=jTextField2.getText().trim();
  /*  String cardType="长期卡";
    java.util.Date now=new java.util.Date();



    queryDataSet1.insertRow(false);
    queryDataSet1.setInt("CardID",cardID);
    queryDataSet1.setString("Password",password);
    queryDataSet1.setString("CardType",cardType);
    queryDataSet1.setString("CarNum",carNum);
    queryDataSet1.setTimestamp("TimeLimit",now.getTime());

    queryDataSet2.insertRow(false);
   queryDataSet2.setInt("CardID",cardID);
    queryDataSet2.setString("OwerName",owerName);
    queryDataSet2.setString("Telephone",telephone);
    queryDataSet2.setString("Address",address);

    database.saveChanges(queryDataSet1);
    database.saveChanges(queryDataSet2);*/
}

  void jRadioButton1_actionPerformed(ActionEvent e) {
    jTextField2.setEditable(true);
    jComboBox1.setEnabled(true);
    jTextField3.setEditable(true);
    jTextField4.setEditable(true);
    jTextField5.setEditable(true);
  }

  void jRadioButton2_actionPerformed(ActionEvent e) {
      jTextField2.setEditable(false);
      jComboBox1.setEnabled(false);
      jTextField3.setEditable(false);
      jTextField4.setEditable(false);
      jTextField5.setEditable(false);
  }

  void jComboBox1_actionPerformed(ActionEvent e) {
    queryDataSet3.open();
    int month=Integer.parseInt(jComboBox1.getSelectedItem().toString());
    java.math.BigDecimal l;
    double money=queryDataSet3.getBigDecimal("Price").doubleValue()*month;
    jLabel7.setText(money+"");
    queryDataSet3.close();
  }





}



class CreateCardDialog_jButton2_actionAdapter implements java.awt.event.ActionListener {
  CreateCardDialog adaptee;

  CreateCardDialog_jButton2_actionAdapter(CreateCardDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}


class CreateCardDialog_jButton1_actionAdapter implements java.awt.event.ActionListener {
  CreateCardDialog adaptee;

  CreateCardDialog_jButton1_actionAdapter(CreateCardDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class CreateCardDialog_jRadioButton1_actionAdapter implements java.awt.event.ActionListener {
  CreateCardDialog adaptee;

  CreateCardDialog_jRadioButton1_actionAdapter(CreateCardDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jRadioButton1_actionPerformed(e);
  }
}

class CreateCardDialog_jRadioButton2_actionAdapter implements java.awt.event.ActionListener {
  CreateCardDialog adaptee;

  CreateCardDialog_jRadioButton2_actionAdapter(CreateCardDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jRadioButton2_actionPerformed(e);
  }
}

class CreateCardDialog_jComboBox1_actionAdapter implements java.awt.event.ActionListener {
  CreateCardDialog adaptee;

  CreateCardDialog_jComboBox1_actionAdapter(CreateCardDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox1_actionPerformed(e);
  }
}