[Android] sqlite 사용예제

Android에서 SQLiteOpenHelper를 상속는 클래스를 만들어 사용하면 쉽게 사용할 수 있다.

public class SqliteTestClass extends SQLiteOpenHelper {

 public static final String DB_NAME   = "test.db";
 private static final int DB_VERSION   = 1;

 @Override
 public void onCreate(SQLiteDatabase db) {
 db.execSQL( "create table query" );
 }

 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 }
 
 public SqliteTestClass(Context context) {
  super(context, DB_NAME, null, DB_VERSION);
 }
}

Insert 예제

synchronized public void insertTest( String insertData ){
 SQLiteDatabase db = getWritableDatabase();

 if( db == null )
  return false;

 db.execSQL("insert into tableName (columnName) values (?);",
   new String[]{ insertData });

 db.close();
}

Select 예제

synchronized public String selectTest( String selectKey ){
 SQLiteDatabase db = getReadableDatabase();
 String result;

 if( db == null )
  return result;

 Cursor cursor = db.rawQuery("select columnName from tableName where selectKeyColumn=?;",
   new String[]{ selectKey });

 if( cursor.moveToNext() ){
  result = cursor.getString( 0 );
 }

 cursor.close();
 db.close();
 return result;
}