reader.java

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

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();    	    
    	    
			//判断是否有这个用户，可以按下面的方法做：	
             if(rst.next()){
		         istrue = true;
			 }
		 
        }catch(SQLException e){
        	System.out.print("SQLException"+e.getMessage());
        }  
         return istrue;
    }  
}