(1)solr
@Autowired
SolrClient solrClient;
SolrQuery query = new SolrQuery();
query.setQuery("*:*"); // 条件
query.setStart(0); // 分页
query.setRows(1);
query.setSort("capture_time", SolrQuery.ORDER.desc); // 排序
query.addFilterQuery("capture_time:[2024-04-15T14:38:53Z TO 2024-04-17T14:38:53Z]"); // 过滤
query.addFilterQuery("camera_id:(32050855001320000176 32050867001327000018)");
log.info("{}", query);
QueryResponse response = solrClient.query("vehicle", query);
long numFound = response.getResults().getNumFound();
log.info("{}", numFound);
SolrDocumentList results = response.getResults();
log.info("{}", results);
(2)jdbc
@Autowired
JdbcTemplate jdbcTemplate;
String sql = "SELECT * FROM sv_user WHERE username IN (:username)";
log.info("{}", sql);
Map<String, Object> params = new HashMap<>();
params.put("username", Arrays.asList(new String[] {"admin", "test"}));
NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(jdbcTemplate);
List<Map<String, Object>> list = namedParameterJdbcTemplate.queryForList(sql, params);
log.info("{}", list);