public static void updateActionType(int idactiontype, String typelibelle) throws SQLException {

        String query = "";
        try {
            query = " UPDATE ACTION_TYPE SET TYP_LIB=? where ID_ACTION_TYPE=?  ";
            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(2, idactiontype);
            pStatement.setString(1, typelibelle.toUpperCase());
            pStatement.executeUpdate();

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

        }
    }