Android in-depth study of SQLite instances (7)

Package EOE. demo; import Java. util. list; import it. bean. person; import it. service. personservice; import android. test. androidtestcase; import android. util. log;/***** run the personservice test **/public class personservicetest extends androidtestcase {Private Static final string tag = "personservicetest"; Public void testsave () throws exception {personservice = new personservice (this. getcontext (); For (INT I = 0; I <10; I ++) {personservice. save (new person ("huhuanhuan", (short) 33) ;}} public void testfindbyid () {personservice = new personservice (this. getcontext (); person P = personservice. findbyid (1); log. I (TAG, P. tostring ();} public void testupdate () {person = new person (1, "Chun", (short) 20); personservice = new personservice (this. getcontext (); personservice. update (person); person P = personservice. findbyid (1); log. I (TAG, P. tostring ();} public void testgetdateperson () {person P = new person (); personservice = new personservice (this. getcontext (); List list = personservice. getdateperson (0, 10); For (INT I = 0; I <p> P = (person) list. get (I); log. I (TAG, P. tostring () ;}} public void testgetcount () {personservice = new personservice (this. getcontext (); long l = personservice. getcount (); log. I (TAG, String. valueof (l);} public void testdelete () {personservice = new personservice (this. getcontext (); personservice. delete (1, 2, 3 );}}

Test code

Package EOE. demo; import Java. util. list; import it. bean. person; import it. service. personsqlservice; import android. test. androidtestcase; import android. util. log;/*** run personsqlservice for testing **/public class personsqlservicetest extends androidtestcase {Private Static final string tag = "personsqlservicetest"; Public void testsave () {personsqlservice Psql = new personsqlservice (this. getcontext (); For (INT I = 0; I <10; I ++) {Psql. save (new person ("Li Yuan", (short) 1) ;}} public void testfind () throws exception {personsqlservice Psql = new personsqlservice (this. getcontext (); person = Psql. find (22); log. I (TAG, person. tostring ();} public void testupdate () throws exception {personsqlservice Psql = new personsqlservice (this. getcontext (); person = Psql. find (1); person. setname ("liming"); Psql. update (person); // log. I (TAG, person. tostring ();} public void testgetcount () throws exception {personsqlservice Psql = new personsqlservice (this. getcontext (); log. I (TAG, String. valueof (Psql. getcount ();} public void testgetscrolldata () throws exception {personsqlservice Psql = new personsqlservice (this. getcontext (); list persons = Psql. getscrolldata (0, 20); For (person: Persons) {log. I (TAG, person. tostring () ;}} public void testdelete () throws exception {personsqlservice Psql = new personsqlservice (this. getcontext (); Psql. delete (1, 2, 3 );}}