안드로이드용 이클립스에서 하고 있는데요
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
public class MySQLiteOpenHelper extends SQLiteOpenHelper{
public MySQLiteOpenHelper(Context context,String name,CursorFactory factory,int version){
super(context,name,factory,version);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql="create table memolist ("+"_id integer primary key autoincrement,"+" title text, content text,time text)";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
String sql="drop table if exists memolist";
db.execSQL(sql);
onCreate(db);
}
}
----------------------------------------------------------------------------------
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
public class MySQLiteHandler {
MySQLiteOpenHelper helper;
SQLiteDatabase db;
public MySQLiteHandler(Context ctx) {
helper = new MySQLiteOpenHelper(ctx, "memolist.sqlite", null, 1);
}
// 데이터베이스 오픈
public static MySQLiteHandler open(Context ctx) {
return new MySQLiteHandler(ctx);
}
// 데이터베이스 close
public void close() {
helper.close();
}
// 데이터베이스 저장
public void insert(String title, String content, String time) {
db = helper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("title", title);
values.put("content", content);
values.put("time", time);
db.insert("memolist", null, values);
}
// 데이터베이스 수정
public void update(String newtime, String content, String newtitle) {
db = helper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("time", newtime);
values.put("title", newtitle);
db.update("memolist", values, "time=?", new String[] { content });
}
// 데이터 삭제
public void delete(String time) {
db = helper.getWritableDatabase();
db.delete("memolist", "time=?", new String[] { time });
}
// 데이터 조회
public Cursor select() {
db = helper.getReadableDatabase();
Cursor c = db.query("memolist", null, null, null, null, null, null);
// while (c.moveToNext()) {
// int _id = c.getInt(c.getColumnIndex("_id"));
// String time = c.getString(c.getColumnIndex("time"));
// String title = c.getString(c.getColumnIndex("title"));
// String content = c.getString(c.getColumnIndex("content"));
// }
return c;
}
}
대체 머가 문제인지.. 계속 테이블이 업다고만 나옵니다. 미치겟네요 ㅡㅡ
sqlite는 해당 테이블이 없으면 자동생성 해준느걸루 아는데..왜 이런지 모르겟네요
좀 도와주세요 돌아버리겟네여