Query Correct, but not functioning

[Michael Paul]

Hi,

I am trying to write to a DB from my code however the data is not writing to the database. I ran the SQL statement through the DB Frontend that I use and it worked, however through my code it does not work. Here is the snippit:

  public class SubmitListener implements ActionListener {
public void actionPerformed(ActionEvent arg) {
Connection conn;
conn = null;
try {
String userName = "root";
String password = "asdf";
String url = "jdbc:mysql://localhost/test";
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(url, userName, password);
Statement stmt = conn.createStatement();
String temp = "INSERT INTO member VALUES ('"
+ UserIDtxf.getText() + "','" + Passtxf.getText() + "',' ', ' ', ' ')";
System.out.println(temp);
stmt.executeQuery("INSERT INTO member VALUES ('name asdf','asdf','ddd ', 'fff','ccc');");
 
} catch (Exception e9) {
}  

Any help at all would be appreciated, I am very stumped,

Atreides

[Bear Bibeault]

"Atreides", please check your private messages for an important administrative matter.

[David O'Meara]

} catch (Exception e9) {
} 

But how would you know if anything was failing?

[Michael Paul]

I did a printStackTrace, and it said I couldn't use "executeQuery" to manipulate data. So I used executeUpdate and it worked, thanks for reminding me to do a printstacktrace, i was being dumb, thanks again!

Michael
[ April 16, 2008: Message edited by: Michael Paul ]

[David O'Meara]

Yes, you ninny :P

Although keep in mind that printStackTrace doesn't count as 'handling the exception' either, but it's one step better than swallowing it without comment.