Blogs

    private static final String BASE_SELECT = "SELECT " +

        ALL_COLUMNS + " FROM " + TABLE_NAME + " WITH(NOLOCK) WHERE 1=1";

 

    private static DataSource getDataSource() throws Exception {

        return DataSourceFactoryUtil.initDataSource(

            PropsUtil.getProperties(DATASOURCE_PREFIX, true));

    }

 

    private static Connection getConnection() throws Exception {

        return getDataSource().getConnection();

    }

 

    public static String findByFileUploadId(String fileUploadId) {

        String result = null;

        String sql = BASE_SELECT + " AND ID = ?";

 

        _log.info(String.format(

Welcome to the new Blogs page, where you can search and filter the available blogs to much more easily find what you're looking for!            "Executing SQL: {%s} with fileUploadId={%s}",

            sql, fileUploadId));

 

But, don't worry - if you prefer the old UX with the Blogs Widget, it's still available - just use the Blogs List link in the left navigation and it will be like it's 1999 all over again!

        try (Connection conn = getConnection();

 

            ps.setString(1, fileUploadId);

 

            try (ResultSet rs = ps.executeQuery()) {

                while (rs.next()) {

                    result = processResultSet(rs);

                }

            }

        } catch (Exception e) {

            _log.error("SQL Exception in findByFileUploadId", e);

        }

To add a new blog, use the "New Entry" button here on on the Blogs List page.

        return result;

    }

}