package com.example.asus.student;import java.util.ArrayList;import java.util.Iterator;import java.util.List;import android.app.AlertDialog;import android.app.ListActivity;import android.content.DialogInterface;import android.content.Intent;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.os.Bundle;import android.util.Log;import android.view.ContextMenu;import android.view.ContextMenu.ContextMenuInfo;import android.view.Menu;import android.view.MenuInflater;import android.view.MenuItem;import android.view.View;import android.view.View.OnClickListener;import android.widget.AdapterView;import android.widget.AdapterView.OnItemClickListener;import android.widget.AdapterView.OnItemLongClickListener;import android.widget.Button;import android.widget.CheckBox;import android.widget.LinearLayout;import android.widget.ListView;import android.widget.RelativeLayout;import android.widget.SimpleCursorAdapter;import android.widget.Toast;import StudentDBHelper.StudentDBHelper;import Student.Student;//import AddStudentActivity;import TableContanst.TableContanst;public class StudentListActivity extends ListActivity implements  OnClickListener, OnItemClickListener, OnItemLongClickListener { private static final String TAG = "TestSQLite"; private Button addStudent; private Cursor cursor; private SimpleCursorAdapter adapter; private ListView listView; private List<Long> list; private RelativeLayout relativeLayout; private Button searchButton; private Button selectButton; private Button deleteButton; private Button selectAllButton; private Button canleButton; private LinearLayout layout; private StudentDao dao; private Student student; private Boolean isDeleteList = false; @Override public void onCreate(Bundle savedInstanceState) {  super.onCreate(savedInstanceState);  setContentView(R.layout.main);  Log.e(TAG, "onCreate");  list = new ArrayList<Long>();  student = new Student();  dao = new StudentDao(new StudentDBHelper(this));  addStudent = (Button) findViewById(R.id.btn_add_student);  searchButton = (Button) findViewById(R.id.bn_search_id);  selectButton = (Button) findViewById(R.id.bn_select);  deleteButton = (Button) findViewById(R.id.bn_delete);  selectAllButton = (Button) findViewById(R.id.bn_selectall);  canleButton = (Button) findViewById(R.id.bn_canel);  layout = (LinearLayout) findViewById(R.id.showLiner);  relativeLayout=(RelativeLayout) findViewById(R.id.RelativeLayout);  listView = getListView();  // 為按鍵設置監(jiān)聽  addStudent.setOnClickListener(this);  searchButton.setOnClickListener(this);  selectButton.setOnClickListener(this);  deleteButton.setOnClickListener(this);  canleButton.setOnClickListener(this);  selectAllButton.setOnClickListener(this);  listView.setOnItemClickListener(this);  listView.setOnItemLongClickListener(this);  listView.setOnCreateContextMenuListener(this); } // 調用load()方法將數據庫中的所有記錄顯示在當前頁面 @Override protected void onStart() {  super.onStart();  load(); } public void onClick(View v) {  // 跳轉到添加信息的界面  if (v == addStudent) {   startActivity(new Intent(StudentListActivity.this, AddStudentActivity.class));  } else if (v == searchButton) {   // 跳轉到查詢界面   startActivity(new Intent(this, StudentSearch.class));  } else if (v == selectButton) {   // 跳轉到選擇界面   isDeleteList = !isDeleteList;   if (isDeleteList) {    checkOrClearAllCheckboxs(true);   } else {    showOrHiddenCheckBoxs(false);   }  } else if (v == deleteButton) {   // 刪除數據   if (list.size() > 0) {    for (int i = 0; i < list.size(); i++) {     long id = list.get(i);     Log.e(TAG, "delete id=" + id);     int count = dao.deleteStudentById(id);    }    dao.closeDB();    load();   }  } else if (v == canleButton) {   // 點擊取消，回到初始界面   load();   layout.setVisibility(View.GONE);   isDeleteList = !isDeleteList;  } else if (v == selectAllButton) {   // 全選，如果當前全選按鈕顯示是全選，則在點擊后變?yōu)槿∠x，如果當前為取消全選，則在點擊后變?yōu)槿x   selectAllMethods(); } } // 創(chuàng)建菜單 public void onCreateContextMenu(ContextMenu menu, View v, ContextMenuInfo menuInfo) {  MenuInflater inflater = new MenuInflater(this); //getMenuInflater();  inflater.inflate(R.menu.menu, menu); } // 對菜單中的按鈕添加響應時間 @Override public boolean onContextItemSelected(MenuItem item) {  int item_id = item.getItemId();  student = (Student) listView.getTag();  Log.v(TAG, "TestSQLite++++student+" + listView.getTag() + "");  final long student_id = student.getId();  Intent intent = new Intent();  Log.v(TAG, "TestSQLite+++++++id"+student_id);  switch (item_id) {   /* 添加   case R.id.add:    startActivity(new Intent(this, AddStudentActivity.class));    break;*/   // 刪除   case R.id.delete:    deleteStudentInformation(student_id);    break;   case R.id.look:    // 查看學生信息    Log.v(TAG, "TestSQLite+++++++look"+student+"");    intent.putExtra("student", student);    intent.setClass(this, ShowStudentActivity.class);    this.startActivity(intent);    break;   case R.id.write:    // 修改學生信息    intent.putExtra("student", student);    intent.setClass(this, AddStudentActivity.class);    this.startActivity(intent);    break;   default:    break;  }  return super.onContextItemSelected(item); }  @Override public boolean onItemLongClick(AdapterView<?> parent, View view, int position, long id) {  Student student = (Student) dao.getStudentFromView(view, id);  listView.setTag(student);  registerForContextMenu(listView);  return false; } // 點擊一條記錄是觸發(fā)的事件 @Override public void onItemClick(AdapterView<?> parent, View view, int position,       long id) {  if (!isDeleteList) {   student = dao.getStudentFromView(view, id);   Log.e(TAG, "student*****" + dao.getStudentFromView(view, id));   Intent intent = new Intent();   intent.putExtra("student", student);   intent.setClass(this, ShowStudentActivity.class);   this.startActivity(intent);  } else {   CheckBox box = (CheckBox) view.findViewById(R.id.cb_box);   box.setChecked(!box.isChecked());   list.add(id);   deleteButton.setEnabled(box.isChecked());  } } // 自定義一個加載數據庫中的全部記錄到當前頁面的無參方法 public void load() {  StudentDBHelper studentDBHelper = new StudentDBHelper(    StudentListActivity.this);  SQLiteDatabase database = studentDBHelper.getWritableDatabase();  cursor = database.query(TableContanst.STUDENT_TABLE, null, null, null,    null, null, TableContanst.StudentColumns.MODIFY_TIME + " desc");  startManagingCursor(cursor);  adapter = new SimpleCursorAdapter(this, R.layout.student_list_item,    cursor, new String[] { TableContanst.StudentColumns.ID,    TableContanst.StudentColumns.NAME,    TableContanst.StudentColumns.AGE,    TableContanst.StudentColumns.SEX,    TableContanst.StudentColumns.LIKES,    TableContanst.StudentColumns.PHONE_NUMBER,    TableContanst.StudentColumns.TRAIN_DATE }, new int[] {    R.id.tv_stu_id, R.id.tv_stu_name, R.id.tv_stu_age,    R.id.tv_stu_sex, R.id.tv_stu_likes, R.id.tv_stu_phone,    R.id.tv_stu_traindate });  listView.setAdapter(adapter); } // 全選或者取消全選 private void checkOrClearAllCheckboxs(boolean b) {  int childCount = listView.getChildCount();   Log.e(TAG, "list child size=" + childCount);  for (int i = 0; i < childCount; i++) {   View view = listView.getChildAt(i);   if (view != null) {    CheckBox box = (CheckBox) view.findViewById(R.id.cb_box);    box.setChecked(!b);   }  }  showOrHiddenCheckBoxs(true); } // 顯示或者隱藏自定義菜單 private void showOrHiddenCheckBoxs(boolean b) {  int childCount = listView.getChildCount();  Log.e(TAG, "list child size=" + childCount);  for (int i = 0; i < childCount; i++) {   View view = listView.getChildAt(i);   if (view != null) {    CheckBox box = (CheckBox) view.findViewById(R.id.cb_box);    int visible = b ? View.VISIBLE : View.GONE;    box.setVisibility(visible);    layout.setVisibility(visible);    deleteButton.setEnabled(false);   }  } } // 自定義一個利用對話框形式進行數據的刪除 private void deleteStudentInformation(final long delete_id) {  // 利用對話框的形式刪除數據  AlertDialog.Builder builder = new AlertDialog.Builder(this);  builder.setTitle("學員信息刪除")    .setMessage("確定刪除所選記錄?")    .setCancelable(false)    .setPositiveButton("確定", new DialogInterface.OnClickListener() {     public void onClick(DialogInterface dialog, int id) {      int raws = dao.deleteStudentById(delete_id);      layout.setVisibility(View.GONE);      isDeleteList = !isDeleteList;      load();      if (raws > 0) {       Toast.makeText(StudentListActivity.this, "刪除成功!",         Toast.LENGTH_LONG).show();      } else       Toast.makeText(StudentListActivity.this, "刪除失敗!",         Toast.LENGTH_LONG).show();     }    })    .setNegativeButton("取消", new DialogInterface.OnClickListener() {     public void onClick(DialogInterface dialog, int id) {      dialog.cancel();     }    });  AlertDialog alert = builder.create();  alert.show(); } // 點擊全選事件時所觸發(fā)的響應 private void selectAllMethods() {  // 全選，如果當前全選按鈕顯示是全選，則在點擊后變?yōu)槿∠x，如果當前為取消全選，則在點擊后變?yōu)槿x  if (selectAllButton.getText().toString().equals("全選")) {   int childCount = listView.getChildCount();   for (int i = 0; i < childCount; i++) {    View view = listView.getChildAt(i);    if (view != null) {     CheckBox box = (CheckBox) view.findViewById(R.id.cb_box);     box.setChecked(true);     deleteButton.setEnabled(true);     selectAllButton.setText("取消全選");    }   }  } else if (selectAllButton.getText().toString().equals("取消全選")) {   checkOrClearAllCheckboxs(true);   deleteButton.setEnabled(false);   selectAllButton.setText("全選");  } }}

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical" android:layout_width="fill_parent" android:layout_height="fill_parent"> <RelativeLayout android:id="@+id/RelativeLayout"  android:layout_width="fill_parent"  android:layout_height="wrap_content">  <Button android:id="@+id/bn_search_id"   android:layout_width="wrap_content"   android:layout_height="wrap_content"   android:text="搜索"   android:gravity="center_vertical" />  <Button android:gravity="center"   android:text="添加學員信息"   android:id="@+id/btn_add_student"   android:layout_width="wrap_content"   android:layout_height="wrap_content"   android:layout_alignParentTop="true"   android:layout_toRightOf="@+id/bn_search_id"   android:layout_toLeftOf="@+id/bn_select" />  <Button android:gravity="center_vertical"   android:text="選擇"   android:id="@+id/bn_select"   android:layout_width="wrap_content"   android:layout_height="wrap_content"   android:layout_alignParentTop="true"   android:layout_alignParentRight="true"></Button> </RelativeLayout> <TextView  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:gravity="center"  android:text="  ID   姓 名    年 齡   性 別  "  /> <ListView  android:id="@android:id/list"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_weight="1" /> <LinearLayout  android:orientation="horizontal"  android:id="@+id/showLiner"  android:visibility="gone"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_gravity="center_horizontal">  <Button   android:id="@+id/bn_delete"   android:layout_width="fill_parent"   android:layout_height="wrap_content"   android:layout_weight="1"   android:text="刪除"   android:enabled="false"   />  <Button   android:id="@+id/bn_selectall"   android:layout_width="fill_parent"   android:layout_height="wrap_content"   android:layout_weight="1"   android:text="全選"   />  <Button   android:id="@+id/bn_canel"   android:layout_width="fill_parent"   android:layout_height="wrap_content"   android:layout_weight="1"   android:text="取消"   /> </LinearLayout></LinearLayout>

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="horizontal" android:layout_width="fill_parent" android:layout_height="wrap_content" > <ImageView android:layout_width="fill_parent"  android:layout_height="130px"  android:layout_gravity="center"  android:layout_weight="1"  android:background="@drawable/icon" /> <TextView android:id="@+id/tv_stu_id"  android:layout_width="fill_parent"  android:layout_gravity="center"  android:layout_height="wrap_content"  android:layout_weight="1"/> <TextView android:id="@+id/tv_stu_name"  android:layout_width="fill_parent"  android:layout_gravity="center"  android:layout_height="wrap_content"  android:layout_weight="1"/> <TextView android:id="@+id/tv_stu_age"  android:layout_width="fill_parent"  android:layout_gravity="center"  android:layout_height="wrap_content"  android:layout_weight="1"/> <TextView android:id="@+id/tv_stu_sex"  android:layout_width="fill_parent"  android:layout_gravity="center"  android:layout_height="wrap_content"  android:layout_weight="1"/> <TextView android:id="@+id/tv_stu_likes"  android:layout_width="fill_parent"  android:layout_gravity="center"  android:layout_height="wrap_content"  android:layout_weight="1"  android:visibility="gone"/> <TextView android:id="@+id/tv_stu_phone"  android:layout_width="fill_parent"  android:layout_gravity="center"  android:layout_height="wrap_content"  android:layout_weight="1"  android:visibility="gone"/> <TextView android:id="@+id/tv_stu_traindate"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_gravity="center"  android:layout_weight="1"  android:visibility="gone"/> <TextView android:id="@+id/tv_stu_modifyDateTime"  android:layout_width="fill_parent"  android:layout_gravity="center"  android:layout_height="wrap_content"  android:layout_weight="1"  android:visibility="gone"/> <CheckBox  android:id="@+id/cb_box"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_weight="1"  android:visibility="gone"  android:checked="false"  android:focusable="false"/></LinearLayout>

