querypanel.java

供初学者学习用的JBUILDER制作的非常简单的信用卡管理系统

package card;

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


public class queryPanel extends JPanel {
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  private String CardID;
  private String UserName;

  public queryPanel(String Name,String ID) {
    try {
      UserName = Name;
      CardID = ID;
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }
  void jbInit() throws Exception {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String url = "jdbc:odbc:creditCard";
    Connection con = DriverManager.getConnection(url,"","");
    Statement stat = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
    ResultSet rs =stat.executeQuery("select LeaveMoney from card where CardID = '"+CardID+"'");
    //ResultSet rs =stat.executeQuery("select LeaveMoney from card where CardID = '111111111'");
    rs.beforeFirst();
    rs.next();

    jLabel1.setBackground(SystemColor.activeCaption);
    jLabel1.setFont(new java.awt.Font("Dialog", 1, 20));
    jLabel1.setForeground(Color.blue);
    jLabel1.setText("用户名：");
    jLabel1.setBounds(new Rectangle(51, 57, 101, 37));
    this.setLayout(null);
    jLabel2.setFont(new java.awt.Font("Dialog", 1, 20));
    jLabel2.setForeground(Color.blue);
    jLabel2.setText(UserName);
    jLabel2.setBounds(new Rectangle(146, 57, 148, 50));
    jLabel3.setBounds(new Rectangle(51, 96, 104, 50));
    jLabel3.setFont(new java.awt.Font("Dialog", 1, 20));
    jLabel3.setForeground(Color.blue);
    jLabel3.setText("卡    号：");
    jLabel4.setFont(new java.awt.Font("Dialog", 1, 20));
    jLabel4.setForeground(Color.blue);
    jLabel4.setText(CardID);
    jLabel4.setBounds(new Rectangle(145, 102, 146, 37));
    jLabel5.setBounds(new Rectangle(51, 142, 137, 50));
    jLabel5.setFont(new java.awt.Font("Dialog", 1, 20));
    jLabel5.setForeground(Color.blue);
    jLabel5.setText("余    额：");
    jLabel6.setFont(new java.awt.Font("Dialog", 1, 20));
    jLabel6.setForeground(Color.blue);
    jLabel6.setText(rs.getFloat(1)+"");
    jLabel6.setBounds(new Rectangle(146, 151, 91, 37));
    this.add(jLabel3, null);
    this.add(jLabel5, null);
    this.add(jLabel1, null);
    this.add(jLabel6, null);
    this.add(jLabel2, null);
    this.add(jLabel4, null);

  }
}