java - 如何解决MySQL语法错误异常？

Question

我正在尝试将数据从 wampserver mysql 数据库插入到我的 jtable 中。我不断收到此特定错误 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntaxe près de ')' à la ligne 1.

这是我的代码

public Boolean add( String Registration,String Departure, String capacity, String Date, String Destination, String Startpoint) {
    //SQL STATEMENT
    String sql = "INSERT INTO travel_schedule( Registrationno,Capacity, Date, Destination,Departuretime,Startpoint) VALUES('"+Registration+"', '"+ capacity + "','" + Date + "','" + Destination + "','" + Departure + "','" + Startpoint + "',)";
    try {
        //GET CONNECTION
        Connection con = DriverManager.getConnection(conString, username, password);

        //PREPARED STATEMENT
        Statement s = con.prepareStatement(sql);
        s.execute(sql);
        return true;
    } catch (Exception ex) {
        ex.printStackTrace();
    }
    return false;
}

Answer 1

在您的 sql 查询中，删除逗号后的空格 Registration+"', '"+ 并将其写为 Registration+"','"+此处去掉逗号 Startpoint + "',)";

使用下面的语句，

 String sql = "INSERT INTO travel_schedule(Registrationno,Capacity,Date,Destination,Departuretime,Startpoint) VALUES('"+Registration+"','"+capacity+"','"+Date+"','"+ Destination +"','"+Departure+"','" +Startpoint+"')";