Android實(shí)驗(yàn)報(bào)告-數(shù)據(jù)庫(kù)接口

數(shù)據(jù)庫(kù)接口實(shí)驗(yàn)實(shí)驗(yàn)?zāi)康模罕緦?shí)驗(yàn)的目的是使學(xué)生深入了解 Android數(shù)據(jù)存儲(chǔ)和訪問(wèn)的方法，利用SQLite進(jìn)行數(shù)據(jù)存儲(chǔ)及訪問(wèn)。通過(guò)實(shí)驗(yàn)，掌握DatePicker和TimePicker的使方法。實(shí)驗(yàn)要求：設(shè)計(jì)程序?qū)崿F(xiàn)一個(gè)日期信息記錄數(shù)據(jù)庫(kù)軟件，如下圖所示SQLite實(shí)現(xiàn)數(shù)據(jù)庫(kù)的建立、數(shù)據(jù)表中的信息的刪DatePickerTimePicker日期和時(shí)間信息寫入到數(shù)據(jù)庫(kù)中。程序源碼（可付紙（包括XML和Java文件：mcy.javapackagecn.mcy;importjava.util.Calendar;importandroid.app.Activity;importandroid.content.ContentValues;importandroid.database.Cursor;importandroid.database.SQLException;importandroid.database.sqlite.SQLiteDatabase;importandroid.os.Bundle;importandroid.view.View;importandroid.view.View.OnClickListener;importandroid.widget.Button;importandroid.widget.DatePicker;importandroid.widget.EditText;importandroid.widget.TextView;importandroid.widget.TimePicker;importandroid.widget.Toast;publicclassmcyextendsActivity{/**Calledwhentheactivityisfirstcreated.*/privateEditTextedtEntry,edtIDEntry;privateButtonbtnAdd,btnShowAll,btnClearShow,btnDeleteAll,btnIDDelete,btnIDSeach,btnIDRefresh;privateTextViewtvSShow;privateintmYear,mMonth,mDay,mHour,mMinute;privateTimePickertp;privateDatePickerdp;privatestaticfinalStringDB_FILE="students.db",DB_TABLE="students";privateSQLiteDatabasemStuDbRW;@OverrideprotectedvoidonDestroy(){//TODOAuto-generatedmethodstubsuper.onDestroy();mStuDbRW.close();}@OverridepublicvoidonCreate(BundlesavedInstanceState){n=w,lfriDbHp.sCreateTableCommand="CREATETABLE"+DB_TABLE+"("+"_idINTEGERPRIMARYKEY,"+"idTEXTNOTNULL,"+"dateTEXT,"+"timeTEXT);";mStuDbRW=friDbHp.getWritableDatabase(); 生成一個(gè)數(shù)據(jù)庫(kù)mStuDbRWwyl)w)l)e)h)h))rc=er=Rh=Hy=Hr=Ye=Edp.init(mYear,mMonth,mDay,newDatePicker.OnDateChangedListener(){publicvoidonDateChanged(DatePickerview,intyear,intmonthOfYear,intdayOfMonth){mYear=year;mMonth=monthOfYear;mDay=dayOfMonth;"+.f"+String.valueOf(mDay)+""+String.valueOf(mHour)+""+String.valueOf(mMinute));}});w{publicvoidonTimeChanged(TimePickerview,inthourOfDay,intminute){mHour=hourOfDay;mMinute=minute;"String.valueOf(mMonth)+""+String.valueOf(mDay)+""+String.valueOf(mHour)+""+String.valueOf(mMinute));}});wpublicvoidonClick(Viewview){ContentValuesnewRow=newContentValues();newRow.put("id",edtIDEntry.getText().toString());newRow.put("date",String.valueOf(mYear)+String.valueOf(mMonth)+String.valueOf(mDay));newRow.put("time",String.valueOf(mHour)+String.valueOf(mMinute));mStuDbRW.insert(DB_TABLE,null,newRow);} });btnShowAll.setOnClickListenenre(wOnClickListener(){publicvoidonClick(Viewview){Cursorc=mStuDbRW.query(true,DB_TABLE,newString[]{"id","date","time"},null,null,null,null,null,null);return;

if(c==null)if(c.getCount()==0){tvSShow.setText("");Toast.makeText(mcy.this,"沒(méi)有資料",Toast.LENGTH_SHORT).show();}else{c.moveToFirst();tvSShow.setText(c.getString(0)+""+c.getString(1)+""+c.getString(2));while(c.moveToNext())tvSShow.append("\n"+c.getString(0)+""+c.getString(1)+""+c.getString(2));}}} );btnClearShow.setOnClickListenenre(wOnClickListener(){publicvoidonClick(Viewview){tvSShow.setText("");} });btnDeleteAll.setOnClickListenenre(wOnClickListener(){publicvoidonClick(Viewview){try{mStuDbRW.delete(DB_TABLE,"_id>?",newString[]{"0"}); }catch(SQLExceptione){ }} });btnIDDelete.setOnClickListenenre(wOnClickListener(){publicvoidonClick(Viewview){try{mStuDbRW.delete(DB_TABLE,"_id=?",newString[]{edtIDEntry.getText().toString()}); }catch(SQLExceptione){ }} });btnIDSeach.setOnClickListenenre(wOnClickListener(){publicvoidonClick(Viewview){Cursorc=null;c=mStuDbRW.query(true,DB_TABLE,newString[]{"id","date","time"},"id="+"\""+edtIDEntry.getText().toString()+"\"",null,null,null,null,null);c.moveToFirst();tvSShow.setText(c.getString(0)+""+c.getString(1)+""+c.getString(2));} });btnIDRefresh.setOnClickListenenre(wOnClickListener(){publicvoidonClick(Viewview){try{mStuDbRW.delete(DB_TABLE,"_id=?",newString[]{edtIDEntry.getText().toString()}); }catch(SQLExceptione){ }ContentValuesnewRow=newContentValues();newRow.put("id",edtIDEntry.getText().toString());newRow.put("date",String.valueOf(mYear)+String.valueOf(mMonth)+String.valueOf(mDay));newRow.put("time",String.valueOf(mHour)+String.valueOf(mMinute));mStuDbRW.insert(DB_TABLE,null,newRow);} });}}Mcy11.javapackagecn.mcy;importandroid.content.Context;importandroid.database.sqlite.SQLiteDatabase;importandroid.database.sqlite.SQLiteDatabase.CursorFactory;importandroid.database.sqlite.SQLiteOpenHelper;mcy11publicclass extendsSQLiteOpenHelper{mcy11publicStringsCreateTableCommand;publicmcy11(Contextcontext,Stringname,CursorFactoryfactory,intversion){super(context,name,factory,version);//TODOAuto-generatedconstructorstubsCreateTableCommand="";}@OverridepublicvoidonCreate(SQLiteDatabasedb){//TODOAuto-generatedmethodstubif(sCreateTableCommand==null)return;db.execSQL(sCreateTableCommand);}@OverridepublicvoidonUpgrade(SQLiteDatabasearg0,intarg1,intarg2){//TODOAuto-generatedmethodstub}}main.xml<?xmlversion="1.0"encoding="utf8"?><ScrollViewxmlns:android="/apk/res/android"android:layout_width="fill_parent"android:layout_height="wrap_content"><LinearLayoutxmlns:android="/apk/res/android"android:orientation="vertical"><LinearLayout>wandroid:layout_height="wrap_content"></TextView>t"=android:layout_width="match_parent"android:layout_height="wrap_content"></EditText></LinearLayout><LinearLayout>nandroid:layout_width="wrap_content"android:layout_height="wrap_content"></Button><Buttonandroid:text="全部顯示"android:id="@+id/btnShowAll"android:layout_width="wrap_content"android:layout_height="wrap_content"></Button><Buttonandroid:text="清除顯示"android:id="@+id/btnClearShow"android:layout_width="wrap_content"android:layout_height="wrap_content"></Button><Buttonandroid:text="全部刪除"android:id="@+id/btnDeleteAll"android:layout_width="wrap_content"android:layout_height="wrap_content"></Button></LinearLayout><LinearLayout>w"android:layout_height="wrap_content"></TextView><EditTextandroid:id="@+id/edtIDEntry"android:layout_width="100dp"android:layout_height="wrap_content"></EditText>nDandroid:layout_width="wrap_content"android:layout_height="wrap_content"></Button><Buttonandroid:text="ID查詢"andr