接下来根据创建帮助类写业务逻辑方法
public class PersonDao { private PersonDBHelper personDBHelper; //源码-使用字段生成构造函数 public PersonDao(PersonDBHelper personDBHelper) { super(); this.personDBHelper = personDBHelper; } public boolean GetList(String username){ SQLiteDatabase db =personDBHelper.getReadableDatabase(); if(db.isOpen()){ Cursor reader =db.rawQuery("select * from userInfo where username=?", new String []{username});//参数化查询 if(reader.moveToNext()){ return true; } reader.close(); db.close(); } return false; } public boolean Insert(Person model ){ Object [] parms =new Object[]{model.getUsername(),model.getTelphone(),model.getCreatedate()}; SQLiteDatabase db =personDBHelper.getReadableDatabase(); if(db.isOpen()){ db.execSQL("insert into userInfo(username,telphone,createdate) values(?,?,?)", parms); db.close(); return true; } return false; } } |
然后用Android下的单元测试测试PersonDao类的方法
public class testPersonDao extends AndroidTestCase {
public void testAdd(){
Person person =new Person();
person.setUsername("黄忠");
person.setTelphone("15110041588");
person.setRemark("我要飞的更高");
person.setCreatedate(new Date());
PersonDBHelper personDBHelper =new PersonDBHelper(getContext(), "person.db", null, 1);
PersonDao dao =new PersonDao(personDBHelper);
boolean res =dao.Insert(person);
assertEquals(true, res);
}
}