getpanel.java~28~

这是一个关于信用卡的JAVA

package xinyongka;

import java.awt.*;
import javax.swing.*;
import java.sql.*;
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.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.Font;

public class getpanel
    extends JPanel {

  private String url;
  private Connection conn;
  private java.text.SimpleDateFormat today;
  ResultSet rs;

  private eventframe eventframe1;
  private String cardid;
  private String username;
  private int lea_money;
  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();
  public getpanel(String id, String name,eventframe eventframe,int leavemoney) {
    try {
      cardid=id;
      username=name;
      eventframe1=eventframe;
      this.lea_money=leavemoney;
      jbInit();
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    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.setToolTipText("");
    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);
    jButton1.setText("确定");
    jButton1.addMouseListener(new getpanel_jButton1_mouseAdapter(this));
    jButton2.setText("重置");
    jTextField1.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    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 jButton1_mouseClicked(MouseEvent e) {
    try {
      if(lea_money<Integer.parseInt(jTextField1.getText().trim()))
      {
        JOptionPane.showMessageDialog(null,"您的余额不足");

      }else{
      today = new java.text.SimpleDateFormat("yyyy-MM-dd", java.util.Locale.US);
      url = "jdbc:odbc:dbcard";
      conn = DriverManager.getConnection(url, "", "");
      Statement event=conn.createStatement();
      Statement update=conn.createStatement();

      String eventsql = "insert event (CardID,EventMoney,EventDate) values ("+cardid+","+Integer.parseInt("-"+
          jTextField1.getText())+",'"+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);

      rs.close();
      event.close();
      update.close();
      conn.close();
      eventframe1.toquery();
    }

    }
    catch (Exception e3) {
      e3.printStackTrace();
    }



  }
}

class getpanel_jButton1_mouseAdapter
    extends MouseAdapter {
  private getpanel adaptee;
  getpanel_jButton1_mouseAdapter(getpanel adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.jButton1_mouseClicked(e);
  }
}