안드로이드 DB연동해서 리스트뷰 띄우려하는데 ...

Question

 

메인화면

 

 @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        lv = (ListView)findViewById(R.id.lv);
        btAddMember = (Button)findViewById(R.id.btAddMember);
        btAddMember.setOnClickListener(this);
        adapter = new AdapterListView();


        DBHelper dbHelper = new DBHelper(this);
        SQLiteDatabase db = dbHelper.getWritableDatabase();
        Cursor cursor = db.rawQuery("SELECT * FROM member", null);

        if(cursor != null){
//            cursor.moveToFirst();
            startManagingCursor(cursor); //db객체 열면 자동으로 닫아주는거  db.close를 대신해주는 역할

            while(cursor.moveToNext()){
                String name = cursor.getString(cursor.getColumnIndex("name"));
                String phone = cursor.getString(cursor.getColumnIndex("phone"));
                String mail = cursor.getString(cursor.getColumnIndex("mail"));
                adapter.addItem(name, phone, mail);
                adapter.notifyDataSetInvalidated();

            }
        }
        lv.setAdapter(adapter);
    }

* DB SQLite 화면

public class DBHelper extends SQLiteOpenHelper {
    public static final int DATABASE_VERSION = 1;
    public DBHelper(Context context) {
        super(context, "database", null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        String sql = "CREATE TABLE member " +
                "(_id integer PRIMARY KEY AUTOINCREMENT, " +
                "name TEXT, " +
                "phone TEXT, " +
                "mail TEXT);";
        sqLiteDatabase.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
        sqLiteDatabase.execSQL("drop table member");
        onCreate(sqLiteDatabase);
    }
}

Comments

혹시나 해서 편집화면도 드릴게요


  @Override
    public void onClick(View v) {


        //버튼 btCancel
        if(v == btCancel){
            finish();

        }
        if(v == btSave){
            String name = etName.getText().toString();
            String phone = etPhone.getText().toString();
            String mail = etMail.getText().toString();

            DBHelper helper = new DBHelper(this);
            SQLiteDatabase db = helper.getWritableDatabase();
            ContentValues values = new ContentValues();

            values.put("name", name);
            values.put("phone", phone);
            values.put("mail", mail);

            db.insert("mail", null, values);
            db.close();


            Toast.makeText(this, "정보가 저장되었습니다.", Toast.LENGTH_SHORT).show();

            Intent i = new Intent(getApplicationContext(), MainActivity.class);
            startActivity(i);
            finish();

        }
    }

---

관련이 있는 코드는 http://www.masterqna.com/android/1 참조해서 본문에 적으세요. 그리고 어떤 증상이 있는지도 적어야 누군가 답변을 하겠죠.
https://susemi99.gitbook.io/howto-for-beginners/2