savepanel.java~33~

这是一个关于信用卡的JAVA

package xinyongka;

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.lang.Number.*;
import java.util.*;
import java.text.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Font;
import java.awt.event.MouseEvent;

public class savepanel
    extends JPanel {
  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();

  private String cardid;
  private String username;
  private String url;
  private Connection conn;
  private java.text.SimpleDateFormat today;
  private eventframe eventframe1;
  public savepanel(String id, String name,eventframe frame1) {
    try {
      cardid = id;
      username = name;
      eventframe1=frame1;
      jbInit();
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
   // eventframe eventframe1=new eventframe(cardid);
    this.setLayout(xYLayout1);
    jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel1.setText("用户名：");
    jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel2.setText("卡  号：");
    jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel3.setText("存  额：");
    jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel4.setText(username);
    jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel5.setText(cardid);
    jTextField1.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jTextField1.setText("");
    jButton1.setText("确定");
    jButton1.addActionListener(new savepanel_jButton1_actionAdapter(this));
    jButton2.setText("重置");
    jButton2.addActionListener(new savepanel_jButton2_actionAdapter(this));

    this.add(jLabel1, new XYConstraints(85, 55, 65, 35));
    this.add(jLabel2, new XYConstraints(85, 115, 65, 35));
    this.add(jLabel3, new XYConstraints(85, 175, 65, 35));
    this.add(jLabel4, new XYConstraints(165, 55, 100, 35));
    this.add(jLabel5, new XYConstraints(165, 115, 100, 35));
    this.add(jTextField1, new XYConstraints(165, 175, 100, 35));
    this.add(jButton1, new XYConstraints(80, 245, 80, 28));
    this.add(jButton2, new XYConstraints(180, 245, 80, 28));
  }

  public void jButton2_actionPerformed(ActionEvent e) {
    jTextField1.setText("");
  }

  public void jButton1_actionPerformed(ActionEvent e) {

    try {
      today = new java.text.SimpleDateFormat("yyyy-MM-dd", java.util.Locale.US);
      url = "jdbc:odbc:dbcard1";
      conn = DriverManager.getConnection(url, "", "");
      Statement event=conn.createStatement();
      Statement update=conn.createStatement();
      String eventsql="insert into event (CardID,EventMoney,EventDate) values ('"+cardid
          +"','"+jTextField1.getText().trim()+"','"+today.format(new java.util.Date())+"')";
      String updateString = "update card set LeaveMoney = LeaveMoney + '"+
      Integer.parseInt(jTextField1.getText().trim())+"' where CardID = '"+cardid+"'";

      event.executeUpdate(eventsql);
      update.executeUpdate(updateString);


    }
    catch (Exception e3) {
      e3.printStackTrace();
    }
  // JOptionPane.showMessageDialog(null,"querypanel");
   eventframe1.toquery();
  }
}

class savepanel_jButton1_actionAdapter
    implements ActionListener {
  private savepanel adaptee;
  savepanel_jButton1_actionAdapter(savepanel adaptee) {
    this.adaptee = adaptee;
  }

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

class savepanel_jButton2_actionAdapter
    implements ActionListener {
  private savepanel adaptee;
  savepanel_jButton2_actionAdapter(savepanel adaptee) {
    this.adaptee = adaptee;
  }

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