jdbc savePoint

最新推荐文章于 2021-10-28 10:11:27 发布

自找苦吃，自得其乐

最新推荐文章于 2021-10-28 10:11:27 发布

阅读量644

点赞数

CC 4.0 BY-SA版权

分类专栏： 22_oracle 文章标签： jdbc insert exception import url string

本文链接：https://blog.youkuaiyun.com/tengdazhang770960436/article/details/7061774

22_oracle 专栏收录该内容

82 篇文章

订阅专栏

本文详细介绍了如何使用Java编程语言在数据库操作中应用事务回滚和保存点技术，确保数据一致性。通过设置事务为非自动提交状态，并在关键操作处设置保存点，可以在发生错误时快速回滚到上一个保存点状态，避免数据污染。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

public class TestSavePoint {

public static void main(String[] args) throws Exception {
TestSavePoint tsp=new TestSavePoint();

Connection conn=tsp.getConn();

//设置自动提交失效

conn.setAutoCommit(false);
Statement stmt=conn.createStatement();
Savepoint sp1=conn.setSavepoint("p1");
stmt.executeUpdate("insert into student(name,sex,grade) values('fengbei','m','2008811237')");
stmt.executeUpdate("insert into student(name,sex,grade) values('lisong','m','2008811221')");
Savepoint sp2=conn.setSavepoint("p2");
stmt.executeUpdate("insert into student(name,sex,grade) values('heyanjie','m','2008811216')");
Savepoint sp3=conn.setSavepoint("p3");
ResultSet rs=stmt.executeQuery("select * from student where name='wangshuhui'");
if(!rs.next()){
conn.rollback(sp1);
}
conn.commit();
rs=stmt.executeQuery("select * from student");
while(rs.next()) {
System.out.println("Row: "+rs.getRow()+"\tId: "+rs.getInt(1)+"\tName: "+rs.getString(2)
+"\tSex: "+rs.getString(3)+"\tGrade: "+rs.getString(4));
}
stmt.close();
conn.close();
}
//获取连接
public Connection getConn() {
Connection conn=null;
String url="jdbc:mysql://localhost/dandan?user=root&password=dada";
try {
Class.forName("org.gjt.mm.mysql.Driver");
try {
conn=DriverManager.getConnection(url);
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
}