@Override
public News getNewsById(int id) {
News news = new News();
SqlUtilities.jbdcUtil();
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
try {
connection =
DriverManager.getConnection(
"jdbc:mysql://localhost:3306/fourscorepicks", "fourscorepicks", "fourscorepicks");
preparedStatement = connection.prepareStatement("SELECT * FROM news WHERE id=?");
preparedStatement.setInt(1, id);
resultSet = preparedStatement.executeQuery();
resultSet.next();
news.setDatePosted(resultSet.getTimestamp("date_posted"));
news.setNewsText(resultSet.getString("news"));
news.setId(resultSet.getInt("id"));
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
SqlUtilities.closePreparedStatement(preparedStatement);
SqlUtilities.closeResultSet(resultSet);
SqlUtilities.closeConnection(connection);
}
return news;
}
@Override
public List<News> getNewsList() {
List<News> newsList = new ArrayList<News>();
SqlUtilities.jbdcUtil();
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
try {
connection =
DriverManager.getConnection(
"jdbc:mysql://localhost:3306/fourscorepicks", "fourscorepicks", "fourscorepicks");
preparedStatement =
connection.prepareStatement("SELECT * FROM news ORDER BY date_posted DESC");
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
News news = new News();
news.setDatePosted(resultSet.getTimestamp("date_posted"));
news.setNewsText(resultSet.getString("news"));
news.setId(resultSet.getInt("id"));
newsList.add(news);
}
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
SqlUtilities.closePreparedStatement(preparedStatement);
SqlUtilities.closeResultSet(resultSet);
SqlUtilities.closeConnection(connection);
}
return newsList;
}