Profil von jorio

jorio

17.02.2013, 16:21

CODE:

try { conn = DriverManager.getConnection("jdbc:mysql://" + host + "/" + data, user, pw); Statement stmt = conn.createStatement();

                               boolean check = true;
                               boolean check2 = true;
                               ResultSet rs = stmt.executeQuery("SELECT * FROM freunde WHERE Spieler='" + p.getName() + "'");
                               ResultSet rs2 = stmt.executeQuery("SELECT * FROM freunde WHERE Spieler='" + freund.getName() + "'");
                               while(rs.next()){
                                   check = false;
                                   String Freunde = rs.getString("Freunde");
                                   Freunde = Freunde + "," + freund.getName();
                                   stmt.executeUpdate("INSERT INTO freunde (Spieler, Freunde) VALUES('" + p.getName() + "', '" + Freunde + "')");
                               }
                               rs.close();
                               while(rs2.next()){
                                   check2 = false;
                                   String Freunde = rs.getString("Freunde");
                                   Freunde = Freunde + "," + p.getName();
                                   stmt.executeUpdate("INSERT INTO freunde (Spieler, Freunde) VALUES('" + freund.getName() + "', '" + Freunde + "')");
                               }
                               rs2.close();
                               if(check){
                                   stmt.executeUpdate("INSERT INTO freunde (Spieler, Freunde) VALUES('" + p.getName() + "', '" + freund.getName() + "')");

                               }
                               if(check2){
                                   stmt.executeUpdate("INSERT INTO freunde (Spieler, Freunde) VALUES('" + freund.getName() + "', '" + p.getName() + "')");

                               }


                               stmt.close();

                            } catch (SQLException e) {
                                System.err.println("Keine Verbindung möglich!");
                                e.printStackTrace();
                                System.err.println("SQLExecption: " + e.getMessage());
                                System.err.println("SQLState: " + e.getSQLState());
                                System.err.println("VendorError: " + e.getErrorCode());
                                System.err.println("Bitte in der Config die MYSQL Daten ändern!");



                            } finally {
                                if (conn != null) {
                                try {
                                    conn.close();
                                } catch (SQLException e) {
                                    e.printStackTrace();
                                }
                                }
                            }

Was ist daran falsch?

Stacktrace: 2013-02-17 15:40:37 [SEVERE] java.sql.SQLException: Operation not allowed after ResultSet closed 2013-02-17 15:40:37 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) 2013-02-17 15:40:37 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) 2013-02-17 15:40:37 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) 2013-02-17 15:40:37 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) 2013-02-17 15:40:37 [SEVERE] at com.mysql.jdbc.ResultSetImpl.ch