[Android] SQLite 설치 및 간단 사용 방법

0. 설치방법

[Android] SQLite DB Browser 다운로드 및 설치 (SQLite DB 확인용)

 

1. DB Helper 생성 

public class DBHelper extends SQLiteOpenHelper {
    public DBHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String sql = "CREATE TABLE if not exists mytable ("
                + "_id integer primary key autoincrement,"
                + "txt text);";

        db.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        String sql = "DROP TABLE if exists mytable";

        db.execSQL(sql);
        onCreate(db);
    }
}

2.  SQLite 데이터베이스  생성 

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        
        DBHelper helper;
        SQLiteDatabase db;
        helper = new DBHelper(MainActivity.this, "newdb.db", null, 1);
        db = helper.getWritableDatabase();
        helper.onCreate(db);
    }
}

3. 테이블 생성

class MainActivity extends AppCompatActivity {
    SQLiteDatabase db;
    static final String DB_NAME = "database";
    static final String TABLE_NAME = "people";
    ...

    void createDatabase() {
        db = openOrCreateDatabase(
                DB_NAME, // 데이터베이스의 이름
                MODE_PRIVATE, // 다른 앱에서의 접근 가능 범위
                null // 쿼리 결과로 리턴되는 커서를 만들 객체
        );
    }

    void createTable() {
        db.execSQL("CREATE TABLE IF NOT EXISTS " + TABLE_NAME + "(" +
                "_id INTEGER PRIMARY KEY AUTOINCREMENT," +
                "name TEXT," +
                "age INTEGER);");
    }

    void insertRecode(String name, int age) {
        db.execSQL("INSERT INTO " + TABLE_NAME +
                " (name, age) VALUES (" +
                "'" + name + "', "
                + age + ");");
    }
    ...

   }

 

 

참고) https://developer.android.com/training/data-storage/sqlite#java

SQLite를 사용하여 데이터 저장  |  Android 개발자  |  Android Developers