事宜的使用
事务的使用
// 保存同步过来的User数据 public static void setUserList_YC(Context con, List<User> ulist) { long beginTime = System.currentTimeMillis(); DatabaseHelper dbhelper = new DatabaseHelper(con, con.getString(R.string.dbname)); SQLiteDatabase db = dbhelper.getWritableDatabase(); // 开启事务 lilin 2012-1-16 db.beginTransaction(); for (User u : ulist) { String szm = ""; szm = HanzhisToPinYin.cn2FirstSpell(u.name); db.execSQL( "insert into user(userguid,ouguid,name,phonenum,namepyshou) values(?,?,?,?,?)", new String[] { u.userguid, u.ouguid, u.name,u.phonenum, szm }); } db.setTransactionSuccessful();// 设置事务标志为成功,当结束事务时就会提交事务 db.endTransaction();// 结束事务 long time = (System.currentTimeMillis() - beginTime) / 1000; System.out.println("保存人员时间:" + time); close(dbhelper, db, null); }