//使用java代码操作oracle数据库的代码如下:
package Transaction;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class demon_1 {
public static void main(String[] args) throws SQLException {
//2:连接数据库
Connection ct=null;
//加载数据库驱动
try {
//1:加载数据库驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
ct=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","SCOTT","toor");
//3:预编译sql语句
// PreparedStatement ps=ct.prepareStatement();
//两种预编译都可以
Statement ps=ct.createStatement();
//4: 执行sql语句,执行结果集
ResultSet res=ps.executeQuery("select * from emp_1");
while(res.next()){
System.out.println("员工名字是:"+res.getString("ename"));
}
//执行事务
ct.setAutoCommit(false);
ps.executeUpdate("update emp_1 set ename='ccc' where empno=4");
ps.executeUpdate("update emp_1 set ename='bbb' where emno=2");
//提交事务
ct.commit();
ct.close();
} catch (Exception e) {
//取消事务
ct.rollback();
System.out.println("SQL语句执行错误。执行了事务回滚");
}
}
}