为什么ResultSet rs1 = st.executeUpdate(sql);的地方报错
来源:百度知道 编辑:UC知道 时间:2024/06/07 12:34:00
try {
InitialContext ctx;
ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:/comp/env/jdbc/pgsql");
Connection con= ds.getConnection();
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sqlString);
while (rs.next()) {
moveFile("d:/"+rs.getString("wave_filename"), "d:/tmp");
String WaveFilename=rs.getString("wave_filename");
if(WaveFilename!=null){
String sql = "update record set export_audio_file_flag=1 where wave_filename='" + WaveFilename+"'" ;
System.out.print(sql+"\n");
ResultSet rs1 = st.executeUpdate(sql);
}
}
rs.close();
st.close();
con.close();
}
catch (Exception e) {
System.out.print(e.getMessage());
}
InitialContext ctx;
ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:/comp/env/jdbc/pgsql");
Connection con= ds.getConnection();
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sqlString);
while (rs.next()) {
moveFile("d:/"+rs.getString("wave_filename"), "d:/tmp");
String WaveFilename=rs.getString("wave_filename");
if(WaveFilename!=null){
String sql = "update record set export_audio_file_flag=1 where wave_filename='" + WaveFilename+"'" ;
System.out.print(sql+"\n");
ResultSet rs1 = st.executeUpdate(sql);
}
}
rs.close();
st.close();
con.close();
}
catch (Exception e) {
System.out.print(e.getMessage());
}
第一个sql还没执行完就又执行了另外的sql
把
String sql = "update record set export_audio_file_flag=1 where wave_filename='" + WaveFilename+"'" ;
System.out.print(sql+"\n");
ResultSet rs1 = st.executeUpdate(sql);
另外写个方法执行.用单独的连接,操作完后关闭连接
ResultSet rs1 = st.executeUpdate(sql);
st.executeUpdate的返回值是int
st.executeUpdate(sql);返回值是受到影响的行数。不是ResultSet,是Int
那个,System.out.print(sql+"\n");输出的啥啊