import
android.app.*;
import
android.database.*;
import
android.os.Bundle;
import
android.util.*;
import
android.view.*;
import
android.widget.*;
public
class
Insert
extends
ListActivity
implements
View.OnClickListener {
DBHandler dbHandler;
EditText editname, editcardsa, editcardnumber;
ListView listView;
Cursor cursor =
null
;
String[] arr =
null
;
private
Button btnexit;
Button btnsave, btnSelect;
@Override
protected
void
onCreate(Bundle savedInstanceState) {
super
.onCreate(savedInstanceState);
setContentView(R.layout.listactivity);
btnsave = (Button) findViewById(R.id.btnsave);
btnSelect = (Button) findViewById(R.id.btnselect);
btnexit = (Button) findViewById(R.id.btnexit);
btnsave.setOnClickListener(
this
);
btnSelect.setOnClickListener(
this
);
btnexit.setOnClickListener(
this
);
editname = (EditText) findViewById(R.id.editText);
editcardsa = (EditText) findViewById(R.id.editText2);
editcardnumber = (EditText) findViewById(R.id.editText3);
listView = (ListView) findViewById(android.R.id.list);
}
@Override
public
void
onClick(View v) {
dbHandler = DBHandler.open(
this
);
try
{
if
(v.getId()== R.id.btnsave) {
if
(editname.getText().toString().equals(
""
)) {
Toast.makeText(
this
,
"이름 입력"
, Toast.LENGTH_SHORT).show();
return
;
}
else
if
(editcardsa.getText().toString().equals(
""
)) {
Toast.makeText(
this
,
"카드사 입력"
, Toast.LENGTH_SHORT).show();
return
;
}
else
if
(editcardnumber.getText().toString().equals(
""
)) {
Toast.makeText(
this
,
"카드번호 입력"
, Toast.LENGTH_SHORT).show();
return
;
}
long
re = dbHandler.insert(
editname.getText().toString(),
editcardsa.getText().toString(),
editcardnumber.getText().toString());
if
(re ==
0
) {
Toast.makeText(
this
,
"추가 실패"
, Toast.LENGTH_SHORT).show();
}
else
{
Toast.makeText(
this
,
"추가 성공"
, Toast.LENGTH_SHORT).show();
cursor = dbHandler.selectAll();
arr =
new
String[cursor.getCount()];
int
count =
0
;
while
(cursor.moveToNext()) {
String code = cursor.getString(
0
);
String strUserName = cursor.getString(
1
);
String strCardSa = cursor.getString(
2
);
String strCardNumber = cursor.getString(
3
);
arr[count] = code +
" "
+ strUserName +
" "
+ strCardSa +
" "
+ strCardNumber;
count++;
}
cursor.close();
invalidate();
}
}
else
if
(v.getId()== R.id.btnselect) {
cursor = dbHandler.selectAll();
arr =
new
String[cursor.getCount()];
int
count =
0
;
while
(cursor.moveToNext()) {
String code = cursor.getString(
0
);
String strUserName = cursor.getString(
1
);
String strCardSa = cursor.getString(
2
);
String strCardNumber = cursor.getString(
3
);
arr[count] = code +
" "
+ strUserName +
" "
+ strCardSa +
" "
+ strCardNumber;
count++;
}
}
else
if
(v.getId()== R.id.btnexit) {
finish();
}
cursor.close();
invalidate();
}
catch
(Exception e) {
Log.i(
"disp"
,
"err:"
+ e);
}
}
private
void
invalidate() {
ListAdapter adapter =
new
ArrayAdapter<String>(
this
,
android.R.layout.simple_list_item_1, arr);
setListAdapter(adapter);
}
@Override
public
boolean
onCreateOptionsMenu(Menu menu) {
getMenuInflater().inflate(R.menu.menu_insert, menu);
return
true
;
}
@Override
public
boolean
onOptionsItemSelected(MenuItem item) {
int
id = item.getItemId();
if
(id == R.id.action_settings) {
return
true
;
}
return
super
.onOptionsItemSelected(item);
}
}