UCanAccess：从空间

Question

我想数字/文本插入表中意外的标记，但是当程序试图插入文本，我得到的错误
net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.2 unexpected token: EX1 required:)

这里是我的相关代码：

try (Connection conn = DriverManager.getConnection(
    "jdbc:ucanaccess://" + dbPath 
    + ";newdatabaseversion=V2010" 
    )) { 
    DatabaseMetaData dmd = conn.getMetaData(); 
    try (ResultSet rs = dmd.getTables(null, null, tableName, new String[] { "TABLE" })) { 
      try (Statement s = conn.createStatement()) { 
       ResultSet resultSet; 
       String tableName = "Database"; 
       s.executeUpdate("CREATE TABLE " + tableName +" ([SUBJID] 
       INTEGER, [PARAMCD] TEXT, [PARAM] TEXT, [AVAL] DOUBLE)"); 
       String s1="Text Ex1"; 
       String s2="Text Ex2"; 
       int a=3; 
       double b=2; 
       resultSet = s.executeQuery("SELECT * FROM " + tableName); 
       s.executeUpdate("INSERT INTO " + tableName 
        + " (SUBJID, PARAMCD, PARAM, AVAL)" 
        + " VALUES ("+ a+", " + s1 + ", " + s2 +" , " + b +")"); 

它看起来是空白出现时引起的错误。我尝试将s1更改为“TextEx1”，将s2更改为“TextEx2”，这给了我net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.2 user lacks privilege or object not found: TEXTEX1的错误。

在此先感谢任何人可以提供的帮助。

Answer 1

你想要做这样的事情：

String sql = "INSERT INTO [" + tableName + "] (SUBJID, PARAMCD, PARAM, AVAL) VALUES (?,?,?,?)"; 
PreparedStatement ps = conn.prepareStatement(sql); 
ps.setInt(1, a); 
ps.setString(2, s1); 
ps.setString(3, s2); 
ps.setDouble(4, b); 
ps.executeUpdate();