Correct jdbc syntax for complicated update statement

brendanmcdonagh

Hi all(again)

I'm struggling with similar issue as yesterdays, I can't seem to find any decent info on how to build sql statements using java and it's variables. Any suggestions would be great. Here's my code ....

Expand|Select|Wrap|Line Numbers

 String strSQL = "UPDATE customers SET customerName='" +name + "', customerAddress='" +address + "', customerEmail = '" +email + "', customerNumber = '" +phone + "', customerPurchase = '" +purchase + "' WHERE id='" +number + "';
 
            s.executeUpdate(strSQL);

I'm trying to update database with java variables name, address, email, phone, purchase into columns where id(access auto increment column) = number(java variable)

I'm just getting a unclosed String literal but I know this won't be the correct way to do it anyway - it was just a guess.
Any one know how to do it?

r035198x

Start by reading Sun's JDBC tutorial.

brendanmcdonagh

Hi, i have just read through the tutorial but still can't find reference to add java variables value correctly into a sql statement.

just tried this but getting null pointer exception

Expand|Select|Wrap|Line Numbers

 PreparedStatement updateSales ;
 
String updateString = "UPDATE customers " +

                      "SET customerName = ? where id = ?";

updateSales = con.prepareStatement(updateString);

updateSales.setString(1, name);

updateSales.setInt(2, idNumber);

//updateSales = con.prepareStatement(updateString);

updateSales.executeUpdate();

If anyone can tell me the syntax then I would know how to insert, delete, and update, don't need to know any more!!

JosAH

Quote:

Originally Posted by brendanmcdonagh

Hi, i have just read through the tutorial but still can't find reference to add java variables value correctly into a sql statement.

just tried this but getting null pointer exception

Please think before you post: a NullPointerException is thrown when something is null which it shouldn't be. Look at your code: are all variables unequal to null? Hint: System.out.println() is your friend.

If the creation of the PreparedStatemnt fails another exception is thrown (always read the API documentation before you start coding so you don't have to guess).

kind regards,

Jos

Correct jdbc syntax for complicated update statement

re: Correct jdbc syntax for complicated update statement

re: Correct jdbc syntax for complicated update statement

re: Correct jdbc syntax for complicated update statement

Similar Java bytes

/bytes/development

/bytes/it

/bytes/about