这是我的JSON:{"res":"01","n":"2","info":[{"id":"1","name":"1111xxx","ver":"132"},{"id":"5","name":"xx","ver":"23"}]}
解析并封装:
for (int i = 0; i < arr.length(); i++) {
JSONObject subObj = arr.getJSONObject(i);
String id = subObj.getString("id");
String name = subObj.getString("name");
String ver = subObj.getString("ver");
Log.i("解析后的数据 ", "id=" + id + ",name=" + name + ",ver=" + ver);
ContentValues values = new ContentValues();
values.put("id", id);
values.put("name",name);
values.put("ver", ver);
db.insert("info", null, values);
}
然后报错
Error inserting id=1 ver=132 name=1111xxx
android.database.sqlite.SQLiteConstraintException: PRIMARY KEY must be unique (code 19)
Error inserting id=5 ver=23 name=xx
android.database.sqlite.SQLiteConstraintException: PRIMARY KEY must be unique (code 19)
我知道是因为键值不唯一,但是我想要的就是解析后把数据自动封装成表格,而不是一项一向的自己写,请问我要怎么改我的方法才能实现呢?