package card;import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.*;import java.lang.Number.*;import java.util.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class getPanel extends JPanel {  JLabel jLabel1 = new JLabel();  JLabel jLabel2 = new JLabel();  JLabel jLabel3 = new JLabel();  JTextField jTextField1 = new JTextField();  JButton jButton1 = new JButton();  JButton jButton2 = new JButton();  public getPanel(String Name,String ID,Connection connection1,eventFrame Frame1) {    try {      UserName = Name;      CardID = ID;      con = connection1;      eventFrame = Frame1;      jbInit();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  void jbInit() throws Exception {    this.setPreferredSize(new Dimension(300, 300));    this.setLayout(null);    jLabel1.setFont(new java.awt.Font("Serif", 1, 18));    jLabel1.setForeground(Color.blue);    jLabel1.setText("用  戶  名：");    jLabel1.setBounds(new Rectangle(65, 30, 100, 30));    jLabel2.setFont(new java.awt.Font("Serif", 1, 18));    jLabel2.setText(UserName);    jLabel2.setBounds(new Rectangle(165, 30, 100, 30));    jLabel3.setFont(new java.awt.Font("Serif", 1, 18));    jLabel3.setForeground(Color.blue);    jLabel3.setText("支取數額：");    jLabel3.setBounds(new Rectangle(65, 100, 100, 30));    jTextField1.setText("0");    jTextField1.setBounds(new Rectangle(165, 100, 100, 25));    jButton1.setBounds(new Rectangle(70, 210, 70, 25));    jButton1.setText("確定");    jButton1.addActionListener(new getPanel_jButton1_actionAdapter(this));    jButton2.setBounds(new Rectangle(160, 210, 70, 25));    jButton2.setText("重置");    jButton2.addActionListener(new getPanel_jButton2_actionAdapter(this));    this.add(jLabel1, null);    this.add(jLabel2, null);    this.add(jTextField1, null);    this.add(jButton1, null);    this.add(jButton2, null);    this.add(jLabel3, null);    today = new java.text.SimpleDateFormat("yyyy-MM-dd", java.util.Locale.US);    getInsert =con.createStatement();    getUpdate =con.createStatement();    insertString = "insert event (CardID,EventMoney,EventDate) values ("+CardID+","+Integer.parseInt("-"+jTextField1.getText())+","+today.format(new java.util.Date())+")";    updateString = "update card set LeaveMoney = LeaveMoney - "+Integer.parseInt(jTextField1.getText())+" where CardID = "+CardID;  }  void jButton2_actionPerformed(ActionEvent e) {    jTextField1.setText("");  }  void jButton1_actionPerformed(ActionEvent e) {    try{      getInsert.executeUpdate(insertString);      getUpdate.executeUpdate(updateString);      eventFrame.toquery();    }    catch(SQLException ex){      System.out.print("系統錯誤，請檢測數據庫");    }  }  private String CardID;  private Connection con;  private String UserName;  private Statement getUpdate;  private Statement getInsert;  private java.text.SimpleDateFormat today;  private eventFrame eventFrame;  private String updateString;  private String insertString;}class getPanel_jButton2_actionAdapter implements java.awt.event.ActionListener {  getPanel adaptee;  getPanel_jButton2_actionAdapter(getPanel adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton2_actionPerformed(e);  }}class getPanel_jButton1_actionAdapter implements java.awt.event.ActionListener {  getPanel adaptee;  getPanel_jButton1_actionAdapter(getPanel adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton1_actionPerformed(e);  }}