+ "(content, section_id, content_id, content_sequence, is_heading, is_notes, content_type, notes_type, format_type) "
+ "values (?, ?, ?, ?, ?, ?, ?, ?, ?)";
private static final class ContentMapper implements RowMapper<ContentPart> {
public ContentPart mapRow(ResultSet rs, int rowNum) throws SQLException {
ContentPart c = new ContentPart();
Section section = new Section();
section.setId(rs.getInt("section_id"));
c.setSection(section);
c.setSectionId(section.getId());
c.setContent(rs.getString("content"));
c.setContentSequence(rs.getInt("content_sequence"));
c.setContentType(rs.getString("content_type"));
c.setHeader(rs.getBoolean("is_heading"));
c.setNotes(rs.getBoolean("is_notes"));
c.setNotesType(rs.getString("notes_type"));
c.setContentId(rs.getInt("content_id"));
c.setFormatType(rs.getString("format_type"));
c.setId(rs.getInt("id"));
return c;
}