android的数据库API操作
16lz
2021-01-23
importcom.liudw.sql.MySqlHelp;importandroid.content.ContentValues;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;importandroid.test.AndroidTestCase;/***android的单元测试框架*@authorAdministrator**/publicclassTestCaseextendsAndroidTestCase{privateMySqlHelpmsl;privateSQLiteDatabasedb;//启动测试前,先初始化数据库protectedvoidsetUp()throwsException{//TODOAuto-generatedmethodstubsuper.setUp();msl=newMySqlHelp(getContext(),"liudw.db",null,1);//创建数据库db=msl.getReadableDatabase();}//启动测试后,关闭数据库连接@OverrideprotectedvoidtearDown()throwsException{//TODOAuto-generatedmethodstubsuper.tearDown();msl.close();db.close();}publicvoidtest01(){System.out.println("测试框架已经搭建好了");StringBuffersb=newStringBuffer();sb.append("createtableperson(_idintegerprimarykeyautoincrement,namechar(10),agechar(10),addresschar(10))");db.execSQL(sb.toString());}publicvoidinsertSQL(){for(inti=0;i<50;i++){ContentValuesvalues=newContentValues();values.put("name","喀喀喀"+i);values.put("age",22+i);values.put("address","撒旦撒旦撒旦"+i);db.insert("person",null,values);}}publicvoidupdateSQL(){ContentValuesvalues=newContentValues();values.put("name","喀喀喀");values.put("age",22);values.put("address","撒旦撒旦撒旦");db.update("person",values,"name=?andage=?",newString[]{"name","age"});}publicvoiddeleteSQL(){db.delete("person","name=?andage=?",newString[]{"name","age"});}publicvoidselectSQL(){Cursorcursor=db.query("person",null,null,null,null,null,null,null);while(cursor.moveToNext()){Stringname=cursor.getString(cursor.getColumnIndex("name"));}}}
更多相关文章
- xpose框架使用android studio
- Android的GLSurfaceView测试源码
- android 网络请求框架
- Android多点触摸测试类
- Android:Ping命令测试网络
- Android常用的第三方开源库和框架
- android wifi框架
- Android系统框架基础
- Adnroid单元测试