java对象拼接json,java通过结果集ResutSet回拼接json数据格式

java通过结果集ResutSet来拼接json数据格式

项目需要，参考了一些网上的方法，修修补补适合自己的项目用的，小计一下。

public class JsonUtil {

/**

*

* @param rs

* 数据结果集

* @param jsonResult

* {result:[ {colName:value,colName1:value2}]}

*

*{result:[

* {id:0,data:["","value2","value1"]}]}

* json result

* @param type

* @return

*/

public static String GetJsonByResultSet(ResultSet rs, String jsonResult,

int type) {

ResultSetMetaData rsmd = null;

StringBuffer sb = null;

try {

rsmd = rs.getMetaData();

if (rs == null || rsmd.getColumnCount() < 0) {

return "{\"ok\":false}";

}

sb = new StringBuffer();

sb = sb.append("{" + jsonResult + ":[");

int i = 0;

while (rs.next()) {

if (i == 0) {

sb.append("{");

} else {

sb.append(",{");

}

if (type == 0) {

sb.append("id:" + i++ + ",data:[\"\"");

} else {

i++;

}

int count = rsmd.getColumnCount();

for (int j = 0; j < count; j++) {

int type_i = rsmd.getColumnType(j + 1);

String colName = rsmd.getColumnName(j + 1);

String colValue = noNull(rs.getString(j + 1));

switch (type_i) {

case Types.VARCHAR:

sb.append(changCharacter(type, colName, j)+ colValue+ "\"");

break;

case Types.CHAR:

sb.append(changCharacter(type, colName, j)+ colValue + "\"");

break;

case Types.INTEGER:

sb.append(changCharacter(type, colName, j)+ colValue + "\"");

break;

case Types.TIMESTAMP:

sb.append(changCharacter(type, colName, j)+ colValue + "\"");

break;

case Types.NUMERIC:

if ((rsmd.getPrecision(j + 1)) == 0) {

sb.append(changCharacter(type, colName, j)+ rs.getLong(j + 1) + "\"");

} else {

DecimalFormat df = new DecimalFormat("######0.00");

double num = rs.getDouble(j + 1);

String numStr = df.format(num);

sb.append(changCharacter(type, colName, j) + numStr+ "\"");

}

break;

case Types.DATE:

sb.append(changCharacter(type, colName, j)+ colValue + "\"");

break;

default:

}

}

if (type == 0) {

sb.append("]}");

} else {

sb.append("}");

}

}

sb.append("]}");

} catch (SQLException ex) {

}

return sb.toString();

}

/**

* 处理字符串，如果为null,转变为"",否则不转变

*/

public static String noNull(Object src) {

if (src == null) {

src = "";

}

return src.toString();

}

private static String changCharacter(int type, String colName, int number) {

String st = null;

if (type == 0) {

st = ",\"";

} else {

if (number == 0) {

st = colName + ":\"";

} else {

st = "," + colName + ":\"";

}

}

return st;

}

}

方法是直接可以用的

返回的数据格式然后后一篇讲怎么通过json-lib 来解析