Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.example.justim.sqliteexample;
- import android.content.Intent;
- import android.database.Cursor;
- import android.support.v7.app.ActionBarActivity;
- import android.os.Bundle;
- import android.util.Log;
- import android.view.Menu;
- import android.view.MenuItem;
- import android.view.View;
- import android.widget.AdapterView;
- import android.widget.Button;
- import android.widget.EditText;
- import android.widget.ListView;
- import android.widget.SimpleCursorAdapter;
- import android.widget.Toast;
- public class MainActivity extends ActionBarActivity {
- ListView todoList;
- DBAccess access;
- SimpleCursorAdapter adapter=null;
- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_main);
- todoList = (ListView)findViewById(R.id.lvToDo);
- access = new DBAccess(this, "schedule", null, 1);
- Button btnAdd = (Button)findViewById(R.id.btnNew);
- btnAdd.setOnClickListener(addNewEvent);
- todoList.setOnItemClickListener(modifyEvent);
- }
- private AdapterView.OnItemClickListener modifyEvent = new AdapterView.OnItemClickListener() {
- @Override
- public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
- Intent it = new Intent();
- it.setClass(MainActivity.this, ModifyActivity.class);
- Bundle bdl = new Bundle();
- bdl.putLong("id", id);
- it.putExtras(bdl);
- startActivity(it);
- }
- };
- /*@Override
- protected void onResume() {
- Cursor c=access.getData(
- DBAccess.DATE_FIELD+">= strftime('%Y-%m-%d','now')",
- DBAccess.DATE_FIELD+" ,"+DBAccess.TIME_FIELD);
- if(adapter == null) {
- adapter=new SimpleCursorAdapter(this, R.layout.todoitem, c,
- new String[]{DBAccess.DATE_FIELD, DBAccess.TIME_FIELD,
- DBAccess.TITLE_FIELD},
- new int[]{R.id.tvDate,R.id.tvTime,R.id.tvEvent},
- 0);
- todoList.setAdapter(adapter);
- } else
- adapter.changeCursor(c);//更新ListView呈現的資料
- super.onResume();
- }*/
- @Override
- protected void onDestroy() {
- super.onDestroy();
- access.close();
- }
- private View.OnClickListener addNewEvent = new View.OnClickListener() {
- @Override
- public void onClick(View v) {
- EditText etDate = (EditText)findViewById(R.id.etDate);
- EditText etTime = (EditText)findViewById(R.id.etTime);
- EditText etEvent = (EditText)findViewById(R.id.etEvent);
- EditText etExplanation = (EditText)findViewById(R.id.etExplanation);
- long result = access.add(etDate.getText().toString(),
- etTime.getText().toString(),
- etEvent.getText().toString(),
- etExplanation.getText().toString());
- if(result>=0) {//新增成功
- Toast.makeText(MainActivity.this, "新增成功", Toast.LENGTH_LONG).show();
- Cursor c=access.getData(
- DBAccess.DATE_FIELD+">= strftime('%Y-%m-%d','now')",
- DBAccess.DATE_FIELD+" ,"+DBAccess.TIME_FIELD);
- adapter.changeCursor(c);//更新ListView呈現的資料
- }else//失敗
- Toast.makeText(MainActivity.this, "新增資料失敗", Toast.LENGTH_LONG).show();
- }
- };
- public boolean onCreateOptionsMenu(Menu menu) {
- // Inflate the menu; this adds items to the action bar if it is present.
- getMenuInflater().inflate(R.menu.menu_main, menu);
- return true;
- }
- @Override
- public boolean onOptionsItemSelected(MenuItem item) {
- // Handle action bar item clicks here. The action bar will
- // automatically handle clicks on the Home/Up button, so long
- // as you specify a parent activity in AndroidManifest.xml.
- int id = item.getItemId();
- //noinspection SimplifiableIfStatement
- if (id == R.id.action_settings) {
- return true;
- }
- return super.onOptionsItemSelected(item);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement