json数据存储到oracle,用Jackson转换json文件插入到Oracle数据库的经历

1、Jackson下载安装：maven依赖方式添加

com.fasterxml.jackson.core

jackson-core

2.9.6

com.fasterxml.jackson.core

jackson-annotations

2.9.6

com.fasterxml.jackson.core

jackson-databind

2.9.6

复制代码

2、Jackson ObjectMapper Jackson对象映射

从JSON字符串转换为Java对象

ObjectMapper objectMapper = new ObjectMapper();

String carJson ="{ \"brand\" : \"Mercedes\", \"doors\" : 5 }";

Car car = objectMapper.readValue(carJson, Car.class);

复制代码

从JSON Reader转换为Java对象

ObjectMapper objectMapper = new ObjectMapper();

String carJson = "{ \"brand\" : \"Mercedes\", \"doors\" : 4 }";

Reader reader = new StringReader(carJson);

Car car = objectMapper.readValue(reader, Car.class);

复制代码

从File 文件中转换为Java对象

ObjectMapper objectMapper = new ObjectMapper();

File file = new File("data/car.json");

Car car = objectMapper.readValue(file, Car.class);

复制代码

从URL(网络或本地资源) 资源转换为Java对象

ObjectMapper objectMapper = new ObjectMapper();

URL url = new URL("file:data/car.json");

Car car = objectMapper.readValue(url, Car.class);

复制代码

从InputStream 输入流中转换为Java对象

ObjectMapper objectMapper = new ObjectMapper();

InputStream input = new FileInputStream("data/car.json");

Car car = objectMapper.readValue(input, Car.class);

复制代码

从Byte Array 中转换为Java对象

ObjectMapper objectMapper = new ObjectMapper();

String carJson = "{ \"brand\" : \"Mercedes\", \"doors\" : 5 }";

byte[] bytes = carJson.getBytes("UTF-8");

Car car = objectMapper.readValue(bytes, Car.class);

复制代码

从JSON字符数组中转换为Java对象数组(Array)

String jsonArray = "[{\"brand\":\"ford\"}, {\"brand\":\"Fiat\"}]";

ObjectMapper objectMapper = new ObjectMapper();

Car[] cars2 = objectMapper.readValue(jsonArray, Car[].class);

复制代码

从JSON字符数组中转换为Java对象列表(List)

String jsonArray = "[{\"brand\":\"ford\"}, {\"brand\":\"Fiat\"}]";

ObjectMapper objectMapper = new ObjectMapper();

List cars1 = objectMapper.readValue(jsonArray, new TypeReference>(){});

复制代码

从JSON字符串中转换为Java的Map存储

String jsonObject = "{\"brand\":\"ford\", \"doors\":5}";

ObjectMapper objectMapper = new ObjectMapper();

Map jsonMap = objectMapper.readValue(jsonObject, new TypeReference>(){});

复制代码