public class MainActivity extends Activity {
DBHelper dbHelper;
private ArrayList<String> item;
private ArrayAdapter<String> adapter;
ListView list;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
juso = (TextView)findViewById(R.id.juso);
dbHelper = new DBHelper(this, dbName, null, dbVersion);
}
public void mOnClick(View v) {
SQLiteDatabase db;
String sql;
switch(v.getId()) {
case R.id.gps :
Log.d("location", "button pressed");
Calendar calendar = Calendar.getInstance();
SimpleDateFormat formater = new SimpleDateFormat("yy.MM.dd HH:mm:ss");
Date current = new Date();
String mtime = formater.format(current);
System.out.println(formater.format(calendar.getTime()));
getTime = (TextView)findViewById(R.id.getTime);
getTime.setText(mtime);
break;
case R.id.save :
String timing2 = getTime.getText().toString();
String juso2 = juso.getText().toString();
dbHelper = new DBHelper(this, dbName, null, dbVersion);
db = dbHelper.getWritableDatabase();
sql = String.format("INSERT INTO ksj(timing, juso) VALUES('%s', '%s');", timing2, juso2);
Log.d("tag", sql);
db.execSQL(sql);
Toast.makeText(this, "저장되었습니다.", Toast.LENGTH_SHORT).show();
break;
case R.id.data :
setContentView(R.layout.activity2nd);
ArrayList<String> item = new ArrayList<String>();
adapter = new ArrayAdapter<String>(this,
android.R.layout.simple_list_item_single_choice, item);
ListView list = (ListView)findViewById(R.id.list);
list.setAdapter(adapter);
list.setChoiceMode(ListView.CHOICE_MODE_SINGLE);
list.setOnItemClickListener(mItemClickListener);
findViewById(R.id.delete).setOnClickListener(mClickListener);
Log.d("DATA", "Search data");
db = dbHelper.getReadableDatabase();
sql = "SELECT*FROM ksj;";
Cursor cursor = db.rawQuery(sql, null);
if(cursor.getCount() > 0) {
while(cursor.moveToNext()){
String time1 = cursor.getString(1);
Log.d("tag", "cursor.getString1 = "+time1);
String juso1 = cursor.getString(2);
Log.d("tag", "cursor.getString2 =" +juso1);
item.add(time1+"\n"+juso1);
adapter.notifyDataSetChanged();
}
cursor.close();
}
dbHelper.close();
break;
}
}
ListView.OnItemClickListener mItemClickListener = new AdapterView.OnItemClickListener() {
public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
}
};
Button.OnClickListener mClickListener = new View.OnClickListener() {
public void onClick(View v) {
switch(v.getId()) {
case R.id.delete:
int id = list.getCheckedItemPosition();
if(id != ListView.INVALID_POSITION) {
item.remove(id);
list.clearChoices();
adapter.notifyDataSetChanged();
}
break;
}
}
};
}
