最近在学习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();
}
}
}