android 메모 어플 소스 ListView + SQLite 활용

안드로이드 메모 어플을 https://github.com/DomHeal/Android-Memo-Application 에서 받아서 코드를 API 28 (Android 9) 에서 동작하도록 수정한 코드이다.

ListView 에 일렬로 보여주는 아주 간단한 메모 코드다. SQLite DB를 사용하여 데이터를 로컬 DB에 저장하고 보여주는 코드이므로 달력 형태로 보여주는 건 아니다.

간단하게 SQLite DB 사용법 익히는 용도로 좋은 예제인거 같다.

memo.zip

앱 build.gradle

apply plugin: 'com.android.application' android {     compileSdkVersion 28     defaultConfig {         applicationId "com.tistory.link2me.memo"         minSdkVersion 19         targetSdkVersion 28         versionCode 1         versionName "1.0"         testInstrumentationRunner "androidx.test.runner.AndroidJUnitRunner"     }     buildTypes {         release {             minifyEnabled false             proguardFiles getDefaultProguardFile('proguard-android-optimize.txt'), 'proguard-rules.pro'         }     } } dependencies {     implementation fileTree(dir: 'libs', include: ['*.jar'])     implementation 'androidx.appcompat:appcompat:1.1.0'     implementation 'androidx.constraintlayout:constraintlayout:1.1.3' }

AndroidManifest.xml

<?xml version="1.0" encoding="utf-8"?> <manifest xmlns:android="http://schemas.android.com/apk/res/android"     package="com.tistory.link2me.memo">     <uses-permission android:name="android.permission.INTERNET" />     <application         android:allowBackup="false"         android:icon="@mipmap/ic_launcher"         android:label="@string/app_name"         android:supportsRtl="true"         android:usesCleartextTraffic="true" <!-- 서버와 http 통신할 경우 추가해야 정상동작 -->         android:theme="@style/AppTheme">         <activity android:name=".Alert"></activity>         <activity android:name=".Edit_Note" />         <activity android:name=".View_Note" />         <activity android:name=".CreateNote" />         <activity android:name=".MainActivity">             <intent-filter>                 <action android:name="android.intent.action.MAIN" />                 <category android:name="android.intent.category.LAUNCHER" />             </intent-filter>         </activity>         <receiver             android:name=".AlarmReceiver"             android:enabled="true"             android:exported="true" />     </application> </manifest>

MainActivity.java

import android.content.Intent; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.os.Bundle; import android.view.Menu; import android.view.MenuItem; import android.view.View; import android.widget.AdapterView; import android.widget.ImageView; import android.widget.ListView; import android.widget.SimpleCursorAdapter; import androidx.appcompat.app.AppCompatActivity; public class MainActivity extends AppCompatActivity {     SQLiteDatabase db;     DbHelper mDbHelper;     ListView list;     @Override     protected void onCreate(Bundle savedInstanceState) {         super.onCreate(savedInstanceState);         setContentView(R.layout.activity_main);         list = (ListView)findViewById(R.id.commentslist);         mDbHelper = new DbHelper(this);         db= mDbHelper.getWritableDatabase();         final ImageView alarmImage = (ImageView) findViewById(R.id.alarmImage);         String[] from = {mDbHelper.TITLE, mDbHelper.DETAIL, mDbHelper.TYPE, mDbHelper.TIME, mDbHelper.DATE};         final String[] column = {mDbHelper.C_ID, mDbHelper.TITLE, mDbHelper.DETAIL, mDbHelper.TYPE, mDbHelper.TIME, mDbHelper.DATE};         int[] to = {R.id.title, R.id.Detail, R.id.type, R.id.time, R.id.date};         final Cursor cursor = db.query(mDbHelper.TABLE_NAME, column, null, null ,null, null, null);         final SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.list_entry, cursor, from, to, 0);         list.setAdapter(adapter);         list.setOnItemClickListener(new AdapterView.OnItemClickListener(){             public void onItemClick(AdapterView<?> listView, View view, int position,                                     long id){                 Intent intent = new Intent(MainActivity.this, View_Note.class);                 intent.putExtra(getString(R.string.rodId), id);                 startActivity(intent);             }         });     }     @Override     public void onBackPressed() {         moveTaskToBack(true);     }     @Override     public boolean onCreateOptionsMenu(Menu menu) {         // Inflate the menu; this adds items to the action bar if it is present.         getMenuInflater().inflate(R.menu.menu_main, menu);         return true;     }     @Override     public boolean onOptionsItemSelected(MenuItem item) {         switch(item.getItemId()) {             case R.id.action_new:                 Intent openCreateNote = new Intent(MainActivity.this, CreateNote.class);                 startActivity(openCreateNote);                 return true;             default:                 return super.onOptionsItemSelected(item);         }     } }

나마저 코드와 xml 파일은 첨부파일을 참조해서 프로젝트 생성하고 모듈 추가해서 코드를 덮어쓰거나 변형하여 덮어쓰기 하면 동작되는 걸 확인할 수 있다.

ListView 를 사용한 코드인데 RecyclerView 로 변경하는 건 나중에 기회되면 수정해서 올려볼 생각이다.

참고자료

안드로이드 모듈 추가 방법 https://link2me.tistory.com/1369 참조