check.java

一个java+sql2000开发的网吧管理系统

package com.jbaptech.accp.netbar.client;

import java.sql.*;


//查询卡号是否存在,在上机界面CheckInPanel按下确定是调用此类的方法

public class Check {
  public Check() {
  }

  //检查卡号是否存在
  public int checkUserName(String UserName){
    try{
      Connection con = ConnectionManager.getConnection();
      String sql = "select * from Card where id ='"+UserName+"'";
      Statement s = con.createStatement();
      ResultSet rs = s.executeQuery(sql);
      while(!rs.next()){
        con.close();
        return 0;                     //不存在时返回0
      }

      con.close();
    }catch (SQLException ce){
      ce.printStackTrace();
    }
    return 1;                          //存在时返回1
  }

  //查询密码是否正确
  public int checkPassword(String Password){
    try{
     Connection con = ConnectionManager.getConnection();
     String sql = "select * from Card where Password ='"+Password+"'";
     Statement s = con.createStatement();
     ResultSet rs = s.executeQuery(sql);
     while(!rs.next()){
       con.close();
       return 0;                         //不正确返回0
     }

     con.close();
   }catch (SQLException ce){
     ce.printStackTrace();
   }
   return 1;                              //正确返回1

  }


}