welpanel.java~19~

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

package bank;

import java.awt.*;
import javax.swing.*;
import java.sql.*;
import java.awt.Rectangle;
import java.awt.Font;

public class welpanel extends JPanel {
  public welpanel(interFrame mFrame1,int ID) {
    try {
      Frame1 = mFrame1;
      CardID = ID;
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }
  void jbInit() throws Exception {
    this.setLayout(null);
    jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
    jLabel5.setText("欢迎光临地大银行");
    jLabel5.setBounds(new Rectangle(103, 45, 154, 43));
    jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel3.setBounds(new Rectangle(107, 124, 157, 42));
    this.setBackground(new Color(236, 0, 80));
    jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel1.setText("客户：");
    jLabel1.setBounds(new Rectangle(49, 119, 59, 47));
    this.add(jLabel5,null);
    this.add(jLabel1);
    this.add(jLabel3, null);
    con = bankconnect.getconn();
    String a,b;
    Statement stmt = con.createStatement();
    b="a"+"f";
    ResultSet rs = stmt.executeQuery("select customer_first,customer_mi,customer_last from customer where customer_id ="+CardID);
    rs.next();
    a=rs.getString("customer_first")+rs.getString("customer_mi")+rs.getString("customer_last");
    jLabel3.setText(a);
    //jLabel2.setText(rs.getString("customer_mi"));
   // jLabel4.setText(rs.getString("customer_last"));
    con.close();
    Frame1.login_false();
    Frame1.SetCardID(0);
  }

  private interFrame Frame1;
  private Connection con;
  private int CardID;
  JLabel jLabel5 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel1 = new JLabel();
}