实现功能:能够添加日记,编辑日记,删除日记。学习数据库存储初期的小实验项目。
首先进行日记本的页面布局:
在刚进入程序时显示的页面,当时没有任何日记:
activity_diary.xml
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical"
android:paddingBottom="@dimen/activity_vertical_margin"
android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
tools:context=".DiaryActivity" >
<ListView
android:id="@+id/listview"
android:layout_height="fill_parent"
android:layout_width="fill_parent" >
</ListView>
<TextView
android:id="@+id/emptyShow"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="这家伙可真懒,还没开始写日记呢" />
</LinearLayout>
编辑页面及添加页面布局使用的是同一个页面:
add_edit.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="vertical" >
<TextView
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:text="@string/label_title" />
<EditText
android:id="@+id/title"
android:layout_width="fill_parent"
android:layout_height="wrap_content" />
<TextView
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:text="@string/label_content" />
<EditText
android:gravity="top"
android:id="@+id/content"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:layout_weight="1" />
<Button
android:id="@+id/confirm"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:onClick="addOrupdate"
android:text="@string/button_confirm" />
</LinearLayout>
当添加了日记之后日记在页面的显示格式页面:
item.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="horizontal" >
<TextView
android:id="@+id/title"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textSize="20sp" />
<TextView
android:id="@+id/createtime"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:gravity="right"
android:textSize="20sp" />
</LinearLayout>
当点击menu时会显示添加一篇新日记:
diary.xml
<menu xmlns:android="http://schemas.android.com/apk/res/android" >
<item
android:id="@+id/diary_add"
android:icon="@android:drawable/ic_menu_add"
android:title="@string/diary_add"/>
</menu>
当长按每一篇日记时会弹出上下文菜单里面会有两个按键:编辑和删除
diary_add.xml
<menu xmlns:android="http://schemas.android.com/apk/res/android" >
<item
android:id="@+id/edit"
android:orderInCategory="100"
android:title="@string/edit"/>
<item
android:id="@+id/delete"
android:orderInCategory="100"
android:title="@string/delete"/>
</menu>
日记实体类:
Diary.java
package test.entity;
/**
* 日记实体类
*/
public class Diary {
private Integer id;
private String title;
private String content;
private String createtime;
public Diary(String title, String content, String createtime) {
super();
this.title = title;
this.content = content;
this.createtime = createtime;
}
public Diary() {
super();
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public String getCreatetime() {
return createtime;
}
public void setCreatetime(String createtime) {
this.createtime = createtime;
}
@Override
public String toString() {
return "Diary [id=" + id + ", title=" + title + ", content=" + content
+ ", createtime=" + createtime + "]";
}
}
日记访问类:
DiaryDao.java
package test.dao;
import java.util.ArrayList;
import java.util.List;
import test.db.DBOpenHelper;
import test.entity.Diary;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
/**
* 日记访问类
* @author fengjun
* 完成了对数据库中的数据进行增删改查操作
*/
public class DiaryDao {
private DBOpenHelper dbOpenHelper;
private SQLiteDatabase db;
public DiaryDao(Context context){
dbOpenHelper=new DBOpenHelper(context);
}
/**
* 保存日记
* @param diary
*/
public void save(Diary diary){
db=dbOpenHelper.getWritableDatabase();
ContentValues values=new ContentValues();
values.put("title", diary.getTitle());
values.put("content", diary.getContent());
values.put("createtime", diary.getCreatetime());
db.insert("diary", null, values);
}
/**
* 根据id删除日记
* @param id
*/
public void delete(Integer id){
//TODO 要求2:此处插入若干行代码,实现根据id删除日记的功能。10分
// db = dbOpenHelper.getWritableDatabase();// 得到的是同一个数据库实例
//db.execSQL("delete from diary where _id=?",new Object[]{id});
db=dbOpenHelper.getWritableDatabase();
db.delete("diary","_id=?",new String[]{id.toString()});
}
// TODO 要求3:编写完成更新日记的方法,请补充
// 此处要封装能够实现更新日记的方法 15分
public void update(Diary diary){
db = dbOpenHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("title", diary.getTitle());
values.put("content", diary.getContent());
values.put("createtime", diary.getCreatetime());
//TODO 调用SQLiteDatabase提供的update方法完成更新操作
db.update("diary", values, "_id=?", new String[]{diary.getId().toString()});
db.close();
}
/**
* 查询所有日记
* @return Cursor
*/
public Cursor getAllDiaries(){
db=dbOpenHelper.getReadableDatabase();
Cursor cursor=db.query("diary", null, null, null, null, null, null);
return cursor;
}
/**
* 根据id查找日记
* @param id
* @return
*/
public Diary getDiaryById(Integer id){
Diary diary=null;
db=dbOpenHelper.getReadableDatabase();
Cursor cursor=db.query("diary", null, "_id=?", new String[]{id.toString()},null, null, null);
if(cursor!=null){
if(cursor.moveToFirst()){
String title=cursor.getString(cursor.getColumnIndex("title"));
String content=cursor.getString(cursor.getColumnIndex("content"));
String createtime=cursor.getString(cursor.getColumnIndex("createtime"));
diary=new Diary(title,content,createtime);
diary.setId(id);
}
}
return diary;
}
/**
* 计算日记数量
* @return
*/
public long count(){
long count=0;
db=dbOpenHelper.getReadableDatabase();
Cursor cursor=db.query("diary", new String[]{"count(*)"}, null, null, null, null, null);
if(cursor.moveToFirst()){
count=cursor.getLong(0);
}
return count;
}
}
数据库访问类:
DBOpenHelper.java
package test.db;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
/**
* 数据库创建辅助类 完成数据库的创建和升级
*/
//TODO 要求1:分析此处报错原因,修改此错误 5分
public class DBOpenHelper extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "diary.db";
public static final int DATABASE_VERSION = 1;
public DBOpenHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
/**
* 数据库第一次被创建出来的时候才会被调用,只会调用1次 完成数据库中表的创建 SQLiteDatabase类主要是为了操作数据库的
*/
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table diary(_id integer primary key autoincrement,title varchar(20),content varchar(1000),createtime)");
}
/**
* 数据库的版本发生改变的时候,一般是在软件升级的时候会调用
*/
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
时间显示:
DataTool.java
package test.tools;
import java.text.SimpleDateFormat;
import java.util.Date;
public class DateTool {
public static String getCurrentTime(){
SimpleDateFormat formatter=new SimpleDateFormat("yyyy年MM月dd日");
return formatter.format(new Date());
}
}
DiaryActivity.java
package test.activity;
import test.dao.DiaryDao;
import test.entity.Diary;
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.graphics.Region;
import android.os.Bundle;
import android.support.v4.widget.SimpleCursorAdapter;
import android.util.Log;
import android.view.ContextMenu;
import android.view.ContextMenu.ContextMenuInfo;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.AdapterView.AdapterContextMenuInfo;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.TextView;
//TODO 要求4:点击列表中的每一项时,弹出上下文菜单,有两个选项编辑、删除 10分
//操作提示:
//步骤1:给列表组件注册上下文菜单 2分
//提示: 调用registerForContextMenu方法
//步骤2:重写onCreateContextMenu方法 8分
//提示:ContextMenu类提供了如下方法
//setHeaderTitle方法设置上下文菜单的标题
//add(分组,菜单id,顺序,显示字符串)方法添加菜单选项,菜单id已经定义好了两个常量MENU_EDIT,MENU_DELETE
//-----------------------------------------------------------------------------------
//TODO 要求5:实现当单击日记列表中的每一项时,在弹出的上下文菜单中选择删除选项则会删除掉选中的日记 10分
//操作提示:重写onContextItemSelected方法,在此方法中实现相应的功能(注意:程序中已经给出了此方法的框架,补充完善即可)
//-----------------------------------------------------------------------------------
//TODO 要求6:实现当单击日记列表中的每一项时,在弹出的上下文菜单中选择编辑选项时打开DiaryEditActivity页面 10分
//操作提示:在onContextItemSelected方法中继续插入若干行代码,实现相应的功能
//-----------------------------------------------------------------------------------
public class DiaryActivity extends Activity {
private ListView listView;
private DiaryDao diaryDao;
private Diary diary;
private Cursor diaries;
public static final String TAG = "DiaryActivity";
private static final int MENU_EDIT = 1;// 编辑菜单id
private static final int MENU_DELETE = 2;// 删除菜单的id
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_diary);
listView = (ListView) this.findViewById(R.id.listview);
refreshList();
// 当列表为空时,显示
TextView emptyText = (TextView) this.findViewById(R.id.emptyShow);
listView.setEmptyView(emptyText);
// TODO 步骤1:给列表组件注册上下文菜单
this.registerForContextMenu(listView);
}
public void onCreateContextMenu(ContextMenu menu, View v,
ContextMenuInfo menuInfo) {
super.onCreateContextMenu(menu, v, menuInfo);
menu.setHeaderTitle("请选择");
menu.add(0,1,0,"编辑");
menu.add(0,2,0,"删除");
}
@Override
protected void onResume() {
refreshList();
super.onResume();
}
/**
* 刷新列表的显示
*/
public void refreshList() {
diaryDao = new DiaryDao(this);
diaries = diaryDao.getAllDiaries();
startManagingCursor(diaries);
SimpleCursorAdapter simpleCursorAdapter = new SimpleCursorAdapter(this,
R.layout.item, diaries, new String[] { "title", "createtime" },
new int[] { R.id.title, R.id.createtime });
listView.setAdapter(simpleCursorAdapter);
}
public boolean onCreateOptionsMenu(Menu menu) {
menu.add(0,0,0,"添加一篇新日记");
return true;
}
public boolean onOptionsItemSelected(MenuItem item) {
switch (item.getItemId()) {
case 0:
Intent intent=new Intent();
intent.setClass(DiaryActivity.this, DiaryEditActivity.class);
startActivity(intent);
break;
default:
break;
}
return super.onOptionsItemSelected(item);
}
// 对应要求5
@Override
public boolean onContextItemSelected(MenuItem item) {
AdapterContextMenuInfo menuInfo = (AdapterContextMenuInfo) item.getMenuInfo();
Log.v(TAG, "context item seleted ID=" + menuInfo.id);
switch (item.getItemId()) {
case MENU_EDIT:
Intent intent = new Intent();
intent.setClass(DiaryActivity.this, DiaryEditActivity.class);
intent.putExtra("id",(int)menuInfo.id);
startActivity(intent);
//TODO 此处插入若干行代码,跳转到DiaryEditActivity,并将选中日记对应的id传过去
break;
case MENU_DELETE:
diaryDao.delete((int)menuInfo.id);
refreshList();
break;
default:
break;
}
return super.onContextItemSelected(item);
}
}
DiaryEditActivity.java
package test.activity;
import test.tools.DateTool;
import java.util.Date;
import test.dao.DiaryDao;
import test.entity.Diary;
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.support.v4.widget.SimpleCursorAdapter;
import android.text.format.DateFormat;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
//TODO 要求7:实现当单击提交日记按钮时,完成对选定日记的更新操作 :40分
//
import android.widget.ListView;
public class DiaryEditActivity extends Activity {
private EditText titleText;
private EditText contentText;
private DiaryDao diaryDao;
private int number=0;
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.add_edit);
initViews();
// 实现添加日记
Bundle extras = getIntent().getExtras();
if (extras != null) {
int id=extras.getInt("id");
if(id!=0){
number=1;
diaryDao=new DiaryDao(this);
Diary diary=diaryDao.getDiaryById(id);
titleText.setText(diary.getTitle());
contentText.setText(diary.getContent());
}
}
//步骤1:获取DiaryActivity传过来的数据,将选定日记的标题和内容显示在相应的文本框中 20分
//此处插入若干行代码
}
private void initViews() {
titleText=(EditText) findViewById(R.id.title);
contentText=(EditText) findViewById(R.id.content);
}
//单击提交日记按钮时调用的方法
public void addOrupdate(View view){
//步骤2:完成日记更新操作 20分
Diary diary = new Diary(titleText.getText().toString(),
contentText.getText().toString(),
DateTool.getCurrentTime());
diaryDao=new DiaryDao(DiaryEditActivity.this);
if(number==1){
diary.setId(this.getIntent().getExtras().getInt("id"));
diaryDao.update(diary);
finish();
}else{
diaryDao.save(diary);
finish();
}
}
}