/TestB/res/layout/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="这家伙可真懒,还没开始写日记呢" />
</LinearLayo
/TestB/res/layout/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:onClick="addOrupdate"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="@string/button_confirm" />
</LinearLayout>
/TestB/res/layout/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>
/TestB/src/test/activity/DiaryActivity.java
package test.activity;
import test.dao.DiaryDao;
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
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.MenuItem;
import android.view.View;
import android.widget.AdapterView.AdapterContextMenuInfo;
import android.widget.ListView;
import android.widget.TextView;
public class DiaryActivity extends Activity {
private ListView listView;
private DiaryDao diaryDao;
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:给列表组件注册上下文菜单
registerForContextMenu(listView);
}
@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);
}
// 对应要求5
@Override
public void onCreateContextMenu(ContextMenu menu, View v,
ContextMenuInfo menuInfo) {
menu.setHeaderTitle("请选择");
menu.add(0, MENU_EDIT, 1, "编辑");
menu.add(0, MENU_DELETE, 2, "删除");
super.onCreateContextMenu(menu, v, menuInfo);
}
@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:
//TODO 此处插入若干行代码,跳转到DiaryEditActivity,并将选中日记对应的id传过去
Intent intent=new Intent();
intent.setClass(this, DiaryEditActivity.class);
intent.putExtra("id",(int)menuInfo.id);
startActivity(intent);
break;
case MENU_DELETE:
diaryDao.delete((int)menuInfo.id);
refreshList();
break;
default:
break;
}
return super.onContextItemSelected(item);
}
}
/TestB/src/test/activity/DiaryEditActivity.java
package test.activity;
import java.util.Date;
import test.dao.DiaryDao;
import test.entity.Diary;
import test.tools.DateTool;
import android.app.Activity;
import android.os.Bundle;
import android.text.format.DateFormat;
import android.view.View;
import android.widget.EditText;
public class DiaryEditActivity extends Activity {
private EditText titleText;
private EditText contentText;
private DiaryDao diaryDao;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.add_edit);
initViews();
}
private void initViews() {
titleText=(EditText) findViewById(R.id.title);
contentText=(EditText) findViewById(R.id.content);
}
//单击提交日记按钮时调用的方法
public void addOrupdate(View view){
String title=titleText.getText().toString();
String content=contentText.getText().toString();
Diary diary=new Diary(title, content, DateTool.getCurrentTime());
diaryDao.save(diary);
finish();
}
}
/TestB/src/test/dao/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){
db = dbOpenHelper.getWritableDatabase();
db.delete("diary","_id=?", new String[]{id.toString()});
}
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()});
}
/**
* 查询所有日记
* @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;
}
}
/TestB/src/test/db/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;
public class DBOpenHelper extends SQLiteOpenHelper {
private static final String DB_NAME = "diary.db";
private static final int DB_VERSION = 1;
/**
* 数据库第一次被创建出来的时候才会被调用,只会调用1次 完成数据库中表的创建 SQLiteDatabase类主要是为了操作数据库的
*/public DBOpenHelper(Context context) {
super(context, DB_NAME,null, DB_VERSION);
// TODO Auto-generated constructor stub
}
@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) {
}
}
/TestB/src/test/entity/Diary.java
package test.entity;
/**
* 日记实体类
* @author fengjun
*/
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 + "]";
}
}
/TestB/src/test/test/DBTest.java
package test.test;
import test.db.DBOpenHelper;
import android.test.AndroidTestCase;
public class DBTest extends AndroidTestCase {
public void testCreateDB(){
DBOpenHelper dbOpenHelper=new DBOpenHelper(getContext());
dbOpenHelper.getWritableDatabase();
}
}
/TestB/src/test/test/DiaryDaoTest.java
package test.test;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import test.dao.DiaryDao;
import test.entity.Diary;
import android.test.AndroidTestCase;
public class DiaryDaoTest extends AndroidTestCase {
public void testSave(){
DiaryDao diaryDao=new DiaryDao(getContext());
Diary diary=null;
diary = new Diary("五一第1天", "不错,今天中奖了", getCurrentTime());
diaryDao.save(diary);
diary = new Diary("五一第2天", "不错,今天中奖了", getCurrentTime());
diaryDao.save(diary);
diary = new Diary("五一第3天", "不错,今天中奖了", getCurrentTime());
diaryDao.save(diary);
diary = new Diary("五一第4天", "不错,今天中奖了", getCurrentTime());
diaryDao.save(diary);
}
public void testGetAllDiaries(){
DiaryDao diaryDao=new DiaryDao(getContext());
//List<Diary> allDiaries=diaryDao.getAllDiaries();
//System.out.println(allDiaries);
}
public String getCurrentTime() {
SimpleDateFormat format = new SimpleDateFormat(
"yyyy年MM月dd日 hh时:mm分:ss秒");
String date = format.format(new Date());
return date;
}
}
/TestB/src/test/tools/DateTool.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());
}
}
/TestB/res/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"/>
<item
android:id="@+id/diary_delete"
android:icon="@android:drawable/ic_menu_delete"
android:title="@string/diary_delete"/>
</menu>