public void save(Ticket ticket){ String sql = "INSERT INTO Ticket (desc , number, user_id) VALUES (:desc, :number, :userId)"; SqlParameterSource parameterSource = new MapSqlParameterSource("desc", ticket.getDesc()) .addValue("number", ticket.getNumber()) .addValue("userId", ticket.getUser().getId()); namedParameterJdbcTemplate.update(sql, parameterSource); }
private String getNotes(Ticket ticket) { StringBuffer notes = new StringBuffer("OpenNMS generated ticket by user: "); notes.append(ticket.getUser()); notes.append("\n"); notes.append("\n"); if (ticket.getAttribute(ATTRIBUTE_USER_COMMENT_ID) != null ) { notes.append("OpenNMS user comment: "); notes.append(ticket.getAttribute(ATTRIBUTE_USER_COMMENT_ID)); notes.append("\n"); notes.append("\n"); } notes.append("OpenNMS logmsg: "); notes.append(ticket.getSummary()); notes.append("\n"); notes.append("\n"); notes.append("OpenNMS descr: "); notes.append(ticket.getDetails()); return notes.toString(); }