编译:select语句时,SQLiteException:没有这样的表:trainingsplan(代码1)



所以这是我的代码为数据库

    private SQLiteDatabase db;
private SQLiteStatement insertStatement;

private String DB_Table = "trainingsplan";

private String INSERT = "insert into " + DB_Table
        + "(zweckkuerzel,aktuellertp,zweck)" + "values (?,?,?)";

表示错误在select语句中

private String SEL_ROW = "select zweckkuerzel,aktuellertp,zweck from "
        + DB_Table;
private String CREATE_TABLE = "create table " + DB_Table
        + "(zweckkuerzel String, " 
        + "aktuellertp String NOT NULL, "
        + "zweck String)";
private String CREATE_INDEX = "create index if not exists " + DB_Table
        + "_ind " + "ON " + DB_Table + " (zweckkuerzel)";

在这里我创建了我的Dao和label

    TrainingsplanDao trainingsDao= new TrainingsplanDao(db);
    trainingsDao.createTable();
    trainingsDao.fillTable();

这是我的Dao的构造函数

public TrainingsplanDao(SQLiteDatabase db) {
    this.db = db;
    try {
        insertStatement = db.compileStatement(INSERT);
        Log.d("ANDRO VEGI", "Create INSERT product");
    } catch (SQLException e) {
        Log.d("ANDRO VEGI", "NO Database, NO INSERT  TrainingsplanDao()");
    }
}

说明在db中没有找到名为trainingsplan的表。

最新更新