Question

为什么ResultSet rs1 = st.executeUpdate(sql);的地方报错

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());
}

Answer 1

第一个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);
另外写个方法执行.用单独的连接,操作完后关闭连接

Answer 2

ResultSet rs1 = st.executeUpdate(sql);

st.executeUpdate的返回值是int

Answer 3

st.executeUpdate(sql);返回值是受到影响的行数。不是ResultSet，是Int

Answer 4

那个,System.out.print(sql+"\n");输出的啥啊