Gson与Json jar 使用的一些区别

public class GsonUtil {

public static JsonArray forJsonUtil(ResultSet rs) {
	JsonArray jsonArray = new JsonArray();
	try {
		ResultSetMetaData md = rs.getMetaData();
		int num = md.getColumnCount();
		JsonObject jsonObject = new JsonObject();
		while (rs.next()) {
			for (int i = 1; i <= num; i++) {
				Object o = rs.getObject(i);
				if (o instanceof Date) {
					jsonObject.addProperty(md.getColumnName(i),
							DateUtil.formatDate((Date) o, "yyyy-MM-dd"));
				} else if (o instanceof Integer) {
					jsonObject.addProperty(md.getColumnName(i),
							(Integer) rs.getObject(i));
				} else if (o instanceof Double) {
					jsonObject.addProperty(md.getColumnName(i),
							(Double) rs.getObject(i));
				} else {
					jsonObject.addProperty(md.getColumnName(i),
							(String) rs.getObject(i));
				}
			}
			jsonArray.add(jsonObject);
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return jsonArray;
}





public static JSONObject forJsonObjectUtil(ResultSet rs) {

	JSONObject jsonObject = new JSONObject();
	try {
		ResultSetMetaData md = rs.getMetaData();
		int num = md.getColumnCount();
		while (rs.next()) {
			for (int i = 1; i <= num; i++) {
				Object o = rs.getObject(i);
				if (o instanceof Date) {
					jsonObject.put(md.getColumnName(i),
							DateUtil.formatDate((Date) o, "yyyy-MM-dd"));
				} else {
					jsonObject.put(md.getColumnName(i), rs.getObject(i));
				}
			}
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return jsonObject;
}

二者主要的区别在 Gson与JSON在使用ResultSetMetaData时的区别在于Gson需要指明栏位的类型,不然存在转换异常的问题

• 而JSON可以指定類型也可以不指定類型.

转载于:https://my.oschina.net/u/946001/blog/262541