我有以下SQL查询的resultSet:
col1 | col2 | col3 | val1 | val2 | ["val3", "val4"]
尝试为JDBC模板创建RowMapper
我有响应类
public class Response { private String field1; private String field2; private List<String> stringFields; }
我需要将“Col3”中的值数组映射到“List stringFields;”
RowMapper<Response> rowMapper = (rs, rowNum) -> { String field1 = rs.getString("col1"); String field2 = rs.getString("col2"); List<String> stringFields = rs.getArray("col3"); Response res = new Response(field1, field2, stringFields); }
这行不起作用:“List stringFields=rs.getArray(“col3”);”
请告知
谢谢