SuishenJi项目_SQLite数据库

public class DbOpenHelper extends SQLiteOpenHelper {

创建库

public DbOpenHelper(Context context, String name, CursorFactory factory,int version) {super(context, DBuserName, factory, i);// TODO Auto-generated constructor stub}

/** 创建表 */</span>

@Overridepublic void onCreate(SQLiteDatabase arg0) {// TODO Auto-generated method stubarg0.execSQL("create table JiShiBo(id integer primary key autoincrement,textname varchar(10), textread )");}

public class UserService {
        public DbOpenHelper dbopenhelper;

	public UserService(Context context) {

		dbopenhelper = new DbOpenHelper(context, null, null, 1);

	}

// 插入数据库操作
	public long insterinfo_1(jishiboBean bean) {
		SQLiteDatabase db = dbopenhelper.getWritableDatabase();
		ContentValues cv = new ContentValues();
		cv.put(jishibo_name, bean.getTextname());
		cv.put(jishibo_text, bean.getTextread());
		long l = db.insert(JiShiBoName, null, cv);
		db.close();
		return l;

	}

	public long insterinfo2(myzhangdanBean bean) {
		SQLiteDatabase db = dbopenhelper.getWritableDatabase();
		ContentValues cv = new ContentValues();
		cv.put("imageID", bean.getImageID());
		cv.put("number", bean.getNumber());
		cv.put("type", bean.getType());
		cv.put("typename", bean.getTypename());
		cv.put("zhanhu", bean.getZhanghu());

		long l = db.insert("MyZhangDanName", null, cv);
		db.close();
		return l;
	}

	public long insterinfo3(myzhanghuBean bean) {
		SQLiteDatabase db = dbopenhelper.getWritableDatabase();
		ContentValues cv = new ContentValues();
		cv.put("zhanghu1", bean.getText1());
		cv.put("zhanghu2", bean.getText2());
		cv.put("zhanghu3", bean.getText3());
		cv.put("zhanghu4", bean.getText4());

		long l = db.insert("MyZhangDanName", null, cv);
		return l;
	}

	/** 查询数据库操作 */

	public List<jishiboBean> findall_1() {

		SQLiteDatabase db = dbopenhelper.getWritableDatabase();
		List<jishiboBean> list = new ArrayList<jishiboBean>();

		// Cursor 是每行的集合
		coursor = db
				.query(JiShiBoName, null, null, null, null, null, "id desc");
		while (coursor.moveToNext()) {
			String textname = coursor.getString(coursor
					.getColumnIndex(jishibo_name));
			String textread = coursor.getString(coursor
					.getColumnIndex(jishibo_text));
			String id = coursor.getString(coursor.getColumnIndex("id"));

			jishiboBean bean = new jishiboBean();
			bean.setId(id);
			bean.setTextname(textname);
			bean.setTextread(textread);
			list.add(bean);

		}
		db.close();
		return list;

	}

	/* 查询单个数据的方法* */
	public jishiboBean fin(String name) {
		SQLiteDatabase db = dbopenhelper.getReadableDatabase();
		jishiboBean bean =null;
		Cursor cousor = db.query(JiShiBoName,
				new String[] { "id", "textread" }, "textname= ?",new String[] { name }, null, null, null);

		if (coursor.moveToFirst()) {
			bean = new jishiboBean();
			String id = coursor.getString(coursor.getColumnIndex("id"));
			String textread = coursor.getString(coursor
					.getColumnIndex("textread"));
			bean.setId(id);
			bean.setTextread(textread);
		}
		db.close();

		return bean;

	}
	
	/**删除单个信息的方法*/
	
	public long delete(String name){
		
		SQLiteDatabase db = dbopenhelper.getReadableDatabase();
	
		
		long l=db.delete(JiShiBoName, "textname= ?", new String[]{name} );
		db.close();
		return l;
		
	}

	public myzhanghuBean findall_2() {

		return null;
	}

}

插入数据库
bean = new jishiboBean();
			String textname=jishibo_addtext_name.getText().toString().trim();
			String textread=jishibo_addtext_read.getText().toString().trim();
			
				bean.setTextname(textname);
			
				if(textread.contains(str)){
					return;
				}else{
					bean.setTextread(str+" "+textread);
				
			}
			
			long l = service.insterinfo_1(bean);
			if (l > 0) {
				Toast.makeText(add_jishiboActivity.this, "新建成功", 1000).show();
			} else {
				Toast.makeText(add_jishiboActivity.this, "新建失败", 1000).show();
			}
			break;

查询数据库
@Override
	public void onStart() {
		// TODO Auto-generated method stub
		super.onStart();
		list = service.findall_1();
		
		adapter = new jishibo_Adapter(list, getActivity());
		jishibo_listview.setAdapter(adapter);
	}