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 ; 
	}
}