java - SQLITE_ERROR SQL 错误或丢失数据库(接近 "(": syntax error)

Question

[SQLITE_ERROR] SQL error or missing database (near "(": syntax error)

try {
    String sql = "SELECT MAX (right(id_kasir,3)) AS no FROM tbl_kasir";
    st = connection.createStatement();
    rs = st.executeQuery(sql);
    while (rs.next()) {
        if (rs.first() == false) {
            txtidkasir.setText("KS001");
        } else {
            rs.last();
            int auto_id = rs.getInt(1) + 1;
            String no = String.valueOf(auto_id);
            int noLong = no.length();
            for (int a = 0; a < 3 - noLong; a++) {
                no = "0" + no;
            }
            txtidkasir.setText("KS" + no);
        }
    }
} catch (Exception e) {
    System.out.println("Error" + e.getMessage());
}

Answer 1

你失踪了；在最后。也许需要指定数据库。

SELECT MAX(right(id_kasir,3)) AS no FROM tbl_kasir;

尝试:

SELECT MAX(right(id_kasir,3)) AS no FROM {DBName}.tbl_kasir;