sqlite多行插入_Sqlite批量插入大数据【原创】

这两天被数据库插入批量数据折磨的有点抓狂还好找到了解决方法，话不多说，直接看下面两部分代码：

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