This is an Android SQlite linkage problem! (Basic question)

In the process of linking Android SQlite, there was no grammar error, but it was forced to stop when I executed it I'm posting a question. Where's the problem?

DBhelper class

package com.example.myapplication;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

public class dbHelper extends SQLiteOpenHelper {

public dbHelper(Context context)
{
    super(context, "GoSchoolDB", null, 1);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("CREATE TABLE GoSchoolDB (_id INTEGER PRIMARY KEY AUTOINCREMENT name TEXT tel TEXT);");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("DROP TABLE IF EXISTS GoSchoolDB");
    onCreate(db);

}

}

MainActivity class

package com.example.myapplication;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteException;

import android.os.Bundle;

import android.support.v7.app.AppCompatActivity;

public class MainActivity extends AppCompatActivity {

dbHelper helper;
SQLiteDatabase db;

@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    helper = new dbHelper(this);

    try{
        db = helper.getWritableDatabase();
    }catch (SQLiteException e)
    {
        db = helper.getReadableDatabase();
    }
}

}

android sqlite

2022-09-22 22:01

1 Answers

There's no comma in the "CREATE TABLE"~

2022-09-22 22:01

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656