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

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

AddrDAO.java 수정

public class AddrDAO {
	Context context;

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

	public SQLiteDatabase getConn(){
		MainDBHelper dbHelper = new MainDBHelper(this.context);
		SQLiteDatabase db = dbHelper.getWritableDatabase();

		return db;
	}

	public int InsertRecord(AddrDTO dto){
		SQLiteDatabase db = getConn();

		String 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){
		SQLiteDatabase db = getConn();
		String sql = "delete from addr where name='"+name+"';";
		db.execSQL(sql);
		db.close();
		return 1;
	}

	public int InsertQuery(AddrDTO dto){
		ContentValues r = new ContentValues();
		r.put("name", dto.name);
		r.put("tel", dto.tel);
		r.put("hp", dto.hp);

		int pos = 0;
		SQLiteDatabase db = getConn();
		pos = (int)db.insert("addr", null, r);
		db.close();

		return pos;
	}

	public int deleteQuery(int id){
		int pos = 0;
		SQLiteDatabase db = getConn();
		pos = (int)db.delete("addr", "_id=?", new String[]{""+id});
		db.close();

		return pos;
	}

	public ArrayList<AddrDTO> selectRecord(){
		ArrayList<AddrDTO> arList = new ArrayList<AddrDTO>();

		SQLiteDatabase db = getConn();
		String sql = "select * from addr;";
		Cursor cursor = db.rawQuery(sql, null);

		while(cursor.moveToNext()){
			String name = cursor.getString(cursor.getColumnIndexOrThrow("name"));
			String tel = cursor.getString(cursor.getColumnIndexOrThrow("tel"));
			String hp = cursor.getString(cursor.getColumnIndexOrThrow("hp"));

			AddrDTO dto = new AddrDTO(name, tel, hp);
			arList.add(dto);
		}

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

		return arList;
	}
}

public class AddrDAO {

Context context;

public AddrDAO(Context context){

this.context = context;

}

public SQLiteDatabase getConn(){

MainDBHelper dbHelper = new MainDBHelper(this.context);

SQLiteDatabase db = dbHelper.getWritableDatabase();

return db;

}

public int InsertRecord(AddrDTO dto){

SQLiteDatabase db = getConn();

String 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){

SQLiteDatabase db = getConn();

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

db.execSQL(sql);

db.close();

return 1;

}

public int InsertQuery(AddrDTO dto){

ContentValues r = new ContentValues();

r.put("name", dto.name);

r.put("tel", dto.tel);

r.put("hp", dto.hp);

int pos = 0;

SQLiteDatabase db = getConn();

pos = (int)db.insert("addr", null, r);

db.close();

return pos;

}

public int deleteQuery(int id){

int pos = 0;

SQLiteDatabase db = getConn();

pos = (int)db.delete("addr", "_id=?", new String[]{""+id});

db.close();

return pos;

}

public ArrayList<AddrDTO> selectRecord(){

ArrayList<AddrDTO> arList = new ArrayList<AddrDTO>();

SQLiteDatabase db = getConn();

String sql = "select * from addr;";

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

while(cursor.moveToNext()){

String name = cursor.getString(cursor.getColumnIndexOrThrow("name"));

String tel = cursor.getString(cursor.getColumnIndexOrThrow("tel"));

String hp = cursor.getString(cursor.getColumnIndexOrThrow("hp"));

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

arList.add(dto);

}

cursor.close();

db.close();

return arList;

}

FragRegister.java 수정

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.InsertQuery(dto);

                Toast.makeText(getContext(), "저장되었습니다.",
                        Toast.LENGTH_SHORT).show();
                break;
            case R.id.btnDelete :
                break;
            case R.id.btnList:
                String buf = "";
                AddrDAO dao2 = new AddrDAO(getContext());
                ArrayList<AddrDTO> arList = dao2.selectRecord();
                for(int i=0; i<arList.size(); i++){
                    buf += "\n" + arList.get(i).name
                            + "  " + arList.get(i).tel
                            + "  " + arList.get(i).hp;
                }
                Toast.makeText(getContext(), buf, Toast.LENGTH_SHORT).show();
                break;
        }
    }
}

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.InsertQuery(dto);

Toast.makeText(getContext(), "저장되었습니다.",

Toast.LENGTH_SHORT).show();

break;

case R.id.btnDelete :

break;

case R.id.btnList:

String buf = "";

AddrDAO dao2 = new AddrDAO(getContext());

ArrayList<AddrDTO> arList = dao2.selectRecord();

for(int i=0; i<arList.size(); i++){

buf += "\n" + arList.get(i).name

+ " " + arList.get(i).tel

+ " " + arList.get(i).hp;

}

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

break;

}

Android Studio에서 File -> Export to ZIP File 메뉴 선택하면 소스코드만 압축됨

whan0623

517