java - 错误 : You have an error with your sql syntax, 检查与您的 MariaDB 对应的手册以获取正确的语法

Question

我有一个java程序，它创建一个新数据库，然后在其中创建一个表。但是当我运行该程序时，它说我的 SQL 语法有一个错误，如下所示

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE barang (id INT NOT NULL AUTO_INCREMENT,nama VARCHAR(50) NOT NULL,ju' at line 1

这是我的代码:

try {
    con = DriverManager.getConnection(URL, USER, PASS);
    int answer = JOptionPane.showOptionDialog(this, "Database tidak ditemukan, ingin membuat baru?", "Database not found", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null, null, null);
    if (answer == JOptionPane.YES_OPTION) {
        st = con.createStatement();
        String sql = ("CREATE DATABASE afifdb;"
                    + "CREATE TABLE barang ("
                    + "id INT NOT NULL AUTO_INCREMENT,"
                    + "nama VARCHAR(50) NOT NULL,"
                    + "jumlah INT(11),"
                    + "tanggal DATE,"
                    + "kondisi VARCHAR(20),"
                    + "keterangan VARCHAR(100),"
                    + "PRIMARY KEY (id)"
                    + ");");
        st.executeUpdate(sql);
    }
} catch (HeadlessException | SQLException e3) {
    JOptionPane.showMessageDialog(this, "Gagal. ERROR : " + e3);
}

抱歉，我在这个程序中使用了我的语言，希望您不要介意。我将感谢您给予的任何支持。谢谢。

Answer 1

executeUpdate() 是 documented如:

Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

注意单数。您的代码有两个 SQL 语句。

尝试将其分成两个单独的调用。

作为检查，您的创建表语法 looks correct .