reader.java.bak

图书管理系统,可以查询 图书管理系统,可以查询

import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.net.*;
import java.lang.*;
import java.util.*;

public class Reader{
    String ID;
    String password;
    String name;    
    String classcode;
    boolean isActive=false;
    Connection con = DBAccess.getConnection();
    
    
    public String getID(){
        return ID;
    }
    public String getpassword(){
        return password;
    }    
    public String getname(){
        return name;
    }
    public String getclasscode(){
        return classcode;
    }
    public boolean getisActive(){
        return isActive;
    }
    
    public void setID(String ID){
        this.ID = ID;
    }
    public void setpassword(String password){
        this.password = password;
    }    
    public void setname(String name){
        this.name = name;
    }    
    public void setclasscode(String classcode){
        this.classcode = classcode;
    }
    public void setisActive(boolean isActive){
        this.isActive = isActive;
    }   
    

    public boolean checkReader(String id, String password){
        boolean istrue=false;//把这个变量的定义放到这里
    	try{
    		String s1 = "%" + id + "%";
    		String s2 = "%" + password+ "%";
        	String sql = "select id,password from reader where ID like ? and password like ? ";        	
        	PreparedStatement pst = con.prepareStatement(sql);
            pst.setString(1, s1);
            pst.setString(2, s2);
        	ResultSet rst=pst.executeQuery();    	    
    	    while(rst.next()){//判断核对查询后的结果是否有数据，有数据就将isture设置为true
    	        isture=true;　//?	
    	                      //?
    	    } 
			/*判断是否有这个用户，可以按下面的方法做：
              if(rst.next()){
		          istrue = true;
			  }
			*/  
        }catch(SQLException e){
        	System.out.print("SQLException"+e.getMessage());
        }  
         return istrue;
    }  
}