setmoneypanel.java

银行管理系统,根据实习的要求以及参考现实中的银行数据库系统

package bank;
import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.awt.Font;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;

import java.sql.Statement;
import java.sql.Connection;
import java.sql.SQLException;
import java.awt.SystemColor;
import java.awt.Color;
import java.sql.*;
import java.util.*;

//存钱界面................
public class SetMoneyPanel extends JPanel implements ActionListener{
  public SetMoneyPanel(String accountID,String branchname,String pswd){
    try {
      jbInit();
      this.accountID=MoneyDia.accountID;
     this.branchname=MoneyDia.branchname;
     this.pswd=MoneyDia.pswd;

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


  private void jbInit() throws Exception {
    jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
    this.setLayout(xYLayout1);
    jButton1.setText("存取");
    jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
    jLabel1.setText("金额：");
    jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
    jButton2.setText("重置");
    jButton2.addActionListener(new SetMoneyPanel_jButton2_actionAdapter(this));
    jTextArea1.setEditable(false);
    jTextArea1.setLineWrap(true);//设置换行
    jTextArea1.setColumns(8);//设置每行的个数
    this.setBackground(new Color(255, 225, 185));
    jButton3.setText("打印信息");
    jButton3.addActionListener(new SetMoneyPanel_jButton3_actionAdapter(this));
    jButton3.setVisible(false);
    this.add(jLabel1, new XYConstraints(20, 35, 100, 43));
    this.add(jLabel1, new XYConstraints(29, 31, 82, 43));
    this.add(jTextArea1, new XYConstraints(28, 85, 301, 128));
    this.add(jTextField1, new XYConstraints(117, 38, 140, 36));
    this.add(jButton2, new XYConstraints(295, 230, 79, 34));
    this.add(jLabel1, new XYConstraints(28, 39, 76, 38));
    this.add(jButton3, new XYConstraints(74, 230, 80, 34));
    this.add(jButton1, new XYConstraints(184, 230, 81, 34));
    jButton1.addActionListener(this);
  }

  XYLayout xYLayout1 = new XYLayout();
  JButton jButton1 = new JButton();
  JLabel jLabel1 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JTextArea jTextArea1 = new JTextArea();
  JButton jButton2 = new JButton();
  private static String accountID;
  private static String branchname;
  private String pswd;
  private Float bal;
  private Statement stmt;
  private Connection con;
  JButton jButton3 = new JButton();
  private float le=0;
  public void actionPerformed(ActionEvent e)
  {
    if(e.getSource()==jButton2){
      jTextField1.setText("");
      jTextArea1.setText("");
    }
    else{

      try{
        bal=Float.valueOf(jTextField1.getText().trim());
        le=bal.floatValue()/1000; //信用值的增加
        con = bankconnect.getconn();
        stmt = con.createStatement();
         //要进行停电处理。。。
         try{
           con.setAutoCommit(false);
         //  String today=PayForPanel.gettime(TodayTime.getDate());
           double b=0;
           ResultSet rs=stmt.executeQuery("select balance,last_time from account where account_num="+accountID);
            while(rs.next()){
                  String amount=rs.getString("balance");
                 java.util.Date lasttime=rs.getDate("last_time");
                 Calendar   c1=Calendar.getInstance();
                  c1.setTime(lasttime);
                 Calendar   c2=Calendar.getInstance();
                  c2.setTime(new java.util.Date());
                 int   days=(int)((c2.getTimeInMillis()-c1.getTimeInMillis())/(1000*60*60*24));
                  b=Double.parseDouble(amount);
                  b=Float.parseFloat(bal.toString())+b+b*days*0.003;
               }
             String sql = "update account set last_time=getdate()"+"where account_num="+accountID;
            stmt.executeUpdate(sql);
            stmt.executeUpdate("update account set balance="+b+"where account_num="+accountID);//update
           jTextArea1.append("今天是：" + TodayTime.getLongDate() + "已经成功存" + bal +
                             "钱，谢谢光临！");
           sql = "insert into message(account_num,message_context,message_time,message_class) values('" +
               accountID + "','" + jTextArea1.getText() + "','" +
               TodayTime.getLongDate() + "',1)";
           //打印信息。。。
           stmt.executeUpdate(sql);
           sql="select customer_id from depositor where account_num="+accountID;
            rs= stmt.executeQuery(sql);
           String a="";//找出客户的ID
          while(rs.next()){
            a=rs.getString("customer_id");
          }
          //稍微加点信用值
           sql="update customer set customer_lever=customer_lever+"+le+" where customer_id like'%"+a+"%'";
           stmt.executeUpdate(sql);
           jButton3.setVisible(true);
           con.commit();
           con.setAutoCommit(true);
           JOptionPane.showMessageDialog(null,"操作成功！");
           jButton3.setVisible(true);
           jButton1.setVisible(true);
           con.close();
           return ;
         }
         catch(Exception exp){
           con.rollback();
           con.close();
           exp.printStackTrace();
         }
      }
      catch(SQLException ex){
         System.out.println("数据库连接错误！"+ex.toString());
      }

    }
  }

  public void jButton3_actionPerformed(ActionEvent e) {
      JOptionPane.showMessageDialog(null,"打印成功！");
      jButton3.setVisible(false);
      jButton1.setVisible(true);
  }

  public void jButton2_actionPerformed(ActionEvent e) {
        jButton3.setVisible(false);
        jTextArea1.setText("");
        jTextField1.setText("");
        jButton1.setVisible(true);
  }
}

class SetMoneyPanel_jButton2_actionAdapter
    implements ActionListener {
  private SetMoneyPanel adaptee;
  SetMoneyPanel_jButton2_actionAdapter(SetMoneyPanel adaptee) {
    this.adaptee = adaptee;
  }

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

class SetMoneyPanel_jButton3_actionAdapter
    implements ActionListener {
  private SetMoneyPanel adaptee;
  SetMoneyPanel_jButton3_actionAdapter(SetMoneyPanel adaptee) {
    this.adaptee = adaptee;
  }

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