createcarddialog.java~33~

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

    panel1.add(jButton1,  new XYConstraints(102, 368, 83, 30));
    panel1.add(jButton2,    new XYConstraints(239, 368, 83, 30));
    panel1.add(jPanel2,       new XYConstraints(16, 215, 388, 144));
    buttonGroup1.add(jRadioButton1);
    buttonGroup1.add(jRadioButton2);

    //向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();//定位到数据集的最后一行
 //   if(queryDataSet1.getprima){}
      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.last();
      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(q);

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

    }




 //   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);
  }
}