简单修改数据_鑫洋数据修改-优快云博客

本文展示了一个使用Java进行Oracle数据库操作的例子，包括连接数据库、查询数据、执行更新操作并再次查询验证更改结果的全过程。代码中详细展示了如何通过Java的SQL API执行SQL语句，适用于初学者学习和参考。

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 update2 {
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");
	
	//先查询在执行再查询
		String sql1="select empno,ename,sal from emp";
		String sql2="update emp set sal='800' 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);
		 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);
		}
		
		rs2.close();
		rs.close();
		stmt.close();
		conn.close();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}

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

}
}