所以这是我的代码为数据库
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
的表。