- publicclassmyDatabase{
-
- staticfinalStringUSERID="_id";
- staticfinalStringPASSWORD="password";
- staticfinalStringEMAIL="email";
- staticfinalStringQQ="qq";
- staticfinalStringCAREER="career";
- staticfinalStringDB_NAME="myDatabase1";
- staticfinalStringDB_TABLE="imfor";
- privatestaticfinalintVERSION=1;
- privateContextmContext;
- SQLiteDatabasemySQLite;
-
- privatestaticStringDB_CREATE="CREATETABLE" +DB_TABLE+"(" +USERID+"INTEGERPRIMARYKEY,"
- +PASSWORD+"TEXT,"
- +EMAIL+"TEXT,"
- +QQ+"TEXT,"
- +CAREER+"TEXT)";
-
- privatestaticclassMyHelperextendsSQLiteOpenHelper{
- publicMyHelper(Contextcontext){
- super(context,DB_NAME,null,VERSION);
- }
- @Override
- publicvoidonCreate(SQLiteDatabasedb){
- db.execSQL(DB_CREATE);
- }
- @Override
- publicvoidonUpgrade(SQLiteDatabasedb,intoldVersion,intnewVersion){
-
- }
-
- }
-
- publicmyDatabase(Contextcontext){
- mContext=context;
- }
- publicvoidopenDatabase(){
- MyHelpermyhelper=newMyHelper(mContext);
- //这时创建或打开数据库,如果数据库是新创建的则激活SQLiteOpenHelper对象的的onCreate()方法
- mySQLite=myhelper.getWritableDatabase();
- }
- publiclonginsert(intid,Stringpassword,Stringemail,Stringqq,Stringcareer){
- ContentValuescv=newContentValues();
- cv.put(USERID,id);
- cv.put(PASSWORD,password);
- cv.put(EMAIL,email);
- cv.put(QQ,qq);
- cv.put(CAREER,career);
- returnmySQLite.insert(DB_TABLE,"null",cv);
- }
- publicCursorfetchData(intid){
-
- returnmySQLite.query(DB_TABLE,newString[]{USERID,PASSWORD,EMAIL,QQ,CAREER},USERID+"="+id,null,null,null,null);
- }
- }
|