数据库

MainActivity读取 和 添加

private void add() {
// TODO Auto-generated method stub
myhelper = new Myhelper(MainActivity.this);
database = myhelper.getWritableDatabase();
Cursor cursor = database.rawQuery(“select * from news”, null);
if (!cursor.moveToNext()) {
for (int i = 0; i < list.size(); i++) {
database.execSQL(“insert into news(id,title) values(?,?)”,
new String[]{list.get(i).getId()+"",list.get(i).getTitle()});
}
}
// Log.i(“aaa”, list.toString());

}

private void readparse() {
	// TODO Auto-generated method stub
	try {
		String path=Environment.getExternalStorageDirectory()+"/news.json";
		FileInputStream fileInputStream=new FileInputStream(path);
		InputStreamReader reader = new InputStreamReader(fileInputStream, "utf-8");
		BufferedReader r=new BufferedReader(reader);
		StringBuilder builder=new StringBuilder();
		String str="";
		while ((str=r.readLine())!=null) {
			builder.append(str);
		}
		Gson gson=new Gson();
		Newsbean newsbean = gson.fromJson(builder.toString(), Newsbean.class);

// Log.i(“aaa”, newsbean.toString());
list = newsbean.getData().getPc_feed_focus();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

Fragment1里 查询 删除

@Override
public void onActivityCreated(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onActivityCreated(savedInstanceState);
parse();
adapter = new MyAdapter(getActivity(), list);
list_view.setAdapter(adapter);
list_view.setOnItemClickListener(new OnItemClickListener() {

		@Override
		public void onItemClick(AdapterView<?> parent, View view,
				int position, long id) {
			// TODO Auto-generated method stub
			Intent intent=new Intent(getActivity(), WebActivity.class);
			startActivity(intent);
		}
	});
	list_view.setOnItemLongClickListener(new OnItemLongClickListener() {

		@Override
		public boolean onItemLongClick(AdapterView<?> parent, View view,
				int position, long id) {
			// TODO Auto-generated method stub
			database.execSQL("delete from news where title=?", new String[]{
					list.get(position).getTitle()
			});
			list.remove(position);
			adapter.notifyDataSetChanged();
			return true;
		}
	});
}
private void parse() {
	list = new ArrayList<pc_feed_focus>();
	myhelper = new Myhelper(getActivity());
	database = myhelper.getWritableDatabase();
	Cursor cursor = database.rawQuery("select * from news", null);
	while (cursor.moveToNext()) {
		int id = cursor.getInt(cursor.getColumnIndex("id"));
		String title = cursor.getString(cursor.getColumnIndex("title"));
		list.add(new pc_feed_focus(id, title));
	}
}

}

Myhelper

public class Myhelper extends SQLiteOpenHelper {

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

@Override
public void onCreate(SQLiteDatabase db) {
	// TODO Auto-generated method stub
	db.execSQL("create table news(id integer primary key autoincrement,title varchar(100))");
}

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

}

}