Java代码增加回滚6_为什么在我的java代码中出现异常后没有完成回滚操作

最新推荐文章于 2021-03-15 22:57:00 发布

weixin_39780784

最新推荐文章于 2021-03-15 22:57:00 发布

阅读量108

点赞数

文章标签： Java代码增加回滚6

本文链接：https://blog.csdn.net/weixin_39780784/article/details/114531786

版权

我有一个jdbc代码，我在代码中使用了事务管理。

以下是代码。我正在使用Mysql数据库。

public class JdbcConn {

public static void main(String[] args){

Savepoint spt1 = null;

Connection con = null;

try{

Class.forName("org.gjt.mm.mysql.Driver");

con = DriverManager.getConnection("jdbc:mysql://localhost","root","tany");

con.setAutoCommit(false);

spt1= con.setSavepoint("svpt1");

PreparedStatement psmt;

String query1 = "select city, countryid from querytest.city;";

psmt=con.prepareStatement(query1);

ResultSet rs=psmt.executeQuery();

while(rs.next()){

String query2 = "insert into sun.city (city,countryid) values('"+rs.getString(1)+"',"+rs.getInt(2)+");";

psmt=con.prepareStatement(query2);

psmt.executeUpdate();

}

String query3 = "create database `transtest`;";

psmt=con.prepareStatement(query3);

psmt.executeUpdate();

String query4 = "CREATE TABLE `transtest`.`trans` (`id` tinyint(4) NOT NULL auto_increment,`val` int(5) NOT NULL default 0, PRIMARY KEY (`id`)) ENGINE=MyISAM;";

psmt=con.prepareStatement(query4);

psmt.executeUpdate();

String query5 = "CREATE TABLE `transtest`.`transone` (`id` tinyint(4) NOT NULL auto_increment,`val` int(5) NOT NULL default 0, PRIMARY KEY (`id`)) ENGINE=MyISAM;";

psmt=con.prepareStatement(query5);

psmt.executeUpdate();

String query6 = "CREATE TABLE `transtest`.`transtwo` (`id` tinyint(4) NOT NULL auto_increment,`val` int(5) NOT NULL default 0, PRIMARY KEY (`id`)) ENGINE=MyISAM;";

psmt=con.prepareStatement(query6);

psmt.executeUpdate();

for(int i=1;i<=10;i++){

String query7 = "insert into `transtest`.`transtwo` (`val`) values ("+i*2+");";

psmt=con.prepareStatement(query7);

psmt.executeUpdate();

}

String query8 = "insertd into `transtest`.`trans` (`val`) values (500);";

psmt=con.prepareStatement(query8);

psmt.executeUpdate();

JOptionPane.showMessageDialog(null, "Process completed!");

con.commit();

con.setAutoCommit(true);

}catch(SQLException sqle){

try {

con.rollback(spt1);

JOptionPane.showMessageDialog(null, "Rollback1!");

} catch (SQLException e) {