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"));
}