public static void addRepresentationCaddie (String numS, String dateRep, String zone, String nofp) throws BDException {
		String requete = null;
		PreparedStatement pstmt = null;
		Statement stmt = null;
		ResultSet rs = null;
		Connection conn = null;

		try {
			conn = BDConnexion.getConnexion();

			BDRequetesTest.testRepresentation(conn, numS, dateRep);

			stmt = conn.createStatement();
			rs =stmt.executeQuery("select idr from lecaddie where numS="+numS+" and dateRep = to_date('"+dateRep+"','dd/mm/yyyy hh24:mi') and numZ="+zone);
			if (rs.next()){
				setQtCaddie(rs.getInt(1)+"", '+');
				return;
			}	

			stmt = conn.createStatement();
			rs = stmt.executeQuery("select max(idr) from lecaddie");		

			int id;
			if (!rs.next())
				id=1;
			else
				id=rs.getInt(1)+1;			

			requete = "insert into LeCaddie values (?,?,?,?,?)";
			pstmt = conn.prepareStatement(requete);
			pstmt.setInt(1, id);
			pstmt.setInt(2, Integer.valueOf(numS));
			pstmt.setTimestamp(3, new Timestamp((new SimpleDateFormat("dd/MM/yyyy HH:mm")).parse(dateRep).getTime()));
			pstmt.setInt(4, Integer.valueOf(zone));
			pstmt.setInt(5, Integer.valueOf(nofp));			
			int nb_insert = pstmt.executeUpdate();
			conn.commit();

			if(nb_insert != 1)
				throw new BDException("Problème dans l'ajout d'une représentation dans le caddie");

			stmt.executeUpdate("update config set date_cad = CURRENT_DATE");

		} catch (SQLException e) {
			throw new BDException("Problème dans l'ajout d'une représentation dans le caddie (Code Oracle : "+e.getErrorCode()+")");
		} catch (ParseException e) {}
		finally {
			BDConnexion.FermerTout(conn, stmt, rs);
			BDConnexion.FermerTout(null, pstmt, null);
		}
	}