创建数据库和表
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;
}
}