在查询后,用ResultSet.update更新数据
package cn.itcast.jdbc;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class UpdateTest {
public static void read(){
Connection conn = null;
Statement st = null;
ResultSet rs = null;
try {
conn = JdbcUtils.getConnection();
//设置可滚动,可更新
st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = st.executeQuery("select id,name,birthday,money from user");
//下一条
while(rs.next()){
System.out.println(rs.getObject("id"));
System.out.println(rs.getObject("name"));
System.out.println(rs.getObject("birthday"));
System.out.println(rs.getObject("money"));
String name = rs.getString("name");
/*更新数据*/
if("batch name0".equals(name)){
rs.updateString("name", "updateName");
rs.updateRow();
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
JdbcUtils.free(rs, st, conn);
}
}
public static void main(String[] args){
UpdateTest.read();
}
}