2023年7月7日发(作者：)

d简易课程表⾸先构建⼀个DbHelper继承SQLiteOpenHelper

8293637383946474849565758package ;

import tValues;import t;import ;import Database;import OpenHelper;

public class DbHelper extends SQLiteOpenHelper { private static final String table="course"; private static final String DbName= "Mycourse";

@Override //把七天的课程都线性放在⼀个表内 public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub L("create table course(_id integer primary key autoincrement,num text,name text,place text);"); } //upgrade的机理还不是很熟，没写 @Override public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) { // TODO Auto-generated method stub } public DbHelper(Context context) { super(context,DbName, null, 1); // TODO Auto-generated constructor stub } //初始化这个表 public void initial() { SQLiteDatabase db=tableDatabase(); CourseData emptydata=new CourseData(); for(int i=0;i<56;i++)

{ String num = null; int temp=i%8; switch(temp) { case 0: num="第⼀节"; break; case 1: num="第⼆节"; break; case 2: num="第三节"; break; case 3: num="第四节"; break; case 4: num="第五节"; break; case 5: num="第六节"; break; case 6: num="第七节"; break; case 7: num="第⼋节"; break; }

insert(num); } } //给mainactivity返回cursor,cursor查阅部分即为每天的那部分

public Cursor select(int weekday) { SQLiteDatabase db=tableDatabase(); int up=8,down=1; up+=weekday*8; down+=weekday*8;5966676869767778798687888996979899104105 String c_up=f(up),c_down=f(down); String where="_id<=? and _id>=?"; String[] wherevalue={c_up,c_down};

Cursor cursor=("course",null, where,wherevalue, null, null,null); return cursor;

}

public long insert(String num) { SQLiteDatabase db=tableDatabase(); ContentValues cv=new ContentValues(); ("num",num); long rowid=(table, null, cv); return rowid;

} //本例中没⽤到delete,可有可⽆

public void delete(CourseData data) { SQLiteDatabase db=tableDatabase(); String where="name=?"; String[] wherevalue={e()}; (table, where, wherevalue);

} //课程的修改通过upgrade进⾏ public void upgrade(int _id,String name,String place) { SQLiteDatabase db=tableDatabase(); String c_id=f(_id); ContentValues cv=new ContentValues(); String where="_id=?"; String[] wherevalue={c_id}; ("name",name); ("place",place); (table,cv, where, wherevalue);

}

}我们的核⼼activity部分LOG了很久，终于调试好了1112package ;

import ty;import ialog;import Interface;import kListener;import Preferences;import ;79363738394647484956575859666768697677import ;import ;import Cursor;import ;import enceManager;import ;import ;import ;import rView;import ClickListener;import SelectedListener;import dapter;import xt;import ew;import CursorAdapter;import r;import ew;

import Data;import er;

public class MainActivity extends Activity { private static final String TAG = "MainActivity"; private ListView lv; private Cursor[] cursor={null,null,null,null,null,null,null}; private SimpleCursorAdapter scAdapter; private DbHelper myDbHelper; private Spinner spinner; private int _id; private int weekday=0; private String tmp_name,tmp_place; private TextView tv;

@Override public void onCreate(Bundle savedInstanceState) { te(savedInstanceState); setContentView(ty_main);

lv=(ListView)findViewById();

myDbHelper=new DbHelper(this); SharedPreferences prefs = aultSharedPreferences(this); boolean firstTime = lean("first_time", true); if (firstTime){ Editor pEdit = (); lean("first_time", false); (); l(); } for(int i=0;i<7;i++) cursor[i]=(i); spinner=(Spinner)findViewById(r); tv=(TextView)findViewById(ew);

scAdapter=new SimpleCursorAdapter (this, ew,cursor[weekday],new String[]{"num","name","place"}, new int[]{,,});

pter(scAdapter); Log.i(TAG, "Adapter OK");

temClickListener(new OnItemClickListener() {

public void onItemClick(AdapterView arg0, View arg1, int arg2, long arg3) {777879868788899697989959759140141142 long arg3) { // TODO Auto-generated method stub Log.i(TAG, "CLICK1"); cursor[weekday].moveToPosition(arg2); _id=cursor[weekday].getInt(0); Log.i("MainActivity",f(_id)+" "+f(arg2)); View view=e(,, null); TextView tv=(TextView)ewById(); final EditText et1=(EditText)ewById(1); final EditText et2=(EditText)ewById(2);

r builder=new r(); le("请修改课程") .setIcon(_dialog_info) .setView(view) .setPositiveButton("确定",new OnClickListener() {

public void onClick(DialogInterface dialog, int which) { // TODO Auto-generated method stub tmp_name=t().toString(); tmp_place=t().toString(); //Log.i("MainActivity",tmp_name+" "+tmp_place); edit(_id,tmp_name,tmp_place); DataSetChanged();

pter(scAdapter);

} } ) .setNegativeButton("取消", null) .show();

} });

ArrayAdapter spinner_adapter=new ArrayAdapter (this,_spinner_item); spinner_pDownViewResource(_spinner_dropdown_item); spinner_("星期⼀"); spinner_("星期⼆"); spinner_("星期三"); spinner_("星期四"); spinner_("星期五"); spinner_("星期六"); spinner_("星期⽇");

pter(spinner_adapter); temSelectedListener(new OnItemSelectedListener() {

public void onItemSelected(AdapterView arg0, View arg1, int arg2, long arg3) { // TODO Auto-generated method stub Spinner spinner = (Spinner)arg0; String day=null; Log.i("MainActivity",f(weekday=(int) ectedItemId())); switch(weekday) {

case 0: day="星期⼀"; break; case 1: day="星期⼆"; break; case 2: day="星期三"; break; case 3: day="星期四"; break; scAdapter=new SimpleCursorAdapter(, ew,cursor[weekday], new String[]{"num","name","place"}, new int[]{,5975975971981992 case 3: day="星期四"; break; case 4: day="星期五"; break; case 5: day="星期六"; break; case 6: day="星期⽇"; break; }

t(day); DataSetChanged(); pter(scAdapter); }

public void onNothingSelected(AdapterView arg0) { // TODO Auto-generated method stub

} });

temSelectedListener(new OnItemSelectedListener() {

public void onItemSelected(AdapterView arg0, View arg1, int arg2, long arg3) {

cursor[weekday].moveToPosition(arg2); Log.i("index",f(cursor[weekday].getInt(0))); // TODO Auto-generated method stub SQLiteCursor sc=(SQLiteCursor)ectedItem(); _id=(0); Log.i("MainActivity",f(_id));

}

public void onNothingSelected(AdapterView arg0) { // TODO Auto-generated method stub

} }); }

private void edit(int _id,String name,String place) { if (name=="") return;

e(_id,name,place); cursor[weekday].requery(); dateViews(); _id=0;

}

private void delete(String name,int time) { if (name=="") return; CourseData data=new CourseData(); e(name); (data); cursor[weekday].requery(); dateViews(); _id=0; }

@Override scAdapter=new SimpleCursorAdapter(, ew,cursor[weekday], new String[]{"num","name","place"}, new int[]{,211212213 @Override public boolean onCreateOptionsMenu(Menu menu) { getMenuInflater().inflate(ty_main, menu); return true;

}}