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();
dbHelper = new MainDBHelper(getContext(), "mydb", 1);
db = dbHelper.getWritableDatabase();
sql = "insert into addr(name) values ('"+name+"');";
db.execSQL(sql);
db.close();
Toast.makeText(getContext(), "저장되었습니다.",
Toast.LENGTH_SHORT).show();
break;
case R.id.btnDelete :
dbHelper = new MainDBHelper(getContext(), "mydb", 1);
db = dbHelper.getWritableDatabase();
sql = "delete from addr where name='전주대학교';";
db.execSQL(sql);
db.close();
Toast.makeText(getContext(), "삭제되었습니다.",
Toast.LENGTH_SHORT).show();
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;
}
}
}
