PHP java MySQL 与 MsSQL 中的事务

MySQL:
//事务开始
mysql_query("SET AUTOCOMMIT=0");

mysql_query("BEGIN");

//事务回滚
mysql_query("ROLLBACK");
//事务提交
mysql_query("COMMIT");

MsSQL:
//事务开始
mssql_query("BEGIN TRANSACTION DEPS02_DEL");
//事务回滚
mssql_query("ROLLBACK TRANSACTION DEPS02_DEL");
//事务提交
mssql_query("COMMIT TRANSACTION DEPS02_DEL");

按理来说，每种语言都是这样写，如java

     jdbcTemplate.execute("begin transaction t_customer_monitorEmail");
     try{
           ......
           jdbcTemplate.execute("commit transaction t_customer_monitorEmail");
     }catch(Exception e){
           jdbcTemplate.execute("rollback transaction t_customer_monitorEmail");
     }

Hibernate方式:

// Non-managed environment idiom
Session sess = factory.openSession();
Transaction tx = null;
try {
    tx = sess.beginTransaction();
    // do some work
    ...
    tx.commit();
}
catch (RuntimeException e) {
    if (tx != null) tx.rollback();
    throw e; // or display error message
}
finally {
    sess.close();
}

转载于:https://blog.51cto.com/xu20cn/74295