<< Click to Display Table of Contents >>

Rollback

롤백합니다.

Prototype

void Rollback()

Example

function DataBaseConnectionSample() {

   var con = OZCreator.GetBuiltInObject(OZBuiltInObject.DBCONNECTION);

   con.SetVendor("mssql");

   con.AddItemValue("serverAddress","127.0.0.1");

   con.AddItemValue("portNo","1433");

   con.AddItemValue("dbName", "oz");

   con.AddItemValue("user", "sa");

   con.AddItemValue("password", "forcs");

   var isOK = con.Connect(false);

   _DEBUG("isOK="+isOK);

   con.SetAutoCommit(false);

   var stmt;

   try {

       stmt = con.CreateStatement();

       var query = "insert into table1 (field1) values("value1")";

       stmt.ExecuteUpdate(query);

       con.Commit();

   } catch(e) {

       con.Rollback();

       _ERROR("error="+e);

   } finally {

       stmt.Close();

       con.Close();

   }

   _DEBUG("OK");

}