checkbalancepane.java

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

package bank;

import javax.swing.*;
import java.awt.Color;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.*;
import java.util.Calendar;
import java.text.*;

public class CheckBalancePane extends JPanel{
  public CheckBalancePane(String accountID,String branchname,String pswd)
  {
    try {
      jbInit();
      this.accountID=accountID;
      this.pswd=pswd;
      this.branchname=branchname;
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }
    private Connection con;
    private  Statement  stmt;
    private String accountID;
    private String branchname;
  private String pswd;
  private void jbInit() throws Exception {
    this.setBackground(new Color(176, 227, 255));
    this.setLayout(xYLayout1);
    jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel1.setText("余 额：");
    jButton1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
    jButton1.setText("确定");
    jButton1.addActionListener(new CheckBalancePane_jButton1_actionAdapter(this));
    this.add(jLabel1, new XYConstraints(31, 42, 91, 53));
    this.add(jTextField1, new XYConstraints(114, 83, 153, 34));
    this.add(jButton1, new XYConstraints(266, 161, 83, 34));
  }

  JLabel jLabel1 = new JLabel();
  XYLayout xYLayout1 = new XYLayout();
  JTextField jTextField1 = new JTextField();
  JButton jButton1 = new JButton();
  public void jButton1_actionPerformed(ActionEvent e) {
      try{
        con=bankconnect.getconn();
        stmt=con.createStatement();
        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=b+b*days*0.0003;//这个利率自定的
         }
         jTextField1.setText(b+"RMB");
         String sql = "update account set last_time='"+TodayTime.getLongDate()+"' where account_num="+accountID;
          stmt.executeUpdate(sql);
         stmt.executeUpdate("update account set balance="+b+"where account_num="+accountID);//update

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

class CheckBalancePane_jButton1_actionAdapter
    implements ActionListener {
  private CheckBalancePane adaptee;
  CheckBalancePane_jButton1_actionAdapter(CheckBalancePane adaptee) {
    this.adaptee = adaptee;
  }

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