package com.example.asus.student;import android.app.Activity;import android.content.Intent;import android.os.Bundle;import android.view.View;import android.widget.TextView;import Student.Student;import TableContanst.TableContanst;public class ShowStudentActivity extends Activity { @Override public void onCreate(Bundle savedInstanceState) {  super.onCreate(savedInstanceState);  setContentView(R.layout.student_info);  Intent intent = getIntent();  Student student = (Student) intent.getSerializableExtra(TableContanst.STUDENT_TABLE);  ((TextView)findViewById(R.id.tv_info_id)).setText(student.getId()+"");  ((TextView)findViewById(R.id.tv_info_name)).setText(student.getName());  ((TextView)findViewById(R.id.tv_info_age)).setText(student.getAge()+"");  ((TextView)findViewById(R.id.tv_info_sex)).setText(student.getSex());  ((TextView)findViewById(R.id.tv_info_likes)).setText(student.getLike());  ((TextView)findViewById(R.id.tv_info_train_date)).setText(student.getTrainDate());  ((TextView)findViewById(R.id.tv_info_phone)).setText(student.getPhoneNumber()); } public void goBack(View view) {  finish(); }}

<?xml version="1.0" encoding="utf-8"?><RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical" android:layout_width="fill_parent" android:layout_height="fill_parent" android:padding="5dip"  > <TextView android:id="@+id/id2_text_id"  android:layout_width="80dip"  android:layout_height="40dip"  android:layout_marginRight="5dip"  android:layout_marginTop="5dip"  android:layout_marginBottom="5dip"  android:textSize="16sp"  android:gravity="left|center_vertical"  android:text="學員ID："  /> <TextView android:id="@+id/tv_info_id"  android:layout_width="fill_parent"  android:layout_height="40dip"  android:layout_toRightOf="@id/id2_text_id"  android:layout_alignParentRight="true"  android:layout_alignTop="@id/id2_text_id"  android:gravity="left|center_vertical"/> <TextView android:id="@+id/name2_text_id"  android:layout_width="80dip"  android:layout_height="40dip"  android:layout_marginRight="5dip"  android:layout_marginTop="5dip"  android:layout_marginBottom="5dip"  android:layout_below="@id/id2_text_id"  android:layout_alignLeft="@id/id2_text_id"  android:textSize="16sp"  android:gravity="left|center_vertical"  android:text="姓名："  /> <TextView android:id="@+id/tv_info_name"  android:layout_width="fill_parent"  android:layout_height="40dip"  android:layout_toRightOf="@id/name2_text_id"  android:layout_alignParentRight="true"  android:layout_alignTop="@id/name2_text_id"  android:gravity="left|center_vertical"  /> <TextView android:id="@+id/age2_text_id"  android:layout_width="80dip"  android:layout_height="40dip"  android:gravity="left|center_vertical"  android:layout_marginRight="5dip"  android:layout_below="@id/name2_text_id"  android:layout_marginBottom="5dip"  android:textSize="16sp"  android:text="年齡："  /> <TextView android:id="@+id/tv_info_age"  android:layout_width="fill_parent"  android:layout_height="40dip"  android:layout_toRightOf="@id/age2_text_id"  android:layout_alignParentRight="true"  android:layout_alignTop="@id/age2_text_id"  android:gravity="left|center_vertical"  /> <TextView android:id="@+id/sex2_text_id"  android:layout_width="80dip"  android:layout_height="40dip"  android:gravity="left|center_vertical"  android:layout_below="@id/age2_text_id"  android:layout_alignLeft="@id/age2_text_id"  android:layout_marginRight="5dip"  android:layout_marginBottom="5dip"  android:text="性別："  android:textSize="16sp"  /> <TextView  android:id="@+id/tv_info_sex"  android:layout_width="fill_parent"  android:layout_height="40dip"  android:layout_toRightOf="@id/sex2_text_id"  android:layout_alignParentRight="true"  android:layout_alignTop="@id/sex2_text_id"  android:gravity="left|center_vertical"   /> <TextView android:id="@+id/like2_text_id"  android:layout_width="80dip"  android:layout_height="40dip"  android:gravity="left|center_vertical"  android:layout_below="@id/sex2_text_id"  android:layout_alignLeft="@id/sex2_text_id"  android:layout_marginRight="5dip"  android:layout_marginBottom="5dip"  android:text="愛好："  android:textSize="16sp"  /> <TextView android:layout_height="40dip"  android:id="@+id/tv_info_likes"  android:layout_width="wrap_content"  android:layout_toRightOf="@id/like2_text_id"  android:layout_below="@id/sex2_text_id"  android:layout_marginRight="52dip"  android:gravity="left|center_vertical"/> <TextView android:id="@+id/contact2_text_id"  android:layout_width="80dip"  android:layout_height="40dip"  android:gravity="center_vertical|left"  android:layout_marginRight="5dip"  android:layout_below="@id/like2_text_id"  android:layout_marginBottom="5dip"  android:textSize="16sp"  android:text="聯系電話："  /> <TextView android:id="@+id/tv_info_phone"  android:layout_width="fill_parent"  android:layout_height="40dip"  android:layout_toRightOf="@id/contact2_text_id"  android:layout_alignParentRight="true"  android:layout_alignTop="@id/contact2_text_id"  android:gravity="center_vertical|left"  /> <TextView android:id="@+id/train2_time_text_id"  android:layout_width="80dip"  android:layout_height="40dip"  android:gravity="center_vertical|left"  android:layout_marginRight="5dip"  android:layout_below="@id/contact2_text_id"  android:layout_marginBottom="5dip"  android:textSize="16sp"  android:text="入學日期"  /> <TextView android:id="@+id/tv_info_train_date"  android:layout_width="fill_parent"  android:layout_height="40dip"  android:layout_toRightOf="@id/train2_time_text_id"  android:layout_alignParentRight="true"  android:layout_alignTop="@id/train2_time_text_id"  android:gravity="center_vertical|left"  /> <Button android:id="@+id/back_to_list_id"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:text="返回列表界面"  android:layout_below="@id/train2_time_text_id"  android:layout_alignParentLeft="true"  android:layout_alignParentRight="true"  android:onClick="goBack"> </Button></RelativeLayout>

