Can I use a java variable in an SQL statement written in a java program?
I am trying to have user input for my java program which takes input variables from a user and inserts them into my postgresql database.
The problem is that at the moment I get an attribute not found error. Below is a snippit of the code:
...<<buffreredReader code here...>>...
String name = tKeyboard.readLine();
st.executeUpdate("INSERT INTO TEST13 " + "VALUES (name)");
The program compiles ok, but when run the program says attribute 'name' not found under SQL Exception.
Any help is much appreciated.
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2001-04-30 03:58:50|
|Subject: Re: take my index, please |
|Previous:||From: suhail sarwar||Date: 2001-04-29 15:00:04|
|Subject: Multiple SQL statements in a java program for postgresql DB|