数据库插入数据排重

 StringBuilder sql = new StringBuilder();

sql.append(" select count(1) ");

sql.append(" from " + TABLE_NAME + " spc ");

sql.append(" where spc.share_id = ? ");

sql.append(" and spc.comment_person = ? ");

sql.append(" and spc.comment_time = ? ");

sql.append(" and instr(?, spc.comments) > 0 ");