mysql resultset null_java.sql.SQLException：ResultSet关闭MySQL Java后不...

每当我尝试使用这种方法时,我都会继续这样做.

java.sql.SQLException: Operation not allowed after ResultSet closed

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)

at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)

at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7077)

at server.util.Plimus$1.run(Plimus.java:77)

这是在第77行：while(resultSet.next()){

public static void process(final Player c, final String playerName) {

if (connection == null && connectionStatus == 0)

createConnection();

else if (connectionStatus != 0)

return;

new Thread() {

@Override

public void run() {

try {

String username = playerName.replaceAll(" ", "_");

String query = "SELECT * FROM donations WHERE username = '" + username + "' AND received = '0' LIMIT 1;";

ResultSet resultSet = query(query);

while (resultSet.next()) {

int[] contractIds = {3178768, 1}; //put all of your contract ids in here.

int contractId = Integer.parseInt(resultSet.getString("contract")), id = Integer.parseInt(resultSet.getString("id"));

query("UPDATE donations SET received = '1' WHERE username = '" + username + "' AND id = '" + id + "';");

if (contractId == contractIds[0]) { //first contract id in array.

c.getItems().addItem(962, 1);

} else if (contractId == contractIds[1]) { //second contract id in array.

c.getItems().addItem(962, 1);

}

}

} catch (Exception e) {

e.printStackTrace();

processMethod(0, true, true, false);

}

}

}.start();

}

这是请求的查询方法.

/**

* Creates query function.

*/

public static ResultSet query(String s) throws SQLException {

try {

if (s.toLowerCase().startsWith("select")) {

ResultSet resultSet = statement.executeQuery(s);

return resultSet;

} else {

statement.executeUpdate(s);

}

return null;

} catch (Exception e) {

e.printStackTrace();

processMethod(0, true, true, false);

}

return null;

}