java resultset转json_java中怎么吧jdbc查询的resultset对象转为json

一条记录 建议先封装成map 对象

多条几率 封装成 list>

protected List> fullToList(ResultSet rs) {

ArrayList result = new ArrayList();

try {

int iColumn = rs.getMetaData().getColumnCount();

while (rs.next()) {

Map map = new LinkedHashMap();

for (int i = 1; i <= iColumn; i++) {

String tmpkey = rs.getMetaData().getColumnName(i);// 通过索引找到行的名字

String[] tmps = tmpkey.split("_");// 分割所有含"_"字符，返回数组

String key = "";

for (int j = 0; j < tmps.length; j++) {

if (j == 0) {

key += tmps[j].toLowerCase();// 转换为小写

} else {

key += tmps[j].substring(0, 1).toUpperCase()

+ tmps[j].substring(1).toLowerCase();

}

}

Object val = null;

// switch行类型

switch (rs.getMetaData().getColumnType(i)) {

case Types.DATE:

val = rs.getDate(i);

break;

case Types.DOUBLE:

if(rs.getObject(i)==null)

val=null;

else

val = rs.getDouble(i);

break;

case Types.NUMERIC:

if(rs.getObject(i)==null)

val=null;

else

val = rs.getDouble(i);

break;

case Types.DECIMAL:

if(rs.getObject(i)==null)

val=null;

else

val = rs.getDouble(i);

break;

case Types.INTEGER:

if(rs.getObject(i)==null)

val=null;

else

val = rs.getInt(i);

break;

default:

val = rs.getString(i);

break;

}

if (null != val) {

// map找找不到指定键便设置个

if (!map.containsKey(key)) {

map.put(key, val);

}

}

}

result.add(map);

}

} catch (Exception e) {

log.error(e.getMessage());

} finally {

try {

if (rs != null)

rs.close();

rs = null;

} catch (SQLException e) {

log.error(e.getMessage());

}

}

return result;

}

protected Map fullToMap(ResultSet rs) {

Map map = new TreeMap();

try {

int iColumn = rs.getMetaData().getColumnCount();

while (rs.next()) {

for (int i = 1; i <= iColumn; i++) {

String tmpkey = rs.getMetaData().getColumnName(i);

String[] tmps = tmpkey.split("_");

String key = "";

for (int j = 0; j < tmps.length; j++) {

if (j == 0) {

key += tmps[j].toLowerCase();

} else {

key += tmps[j].substring(0, 1).toUpperCase()

+ tmps[j].substring(1).toLowerCase();

}

}

Object val = null;

switch (rs.getMetaData().getColumnType(i)) {

case Types.DATE:

val = rs.getDate(i);

break;

default:

val = rs.getString(i);

break;

}

if (null != val) {

if (!map.containsKey(key)) {

map.put(key, val);

}

}

}

break;

}

} catch (Exception e) {

log.error(e.getMessage());

} finally {

try {

if (rs != null)

rs.close();

rs = null;

} catch (SQLException e) {

log.error(e.getMessage());

}

}

return map;

}

然后再将map 装成json