简单修改数据使用commit

最新推荐文章于 2022-05-10 19:17:17 发布

clearlove_t

最新推荐文章于 2022-05-10 19:17:17 发布

阅读量336

点赞数

CC 4.0 BY-SA版权

分类专栏： OracleJava基础

本文链接：https://blog.youkuaiyun.com/clearlove_t/article/details/94614153

OracleJava基础专栏收录该内容

3 篇文章

订阅专栏

本文展示了一个使用Java连接Oracle数据库并进行事务处理的示例，包括查询、更新操作及提交事务的过程。

package com.my_java_oracle;

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

public class commit {
public static void main(String[] args) {

try {
	Class.forName("oracle.jdbc.driver.OracleDriver");
	
	try {
		Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "123");
		conn.setAutoCommit(false);
	//先查询在执行再查询
		String sql1="select empno,ename,sal from emp";
		String sql2="update emp set sal=sal-100 where ename='SCOTT'";
		String sql3="update emp set sal=sal+100 where ename='SMITH'";
		
		Statement stmt = conn.createStatement();
		ResultSet rs = stmt.executeQuery(sql1);
		System.out.println("-----------更改前-----------");
		System.out.println("编号"+"\t"+"姓名"+"\t"+"薪水");
		while(rs.next()) {
			int empno=rs.getInt(1);
			String  ename=rs.getString(2);
			double sal=rs.getDouble(3);
			System.out.println(empno+"\t"+ename+"\t"+sal);
		}
		
		System.out.println("----------更新后----------");
		System.out.println("编号"+"\t"+"姓名"+"\t"+"薪水");
		
		
		stmt.executeUpdate(sql2);
		//int i=3/0;
		stmt.executeUpdate(sql3);
		conn.commit();
		
		ResultSet rs2 = stmt.executeQuery(sql1);
		
		while(rs2.next()) {
			int empno=rs2.getInt(1);
			String  ename=rs2.getString(2);
			double sal=rs2.getDouble(3);
			System.out.println(empno+"\t"+ename+"\t"+sal);
		}
		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}

} catch (ClassNotFoundException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}

}
}