mysql prepared statement error: MySQLSyntaxErrorException

Question

I wrote select statement using prepared statement. Each time try to run it gives this error. How am I over come this error? my jdbc connector is mysql-connector-java-5.1.13-bin.jar. my code :

 public Main_add_ad_to getAdDetail(int ad_id) {
    Dbconnection db = new Dbconnection();
    Connection con = db.getConnection();
    ResultSet rs = null;

    PreparedStatement stmt = null;
    Main_add_ad_to detail_to = new Main_add_ad_to();
    try {
    String selectSQL = "SELECT *  FROM ads_tbl where id = ?";

    stmt = con.prepareStatement(selectSQL);
    stmt.setInt(1, ad_id);
    rs = stmt.executeQuery(selectSQL);
    while (rs.next()) {

        detail_to.setCat_ad(rs.getString("cat"));
        detail_to.setType_ad(rs.getString("sale_type"));
        detail_to.setBrand(rs.getString("brand"));
    }catch (SQLException ex) {
        Logger.getLogger(Lands_cls.class.getName()).log(Level.SEVERE, null, ex);
    }
return detail_to;
}

error code..

Oct 01, 2013 1:23:23 PM sanin.lands.model.View_ads_cls getAdDetail

SEVERE: null
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

SpringLearner · Accepted Answer · 2013-10-01 08:13:51Z

8

error is in this line

    rs = stmt.executeQuery(selectSQL);

do this way

    rs = stmt.executeQuery();

answered Oct 1, 2013 at 8:13

SpringLearner

13.9k20 gold badges82 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dilis Over a year ago

Thanks. It worked. I referred this tutorial. Looks like its wrong. :( mkyong.com/jdbc/…

KhAn SaAb · Accepted Answer · 2013-10-01 08:23:45Z

1

executeQuery(your QUERY)

is supported while you all dealing with Statment object

 rs = stmt.executeQuery();

edited Oct 1, 2013 at 8:23

answered Oct 1, 2013 at 8:15

KhAn SaAb

5,4166 gold badges34 silver badges55 bronze badges

3 Comments

SpringLearner Over a year ago

Is Statement is an interface?

Dilis Over a year ago

Thanks. It worked. I referred this tutorial. Looks like its wrong. :( mkyong.com/jdbc/…

KhAn SaAb Over a year ago

Statement "The object used for executing a static SQL statement and returning the results it produces."

Collectives™ on Stack Overflow

mysql prepared statement error: MySQLSyntaxErrorException

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related