gpt4 book ai didi

java - mysql准备语句错误: MySQLSyntaxErrorException

转载 作者:行者123 更新时间:2023-11-29 01:11:28 26 4
gpt4 key购买 nike

我使用准备语句编写了 select 语句。每次尝试运行它都会出现此错误。我是怎么克服这个错误的?我的 jdbc 连接器是 mysql-connector-java-5.1.13-bin.jar。我的代码:

 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;
}

错误代码..

2013 年 10 月 1 日下午 1:23:23 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)

最佳答案

错误在这一行

    rs = stmt.executeQuery(selectSQL);

这样做

    rs = stmt.executeQuery();

关于java - mysql准备语句错误: MySQLSyntaxErrorException,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/19111143/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com