/** * @Description: 组织sql * * @param note * @return:void */ private String genSql(Note note) { // 组装sql StringBuilder sb = new StringBuilder(); sb.append(" update tcnote set "); if (note.getAuthorName() != null) { sb.append(" author_name='" + note.getAuthorName() + "', "); } if (note.getFromUrl() != null) { sb.append(" from_Url='" + note.getFromUrl() + "', "); } if (note.getNoteName() != null) { sb.append(" note_name='" + note.getNoteName() + "', "); } // flag=0防止note里面字段都是空的 sb.append(" flag=0 where note_id= " + note.getNoteId()); return sb.toString(); }
private String insertSql(Note note) { // 组装sql StringBuilder sb = new StringBuilder(); sb.append( "insert into tcnote (note_id,note_name,author_name,from_url,flag,noteBook,noteBookGroup) values ( "); sb.append(note.getNoteId() + ", "); sb.append("'" + note.getNoteName() + "', "); sb.append("'" + note.getAuthorName() + "', "); sb.append("'" + note.getFromUrl() + "', "); sb.append(note.getFlag() + ", "); sb.append(" 1, "); sb.append(" 1 )"); return sb.toString(); }