List rows = jdbcTemplate.queryForList("SELECT * FROM USER");
Iterator it = rows.iterator();
while(it.hasNext()) {
Map userMap = (Map) it.next();
System.out.print(userMap.get("id") + "\t");
System.out.print(userMap.get("name") + "\t");
System.out.print(userMap.get("sex") + "\t");
System.out.println(userMap.get("age") + "\t");
}
List<Map<String, Object>> rows = jdbcTemplate.queryForList("select * from user_token where address=? and contract_address not in (select contract_address from token)", new Object[] { address });
Iterator<Map<String, Object>> it = rows.iterator();
while (it.hasNext()) {
Map<String, Object> userMap = (Map<String, Object>) it.next();
String contractAddress = (String) userMap.get("contract_address");
String symbol = (String) userMap.get("symbol");
int decimals = (int) userMap.get("decimals");
}
@RequestMapping("/article/tag/{siteId}")
public ResponseRestful tag(@PathVariable int siteId) {
List<Tag> tags = new ArrayList<Tag>();
List<Map<String, Object>> rows = new ArrayList<Map<String, Object>>();
String sql = "SELECT id,name FROM cms.tag WHERE site_id = ?";
rows = jdbcTemplate.queryForList(sql, new Object[] { siteId });
for (Map<String, Object> row : rows) {
Tag tag = new Tag();
tag.setId((Integer) row.get("id"));
tag.setName((String) row.get("name"));
tags.add(tag);
}
logger.info("tag {} SQL: {}", siteId, sql);
return new ResponseRestful(true, tags.size(), "标签", tags);
}
jdbcTemplate.queryForList("select id from public.contract").forEach(item -> {
logger.debug(item.toString());
});