在JDBC中处理可更新的结果集

 

import java.sql.*;

public class TestPrepStmt ...{

    public static void main(String[] args) ...{
        
        Statement stmt = null;
        Connection conn = null;
        try ...{
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost/data?user=root&password=123456";
            conn = DriverManager.getConnection(url);
            //注意处理可更新的结果集时，只能处理一张表，而且表中必须有主键。
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
            
            ResultSet rs=stmt.executeQuery("select * from user");
            
            rs.next();//定位到下一条记录
            //更新一行数据
            rs.updateString("name","AAAA");
            rs.updateRow();

            //插入新行
            rs.moveToInsertRow();
            //rs.updateInt(1, 99);
            rs.updateString("name","AABB");
            rs.updateString("address", "BBBB");
            rs.insertRow();
            //将光标移动到新建的行
            rs.moveToCurrentRow();

            //删除行
            rs.absolute(5);
            rs.deleteRow();

            //取消更新
            //rs.cancelRowUpdates();
            
            
        } catch (ClassNotFoundException e) ...{
            e.printStackTrace();
        } catch (SQLException e) ...{
            e.printStackTrace();
        } finally ...{
            try ...{
                if(stmt != null) ...{
                    stmt.close();
                    stmt = null;
                }
                if(conn != null) ...{
                    conn.close();
                    conn = null;
                }
            } catch (SQLException e) ...{
                e.printStackTrace();
            }
        }
    }

}