17,140
社区成员




begin
update gjhohj_a set name='123' where id=1 ;
update gjhohj_b set name = '456' where id=4 ;
commit ;
exception
when others then
rollback ;
end ;
package com.xlh.read;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
public class Conn {
public void update() {
String sql1 = "update table1 set name = 'A' ";
String sql2 = "update table2 set name = 'B' ";
String sql3 = "update table3 set name = 'B' " ;
Connection conn = DBConnection.getConnection() ;
PreparedStatement ps = null ;
try {
conn.setAutoCommit(false) ;
ps = conn.prepareStatement(sql1) ;
ps.executeUpdate() ;
ps = conn.prepareStatement(sql2) ;
ps.executeUpdate() ;
ps = conn.prepareStatement(sql3) ;
ps.executeUpdate() ;
conn.setAutoCommit(true) ;
} catch (SQLException e) {
conn.rollback() ;
e.printStackTrace() ;
}
}
}
如果是java的话.declare
begin
update table1 set name = 'A' ;
update table2 set name = 'B' ;
update table3 set name = 'B' ;
end;
/