www.pudn.com > students.rar > Login.java

package students; 
import students.UserDAO; 
import java.sql.*; 
public class Login { 
	public static int checkUser(String studentid,String password){ 
		int result = 0 ; 
		String pas = null; 
//		User user=new User(); 
		ResultSet rs = UserDAO.queryUserByUsername(studentid); 
		try { 
			if(rs.next()){ 
				 
				pas=rs.getString("password"); 
				 
			} 
		} catch (SQLException e) { 
			e.printStackTrace(); 
		} 
		if (pas==null){	// user not found 
			result = 1; 
		} else if (! pas.equals(password)){	//password is incorrect 
			result = 2; 
		} else {	// check user OK 
			result = 3; 
		} 
		return result ;  
	} 
}