how to use 'where' clause

[gaurav chhabra]

sir i m using MS ACCESS and writing the query...

String query = "select * from general_information where id = '" + id5+ "'";

id is "int" and id5 is also an "int"....

id5 is a variable....of int type
but if i write the above query then it is giving no result but if i m writing ...

String query = "select * from general_information where id = 10 ";

then it is working........

please tell me for the query........
thank you
gaurav

[David Ulicny]

try to remove ' '

[Avi Abrami]

Gaurav,
In my opinion, better to use a "PreparedStatement".
[NOTE: Below code is uncompiled and untested.]

import java.sql.*;
public class Gaurav {
  public static void main(String[] args) {
    Connection c = // However you get it.
    String sql = "select * from GENERAL_INFORMATION where ID = ?";
    PreparedStatement ps = c.prepareStatement(sql);
    ps.setInt(1, id5);
    ResultSet rs = ps.executeQuery();
  }
}

Good Luck,
Avi.

[Adeel Ansari]

Actually, integer/number literals should not be in single quotes. Better use PreparedStatement, as said earlier.

By the way, why you kept "id5" in single quotes and "10" without quote, both are integers/numbers though.