Updating Ms Access Database using jsp

[gauravmanral]

I am updating my MS Access database using JSP.

I am getting this exception...

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

table name is "user_registration".
My code is--

ResultSet rs;
rs = st1.executeQuery("select * from user_registration where username='" + s1 + "' and password='" + s2 + "'");


while(rs.next())
{
PreparedStatement ps=null;

ps=con.prepareStatement("update user_registration set values(?,?,?,?,?,?,?,?,?,?,?,?,?) where username=?");

ps.setString(14,username);
ps.setString(1,firstname);
ps.setString(2,lastname);
ps.setString(3,username);
ps.setString(4,password);
ps.setString(5,confirm);
ps.setString(6,date);
ps.setString(7,month);
ps.setString(8,year);
ps.setString(9,gender);
ps.setString(10,mobile);
ps.setString(11,email);
ps.setString(12,image);
ps.setString(13,"u");

if(ps!=null)
{
ps.executeUpdate();
}
else
{
ps.close();
}

if(con==null)
{
con.close();
}

}




Please Help..!!

[DarrylBurke]

BB Code List - Java Programming Forum

db

[Tolls]

Please use [code] tags [/code] when posting code. See the link provided by Darryl.
What do the Access docs say about the structure of an UPDATE statement?
Are you sure your fields are all Strings (VARCHAR or whatever they're called in Access) in the database?

[gauravmanral]

I have checked, All fields are strings.

[gauravmanral]

thanks Darryl....I will mind this now..

[Tolls]

Run that update directly in Access, with the values you are having problems with.

[gauravmanral]

now this exception is occured...


java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

[Tolls]

Which is the same as the other exception.
All that means is there is a problem in your update SQL.
Not really a Java problem to be honest.