package com.example.asus.student;import java.io.Serializable;import java.text.SimpleDateFormat;import java.util.Calendar;import java.util.Date;import java.util.HashSet;import android.app.Activity;import android.app.DatePickerDialog;import android.app.Dialog;import android.content.ContentValues;import android.content.Intent;import android.database.sqlite.SQLiteDatabase;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.CheckBox;import android.widget.CompoundButton;import android.widget.CompoundButton.OnCheckedChangeListener;import android.widget.DatePicker;import android.widget.EditText;import android.widget.RadioButton;import android.widget.RadioGroup;import android.widget.TextView;import android.widget.Toast;import StudentDBHelper.StudentDBHelper;import Student.Student;import TableContanst.TableContanst;public class AddStudentActivity extends Activity implements OnClickListener { private static final String TAG = "AddStudentActivity"; private final static int DATE_DIALOG = 1; private static final int DATE_PICKER_ID = 1; private TextView idText; private EditText nameText; private EditText ageText; private EditText phoneText; private EditText dataText; private RadioGroup group; private RadioButton button1; private RadioButton button2; private CheckBox box1; private CheckBox box2; private CheckBox box3; private Button restoreButton; private String sex; private Button resetButton; private Long student_id; private StudentDao dao; private boolean isAdd = true; @Override public void onCreate(Bundle savedInstanceState) {  super.onCreate(savedInstanceState);  setContentView(R.layout.add_student);  idText = (TextView) findViewById(R.id.tv_stu_id);  nameText = (EditText) findViewById(R.id.et_name);  ageText = (EditText) findViewById(R.id.et_age);  button1 = (RadioButton) findViewById(R.id.rb_sex_female);  button2 = (RadioButton) findViewById(R.id.rb_sex_male);  phoneText = (EditText) findViewById(R.id.et_phone);  dataText = (EditText) findViewById(R.id.et_traindate);  group = (RadioGroup) findViewById(R.id.rg_sex);  box1 = (CheckBox) findViewById(R.id.box1);  box2 = (CheckBox) findViewById(R.id.box2);  box3 = (CheckBox) findViewById(R.id.box3);  restoreButton = (Button) findViewById(R.id.btn_save);  resetButton = (Button) findViewById(R.id.btn_clear);  dao = new StudentDao(new StudentDBHelper(this)); // 設置監(jiān)聽 78  restoreButton.setOnClickListener(this);  resetButton.setOnClickListener(this);  dataText.setOnClickListener(this);  checkIsAddStudent(); } // 檢查此時Activity是否用于添加學員信息 private void checkIsAddStudent() {  Intent intent = getIntent();  Serializable serial = intent.getSerializableExtra(TableContanst.STUDENT_TABLE);  if (serial == null) {   isAdd = true;   dataText.setText(getCurrentDate());  } else {   isAdd = false;   Student s = (Student) serial;   showEditUI(s);  } } //顯示學員信息更新的UI104 private void showEditUI(Student student) {  // 先將Student攜帶的數據還原到student的每一個屬性中去  student_id = student.getId();  String name = student.getName();  int age = student.getAge();  String phone = student.getPhoneNumber();  String data = student.getTrainDate();  String like = student.getLike();  String sex = student.getSex();  if (sex.toString().equals("男")) {   button2.setChecked(true);  } else if (sex.toString().equals("女")) {   button1.setChecked(true);  }  if (like != null && !"".equals(like)) {   if (box1.getText().toString().indexOf(like) >= 0) {    box1.setChecked(true);   }   if (box2.getText().toString().indexOf(like) >= 0) {    box2.setChecked(true);   }   if (box3.getText().toString().indexOf(like) >= 0) {    box3.setChecked(true);   }  }  // 還原數據  idText.setText(student_id + "");  nameText.setText(name + "");  ageText.setText(age + "");  phoneText.setText(phone + "");  dataText.setText(data + "");  setTitle("學員信息更新");  restoreButton.setText("更新"); } public void onClick(View v) {  // 收集數據  if (v == restoreButton) {   if (!checkUIInput()) {// 界面輸入驗證    return;   }   Student student = getStudentFromUI();   if (isAdd) {    long id = dao.addStudent(student);    dao.closeDB();    if (id > 0) {     Toast.makeText(this, "保存成功， ID=" + id,Toast.LENGTH_SHORT).show();     finish();    } else {     Toast.makeText(this, "保存失敗，請重新輸入！", Toast.LENGTH_SHORT).show();    }   } else if (!isAdd) {    long id = dao.addStudent(student);    dao.closeDB();    if (id > 0) {     Toast.makeText(this, "更新成功",Toast.LENGTH_SHORT).show();     finish();    } else {     Toast.makeText(this, "更新失敗，請重新輸入！",Toast.LENGTH_SHORT).show();    }   }  } else if (v == resetButton) {   clearUIData();  } else if (v == dataText) {   showDialog(DATE_PICKER_ID);  } } //  清空界面的數據176 private void clearUIData() {  nameText.setText("");  ageText.setText("");  phoneText.setText("");  dataText.setText("");  box1.setChecked(false);  box2.setChecked(false);  group.clearCheck(); } //  收集界面輸入的數據，并將封裝成Student對象 private Student getStudentFromUI() {  String name = nameText.getText().toString();  int age = Integer.parseInt(ageText.getText().toString());  String sex = ((RadioButton) findViewById(group    .getCheckedRadioButtonId())).getText().toString();  String likes = "";  if (box1.isChecked()) { // basketball, football football   likes += box1.getText();  }  if (box2.isChecked()) {   if (likes.equals("")) {    likes += box2.getText();   } else {    likes += "," + box2.getText();   }   if (likes.equals("")) {    likes += box3.getText();   } else {    likes += "," + box3.getText();   }  }  String trainDate = dataText.getText().toString();  String phoneNumber = phoneText.getText().toString();  String modifyDateTime = getCurrentDateTime();  Student s=new Student(name, age, sex, likes, phoneNumber, trainDate,    modifyDateTime);  if (!isAdd) {   s.setId(Integer.parseInt(idText.getText().toString()));   dao.deleteStudentById(student_id);  }  return s; } //  * 得到當前的日期時間 private String getCurrentDateTime() {  SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");  return format.format(new Date()); } //  * 得到當前的日期 private String getCurrentDate() {  SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");  return format.format(new Date()); } //驗證用戶是否按要求輸入了數據 private boolean checkUIInput() { // name, age, sex  String name = nameText.getText().toString();  String age = ageText.getText().toString();  int id = group.getCheckedRadioButtonId();  String message = null;  View invadView = null;  if (name.trim().length() == 0) {   message = "請輸入姓名！";   invadView = nameText;  } else if (age.trim().length() == 0) {   message = "請輸入年齡！";   invadView = ageText;  } else if (id == -1) {   message = "請選擇性別！";  }  if (message != null) {   Toast.makeText(this, message, Toast.LENGTH_SHORT).show();   if (invadView != null)    invadView.requestFocus();   return false;  }   return true;  } //時間的監(jiān)聽與事件 private DatePickerDialog.OnDateSetListener onDateSetListener = new DatePickerDialog.OnDateSetListener() {  @Override  public void onDateSet(DatePicker view, int year, int monthOfYear,        int dayOfMonth) {   dataText.setText(year + "-" + (monthOfYear + 1) + "-" + dayOfMonth);  } }; @Override protected Dialog onCreateDialog(int id) {  switch (id) {   case DATE_PICKER_ID:    return new DatePickerDialog(this, onDateSetListener, 2011, 8, 14);  }  return null; }}

<?xml version="1.0" encoding="utf-8"?><ScrollView xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="fill_parent" android:fillViewport="true" android:scrollbarStyle="outsideInset" > <RelativeLayout  android:orientation="vertical"  android:layout_width="fill_parent"  android:layout_height="fill_parent"  android:padding="5dip"  >  <TextView android:id="@+id/tv_stu_text_id"   android:layout_width="80dip"   android:layout_height="40dip"   android:gravity="center_vertical|right"   android:layout_marginRight="5dip"   android:layout_marginTop="5dip"   android:layout_marginBottom="5dip"   android:textSize="16sp"   android:text="學員ID："  />  <TextView android:id="@+id/tv_stu_id"   android:layout_width="fill_parent"   android:layout_height="40dip"   android:text="未分配ID"   android:layout_toRightOf="@id/tv_stu_text_id"   android:layout_alignParentRight="true"   android:layout_alignTop="@id/tv_stu_text_id"   android:gravity="center"   android:background="#ffffff"   android:textColor="#000000"   android:textSize="16sp"  />  <TextView android:id="@+id/tv_name_text"   android:layout_width="80dip"   android:layout_height="40dip"   android:gravity="center_vertical|right"   android:layout_marginRight="5dip"   android:layout_below="@id/tv_stu_text_id"   android:layout_alignLeft="@id/tv_stu_text_id"   android:layout_marginBottom="5dip"   android:textSize="16sp"   android:text="姓名："  />  <EditText android:id="@+id/et_name"   android:layout_width="fill_parent"   android:layout_height="40dip"   android:layout_toRightOf="@id/tv_name_text"   android:layout_alignParentRight="true"   android:layout_alignTop="@id/tv_name_text"   android:hint="請輸入姓名，如liukenken"   android:inputType="textPersonName"   android:paddingLeft="20dip"/>  <TextView android:id="@+id/tv_age_text"   android:layout_width="80dip"   android:layout_height="40dip"   android:gravity="center_vertical|right"   android:layout_marginRight="5dip"   android:layout_below="@id/tv_name_text"   android:layout_marginBottom="5dip"   android:textSize="16sp"   android:text="年齡："  />  <EditText android:id="@+id/et_age"   android:layout_width="fill_parent"   android:layout_height="40dip"   android:layout_toRightOf="@id/tv_age_text"   android:layout_alignParentRight="true"   android:layout_alignTop="@id/tv_age_text"   android:hint="請輸入年齡"   android:paddingLeft="20dip"   android:maxLength="3"   android:inputType="number"  />  <TextView android:id="@+id/tv_sex_text"   android:layout_width="80dip"   android:layout_height="40dip"   android:gravity="center_vertical|right"   android:layout_below="@id/tv_age_text"   android:layout_alignLeft="@id/tv_age_text"   android:layout_marginRight="5dip"   android:layout_marginBottom="5dip"   android:text="性別："   android:textSize="16sp"  />  <RadioGroup   android:id="@+id/rg_sex"   android:layout_width="fill_parent"   android:layout_height="40dip"   android:orientation="horizontal"   android:layout_toRightOf="@id/tv_sex_text"   android:layout_alignParentRight="true"   android:layout_alignTop="@id/tv_sex_text"   >   <RadioButton    android:id="@+id/rb_sex_male"    android:layout_width="wrap_content"    android:layout_height="wrap_content"    android:layout_weight="1"    android:text="男"    android:textSize="16sp"  />   <RadioButton android:layout_width="wrap_content"    android:layout_height="wrap_content"    android:text="女"    android:id="@+id/rb_sex_female"    android:layout_weight="1"    android:textSize="16sp">   </RadioButton>  </RadioGroup>  <TextView android:id="@+id/tv_likes_text"   android:layout_width="80dip"   android:layout_height="40dip"   android:gravity="center_vertical|right"   android:layout_below="@id/rg_sex"   android:layout_alignLeft="@id/tv_sex_text"   android:layout_marginRight="5dip"   android:layout_marginBottom="5dip"   android:text="愛好："   android:textSize="16sp"  />  <CheckBox android:id="@+id/box1"   android:layout_width="wrap_content"   android:layout_height="wrap_content"   android:layout_toRightOf="@id/tv_likes_text"   android:layout_below="@+id/rg_sex"   android:text="@string/box1" ></CheckBox>  <CheckBox android:id="@+id/box2"   android:layout_width="wrap_content"   android:layout_height="wrap_content"   android:layout_toRightOf="@+id/box1"   android:layout_below="@+id/rg_sex"   android:text="@string/box2">  </CheckBox>  <CheckBox  android:id="@+id/box3"   android:layout_width="wrap_content"   android:layout_height="wrap_content"   android:layout_toRightOf="@+id/box2"   android:layout_below="@+id/rg_sex"   android:text="@string/box3"  >  </CheckBox>  <TextView android:id="@+id/tv_phone_text"   android:layout_width="80dip"   android:layout_height="40dip"   android:gravity="center_vertical|right"   android:layout_marginRight="5dip"   android:layout_below="@id/tv_likes_text"   android:layout_marginBottom="5dip"   android:textSize="16sp"   android:text="聯系電話："  />  <EditText android:id="@+id/et_phone"   android:layout_width="fill_parent"   android:layout_height="40dip"   android:layout_toRightOf="@id/tv_phone_text"   android:layout_alignParentRight="true"   android:layout_alignTop="@id/tv_phone_text"   android:hint="請輸入手機號"   android:paddingLeft="20dip"   android:inputType="phone"   android:maxLength="11"  />  <TextView android:id="@+id/tv_traindate_text"   android:layout_width="80dip"   android:layout_height="40dip"   android:gravity="center_vertical|right"   android:layout_marginRight="5dip"   android:layout_below="@id/tv_phone_text"   android:layout_marginBottom="5dip"   android:textSize="16sp"   android:text="入學日期"    />  <EditText android:id="@+id/et_traindate"   android:layout_width="fill_parent"   android:layout_height="40dip"   android:layout_toRightOf="@id/tv_traindate_text"   android:layout_alignParentRight="true"   android:layout_alignTop="@id/tv_traindate_text"   android:hint="點擊選擇日期"   android:inputType="date"   android:paddingLeft="20dip"   android:focusable="false"  />  <Button android:id="@+id/btn_save"   android:layout_width="wrap_content"   android:layout_height="wrap_content"   android:text="保存"   android:layout_below="@id/tv_traindate_text"   android:layout_alignRight="@id/rg_sex">  </Button>  <Button android:id="@+id/btn_clear"   android:layout_width="wrap_content"   android:layout_height="wrap_content"   android:text="重置"   android:layout_below="@id/tv_traindate_text"   android:layout_toLeftOf="@id/btn_save"   android:layout_marginRight="10dip">  </Button> </RelativeLayout> </ScrollView>

package com.example.asus.student;import StudentDBHelper.StudentDBHelper;import TableContanst.TableContanst;import android.app.Activity;import android.content.Intent;import android.database.Cursor;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.EditText;import android.widget.LinearLayout;import android.widget.ListView;import android.widget.SimpleCursorAdapter;import android.widget.Toast;public class StudentSearch extends Activity implements OnClickListener { private EditText nameText; private Button button; private Button reButton; private Cursor cursor; private SimpleCursorAdapter adapter; private ListView listView; private StudentDao dao; private Button returnButton; private LinearLayout layout; @Override protected void onCreate(Bundle savedInstanceState) {  super.onCreate(savedInstanceState);  setContentView(R.layout.search);  nameText = (EditText) findViewById(R.id.et_srarch);  layout=(LinearLayout) findViewById(R.id.linersearch);  button = (Button) findViewById(R.id.bn_sure_search);  reButton = (Button) findViewById(R.id.bn_return);  listView = (ListView) findViewById(R.id.searchListView);  returnButton = (Button) findViewById(R.id.return_id);  dao = new StudentDao(new StudentDBHelper(this));  reButton.setOnClickListener(this);  returnButton.setOnClickListener(this);  button.setOnClickListener(this); } @Override public void onClick(View v) {  if (v == button) {   reButton.setVisibility(View.GONE);   button.setVisibility(View.GONE);   nameText.setVisibility(View.GONE);   layout.setVisibility(View.VISIBLE);   String name = nameText.getText().toString();   cursor = dao.findStudent(name);   if (!cursor.moveToFirst()) {    Toast.makeText(this, "沒有所查學員信息！", Toast.LENGTH_SHORT).show();   } else    //如果有所查詢的信息，則將查詢結果顯示出來    adapter = new SimpleCursorAdapter(this, R.layout.find_student_list_item,    cursor, new String[] { TableContanst.StudentColumns.ID,      TableContanst.StudentColumns.NAME,      TableContanst.StudentColumns.AGE,      TableContanst.StudentColumns.SEX,      TableContanst.StudentColumns.LIKES,      TableContanst.StudentColumns.PHONE_NUMBER,      TableContanst.StudentColumns.TRAIN_DATE },      new int[] {        R.id.tv_stu_id,        R.id.tv_stu_name,        R.id.tv_stu_age,        R.id.tv_stu_sex,        R.id.tv_stu_likes,        R.id.tv_stu_phone,        R.id.tv_stu_traindate });   listView.setAdapter(adapter);  }else if(v==reButton|v==returnButton){   finish();  } }}

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical" android:layout_width="fill_parent" android:layout_height="fill_parent" > <EditText  android:id="@+id/et_srarch"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:hint="請輸入學員姓名"  android:inputType="textPersonName" /> <Button  android:id="@+id/bn_sure_search"  android:gravity="center"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:text="確定"   /> <Button  android:id="@+id/bn_return"  android:gravity="center"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:text="返回"   /> <LinearLayout  android:id="@+id/linersearch"  android:orientation="vertical"  android:visibility="gone"  android:layout_width="fill_parent"  android:layout_height="wrap_content">  <TextView   android:layout_width="fill_parent"   android:layout_height="wrap_content"   android:gravity="center"   android:text="ID  姓 名  年 齡  性 別  愛 好  電 話  日 期"   />  <ListView   android:id="@+id/searchListView"   android:layout_weight="1"   android:layout_width="fill_parent"   android:layout_height="wrap_content"   android:gravity="right"/>  <Button   android:id="@+id/return_id"   android:layout_width="fill_parent"   android:layout_height="wrap_content"   android:text="返回"  /> </LinearLayout></LinearLayout>

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="horizontal" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_weight="1" > <TextView android:id="@+id/tv_stu_id"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_weight="1" /> <TextView android:id="@+id/tv_stu_name"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_weight="1" /> <TextView android:id="@+id/tv_stu_age"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_weight="1" /> <TextView android:id="@+id/tv_stu_sex"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_weight="1" /> <TextView android:id="@+id/tv_stu_likes"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_weight="1" /> <TextView android:id="@+id/tv_stu_phone"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_weight="1" /> <TextView android:id="@+id/tv_stu_traindate"  android:layout_width="fill_parent"  android:layout_height="wrap_content"  android:layout_weight="1" /></LinearLayout>

<menu xmlns:android="http://schemas.android.com/apk/res/android" android:layout_height="40dip" android:layout_width="80dip"> <group android:checkableBehavior="single">  <item android:id="@+id/delete" android:title="刪除學員信息" />  <item android:id="@+id/look" android:title="詳細信息" />  <item android:id="@+id/write" android:title="修改學員信息" /> </group></menu>

package com.example.asus.student;import StudentDBHelper.StudentDBHelper;import TableContanst.TableContanst;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import android.content.ContentValues;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.view.View;import android.widget.SimpleCursorAdapter;import android.widget.TextView;import Student.Student;public class StudentDao { private StudentDBHelper dbHelper; private Cursor cursor; public StudentDao(StudentDBHelper dbHelper) {  this.dbHelper = dbHelper; } // 添加一個Student對象數據到數據庫表 public long addStudent(Student s) {  ContentValues values = new ContentValues();  values.put(TableContanst.StudentColumns.NAME, s.getName());  values.put(TableContanst.StudentColumns.AGE, s.getAge());  values.put(TableContanst.StudentColumns.SEX, s.getSex());  values.put(TableContanst.StudentColumns.LIKES, s.getLike());  values.put(TableContanst.StudentColumns.PHONE_NUMBER, s.getPhoneNumber());  values.put(TableContanst.StudentColumns.TRAIN_DATE, s.getTrainDate());  values.put(TableContanst.StudentColumns.MODIFY_TIME, s.getModifyDateTime());  return dbHelper.getWritableDatabase().insert(TableContanst.STUDENT_TABLE, null, values); } // 刪除一個id所對應的數據庫表student的記錄 public int deleteStudentById(long id) {  return dbHelper.getWritableDatabase().delete(TableContanst.STUDENT_TABLE,    TableContanst.StudentColumns.ID + "=?", new String[] { id + "" }); } // 更新一個id所對應數據庫表student的記錄 public int updateStudent(Student s) {  ContentValues values = new ContentValues();  values.put(TableContanst.StudentColumns.NAME, s.getName());  values.put(TableContanst.StudentColumns.AGE, s.getAge());  values.put(TableContanst.StudentColumns.SEX, s.getSex());  values.put(TableContanst.StudentColumns.LIKES, s.getLike());  values.put(TableContanst.StudentColumns.PHONE_NUMBER, s.getPhoneNumber());  values.put(TableContanst.StudentColumns.TRAIN_DATE, s.getTrainDate());  values.put(TableContanst.StudentColumns.MODIFY_TIME, s.getModifyDateTime());  return dbHelper.getWritableDatabase().update(TableContanst.STUDENT_TABLE, values,    TableContanst.StudentColumns.ID + "=?", new String[] { s.getId() + "" }); } // 查詢所有的記錄 public List<Map<String,Object>> getAllStudents() {  //modify_time desc  List<Map<String, Object>> data = new ArrayList<Map<String,Object>>();  Cursor cursor = dbHelper.getWritableDatabase().query(TableContanst.STUDENT_TABLE, null, null, null,    null, null, TableContanst.StudentColumns.MODIFY_TIME+" desc");  while(cursor.moveToNext()) {   Map<String, Object> map = new HashMap<String, Object>(8);   long id = cursor.getInt(cursor.getColumnIndex(TableContanst.StudentColumns.ID));   map.put(TableContanst.StudentColumns.ID, id);   String name = cursor.getString(cursor.getColumnIndex(TableContanst.StudentColumns.NAME));   map.put(TableContanst.StudentColumns.NAME, name);   int age = cursor.getInt(cursor.getColumnIndex(TableContanst.StudentColumns.AGE));   map.put(TableContanst.StudentColumns.AGE, age);   String sex = cursor.getString(cursor.getColumnIndex(TableContanst.StudentColumns.SEX));   map.put(TableContanst.StudentColumns.SEX, sex);   String likes = cursor.getString(cursor.getColumnIndex(TableContanst.StudentColumns.LIKES));   map.put(TableContanst.StudentColumns.LIKES, likes);   String phone_number = cursor.getString(cursor.getColumnIndex(TableContanst.StudentColumns.PHONE_NUMBER));   map.put(TableContanst.StudentColumns.PHONE_NUMBER, phone_number);   String train_date = cursor.getString(cursor.getColumnIndex(TableContanst.StudentColumns.TRAIN_DATE));   map.put(TableContanst.StudentColumns.TRAIN_DATE, train_date);   String modify_time = cursor.getString(cursor.getColumnIndex(TableContanst.StudentColumns.MODIFY_TIME));   map.put(TableContanst.StudentColumns.MODIFY_TIME, modify_time);   data.add(map);  }  return data; } //模糊查詢一條記錄 public Cursor findStudent(String name){  Cursor cursor = dbHelper.getWritableDatabase().query(TableContanst.STUDENT_TABLE, null, "name like ?",    new String[] { "%" + name + "%" }, null, null, null,null);  return cursor;  } //按姓名進行排序 public Cursor sortByName(){  Cursor cursor = dbHelper.getWritableDatabase().query(TableContanst.STUDENT_TABLE, null,null,    null, null, null,TableContanst.StudentColumns.NAME);  return cursor;  } //按入學日期進行排序 public Cursor sortByTrainDate(){  Cursor cursor = dbHelper.getWritableDatabase().query(TableContanst.STUDENT_TABLE, null,null,    null, null, null,TableContanst.StudentColumns.TRAIN_DATE);  return cursor; } //按學號進行排序 public Cursor sortByID(){  Cursor cursor = dbHelper.getWritableDatabase().query(TableContanst.STUDENT_TABLE, null,null,    null, null, null,TableContanst.StudentColumns.ID);  return cursor; } public void closeDB() {  dbHelper.close();  } //自定義的方法通過View和Id得到一個student對象 public Student getStudentFromView(View view, long id) {  TextView nameView = (TextView) view.findViewById(R.id.tv_stu_name);  TextView ageView = (TextView) view.findViewById(R.id.tv_stu_age);  TextView sexView = (TextView) view.findViewById(R.id.tv_stu_sex);  TextView likeView = (TextView) view.findViewById(R.id.tv_stu_likes);  TextView phoneView = (TextView) view.findViewById(R.id.tv_stu_phone);  TextView dataView = (TextView) view.findViewById(R.id.tv_stu_traindate);  String name = nameView.getText().toString();  int age = Integer.parseInt(ageView.getText().toString());  String sex = sexView.getText().toString();  String like = likeView.getText().toString();  String phone = phoneView.getText().toString();  String data = dataView.getText().toString();  Student student = new Student(id, name, age, sex, like, phone, data,null);  return    student; }}

package StudentDBHelper;import TableContanst.TableContanst;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteDatabase.CursorFactory;import android.database.sqlite.SQLiteOpenHelper;import android.util.Log;public class StudentDBHelper extends SQLiteOpenHelper { private static final String TAG = "StudentDBHelper"; public static final String DB_NAME = "student_manager.db"; public static final int VERSION = 1; //構造方法 public StudentDBHelper(Context context, String name, CursorFactory factory, int version) {  super(context, name, factory, version); } public StudentDBHelper(Context context) {  this(context, DB_NAME, null, VERSION);  } //創(chuàng)建數據庫 @Override public void onCreate(SQLiteDatabase db) {  Log.v(TAG, "onCreate");  db.execSQL("create table "    + TableContanst.STUDENT_TABLE     + "(_id Integer primary key AUTOINCREMENT,"    + "name char,age integer, sex char, likes char, phone_number char,train_date date, "    + "modify_time DATETIME)");  } //更新數據庫 @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {  Log.v(TAG, "onUpgrade"); }}

package Student;import java.io.Serializable;import android.view.View;import android.widget.TextView;public class Student implements Serializable{ private long id; private String name; private int age; private String sex; private String like; private String phoneNumber; private String trainDate; private String modifyDateTime; public Student() {  super(); } public Student(long id, String name, int age, String sex, String like, String phoneNumber,     String trainDate, String modifyDateTime) {  super();  this.id = id;  this.name = name;  this.age = age;  this.sex = sex;  this.like = like;  this.phoneNumber = phoneNumber;  this.trainDate = trainDate;  this.modifyDateTime = modifyDateTime; } public Student(String name, int age, String sex, String like, String phoneNumber,     String trainDate, String modifyDateTime) {  super();  this.name = name;  this.age = age;  this.sex = sex;  this.like = like;  this.phoneNumber = phoneNumber;  this.trainDate = trainDate;  this.modifyDateTime = modifyDateTime; } public long getId() {  return id; } public void setId(long id) {  this.id = id; } public String getName() {  return name; } public void setName(String name) {  this.name = name; } public int getAge() {  return age; } public void setAge(int age) {  this.age = age; } public String getSex() {  return sex;  } public void setSex(String sex) {  this.sex = sex; } public String getLike() {  return like; } public void setLike(String like) {  this.like = like; } public String getPhoneNumber() {  return phoneNumber; } public void setPhoneNumber(String phoneNumber) {  this.phoneNumber = phoneNumber;  } public String getTrainDate() {  return trainDate; } public void setTrainDate(String trainDate) {  this.trainDate = trainDate; } public String getModifyDateTime() {  return modifyDateTime; } public void setModifyDateTime(String modifyDateTime) {  this.modifyDateTime = modifyDateTime; }}

package TableContanst;public final class TableContanst { public static final String STUDENT_TABLE = "student"; public static final class StudentColumns {  public static final String ID = "_id";  public static final String NAME = "name";  public static final String AGE = "age";  public static final String SEX = "sex";  public static final String LIKES = "likes";  public static final String PHONE_NUMBER = "phone_number";  public static final String TRAIN_DATE = "train_date";  public static final String MODIFY_TIME = "modify_time"; }}

<?xml version="1.0" encoding="utf-8"?><resources> <color name="colorPrimary">#3F51B5</color> <color name="colorPrimaryDark">#303F9F</color> <color name="colorAccent">#EE82EE</color></resources>

<?xml version="1.0" encoding="utf-8"?><resources> <string name="hello">Hello World, TextStudentManager!</string> <string name="app_name">學員管理系統</string> <string name="information_write">學員信息修改</string> <string name="button1">男</string> <string name="button2">女</string> <string name="box1">唱歌</string> <string name="box2">跳舞</string> <string name="box3">健身</string> <string name="myButton">添加學員信息</string> <string name="spinner">請選擇</string></resources>

<resources> <!-- Base application theme. --> <style name="AppTheme" parent="Theme.AppCompat.Light.DarkActionBar">  <!-- Customize your theme here. -->  <item name="colorPrimary">@color/colorPrimary</item>  <item name="colorPrimaryDark">@color/colorPrimaryDark</item>  <item name="colorAccent">@color/colorAccent</item> </style></resources>

<?xml version="1.0" encoding="utf-8"?><manifest xmlns:android="http://schemas.android.com/apk/res/android" package="com.example.asus.student"> <application  android:allowBackup="true"  android:icon="@mipmap/ic_launcher"  android:label="@string/app_name"  android:roundIcon="@mipmap/ic_launcher_round"  android:supportsRtl="true"  android:theme="@style/AppTheme">  <activity android:name=".StudentListActivity">   <intent-filter>    <action android:name="android.intent.action.MAIN" />    <category android:name="android.intent.category.LAUNCHER" />   </intent-filter>  </activity>  <activity android:name=".AddStudentActivity">  </activity>  <activity android:name=".ShowStudentActivity">  </activity>  <activity android:name=".StudentSearch">  </activity> </application></manifest>