@Override
public String updatePage(Project project, Page page) {
try {
cmdString = "update pages set title = ?, body = ?, views = ? where id = ?";
PreparedStatement s = db.prepareStatement(cmdString);
s.setString(1, page.getTitle());
s.setString(2, page.getMarkdown());
s.setInt(3, page.getViewCount());
s.setString(4, page.getID());
s.executeUpdate();
} catch (Exception e) {
processSQLError(e);
}
return null;
}
@Override
public String insertPage(Project project, Page page) {
if (page == null) {
return "ERROR: Page cannot be null";
}
try {
cmdString = "insert into pages (id, body, title, views, project) values (?, ?, ?, ?, ?)";
PreparedStatement s = db.prepareStatement(cmdString);
s.setString(1, page.getID());
s.setString(2, page.getMarkdown());
s.setString(3, page.getTitle());
s.setInt(4, 0);
s.setString(5, page.getProjectID());
// On delete cascade will delete categories and pages involved.
s.executeUpdate();
} catch (Exception e) {
processSQLError(e);
}
return null;
}