JAVA的JDBC自动提交机制测试-----JDBC

超、凢脫俗 2024-03-23 19:50 81阅读 0赞

> ###  ###
> 
>     package com.powernode.jdbc;
>     
>     import java.sql.*;
>     import java.util.ResourceBundle;
>     
>     public class JDBCTest03
>     {
>         public static void main(String[] args)
>         {
>             //JDBC的事务都是自动提交的,什么叫自动提交(只要执行任意一条DML语句就会自动提交一次),这是JDBC默认的行为
>             //在业务流程中我们通常是多条SQL语句(DML)同时执行,同时成功,同时失败
>             //JDBC的事务是自动提交机制的,JDBC只要执行容易DML语句就提交一次
>                 PreparedStatement preparedStatement = null;
>                 Connection connection = null;
>                 ResourceBundle resourceBundle = ResourceBundle.getBundle("JDBC");
>                 String url = resourceBundle.getString("url");
>                 String user = resourceBundle.getString("user");
>                 String password = resourceBundle.getString("password");
>                 try
>                 {
>                     Class.forName(resourceBundle.getString("Driver"));
>                     connection = DriverManager.getConnection(url,user,password);
>                     String sql = "update users set email = ? where username = ?";
>                     preparedStatement = connection.prepareStatement(sql);
>                     preparedStatement.setString(1,"X");
>                     preparedStatement.setString(2,"Allan");
>                     System.out.println(preparedStatement.executeUpdate());
>                     preparedStatement.setString(1,"Y");
>                     preparedStatement.setString(2,"Ailien");
>                     System.out.println(preparedStatement.executeUpdate());
>                 }
>                 catch(Exception e)
>                 {
>                     e.printStackTrace();
>                 }
>                 finally
>                 {
>                     if (preparedStatement != null)
>                     {
>                         try
>                         {
>                             preparedStatement.close();
>                         }
>                         catch (SQLException e)
>                         {
>                             throw new RuntimeException(e);
>                         }
>                     }
>                     if (connection != null)
>                     {
>                         try
>                         {
>                             connection.close();
>                         }
>                         catch (SQLException e)
>                         {
>                             throw new RuntimeException(e);
>                         }
>                     }
>                 }
>             }
>     }
> 
> package com.powernode.jdbc;  
>   
> import java.sql.\*;  
> import java.util.ResourceBundle;  
>   
> public class JDBCTest03  
> \{  
> public static void main(String\[\] args)  
> \{  
> //JDBC的事务都是自动提交的,什么叫自动提交(只要执行任意一条DML语句就会自动提交一次),这是JDBC默认的行为  
> //在业务流程中我们通常是多条SQL语句(DML)同时执行,同时成功,同时失败  
> //JDBC的事务是自动提交机制的,JDBC只要执行容易DML语句就提交一次  
> PreparedStatement preparedStatement = null;  
> Connection connection = null;  
> ResourceBundle resourceBundle = ResourceBundle.getBundle("JDBC");  
> String url = resourceBundle.getString("url");  
> String user = resourceBundle.getString("user");  
> String password = resourceBundle.getString("password");  
> try  
> \{  
> Class.forName(resourceBundle.getString("Driver"));  
> connection = DriverManager.getConnection(url,user,password);  
> String sql = "update users set email = ? where username = ?";  
> preparedStatement = connection.prepareStatement(sql);  
> preparedStatement.setString(1,"X");  
> preparedStatement.setString(2,"Allan");  
> System.out.println(preparedStatement.executeUpdate());  
> preparedStatement.setString(1,"Y");  
> preparedStatement.setString(2,"Ailien");  
> System.out.println(preparedStatement.executeUpdate());  
> \}  
> catch(Exception e)  
> \{  
> e.printStackTrace();  
> \}  
> finally  
> \{  
> if (preparedStatement != null)  
> \{  
> try  
> \{  
> preparedStatement.close();  
> \}  
> catch (SQLException e)  
> \{  
> throw new RuntimeException(e);  
> \}  
> \}  
> if (connection != null)  
> \{  
> try  
> \{  
> connection.close();  
> \}  
> catch (SQLException e)  
> \{  
> throw new RuntimeException(e);  
> \}  
> \}  
> \}  
> \}  
> \}