ResultSet转json

你的名字 2022-11-29 05:57 467阅读 0赞

### ResultSet转json ###

*  转载：https://www.javaroad.cn/articles/2192

# 转载：https://www.javaroad.cn/articles/2192 #

工具类：

public static JSONArray convert( ResultSet rs )
    		throws SQLException, JSONException
    	{ 
    		JSONArray json = new JSONArray();
    		ResultSetMetaData rsmd = rs.getMetaData();
    
    		while(rs.next()) { 
    			int numColumns = rsmd.getColumnCount();
    			JSONObject obj = new JSONObject();
    
    			for (int i=1; i<numColumns+1; i++) { 
    				String column_name = rsmd.getColumnName(i);
    
    				if(rsmd.getColumnType(i)==java.sql.Types.ARRAY){ 
    					obj.put(column_name, rs.getArray(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.BIGINT){ 
    					obj.put(column_name, rs.getInt(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.BOOLEAN){ 
    					obj.put(column_name, rs.getBoolean(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.BLOB){ 
    					obj.put(column_name, rs.getBlob(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.DOUBLE){ 
    					obj.put(column_name, rs.getDouble(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.FLOAT){ 
    					obj.put(column_name, rs.getFloat(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.INTEGER){ 
    					obj.put(column_name, rs.getInt(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.NVARCHAR){ 
    					obj.put(column_name, rs.getNString(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.VARCHAR){ 
    					obj.put(column_name, rs.getString(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.TINYINT){ 
    					obj.put(column_name, rs.getInt(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.SMALLINT){ 
    					obj.put(column_name, rs.getInt(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.DATE){ 
    					obj.put(column_name, rs.getDate(column_name));
    				}
    				else if(rsmd.getColumnType(i)==java.sql.Types.TIMESTAMP){ 
    					obj.put(column_name, rs.getTimestamp(column_name));
    				}
    				else{ 
    					obj.put(column_name, rs.getObject(column_name));
    				}
    			}
    			json.put(obj);
    		}
    		return json;
    	}

调用并转换为List：

JSONArray convert = null;
    while (rs.next()) { 
    	convert = ResultSetToJSON.convert(rs);
    }
    List<PBICommonlyDTO> pbiCommonlyDTOS = JSON.parseArray(convert.toString(), PBICommonlyDTO.class);