주소관리 앱개발 ver.1 (4일차)

Posted on: 2018년 03월 22일 2018년 03월 22일
Categories: 강의자료, 안드로이드

AddrDTO.java 생성

public class AddrDTO {
    int _id;
    String name;
    String tel;
    String hp;

    public AddrDTO(){

    }

    public AddrDTO(String name, String tel, String hp){
        this.name = name;
        this.tel = tel;
        this.hp = hp;
    }
}

public class AddrDTO {

int _id;

String name;

String tel;

String hp;

public AddrDTO(){

}

public AddrDTO(String name, String tel, String hp){

this.name = name;

this.tel = tel;

this.hp = hp;

}

AddrDAO.java 생성

public class AddrDAO {
    Context context;

    public AddrDAO(Context context){
        this.context = context;
    }

    public int InsertRecord(AddrDTO dto){
        MainDBHelper dbHelper = null;
        SQLiteDatabase db = null;
        String sql = "";

        dbHelper = new MainDBHelper(this.context, "mydb", 1);

        db = dbHelper.getWritableDatabase();
        sql = "insert into addr(name, tel, hp) values ('"+dto.name+"','"+dto.tel+"','"+dto.hp+"');";
        db.execSQL(sql);
        db.close();


        return 1;
    }

    public int DeleteRecord(String name){
        MainDBHelper dbHelper = null;
        SQLiteDatabase db = null;
        String sql = "";

        dbHelper = new MainDBHelper(this.context, "mydb", 1);

        db = dbHelper.getWritableDatabase();
        sql = "delete from addr where name='"+name+"';";
        db.execSQL(sql);
        db.close();
        return 1;
    }
}

public class AddrDAO {

Context context;

public AddrDAO(Context context){

this.context = context;

}

public int InsertRecord(AddrDTO dto){

MainDBHelper dbHelper = null;

SQLiteDatabase db = null;

String sql = "";

dbHelper = new MainDBHelper(this.context, "mydb", 1);

db = dbHelper.getWritableDatabase();

sql = "insert into addr(name, tel, hp) values ('"+dto.name+"','"+dto.tel+"','"+dto.hp+"');";

db.execSQL(sql);

db.close();

return 1;

}

public int DeleteRecord(String name){

MainDBHelper dbHelper = null;

SQLiteDatabase db = null;

String sql = "";

dbHelper = new MainDBHelper(this.context, "mydb", 1);

db = dbHelper.getWritableDatabase();

sql = "delete from addr where name='"+name+"';";

db.execSQL(sql);

db.close();

return 1;

}

FragRegister.java 수정

package com.example.smart.s201612345;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.annotation.Nullable;
import android.support.v4.app.Fragment;
import android.view.LayoutInflater;
import android.view.View;
public class FragRegister extends Fragment implements View.OnClickListener{
    @Nullable
    @Override
    public View onCreateView(LayoutInflater inflater, @Nullable ViewGroup container, @Nullable Bundle savedInstanceState) {
        View view = inflater.inflate(R.layout.frag_register,
                container,
                false);

        ((Button)view.findViewById(R.id.btnSave)).setOnClickListener(this);
        ((Button)view.findViewById(R.id.btnList)).setOnClickListener(this);
        ((Button)view.findViewById(R.id.btnDelete)).setOnClickListener(this);

        return view;
    }

    @Override
    public void onClick(View v) {
        MainDBHelper dbHelper = null;
        SQLiteDatabase db = null;
        String sql = "";

        switch (v.getId()){
            case R.id.btnSave :
                String name = ((EditText)getView().findViewById(R.id.txtName)).getText().toString();
                String tel = ((EditText)getView().findViewById(R.id.txtTel)).getText().toString();
                String hp = ((EditText)getView().findViewById(R.id.txtHp)).getText().toString();

                AddrDTO dto = new AddrDTO(name, tel, hp);
                AddrDAO dao = new AddrDAO(getContext());
                dao.InsertRecord(dto);
                break;
            case R.id.btnDelete :
                AddrDAO dao1 = new AddrDAO(getContext());
                dao1.DeleteRecord("1");
                break;
            case R.id.btnList:
                dbHelper = new MainDBHelper(getContext(), "mydb", 1);

                db = dbHelper.getReadableDatabase();
                sql = "select * from addr;";
                Cursor cursor = db.rawQuery(sql, null);

                String buf = "";
                while(cursor.moveToNext()){
                    buf += "\n" + cursor.getString(
                            cursor.getColumnIndexOrThrow("name")
                    );
                }

                cursor.close();
                db.close();

                Toast.makeText(getContext(), buf, Toast.LENGTH_SHORT).show();

                break;
        }
    }
}

package com.example.smart.s201612345;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.support.annotation.Nullable;

import android.support.v4.app.Fragment;

import android.view.LayoutInflater;

import android.view.View;

public class FragRegister extends Fragment implements View.OnClickListener{

@Nullable

@Override

public View onCreateView(LayoutInflater inflater, @Nullable ViewGroup container, @Nullable Bundle savedInstanceState) {

View view = inflater.inflate(R.layout.frag_register,

container,

false);

((Button)view.findViewById(R.id.btnSave)).setOnClickListener(this);

((Button)view.findViewById(R.id.btnList)).setOnClickListener(this);

((Button)view.findViewById(R.id.btnDelete)).setOnClickListener(this);

return view;

}

@Override

public void onClick(View v) {

MainDBHelper dbHelper = null;

SQLiteDatabase db = null;

String sql = "";

switch (v.getId()){

case R.id.btnSave :

String name = ((EditText)getView().findViewById(R.id.txtName)).getText().toString();

String tel = ((EditText)getView().findViewById(R.id.txtTel)).getText().toString();

String hp = ((EditText)getView().findViewById(R.id.txtHp)).getText().toString();

AddrDTO dto = new AddrDTO(name, tel, hp);

AddrDAO dao = new AddrDAO(getContext());

dao.InsertRecord(dto);

break;

case R.id.btnDelete :

AddrDAO dao1 = new AddrDAO(getContext());

dao1.DeleteRecord("1");

break;

case R.id.btnList:

dbHelper = new MainDBHelper(getContext(), "mydb", 1);

db = dbHelper.getReadableDatabase();

sql = "select * from addr;";

Cursor cursor = db.rawQuery(sql, null);

String buf = "";

while(cursor.moveToNext()){

buf += "\n" + cursor.getString(

cursor.getColumnIndexOrThrow("name")

);

}

cursor.close();

db.close();

Toast.makeText(getContext(), buf, Toast.LENGTH_SHORT).show();

break;

}

소스 제출
1. 제출일 : 3월 26일(월) 오후 6시까지
2. 제출방법 : FileZilla FTP 프로그램으로 제출
3. Android Studio에서 File -> Export to ZIP File 메뉴 선택하면 소스코드만 압축됨

whan0623

517