MySQL数据库中，对事物设置中间点，使用setSavepoint()方法的测试

package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Savepoint;


/**
 *测试事务中设置中间点  setSavepoint()
 * @author YU
 *
 */
public class Demo6 {
	@SuppressWarnings("unused")
	public static void main(String[] args) throws SQLException {
		Connection conn = null;
		PreparedStatement ps1 = null , ps2 = null , ps3 = null , ps4 = null; // 假设ps1 ps2必须实现，ps3 ps4可选
		
		Savepoint savepoint = null;
		
		try {
			// 加载驱动类
			Class.forName("com.mysql.cj.jdbc.Driver");

			//建立连接（连接对象内部包含了socket对象，是一个远程的连接，  连接池！！）
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test_jdbc?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false",
					"root","a19961015");
			
			conn.setAuto