moneylogpanel.java~1~

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

package bank;

import javax.swing.*;
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.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;

public class MoneyLogPanel extends JPanel{
  public MoneyLogPanel() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jTextField1.addActionListener(new
                                  GetMoneyLogPanel_jTextField1_actionAdapter(this));
    jButton1.setText("确定");
    jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jLabel4.setText("密码：");
    jPasswordField1.setText("1");
    jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jLabel5.setText("存款卡类型：");
    this.add(jLabel3, new XYConstraints(70, 70, -1, -1));
    jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    this.add(jLabel2, new XYConstraints(50, 50, -1, -1));
    this.setLayout(xYLayout1);
    jButton2.setText("重置");
    jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
    jLabel1.setText("卡号：");
    this.add(jLabel5, new XYConstraints(37, 36, -1, -1));
    this.add(jComboBox1, new XYConstraints(149, 34, 142, 33));
    this.add(jTextField1, new XYConstraints(150, 88, 140, 32));
    this.add(jPasswordField1, new XYConstraints(154, 147, 136, 42));
    this.add(jLabel4, new XYConstraints(50, 165, -1, -1));
    this.add(jLabel1, new XYConstraints(45, 95, 57, 27));
    this.add(jButton2, new XYConstraints(234, 232, 78, 37));
    this.add(jButton1, new XYConstraints(87, 235, 77, 36));
    try{

     con = bankconnect.getconn();
     Statement stmt = con.createStatement();
     ResultSet rs = stmt.executeQuery("select  branch_name from branch");
     String a;
    while(rs.next())//一行行的移
    {

      a=rs.getString("branch_name");
      jComboBox1.addItem(a);

    }
        rs.close();
        con.close();
         this.hide();
        return;
    }
 catch(SQLException ex)
{
  System.out.print("数据库连接出错！"+ex.toString());
}

  }
 // private String name;
//  private String city;
//  private String bankname;
//  private String mima;
//  private static int customer_id=100;
  private Connection con;
  XYLayout xYLayout1 = new XYLayout();
  JButton jButton2 = new JButton();
  JLabel jLabel1 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel3 = new JLabel();
  JButton jButton1 = new JButton();
  JLabel jLabel4 = new JLabel();
  JPasswordField jPasswordField1 = new JPasswordField();
  JLabel jLabel5 = new JLabel();
  public void jTextField1_actionPerformed(ActionEvent e) {

  }
}

class MoneyLogPanel_jTextField1_actionAdapter
    implements ActionListener {
  private MoneyLogPanel adaptee;
  MoneyLogPanel_jTextField1_actionAdapter(MoneyLogPanel adaptee) {
    this.adaptee = adaptee;
  }

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