这两天被数据库插入批量数据折磨的有点抓狂还好找到了解决方法,话不多说,直接看下面两部分代码:
SQLiteDatabase db = dbHelper.getWritableDatabase();
// LogUtils.i("开始解析*****************"+ new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()));
for (int i = 0; i < messageArray.length(); i++) {
try {
JSONObject messageObject = (JSONObject) messageArray.get(i);
int stamp = JSONUtils.getInt(messageObject, "nTime", 0);
String dbLon = JSONUtils.getString(messageObject, "dbLon", "");
String dbLat = JSONUtils.getString(messageObject, "dbLat", "");
/******************** 数据库事务开始 **************************/
db.beginTransaction();
db.execSQL("insert into waybaby(stamp,lontude,lantude) values(?,?,?)",new Object[] { stamp, dbLon,dbLat });
db.setTransactionSucces