To update the contents of the ResultSet you need to create a statement by passing the ResultSet type updatable, as:
//Creating a Statement objectStatement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
就像getXXX()和setXXX()方法一样，ResultSet接口还提供了updateXXX()方法来更新结果集中行的内容。
这些方法接受表示要更新的行的索引或列标签的字符串值。
请注意，如果您需要更新ResultSet的内容，表格应该有一个主键。
立即进入“豆包AI人工智官网入口”；
立即学习“豆包AI人工智能在线问答入口”；
示例
假设我们有一个名为Employees的表，其中有5条记录，如下所示：
+----+---------+--------+----------------+| Id | Name | Salary | Location |+----+---------+--------+----------------+| 1 | Amit | 3000 | Hyderabad || 2 | Kalyan | 4000 | Vishakhapatnam || 3 | Renuka | 6000 | Delhi || 4 | Archana | 9000 | Mumbai || 5 | Sumith | 11000 | Hyderabad |+----+---------+--------+----------------+
以下示例演示了如何更新结果集的内容：
import java.sql.*;public class ResultSetExample { public static void main(String[] args) throws Exception { //Registering the Driver DriverManager.registerDriver(new com.mysql.jdbc.Driver()); //Getting the connection String mysqlUrl = "jdbc:mysql://localhost/TestDB"; Connection con = DriverManager.getConnection(mysqlUrl, "root", "password"); System.out.println("Connection established......"); //Creating a Statement object Statement stmt = con.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); //Retrieving the data ResultSet rs = stmt.executeQuery("select * from Employees"); //Printing the contents of the table System.out.println("Contents of the table: "); printRs(rs); //Moving the pointer to the starting point in the ResultSet rs.beforeFirst(); //Updating the salary of each employee by 5000 while(rs.next()){ //Retrieve by column name int newSal = rs.getInt("Salary") + 5000; rs.updateInt( "Salary", newSal ); rs.updateRow(); } System.out.println("Contents of the ResultSet after increasing salaries"); printRs(rs); // Set position to second record first rs.beforeFirst(); rs.absolute(2); System.out.println("Record we need to delete: "); System.out.print("ID: " + rs.getInt("id")); System.out.print(", Salary: " + rs.getInt("Salary")); System.out.print(", Name: " + rs.getString("Name")); System.out.println(", Location: " + rs.getString("Location")); System.out.println(" "); //Deleting the row rs.deleteRow(); System.out.println("Contents of the ResultSet after deleting one records..."); printRs(rs); System.out.println("Goodbye!"); } public static void printRs(ResultSet rs) throws SQLException{ //Ensure we start with first row rs.beforeFirst(); while(rs.next()){ System.out.print("ID: " + rs.getInt("id")); System.out.print(", Salary: " + rs.getInt("Salary")); System.out.print(", Name: " + rs.getString("Name")); System.out.println(", Location: " + rs.getString("Location")); } System.out.println(); }}
输出
Connection established......Contents of the table:ID: 1, Salary: 3000, Name: Amit, Location: HyderabadID: 2, Salary: 4000, Name: Kalyan, Location: VishakhapatnamID: 3, Salary: 6000, Name: Renuka, Location: DelhiID: 4, Salary: 9000, Name: Archana, Location: MumbaiID: 5, Salary: 11000, Name: Sumith, Location: HyderabadConetnets of the resultset after increaing salariesID: 1, Salary: 8000, Name: Amit, Location: HyderabadID: 2, Salary: 9000, Name: Kalyan, Location: VishakhapatnamID: 3, Salary: 11000, Name: Renuka, Location: DelhiID: 4, Salary: 14000, Name: Archana, Location: MumbaiID: 5, Salary: 16000, Name: Sumith, Location: HyderabadRecord we need to delete:ID: 2, Salary: 9000, Name: Kalyan, Location: VishakhapatnamContents of the resultset after deleting one records...ID: 1, Salary: 8000, Name: Amit, Location: HyderabadID: 3, Salary: 11000, Name: Renuka, Location: DelhiID: 4, Salary: 14000, Name: Archana, Location: MumbaiID: 5, Salary: 16000, Name: Sumith, Location: HyderabadGoodbye!
以上就是如何使用 JDBC 程序更新 ResultSet 的内容？的详细内容，更多请关注创想鸟其它相关文章！
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/114807.html
微信扫一扫 
支付宝扫一扫 
