usersdao.java

用Java与MySQL开发的小型学生成绩管理系统

package login;
import chuangti.*;
import java.sql.*;
public class UsersDAO {
public boolean checkUser(String userName, String password,String xuehao){
		try {
			DBConnection dbConn = new DBConnection();
			Connection conn = DBConnection.getConncetion();
		PreparedStatement checkUser = conn.prepareStatement("SELECT * FROM jiben WHERE xingming=? AND mima=? and xuehao=?");
		checkUser.setString(1,userName);
		checkUser.setString(2,password);
		checkUser.setString(3, xuehao);
		ResultSet rs = checkUser.executeQuery();
		if(rs.next())
			return true;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return false;
}

public boolean checkUser1(String userName, String password,String bianhao){
	try {
		DBConnection dbConn = new DBConnection();
		Connection conn = DBConnection.getConncetion();
	PreparedStatement checkUser1 = conn.prepareStatement("SELECT * FROM jiaoshi WHERE jiaoshiming=? AND mima=? and bianhao=?");
	checkUser1.setString(1,userName);
	checkUser1.setString(2,password);
	checkUser1.setString(3, bianhao);
	ResultSet rs1 = checkUser1.executeQuery();
	if(rs1.next())
		return true;
	} catch (Exception e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return false;
}
}