NamedParameterJdbcTemplate 查询

代码片段

 StringBuilder query = new StringBuilder(sql);
        query.append("AND pl.userName<> pl.userNickname");
        query.append("AND pl.crate_date = :createDate ");
       ...//LocalDate.now().toString()直接应用查询日期（yyyy-MM-dd)
        List<VendorSpecPriceLatestViewEntity> content = jdbcTemplate.query(query.toString(), Collections.singletonMap("crawlDate", LocalDate.now().toString()), (rs, rowNum)-> new   					Entity().setId(rs.getInt("id"))
            .setUserName(rs.getString("userName"))
            .setCreatelDate(rs.getDate("create_date").toLocalDate());//Stirng -> localDate使用toLocalDate()）;