public static ActionCom SelectActionComById(int id) throws SQLException {
        String query = null;
        ActionCom Action = new ActionCom();
        ResultSet resultat;

        try {
            query = "SELECT * from ACTION_COM  where ID_ACTION=? ";
            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(1, id);
            resultat = pStatement.executeQuery();

            while (resultat.next()) {
               
                Action = new ActionCom(resultat.getInt("ID_ACTION"), resultat.getInt("ID_ACTION_TYPE"), resultat.getInt("ID_INTERLOCUTEUR"), resultat.getDate("ACTDATE"),resultat.getString("ACTCOMM"));
            }

        } catch (SQLException ex) {
            Logger.getLogger(RequetesActionCom.class.getName()).log(Level.SEVERE, null, ex);

        }
        return Action;
    }