如何修复语法错误"("？

Question

现在我使用postgreSQL编写库存管理程序。
当我制作表格时，错误发生了。
我的代码是这样的!

import java.sql.Connection;
import java.sql.Statement;
public class Create_Table {
public static void main(String[] args) {

Connection connection = null;
Statement statement = null;

ConnectDB obj_ConnectDB = new ConnectDB();

connection = obj_ConnectDB.get_connection();

try {
String query = "CREATE TABLE IF NOT EXISTS stockmanagement ("
+ "ID SERIAL primary key, "
+ "Name varchar(20), "
+ "Unit_price numeric(15,1), "
+ "Qty INT(20),"
+ "Imported_Date Date,"
+ ")";
statement = connection.createStatement();
statement.executeUpdate(query);
System.out.println("finished");

} catch (Exception e) {
e.printStackTrace();
}
}
}

， error的内容如下:
error : syntax error, "("
如何修复此错误?如果你知道这个方法，你能教我吗?

Answer 1

字符串中有两个错误。

1. 末尾多一个逗号
2. INT(20)不合法

应该可以

String query = "CREATE TABLE IF NOT EXISTS stockmanagement ("
+ "ID SERIAL primary key, "
+ "Name varchar(20), "
+ "Unit_price numeric(15,1), "
+ "Qty INT,"
+ "Imported_Date Date"
+ ")";