| 12
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 
 | public boolean hasvoted(String id_electeur, String id_election) {
		boolean flag = false;
		try {
			String sql = "SELECT EXISTS (SELECT 1 FROM tbl_vote WHERE id_elector = ? AND id_election = ?)";
 
			connection = DBManager.openConnection();
			PreparedStatement testvote = connection.prepareStatement(sql);
			testvote.setString(1,id_electeur);
			testvote.setString(2,id_election);
			resultSet = testvote.executeQuery();
			if(resultSet.absolute(1)){
                flag = true;
            }else{
                flag = false; }
		}catch(SQLException ex) {
			ex.printStackTrace();
		}
		return flag;
	} | 
Partager