1、資料庫中存儲的字段資訊如下:
2、 定義與之相對應的Record對象
public class Record{
private String name;
private String value;
public Record() {
super();
}
public Record(String name, String value) {
super();
this.name = name;
this.value = value;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getValue() {
return value;
}
public void setValue(String value) {
this.value = value;
}
}
3、存入資料庫
String ip = "127.0.0.1";
String device = "安卓手機";
SimpleDateFormat sdf = new SimpleDateFormat("yyy-MM-dd HH:mm:ss");
String date = sdf.format(new Date());
Record r1=new Record("驗證時間", date);
Record r2=new Record("ip位址", ip);
Record r3=new Record("裝置類型", device);
List<Record> recordList=new ArrayList<Record>();
recordList.add(r1);
recordList.add(r2);
recordList.add(r3);
//插入資料庫資訊
方法略過,括号裡的為要插入的參數(JSON.toJSONString(recordList));
4、從資料庫取出
//方法一:把json轉換成List集合
JSONArray jsonArray = JSONArray.fromObject(括号裡為資料庫讀取到的字元串型json資料);
List<Record> recordList=(List<Record>) jsonArray.toCollection(jsonArray, Record.class);
//方法二:直接輸出
JSONArray jsonArray = JSONArray.fromObject(括号裡為資料庫讀取到的字元串型json資料);
Object[] os = jsonArray .toArray();
for(int i=0; i<os.length; i++) {
JSONObject jsonObj = JSONObject.fromObject(os[i]);
System.out.println(jsonObj.get("name"));
System.out.println(jsonObj.get("value"));
}