Looking for MySQL / JDBC expert

[Celestin]

Yeah, I know a gaming forum isn't the best place to post this ( I'm posting in some other areas as well ), but my god, if you can help me, please do so.

I'm going to take a nap because I pretty much have to.

If you know how to perform an insert query into MySQL using JDBC, please help me! :O

This is what I have:

query = "insert into stars value(" +starId +", '" +firstName +"', '" +lastName +"', null, '" +url +"');";
System.out.println(query);
            
try {
   select = connection.createStatement();
   result = select.executeQuery(query);
} catch (SQLException e) {
   System.out.println("Error: I have no idea at all what this error indicates."
      +"n");
}

And this is the output:

Requested Id: 2
First name: Frank
Last name: Lee
Photo URL: www.url.com
insert into stars value(2, 'Frank', 'Lee', null, 'www.url.com');
Error: I have no idea at all what this error indicates.

The output is a copy paste of what happens when I run that part of my program. The blue is user input, everything else is system output.

The error that is being caught is a general SQL error, could really be anything like column count mismatch or something. Anything that causes the MySQL db backend to freak out. I'm also too lazy to come up with a solution or create a better error message.

I have checks on all the inserted fields to ensure they are of the right type. As far as I can tell, the insert query itself is correct so I think it has something to do with the code, specifically the select.executeQuery(query) part. Please halp!

[arkhaal]

It's because your request is an "INSERT", so you have to use "executeUpdate" instead of "executeQuery" in the part :

try {
   select = connection.createStatement();
   result = select.executeQuery(query);
} catch (SQLException e) {
   System.out.println("Error: I have no idea at all what this error indicates."
      +"n");
}

should be :

try {
   select = connection.createStatement();
   result = select.executeUpdate(query);
} catch (SQLException e) {
   System.out.println("Error: I have no idea at all what this error indicates."
      +"n");
}

and you can modity your error msg to :

System.err.println("error : " + e.getMessage());

soo.... final code is :

try {
   select = connection.createStatement();
   result = select.executeUpdate(query);
} catch (SQLException e) {
   System.err.println("error : " + e.getMessage());
}