问题描述
java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
问题代码
try {
connection = DriverManager.getConnection(url, user, password);
sql = connection.createStatement();
sql.executeQuery(condition1);
sql.executeQuery(condition2);
sql.executeQuery(condition3);
connection.close();
}catch (Exception e){
out.print(""+e);
}
解决方法
try {
connection = DriverManager.getConnection(url, user, password);
sql = connection.createStatement();
sql.execute(condition1);
sql.execute(condition2);
sql.execute(condition3);
connection.close();
}catch (Exception e){
out.print(""+e);
}
即sql.executeQuery()
改为sql.execute()