最近我下载了一个我打算在我的项目中使用的小应用程序的代码。该应用程序可以创建数据库和表格。但只要我尝试在该应用程序的数据库帮助程序文件中创建一个新表,它会一直抛出一个错误“android.database.sqlite.SQLiteException:no such table:”。这里是代码:
用于创建表格
public void createTables(SQLiteDatabase database) {
String batches_table_sql = "create table " + Database.BATCHES_TABLE_NAME + " ( " +
Database.BATCHES_ID + " integer primary key autoincrement," +
Database.BATCHES_BATCHCODE + " TEXT," +
Database.BATCHES_COURSE + " TEXT," +
Database.BATCHES_STARTDATE + " TEXT," +
Database.BATCHES_STARTTIME + " TEXT," +
Database.BATCHES_CLASSES + " integer," +
Database.BATCHES_PERIOD + " integer," +
Database.BATCHES_CLASSESPERWEEK + " integer," +
Database.BATCHES_REMARKS + " TEXT)";
String classes_table_sql = "create table " + Database.CLASSES_TABLE_NAME + " ( " +
Database.CLASSES_CLASSES_ID + " integer primary key autoincrement," +
Database.CLASSES_BATCHCODE + " TEXT," +
Database.CLASSES_CLASSDATE + " TEXT," +
Database.CLASSES_CLASSTIME + " TEXT," +
Database.CLASSES_CLASSPERIOD + " integer," +
Database.CLASSES_TOPICS+ " TEXT," +
Database.CLASSES_REMARKS + " TEXT)";
try {
database.execSQL(batches_table_sql);
Log.d("CS","Batches Tables created!");
database.execSQL("insert into batches (batchcode,course, startdate,starttime,classes,period,classesperweek,remarks)"
+ "values ('HB2404','Hibernate','2012-04-24','19:00',6,90,6,'Short course')");
Log.d("CS","teacher Tables values saved2!");
database.execSQL(classes_table_sql);
database.execSQL("insert into classes (batchcode,classdate,classtime,period,topics,remarks)"
+ "values ('HB2404','2012-04-24','19:00',90,null,null)");
database.execSQL("insert into classes (batchcode,classdate,classtime,period,topics,remarks)"
+ "values ('HB2404','2012-04-25','19:00',90,null,null)");
database.execSQL("insert into classes (batchcode,classdate,classtime,period,topics,remarks)"
+ "values ('HB2404','2012-04-26','19:00',90,null,null)");
database.execSQL("insert into classes (batchcode,classdate,classtime,period,topics,remarks)"
+ "values ('HB2404','2012-04-27','19:00',90,null,null)");
database.execSQL("insert into classes (batchcode,classdate,classtime,period,topics,remarks)"
+ "values ('HB2404','2012-04-28','19:00',90,null,null)");
database.execSQL("insert into classes (batchcode,classdate,classtime,period,topics,remarks)"
+ "values ('HB2404','2012-04-30','19:00',90,null,'Last class')");
Log.d("CS","Tables created!");
}
catch(Exception ex) {
Log.d("CS", "Error in DBHelper.onCreate() : " + ex.getMessage());
}
}
当我运行选择查询从批处理表或类表中获取它开始抛出一个错误“android.database.sqlite.SQLiteException:没有这样的表:
这是查询:
**String selectQuery = "SELECT batchcode FROM batches";**
我在这里做错了什么?
发布于 2018-06-04 16:35:03
如果你已经使用旧表运行应用程序,并且在运行带有新表的版本(或onUpgrade的附带代码)之前未卸载该应用程序,我认为不会添加新表。
https://stackoverflow.com/questions/-100004735
复制相似问题