querypanel.java~60~

这是一个关于信用卡的JAVA

package xinyongka;

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.awt.Font;

public class querypanel
    extends JPanel {
  XYLayout xYLayout1 = new XYLayout();
  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 ResultSet rs;
  private String username;
  private String leavemoney;
  private eventframe frame1;

  public querypanel(String id,String name,eventframe frame) {
    try {
      cardid=id;
      username=name;
      frame1=frame;
      jbInit();
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    this.setLayout(xYLayout1);
    jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel1.setHorizontalAlignment(SwingConstants.LEFT);
    jLabel1.setText("卡  号：");
    jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel2.setHorizontalAlignment(SwingConstants.LEFT);
    jLabel2.setText("余  额：");
    jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel3.setHorizontalAlignment(SwingConstants.LEFT);
    jLabel3.setText(cardid);
    jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel6.setHorizontalAlignment(SwingConstants.LEFT);
    jLabel6.setText(username);
    try{
      String url = "jdbc:odbc:dbcard";
      Connection conn1 = DriverManager.getConnection(url, " ", " ");
      Statement stmt1 = conn1.createStatement();
      String querysql = "Select leavemoney from card where CardID=" +cardid;
      rs = stmt1.executeQuery(querysql);
      rs.next();
      //关闭数据库连接
      //rs.close();
      //stmt1.close();
      //conn1.close();

    }catch(Exception e2){
      e2.printStackTrace();
    }
    jLabel4.setText(rs.getString("leavemoney"));
    jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel5.setHorizontalAlignment(SwingConstants.LEFT);
    jLabel5.setText("用户名：");
    jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel4.setHorizontalAlignment(SwingConstants.LEFT);
    this.add(jLabel5, new XYConstraints(85, 55, 65, 35));
    this.add(jLabel1, new XYConstraints(85, 115, 65, 35));
    this.add(jLabel2, new XYConstraints(85, 175, 65, 35));

    this.add(jLabel6, new XYConstraints(165, 55, 100, 35));
    this.add(jLabel3, new XYConstraints(165, 115, 100, 35));
    this.add(jLabel4, new XYConstraints(165, 175, 100, 35));

  }

}