staticmessage.java

J2SE实现信用卡管理系统,适合新手学习使用

package card;

import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
/**
 * 获取静态信息的辅助类
 */
public class StaticMessage
{
  String queryString;
  Connection con;
  Statement query;
  ResultSet rs;
  String CardID;
  String userName;
  String leftMoney;
  boolean exist = false;

  public StaticMessage(String id)
  {
    this.CardID=id;
    try
    {
      con = CardConnect.getconn();
      query = con.createStatement();
      queryString = "Select LeaveMoney,Name From queryview Where CardID=" + CardID;
      rs = query.executeQuery( queryString ); //得到查询结果
      if( rs.next() )
      {
        leftMoney=rs.getString(1);
        userName=rs.getString(2);
        exist=true;
      }
    }catch(Exception ee)
    {}
    finally
    {
      CardConnect.close(rs);
      CardConnect.close(query);
      CardConnect.close(con);
    }
  }

  public boolean isExist()
  {
    return exist;
  }
  public  String getUserName()
  {
    return userName;
  }
  public  String getLeftMoney()
  {
    return leftMoney;
  }
}