如何解决"<EOF>在第 1 行遇到..."问题

Question

我试图在JavaFx项目中创建一个derby数据库，当我运行项目和创建表时，这个错误出现在我面前，但我无法向表添加一行。

代码如下:

void setupMEMBERTable() 
{
String TABLE_NAME = "MEMBER";
try {
stmt = conn.createStatement();
DatabaseMetaData dbm = conn.getMetaData();
ResultSet tables = dbm.getTables(null, null, TABLE_NAME.toUpperCase(), null);
if (tables.next()) {
System.out.println("Table" + TABLE_NAME);
} else {
stmt.execute("create TABLE MEMBER("
+"full_name varchar  (200),"
+"address  varchar  (200),"
+"mobile  varchar  (200),"
+"email varchar(200) primary key ,"
+"password  varchar  (200),"
+"status boolean default true " + ")"); // Updated
}
} catch (SQLException e){
System.err.println(e.getMessage()+"........SETUP DATABASE");
} finally { }
}
public ResultSet execQuery(String query) {
ResultSet result;
try {
stmt = conn.createStatement();
result = stmt.executeQuery(query);
}
catch (SQLException ex) {
System.out.println("Exception at execQuery:dataHandler" + ex.getLocalizedMessage());
return null;
}
finally {
}
return result;
}
public boolean execAction(String qu) {
try {
stmt = conn.createStatement();
stmt.execute(qu);
return true;
}
catch (SQLException ex) {
JOptionPane.showMessageDialog(null, "Error:" + ex.getMessage(), "Error Occurred", JOptionPane.ERROR_MESSAGE);
System.out.println("Exception at execAction:DataHandler " + ex.getLocalizedMessage());
return false;
}
finally {
}
}

误差

Exception at execAction:dataHandler23505 : [0] SQL0000000001-03d30059-0177-5922-d5b6-00001e28fd60, [1] MEMBER

当我尝试添加一个新成员时发生。如您所见，查询没有在execAction(qu)方法中执行。我能做些什么来解决这个问题?

Answer 1

在我看来，您在一行中缺少一个):

"status boolean default true <HERE>");

我相信Encountered <EOF> at line 1异常消息是数据库驱动程序发出的语法错误，因为它仍然期待的东西，当它到达你的语句结束时，在你的情况下177个字符长。