How to edit a row

[James Eman]

So I have a program that asks questions and then submits the number of correct response to a database(MYSQL). Keeps saying

java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
	at com.mysql.jdbc.StatementImpl.checkForDml(StatementImpl.java:502)
	at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1565)
	at Submit.check(Submit.java:34)
	at Submit.<init>(Submit.java:17)
	at GUITableResult.<init>(GUITableResult.java:56)
	at GUI.done(GUI.java:257)
	at GUI.sys(GUI.java:233)
	at GUI.submit(GUI.java:99)
	at GUI.actionPerformed(GUI.java:85)
	at javax.swing.JTextField.fireActionPerformed(JTextField.java:508)
	at javax.swing.JTextField.postActionEvent(JTextField.java:721)
	at javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:836)
	at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1662)
	at javax.swing.JComponent.processKeyBinding(JComponent.java:2878)
	at javax.swing.JComponent.processKeyBindings(JComponent.java:2925)
	at javax.swing.JComponent.processKeyEvent(JComponent.java:2841)
	at java.awt.Component.processEvent(Component.java:6282)
	at java.awt.Container.processEvent(Container.java:2229)
	at java.awt.Component.dispatchEventImpl(Component.java:4861)
	at java.awt.Container.dispatchEventImpl(Container.java:2287)
	at java.awt.Component.dispatchEvent(Component.java:4687)
	at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1895)
	at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:762)
	at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1027)
	at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:899)
	at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:727)
	at java.awt.Component.dispatchEventImpl(Component.java:4731)
	at java.awt.Container.dispatchEventImpl(Container.java:2287)
	at java.awt.Window.dispatchEventImpl(Window.java:2719)
	at java.awt.Component.dispatchEvent(Component.java:4687)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
	at java.awt.EventQueue.access$200(EventQueue.java:103)
	at java.awt.EventQueue$3.run(EventQueue.java:694)
	at java.awt.EventQueue$3.run(EventQueue.java:692)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
	at java.awt.EventQueue$4.run(EventQueue.java:708)
	at java.awt.EventQueue$4.run(EventQueue.java:706)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

Here is my code

import java.sql.*;  
import java.sql.DriverManager;  
import java.sql.SQLException;  
import java.net.*;  

public class Submit  
{ 
    int x;
    int y;
    public Submit(int x1,int y2)
    {
        x = x1;
        y = y2;

        try
        {
            check();
        }
        catch (Exception e) {  
            e.printStackTrace();  
        }
    }

    public boolean check() throws SQLException {  

        boolean login = false;
        Connection con = null;  

        try {  
            Class.forName("com.mysql.jdbc.Driver");  
            con = DriverManager.getConnection("jdbc:mysql://192.168.1.178:3308/chemworld", "Client", "PC-2011.com");  

            Statement st = con.createStatement();  
            ResultSet rs = st.executeQuery("UPDATE `chemworld`.`users` SET `Score`='"+y+"' WHERE `ID`='"+x+"'");

        } catch (Exception e) {  
            e.printStackTrace();  
        } finally {  
            if(con != null) {  
                con.close();  
            }  
        }  
        return login;
    }  
}

y is the row the user is located and x is the number of questions they got right.
Any suggestions i'm not the greatest in MySQL yet but i am trying to teach myself.

[Jeanne Boyarsky]

st.executeQuery is for select statements. st.executeUpdate is for insert/update/delete statements.

The error message does hint at this with "Can not issue data manipulation statements with executeQuery()." It just doesn't tell you the fix. As you learn about JDBC, look into PreparedStatements. They are easier to use when setting parameters. And safer too - you don't have to worry about evil users attacking your database with SQL Injection.