public void updateBlogEntry(long id, String email, String title, String blogText, List<String> tags, Date updatedDate) {
if (id == -1)
throw new IllegalArgumentException(
"Not a BlogEntry returned by this interface");
EntryImpl b = getBlogEntryById(id);
String sql_se = "SELECT * FROM BLOGENTRY bp WHERE bp.id = " + id;
String email_old = null;
// let's find out the email address for the blog post to see whether the
// table Author_BlogEntry needs to be updated
// if the email is updated, we need to update the table Author_BlogEntry
// to reflect the change.
try {
Connection connection = dataSource.getConnection();
PreparedStatement ppsm = connection.prepareStatement(sql_se);
ResultSet rs = ppsm.executeQuery();
// there should be just one record
rs.next();
email_old = rs.getString("AUTHOR_EMAIL");
ppsm.close();
connection.close();
} catch (SQLException sqle) {
sqle.printStackTrace();
}
String sql = "UPDATE BLOGENTRY bp SET bp.blogText = ?, bp.publishDate = ?, bp.title = ?, bp.updatedDate = ?, bp.AUTHOR_EMAIL = ? where bp.id = "
+ id;
int updatedRows = 0;
try {
Connection connection = dataSource.getConnection();
PreparedStatement ppsm = connection.prepareStatement(sql);
ppsm.setString(1, blogText);
if (b.getPublishDate() != null)
ppsm
.setDate(2, new java.sql.Date(b.getPublishDate()
.getTime()));
else
ppsm.setDate(2, null);
ppsm.setString(3, b.getTitle());
if (b.getUpdatedDate() != null)
ppsm
.setDate(4, new java.sql.Date(b.getUpdatedDate()
.getTime()));
else
ppsm.setDate(4, null);
ppsm.setString(5, email);
updatedRows = ppsm.executeUpdate();
ppsm.close();
connection.close();
if (updatedRows != 1)
throw new IllegalArgumentException("The Blog " + b.getId()
+ " cannot be updated.");
} catch (SQLException e) {
e.printStackTrace();
}
// if the email address is changed, we need to need to update the
// relationship table Author_BlogEntry
if ((email_old != null) && (!!!email_old.equals(email))) {
// update the table Author_BlogEntry
String sql_ab = "UDPATE Author_BlogEntry ab SET ab.AUTHOR_EMAIL = '"
+ email + "'";
updatedRows = 0;
try {
Connection connection = dataSource.getConnection();
PreparedStatement ppsm = connection.prepareStatement(sql_ab);
updatedRows = ppsm.executeUpdate();
ppsm.close();
connection.close();
if (updatedRows != 1)
throw new IllegalArgumentException(
"The Author_BlogEntry with the postsID "
+ b.getId() + " cannot be updated.");
} catch (SQLException e) {
e.printStackTrace();
}
}
}