welpanel.java~23~

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

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(92, 36, 105, 43));
    jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel3.setBounds(new Rectangle(107, 117, 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));
    bankname.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
    bankname.setBounds(new Rectangle(196, 36, 64, 43));
    jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 18));
    jLabel2.setText("银 行");
    jLabel2.setBounds(new Rectangle(259, 36, 99, 43));
    this.add(jLabel1);
    this.add(jLabel3, null);
    this.add(jLabel2);
    this.add(jLabel5, null);
    this.add(bankname,null);
    con = bankconnect.getconn();
    String a;
    Statement stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery("select customer_first,customer_mi,customer_last from customer where customer_id ="+CardID);
    //ResultSet rt=stmt.executeQuery("select branch_name from branch ");//查找银行名字
     rs.next();
    a=rs.getString("customer_first")+rs.getString("customer_mi")+rs.getString("customer_last");
    jLabel3.setText(a);
   // bankname.setText(rs.getString("branch_name"));//修改中
    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();
  JLabel bankname = new JLabel();
  JLabel jLabel2 = new JLabel();
}