JAVA--JDBC中的事务

最近在学习JDBC,就当把数据库Mysql再复习一下吧。

c.setAutoCommit(false);

c.commit();

package 事务;
import java.sql.*;
import java.util.Scanner;
public class TestJDBC {
	public static void main(String[] args) {
		try{
			Class.forName("com.mysql.jdbc.Driver");
		}catch(ClassNotFoundException e){
			e.printStackTrace();
			
		}
		try(Connection c = 
				DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/how2java?characterEncoding=UTF-8",
		                "root", "admin");
			Statement stQuery  = c.createStatement();
			Statement stDelete = c.createStatement();
			Scanner sr = new Scanner(System.in);
				){
			//把自动提交关闭
			c.setAutoCommit(false);
			String sql1 = "select id from Hero order by id asc limit 0,10 ";
			ResultSet rs = stQuery.executeQuery(sql1);
			while(rs.next()){
				int id = rs.getInt(1);
				System.out.printf("试图删除id=%d的数据%n",id);
				stDelete.execute("delete from hero where id = "+id);
			}
			while(true){
				System.out.println("是否要删除数据（Y/N）");
				String str = sr.nextLine();
				if("Y".equals(str)){
					 c.commit();
	                    System.out.println("提交删除");
	                    break;
				}else if("N".equals(str)){
					 System.out.println("放弃删除");
	                    break;
				}
			}
			
		
			
		}catch(SQLException e){
			e.printStackTrace();
		}
	}

}