Question

java连接mysql删除时老出现下面的问题，请大神帮忙看一下！！！

public int deleteStudent(String id){
Connection con = null;
PreparedStatement pstmt = null;
int n =0;
try {
con = DBUtil.getConnection();
String sql = "delete base_students where id=?";
pstmt = con.prepareStatement(sql);
pstmt.setString(1, id);
n= pstmt.executeUpdate();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}finally{
DBUtil.close(con, pstmt, null);
}
return n;

public class Test {

public static void main(String[] args) {
us.deleteStudent("5");
}
}
出现的错误为：

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 'where id='5'' at line 1

Answer 1

你看看你数据库中的base_students这张表中id这个字段是什么类型？

追问

varchar类型的

追答

那么你SQL语句有问题，应该这么写delete base_students where id="+“+"'”+“？”+"'";