Error while executing SQL query on database '表名': near "truncate": syntax error

SQLite不支持truncate，如果你想清空db文件里某个表的记录，可以使用delete from 表名

Connection connection = DriverManager.getConnection("jdbc:sqlite:" + DB_PATH);
Statement statement = connection.createStatement();
statement.execute("delete from 表名;");
statement.close();
connection.close();