<< Click to Display Table of Contents >>
Commit
커밋을 실행합니다.
Prototype
void Commit()
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");
}