Database help... whats wrong?

Hi all,

I am trying to make an SQL statement which inserts values in to a database. So far, i have typed this in but it doesnt work and Netbeans gives a red error line underneath the line which reads ResultSet theResult=theStatement.executeQuery("INSERT INTO etc etc

You should really use PreparedStatement and not cobble together statements like this. That will prevent a lot of these sorts of errors, as well as automatically correctly formatting values, and help to prevent SQL Injection attacks.