从键创建表Spring JDBC

Question

因此，我尝试使用JSON对象中的键在数据库中创建表，但它显示了如下错误

ERROR o.a.c.c.C.[.[.[.[dispatcherServlet] - Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [CREATE TABLE siswas (  Category INT NOT NULL AUTO_INCREMENT,  nama VARCHAR(45) ,  Absensi VARCHAR(45) ,  Entertain LONG ,  id INT ,  Gaji_Pokok INT ,  Tunjangan_Pulsa LONG ,  Tunjangan_Makan LONG ,  Tunjangan_Trans LONG ,  Tunjangan_Ent LONG ,  PRIMARY KEY (id));]; nested exception is java.sql.SQLSyntaxErrorException: Incorrect table definition; there can be only one auto column and it must be defined as a key] with root cause

sqlsyntaxerrorexception：错误的表定义；只能有一个自动列，并且必须将其定义为键

public void buatTable(ArrayList<String> array) {
    System.out.println("Creating table at database");
    id = array.get(0);
    nama = array.get(1);
    Category = array.get(2);
    Gaji_pokok = array.get(3);
    Absensi = array.get(4);
    Entertain = array.get(5);
    TunjanganP = array.get(6);
    TunjanganM = array.get(7);
    TunjanganT = array.get(8);
    TunjanganE = array.get(9);

    jdbcTemplate.execute("DROP TABLE  IF EXISTS Karyawan");
    jdbcTemplate.execute("CREATE TABLE Karyawan (" +
            "  "+id+" INT NOT NULL AUTO_INCREMENT," +
            "  "+nama+" VARCHAR(45) ," +
            "  "+Category+" VARCHAR(45) ," +
            "  "+Gaji_pokok+" LONG ," +
            "  "+Absensi+" INT ," +
            "  "+Entertain+" INT ," +
            "  "+TunjanganP+" LONG ," +
            "  "+TunjanganM+" LONG ," +
            "  "+TunjanganT+" LONG ," +
            "  "+TunjanganE+" LONG ," +
            "  PRIMARY KEY (id));");
}

我的代码有问题吗？

Answer 1

您不指定正在使用的数据库，但尝试将LONG更改为INT