[Solved] Can anyone please correct this SQL syntax exception

by

[ad_1]

index is a keyword, if you use this as a column name try escaping it with tilts. (`)

....
PreparedStatement ps=(PreparedStatement) dbConnection.prepareStatement(" select `index` from books where `index`=? ");
....

[ad_2]

solved Can anyone please correct this SQL syntax exception