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;

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