我正在尝试在android SQLite上创建本地数据库,但是每次尝试创建时,我的logcat都会收到此异常,为什么会这样?我已经删除了该应用程序并作为新的应用程序运行...
private static final int DATABASE_VERSAO = 1;
public static final String DATABASE_NAME = "STARA_DB";
private static final String TB_CLIENTE = "Table de Clientes";
private final Context context;
private DatabaseHelper DBHelper;
private SQLiteDatabase database;
private static final String TAG = "DBAdapter";
String TabelaClientes = "CREATE TABLE "
+ TB_CLIENTE
+ "(ID_CLIENTE PRIMARY KEY NOT NULL AUTOINCREMENT, "
+ "KUNNR TEXT, "
+ "NAME1 TEXT );";
public ClienteDAO(Context ctx) {
this.context = ctx;
DBHelper = new DatabaseHelper(context);
}
private class DatabaseHelper extends SQLiteOpenHelper {
DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSAO);
}
public void onCreate(SQLiteDatabase database) {
try {
database.execSQL(TB_CLIENTE);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
Log.w(TAG, "Upgrading database from version " + oldVersion + " to " + newVersion + ", which will destroy all old data");
database.execSQL("DROP TABLE IF EXISTS" + TB_CLIENTE);
// onCreate(database);
onUpgrade(database, oldVersion, newVersion);
}
public long insertCliente(String KUNNR, String NAME1) {
ContentValues initialValuesClientes = new ContentValues();
initialValuesClientes.put("KUNNR", KUNNR);
initialValuesClientes.put("NAME1", NAME1);
return database.insert(TB_CLIENTE, null, initialValuesClientes);
}
public List<ClienteModelo> getListaClientes() {
List<ClienteModelo> clientes = new ArrayList<ClienteModelo>();
Cursor cCli = DBHelper.getReadableDatabase().rawQuery("Select KUNNR, NAME1 from " + TB_CLIENTE + ";", null);
while (cCli.moveToNext()) {
ClienteModelo cliente = new ClienteModelo();
// cliente.setClienteID(cCli.getLong(cCli.getColumnIndex("ID_CLIENTE")));
cliente.setKunnr(cCli.getString(cCli.getColumnIndex("KUNNR")));
cliente.setName1(cCli.getString(cCli.getColumnIndex("NAME1")));
clientes.add(cliente);
}
cCli.close();
return clientes;
}
public void deleteCliente() {
database.delete(TB_CLIENTE, null, null);
}
以及LogCat上的消息:
no such table: TABLE_CLIENTE
java.lang.RuntimeException: Unable to start activity ComponentInfo{stara.formularios/stara.formularios.views.FormNota}: android.database.sqlite.SQLiteException: no such table: TABLE_CLIENTE (code 1): , while compiling: Select KUNNR, NAME1 from TABLE_CLIENTE;
Caused by: android.database.sqlite.SQLiteException: no such table: TABLE_CLIENTE (code 1): , while compiling: Select KUNNR, NAME1 from TABLE_CLIENTE;"
您CREATE TABLE
忽略了语法错误。
"Table de Clientes"
"TABLE_CLIENTE"
根据您的堆栈跟踪,它应该可能是一个有效的标识符,就像您稍后使用的标识符一样。
ID_CLIENTE PRIMARY KEY NOT NULL AUTOINCREMENT
需要包含INTEGER
在其中,例如ID_CLIENTE INTEGER PRIMARY KEY AUTOINCREMENT
。的NOT NULL
是多余的; 主键不能为null。
您实际上需要将SQL而不是表名传递给execSQL()
。
删除您的中的try
- 。回调需要引发错误,而不能忽略问题。catch
onCreate()
更改之后,请卸载您的应用程序,以便删除旧的数据库文件。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句