자꾸 데이터 베이스 테이블 에러가 뜨는데 제가 뭘 잘못한건지 아직 sql문을 잘 이해를 못하고 활용을 잘 못해서 못찾겠어요....ㅠㅠ
public void insertRecord (String name, String phonenumber, int age, int month, int day){
try {
String query =
"INSERT INTO "+ TABLENAME +" VALUES (null, '"+name+"', '"+phonenumber+"', '"+age+"', '"+month+"', '"+day+"' );";
db.execSQL(query);
}catch(Exception ex){
Log.d(TAG, "exception in insertRecord", ex);
}
}
public class DBHelper extends SQLiteOpenHelper {
public DBHelper(Context context) {
super(context, DATABASENAME, null, DATABASEVERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
//
// create table
String CREATE_SQL = "CREATE TABLE IF NOT EXISTS " + TABLENAME + "("
+ "_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "
+ "NAME TEXT, "
+ "PHONENUMBER TEXT, "
+ "AGE INTEGER, "
+ "MONTH INTEGER, "
+ "DAY INTEGER )";
try {
db.execSQL(CREATE_SQL);
} catch(Exception ex) {
Log.e(TAG, "Exception in CREATE_SQL", ex);
}
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS "+TABLENAME);
onCreate(db);
}
}
10-16 04:39:00.099 3816-3816/com.example.chahyunbin.cwapp D/BookDatabase: exception in insertRecord
android.database.sqlite.SQLiteException: no such table: MEMBER (code 1): , while compiling: INSERT INTO MEMBER VALUES (null, '차현빈', '01075666734', '21', '9', '9' );
#################################################################
Error Code : 1 (SQLITE_ERROR)
Caused By : SQL(query) error or missing database.
(no such table: MEMBER (code 1): , while compiling: INSERT INTO MEMBER VALUES (null, '차현빈', '01075666734', '21', '9', '9' );)
#################################################################
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1221)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:695)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:2212)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:2142)
at com.example.chahyunbin.cwapp.MemberDatabase.insertRecord(MemberDatabase.java:63)
at com.example.chahyunbin.cwapp.AddMember.insert(AddMember.java:155)
at com.example.chahyunbin.cwapp.AddMember$2.onClick(AddMember.java:126)
at com.android.internal.app.AlertController$ButtonHandler.handleMessage(AlertController.java:177)
at android.os.Handler.dispatchMessage(Handler.java:106)
at android.os.Looper.loop(Looper.java:164)
at android.app.ActivityThread.main(ActivityThread.java:7002)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:441)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1408)