2.Android简易课程表

首先构建一个DbHelper继承SQLiteOpenHelper

 

package com.example.helper;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

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
		db.execSQL("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=this.getWritableDatabase();
		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=this.getWritableDatabase();
		int up=8,down=1;
		up+=weekday*8; down+=weekday*8;
		String c_up=String.valueOf(up),c_down=String.valueOf(down);
		String where="_id<=? and _id>=?";
		String[] wherevalue={c_up,c_down};
		
		Cursor cursor=db.query("course",null, where,wherevalue, null,