JDBC设置回滚点

最新推荐文章于 2023-02-19 08:59:49 发布

u010487489

最新推荐文章于 2023-02-19 08:59:49 发布

阅读量192

点赞数

分类专栏： java 文章标签： JDBC 回滚点

本文链接：https://blog.csdn.net/u010487489/article/details/84617466

版权

java 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

有的时候操作数据库需要先删除一个数据表的数据，然后再插入另一个表的数据，这个时候就需要使用回滚点，示例代码如下

//添加一个新的行业类型
	public int addSupplierDetailModelEnt(List<String> newName,List<String> newSelect,List<String> minLength,List<String> maxLength,List<String> chooseType,List<String> newDescribe,int Relation_Company_id) throws SQLException {
	    Savepoint sp = null;  
	    System.out.println("addSupplierDetailModelEnt begin!");
	    System.out.println("Relation_Company_id : "+Relation_Company_id);
	    //删除原来的数据	
	    String basicInfoSql2 = "delete from supplier_detail_model where Relation_Company_id = ? ";
	    	// 插入一条数据
		String basicInfoSql = "insert into supplier_detail_model(Field_name,Field_type,minLength,maxLength,chooseType,newDescribe,Relation_Company_id) values(?,?,?,?,?,?,?)";
		conn = bdConn.getConnection();
		int[] count = new int[newName.size()];
		try {
		    conn.setAutoCommit(false); 
		    pstm = conn.prepareStatement(basicInfoSql2);
			pstm.setInt(1, Relation_Company_id);
			pstm.executeUpdate();
			sp = conn.setSavepoint();    //设置回滚点  
		    pstm = conn.prepareStatement(basicInfoSql);
		    for(int i=0;i<newName.size();i++){
			System.out.println(i);
			pstm.setString(1, newName.get(i));
			pstm.setString(2, newSelect.get(i));
			pstm.setString(3, minLength.get(i));
			pstm.setString(4, maxLength.get(i));
			pstm.setString(5, chooseType.get(i)==null?"no":chooseType.get(i));
			pstm.setString(6, newDescribe.get(i)==null?"no":newDescribe.get(i));
			pstm.setInt(7, Relation_Company_id);
			pstm.addBatch();
		    }
			count = pstm.executeBatch();
			System.out.println("addSupplierDetailModelEnt commit!");
			conn.commit();
		} catch (Exception e) {
		    System.out.println("addSupplierDetailModelEnt rollback!");
		              conn.rollback(sp);//回滚到那个事务点上去
		              conn.commit();
		              e.printStackTrace();
		} finally {
			try {
				DBConnection.closeResultSet(rs);
			} catch (SQLException e) {
				e.printStackTrace();
			}
			try {
				DBConnection.closePtmt(pstm);
			} catch (SQLException e) {
				e.printStackTrace();
			}
			try {
				DBConnection.closeConnection(conn);
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return count.length;
	}