怎样设置ResultSet为可更新结果集？在线等待...

Question

Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);

Answer 1

public void updateChangeInfo(ChangeInfo info) throws Exception {
    /**@todo Complete this method*/
    String sql = "select  n.*  from xj_xjyd  n  where id=?";
    PreparedStatement prepareStatement = null;
    ResultSet resultSet = null;
    Connection conn = null;
    try {
      conn = getConnection();
      prepareStatement = conn.prepareStatement(sql,
                                               ResultSet.TYPE_SCROLL_SENSITIVE,
                                               ResultSet.CONCUR_UPDATABLE);
      prepareStatement.setInt(1, info.getChangeNumber());
      resultSet = prepareStatement.executeQuery();      while (resultSet.next()) {
        resultSet.updateString(info.studentName_C, info.getStudentName());
        resultSet.updateString(info.studentNumber_C, info.getStudentNumber());
        java.sql.Date start = (java.sql.Date)new DateConvert().
            convertFormToObject(info.getStartDate());
        resultSet.updateDate(info.startDate_C, start);
        resultSet.updateString(info.whychange_C, info.getWhychange());
        resultSet.updateString(info.re_C, info.getRe());
        resultSet.updateString(info.transactor_C, info.getTransactor());        resultSet.updateRow();
      }      log.info("更新数据成功 :" + info);
    }
    catch (SQLException e) {
      log.error("更新数据失败");
      throw e;
    }
    finally {
     release(resultSet,prepareStatement,conn);
    }  }