public class MainActivity extends AppCompatActivity implements View.OnClickListener {

 private EditText subject;
 private EditText body;
 private EditText date;
 private Button chooseDate;
 private Button add;
 private Button query;
 private ListView result;
 private LinearLayout title;
 private MyDataBaseHelper mMyDataBaseHelper;
 @Override
 protected void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_main);
 initView();
 }

 private void initView() {
 //控件初始化
 subject=(EditText)findViewById(R.id.subject);
 body=(EditText)findViewById(R.id.body);
 date=(EditText)findViewById(R.id.date);
 chooseDate=(Button)findViewById(R.id.chooseDate);
 add=(Button)findViewById(R.id.add);
 query=(Button)findViewById(R.id.query);
 result=(ListView)findViewById(R.id.result);
 title=(LinearLayout)findViewById(R.id.title);

 //選擇日期，添加，查詢的監(jiān)聽事件
 chooseDate.setOnClickListener(this);
 add.setOnClickListener(this);
 query.setOnClickListener(this);
 //查詢情況默認隱藏，只有點擊查詢時才有效果
 title.setVisibility(View.INVISIBLE);
 }

 @Override
 public void onClick(View v) {
 //創(chuàng)建數(shù)據(jù)庫
 mMyDataBaseHelper=new MyDataBaseHelper(MainActivity.this,"memento.db",null,1);
 SQLiteDatabase sqLiteDatabase=mMyDataBaseHelper.getReadableDatabase();
 //獲取輸入框的內(nèi)容
 String strSubject=subject.getText().toString().trim();
 String strBody=body.getText().toString().trim();
 String strDate=date.getText().toString().trim();

 switch (v.getId()){
 case R.id.chooseDate:
 Calendar calendar=Calendar.getInstance();
 //選擇時間，并將時間設置在date中
 new DatePickerDialog(MainActivity.this, new DatePickerDialog.OnDateSetListener() {
  @Override
  public void onDateSet(DatePicker view, int year, int month, int dayOfMonth) {
  date.setText(year+"-"+month+"-"+dayOfMonth);
  }
 },calendar.get(Calendar.YEAR),calendar.get(Calendar.MONTH),calendar.get(Calendar.DAY_OF_MONTH)).show();
 break;
 case R.id.add:
 //添加內(nèi)容到數(shù)據(jù)庫中，添加方法是add
 title.setVisibility(View.INVISIBLE);
 add(sqLiteDatabase,strSubject,strBody,strDate);
 Toast.makeText(this, "success!", Toast.LENGTH_SHORT).show();
 result.setAdapter(null);
 break;
 case R.id.query:
 //查詢時顯示結(jié)果設置為visible
 title.setVisibility(View.VISIBLE);
 //查詢的結(jié)果保存在cursor中
 Cursor cursor=query(sqLiteDatabase,strSubject,strBody,strDate);
 SimpleCursorAdapter simpleCursorAdapter=new SimpleCursorAdapter(MainActivity.this,R.layout.result,cursor,new String[]{"_id", "subject", "body", "date"},
  new int[]{R.id.memento_num, R.id.memento_subject, R.id.memento_body, R.id.memento_date});
 //為listview添加適配器
 result.setAdapter(simpleCursorAdapter);
 break;
 }
 }

 //添加數(shù)據(jù)到數(shù)據(jù)庫中的方法
 public void add(SQLiteDatabase sqLiteDatabase,String subject,String body,String date){
 sqLiteDatabase.execSQL("Insert into memento_tb values(null,?,?,?)",new String[]{subject,body,date});
 //初始設置為空
 this.subject.setText("");
 this.body.setText("");
 this.date.setText("");
 }

 //查詢的方法，返回值為cursor
 public Cursor query(SQLiteDatabase sqLiteDatabase, String subject, String body, String date){
 Cursor cursor = sqLiteDatabase.rawQuery(
 "select * from memento_tb where subject like ? and body like ? and date like ? ",
 new String[]{"%" + subject + "%", "%" + body + "%",
  "%" + date + "%"});//對表的查詢（insert的操作）
 return cursor;
 }

 protected void onDestroy() {
 super.onDestroy();
 if (mMyDataBaseHelper != null) {
 mMyDataBaseHelper.close();
 }
 }
}

public class MyDataBaseHelper extends SQLiteOpenHelper {
 //創(chuàng)建數(shù)據(jù)庫的語句
 final String CREATE_TABLE_SQL =
 "create table memento_tb(_id integer primary " +
  "key autoincrement,subject,body,date)"; //建表


 public MyDataBaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
 super(context, name, factory, version);
 }

 //執(zhí)行建表的操作
 @Override
 public void onCreate(SQLiteDatabase db) {
 db.execSQL(CREATE_TABLE_SQL);
 }

 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 System.out.println("---------" + oldVersion + "------->" + newVersion);
 }
}