//从properties文件中加载数据库配置

         Properties properties = new Properties();

         InputStream inputStream =Class.forName("test.Test").getResourceAsStream("/mysql.properties");

         properties.load(inputStream);

         String driver = properties.getProperty("driver");

         String url = properties.getProperty("url");

         String user = properties.getProperty("user");

         String pwd=properties.getProperty("password");

         Class.forName(driver);

         Connection connection = DriverManager.getConnection(url, user, pwd);

         connection.setAutoCommit(false);   //关闭自动提交，此句代码会自动开启事务。默认为true，自动提交。

         String sql1 = "insert into student_tb (name,age,score) values (?,?,?)";

         PreparedStatement preparedStatement1 = connection.prepareStatement(sql1);

         preparedStatement1.setString(1,"chy");

         preparedStatement1.setInt(2,20);

         preparedStatement1.setInt(3,100);

         preparedStatement1.executeUpdate();  //放置到队列中

         String sql2 = "update student_tb set name=? where id=?";

         PreparedStatement preparedStatement2 = connection.prepareStatement(sql2);

         preparedStatement2.setString(1,"CoCo");

         preparedStatement2.setInt(2,10);

         preparedStatement2.executeUpdate();  //放置到队列中

         try{

             connection.commit();   //提交事务

         }catch (SQLException e){

             connection.rollback();  //失败就回滚

         } finally {

             preparedStatement1.close();

             preparedStatement2.close();

             connection.close();

         }