数据库的使用

创建数据库和表

package db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class MHelper extends SQLiteOpenHelper{

	public MHelper(Context context) {
		super(context,"bw.db",null, 1);
		// TODO Auto-generated constructor stub
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		//创建表
		db.execSQL("create table yd_paths (id integer primary key autoincrement,content text,title text)");
		
	}

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

}

package db;

import java.util.ArrayList;

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

public class WebDao {
   private SQLiteDatabase database;
   private MHelper helper;
   private ArrayList<WebBean> list;
public WebDao(Context context) {
	//获得数据库帮助
	helper=new MHelper(context);
	//帮助类对象
	database=helper.getReadableDatabase();
	
}
public void add(String content,String title) {
	database.execSQL("insert into yd_paths(content,title) values(?,?)",new Object[]{content,title});
	
	
}
public ArrayList<WebBean> query() {
	Cursor cursor=database.rawQuery("select * from yd_paths", null);
	list=new ArrayList<WebBean>();
	while(cursor.moveToNext()){
		String content=cursor.getString(cursor.getColumnIndex("content"));
		String title=cursor.getString(cursor.getColumnIndex("title"));
		list.add(new WebBean(content, title));
		
	}
	return list;
	
	
	
}
public void del(String title) {
	database.execSQL("delete from yd_paths where title=?",new Object[]{title});
	
	
}
public void upd(String content,String title) {
	database.execSQL("update yd_paths set content=? where title=?",new Object[]{content,title});
	
	
} 
}

开始增删改查

@Override
	public void onClick(View v) {
		switch (v.getId()) {
		case R.id.add://添加
			dao.add("123", "搜狐");
			list=dao.query();
			ma.notifyDataSetChanged();
			Toast.makeText(getActivity(),"添加成功",0).show();
			break;
		case R.id.del://删除
			dao.del("搜狐");
			list=dao.query();
			ma.notifyDataSetChanged();
			Toast.makeText(getActivity(),"删除成功",0).show();
			break;
		case R.id.upd://修改
			dao.upd("000","搜狐");		
			list=dao.query();
			ma.notifyDataSetChanged();
			Toast.makeText(getActivity(),"修改成功",0).show();
			break;
		case R.id.cha://查询
			
			list=dao.query();
			Toast.makeText(getActivity(),"查询成功",0).show();
			for (int i = 0; i < list.size(); i++) {
				Log.e("查询",list.get(i).toString());
			}
			ma.notifyDataSetChanged();
			break;
		default:
			break;
		}
		
	}