Android学习笔记6：SQLite使用方法

public class MyHelper extends SQLiteOpenHelper {
	private static String name = "myDb.db";
	private static int version = 1;
	public MyHelper(Context context) {
		super(context, name, null, version);
		// TODO Auto-generated constructor stub
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		db.execSQL("CREATE TABLE person(id integer primary key autoincrement,name varchar(32),tel varchar(32))");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub

	}

}

public class PersonService {
	private static Context context;
	
	public PersonService(Context context) {
		super();
		this.context = context;
		
	}

	public  void addPerson(Object[] params){
		MyHelper helper = new MyHelper(context);
		SQLiteDatabase db = helper.getWritableDatabase();
		String sql = "insert into person(name,tel) values(?,?)";
		db.execSQL(sql,params);
		db.close();
	}
	public void updatePerson(Object[] params){
		MyHelper helper = new MyHelper(context);
		SQLiteDatabase db = helper.getWritableDatabase();
		String sql = "update person set tel=? where id=?";
		db.execSQL(sql, params);
		db.close();
	} 
	public void deletePerson(Object[] params){
		MyHelper helper = new MyHelper(context);
		SQLiteDatabase db = helper.getWritableDatabase();
		String sql = "delete from person where id=?";
		db.execSQL(sql, params);
		db.close();
	}
	public Map<String,Object> viewPerson(String[] params){
		MyHelper helper = new MyHelper(context);
		SQLiteDatabase db = helper.getReadableDatabase();
		Map<String,Object> map = new HashMap<String, Object>();
		String sql = "select * from person where id=?";
		Cursor cursor = db.rawQuery(sql, params);
		while(cursor.moveToNext()){
			String name = cursor.getString(cursor.getColumnIndex("name"));
			String tel = cursor.getString(cursor.getColumnIndex("tel"));
			map.put("name", name);
			map.put("tel", tel);
		}
		db.close();
		return map;
	} 
}