JDBC事务实现

package cn.itcast_jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCDome {

	public static void main(String[] args)  {
		
		//通过jdbc去控制事务
		Connection coon  = null;
		try {
			
			//注册驱动
			Class.forName("com.mysql.cj.jdbc.Driver");
			
			//获取connection
		    coon =  DriverManager.getConnection("jdbc:mysql://localhost:3306/web19?useSSL=FALSE&serverTimezone=GMT%2B8","root","123456");

		    //手动开启事务
		    coon.setAutoCommit(false);
		    
			//获取执行平台操作SQL语句
			Statement stmt = coon.createStatement();
			
			//操作sql
			stmt.executeUpdate("insert into account values(null,'dalong',3000)");
			
			//事务提交
			coon.commit();
			
			//关闭资源
			stmt.close();
			coon.close();
			
		} catch (Exception e) {
			// 事务回滚
			try {
				coon.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			e.printStackTrace();
		}
	}
}