android下的数据库事物: Transaction

public class TestTransaction extends AndroidTestCase {

   public void testTransaction() throws Exception{

             

           

             //拿到数据库

            PersonDBOpenHelp   herper= new PersonDBOpenHelp(getContext());

            SQLiteDatabase db = herper.getWritableDatabase();

            

             //开启数据库事物

            db.beginTransaction();

            

             try{

                  db.execSQL( "update person set money=money-100  where name='zhangsan'");

                  

                   //System.out.println(1/0);

                  db.execSQL( "update person set money=money+100  where name='zhangsan0'");

                  

                  db.setTransactionSuccessful();    //如果没有标记数据库事物成功,数据会回滚

            } finally{

                  

                  db.endTransaction();   //关闭数据库事物

            }

            

            db.close();

            

      }

      

      

}

------------------------------------------------------------------------------------------------

在内容提供者中开启事物:

/**

       * 内容提供者中开启事物

       * @throws Exception

       */

      public void testBatch() throws Exception {

            ContentResolver resolver = getContext().getContentResolver();

            ArrayList<ContentProviderOperation> list = new ArrayList<ContentProviderOperation>();

            

            ContentProviderOperation operation1 = ContentProviderOperation.newInsert(rawContactsUri)

                        .withValue( "_id", null)

                        .build();

            

            ContentProviderOperation operation2 = ContentProviderOperation.newInsert(dataUri)

                        .withValueBackReference( "raw_contact_id", 0)       // 把同组第一个操作的结果作为值

                        .withValue( "mimetype", "vnd.android.cursor.item/name" )

                        .withValue( "data1", "CR")

                        .build();

            

            ContentProviderOperation operation3 = ContentProviderOperation.newInsert(dataUri)

                        .withValueBackReference( "raw_contact_id", 0)    

                        .withValue( "mimetype", "vnd.android.cursor.item/phone_v2" )

                        .withValue( "data1", "131999888888")

                        .build();

            

            ContentProviderOperation operation4 = ContentProviderOperation.newInsert(dataUri)

                        .withValueBackReference( "raw_contact_id", 0)    

                        .withValue( "mimetype", "vnd.android.cursor.item/email_v2" )

                        .withValue( "data1", "cr@hotmail.com")

                        .build();

            

            list.add(operation1);

            list.add(operation2);

            list.add(operation3);

            list.add(operation4);

            

            resolver.applyBatch( "com.android.contacts", list);

      }

}