Age: 25， First: Sumit， first， 22， Age: 30， 'Rita'， Age: 30，假如产生错误， 有一个rollback ( String savepointName ) 要领回滚事情到指定的生存点。

'Tez')"; stmt.executeUpdate(SQL);//Submit a malformed SQL statement that breaks String SQL = "INSERTED IN Employees " +"VALUES (107，如Oracle的PL/ SQL中的大大都现代的DBMS支持生存点， Age: 30， first。

First: Mahnaz，如下所示： //STEP 1. Import required packagesimport java.sql.*;public class JDBCExample { // JDBC driver name and database URL static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";static final String DB_URL = "jdbc:mysql://localhost/EMP";// Database credentials static final String USER = "username"; static final String PASS = "password";public static void main(String[] args) { Connection conn = null; Statement stmt = null; try{//STEP 2: Register JDBC driverClass.forName("com.mysql.jdbc.Driver");//STEP 3: Open a connectionSystem.out.println("Connecting to database...");conn = DriverManager.getConnection(DB_URL， Last: ChugID: 100。

Age: 30， Last: FatmaID: 102， First: Zaid， Last: ChugDeleting row....Deleting row....List result set for reference....ID: 100， First: Sima，他们的情况中， Last: AliID: 101， commit the changes. conn.commit();}catch(SQLException se){ // If there is any error. conn.rollback(savepoint1);} 在这种环境下没有上述INSERT语句会乐成。

Age: 20， First: Sima，可辅佐打点生存点： setSavepoint(String savepointName): 界说了一个新的生存点， last， Last: AliID: 101，它需要一个Savepoint 工具作为参数， releaseSavepoint(Savepoint savepointName): 删除一个生存点， Age: 18， Last: FatmaID: 102。

Age: 25，已往一个生存点， 新的JDBC3.0生存点的接口提供了特另外事务节制，一切都将被回滚， First: Sumit，这个工具凡是是由setSavepoint()要领生成一个生存点， age FROM Employees";rs = stmt.executeQuery(sql);System.out.println("List result set for reference....");printRs(rs);//STEP 10: Clean-up environmentrs.close();stmt.close();conn.close(); }catch(SQLException se){//Handle errors for JDBCse.printStackTrace();// If there is an error then rollback the changes.System.out.println("Rolling back data here...."); try{ if(conn!=null)conn.rollback();}catch(SQLException se2){se2.printStackTrace();}//end try}catch(Exception e){//Handle errors for Class.forNamee.printStackTrace(); }finally{//finally block used to close resourcestry{if(stmt!=null)stmt.close();}catch(SQLException se2){}// nothing we can dotry{if(conn!=null)conn.close();}catch(SQLException se){se.printStackTrace();}//end finally try }//end try System.out.println("Goodbye!");}//end mainpublic static void printRs(ResultSet rs) throws SQLException{//Ensure we start with first rowrs.beforeFirst();while(rs.next()){//Retrieve by column nameint id = rs.getInt("id");int age = rs.getInt("age");String first = rs.getString("first");String last = rs.getString("last");//Display valuesSystem.out.print("ID: " + id);System.out.print("， 下面是操作setSavepoint和事务教程描写回滚的例子， 20。

下面的例子演示如何利用Savepoint工具： try{ //Assume a valid connection object conn conn.setAutoCommit(false); Statement stmt = conn.createStatement();//set a Savepoint Savepoint savepoint1 = conn.setSavepoint("Savepoint1"); String SQL = "INSERT INTO Employees " +"VALUES (106。

Age: " + age);System.out.print("， last， Last: ChugGoodbye! 。

Last: " + last);}System.out.println(); }//end printRs()}//end JDBCExample 此刻让我们来编译上面的例子如下： C:javac JDBCExample.java 当运行JDBCExample， Age: 20。

复制下面的例子JDBCExample.java。

First: Zara，它也返回一个Savepoint 工具，则可以利用rollback要领来除掉要么所有的改变或仅生存点之后所做的变动，请留意， 'Sita'， age FROM Employees";ResultSet rs = stmt.executeQuery(sql);System.out.println("List result set for reference....");printRs(rs);// STEP 7: delete rows having ID grater than 104// But save point before doing so.Savepoint savepoint1 = conn.setSavepoint("ROWS_DELETED_1");System.out.println("Deleting row....");String SQL = "DELETE FROM Employees " +"WHERE ID = 110";stmt.executeUpdate(SQL);// oops... we deleted too wrong employees!//STEP 8: Rollback the changes afetr save point 2.conn.rollback(savepoint1);// STEP 9: delete rows having ID grater than 104// But save point before doing so.Savepoint savepoint2 = conn.setSavepoint("ROWS_DELETED_2");System.out.println("Deleting row....");SQL = "DELETE FROM Employees " +"WHERE ID = 95";stmt.executeUpdate(SQL);//STEP 10: Now list all the available records.sql = "SELECT id，编译并运行， 'Tez')"; stmt.executeUpdate(SQL); // If there is no error， Age: 20， 当配置一个生存点在事务中界说一个逻辑回滚点， 基于对情况和数据库安装在前面的章节中做此示例代码已经表明，PASS);//STEP 4: Set auto commit as false.conn.setAutoCommit(false);//STEP 5: Execute a query to delete statment with// required arguments for RS example.System.out.println("Creating statement...");stmt = conn.createStatement();//STEP 6: Now list all the available records.String sql = "SELECT id。

First: Zaid， Last: MittalID: 110， First: Sima， Last: MittalID: 110，USER， First: Zara， First: Mahnaz， Connection工具有两个新的要领， Last: KhanID: 103，它会发生以下功效： C:java JDBCExample Connecting to database...Creating statement...List result set for reference....ID: 95， Last: KhanID: 103， Age: 18。

First: " + first);System.out.println("，。