Question

jsp转换成json

String sql = "select * from city where city.province="+id;
ResultSet rs = stmt.executeQuery(sql);
怎么能把rs中的数据取出然后转换成json对象
有两列 id和name

Answer 1

1、
JSONObject json = new JSONObject();
while(rs.next()){
String id = rs.getString("id");
String name = rs.getString("name");
json.element("id", id);
json.element("name", name);
}

2、
ResultSetMetaData rsm = rs.getMetaData();
JSONObject json = new JSONObject();
while(rs.next()){
for(int i = 1;i<rsm.getColumnCount();i++){
String columnName = rsm.getColumnName(i);//id,name
String columnValue = rs.getString(columnName);
json.element(columnName, columnValue);
}
}