Getting "Query does not returns results" SQL exception

Question

I was trying to make a register program in Java in Eclipse. But i got an error :

java.sql.SQLException: Query does not return results

You can see my following code :

Login.addnewuser(lblname.getText(), lblusername.getText(), lblpseudo.getText(), passwordField.getText(), rankchoice.getSelectedItem());

of :

    public static void addnewuser(String Name, String Username, String Pseudo, String Password, String Rank) {

    String query = ("INSERT INTO UsersInfos (Name, Username, Pseudo, Password, Rank) " + "VALUES ('"  + Name +  "' , '"  + Username +  "' , '"  + Pseudo +  "' , '"  + Password +  "' , '"  + Rank +  "')");

    connection = SqliteConnection.dbConnector();

    try {

        PreparedStatement name2 = connection.prepareStatement(query);
        name2.executeQuery();

    } catch (SQLException e) {

        e.printStackTrace();

    }

}

Can someone help me please ? Thanks :) !

Answer 1

For INSERT, UPDATE or DELETE use the executeUpdate() method and for SELECT use the executeQuery() method which returns the ResultSet.