怎样设置ResultSet为可更新结果集?在线等待... Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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); } } 一个季度没来了《送点分给大家》 将条过长的通知分成两条存起来怎么弄,求大神指导!!!(java 语言) 文思创新公司怎么样? 简单问题一个 epr是什么意思 如何获取文本区的行和列数?急!!! 怎样通过一个链接打开.wma文件????? html的简单问题 关于classpath 找开源的JMS Server(非集成)。 struts的action与页面传值的问题。 急!急!急!struts1.1中的<action>的input属性问题!!!
/**@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);
} }