sql语句

//增加的方法
public void add(my m){
    SQLiteDatabase sb = s.getWritableDatabase();
sb.execSQL("insert into myt values(null,?,?)",new String[]{m.getName(),m.getPwd()});
}
//删除的方法
public void del(int idd){
SQLiteDatabase sb = s.getWritableDatabase();
sb.execSQL("delete from myt where id=?",new Object[]{idd});


}
//查询的方法
public List<my> query(){
SQLiteDatabase sb = s.getWritableDatabase();
 
List<my>list=new ArrayList<my>();
Cursor cu = sb.rawQuery("select *from myt",null);
while(cu.moveToNext()){
my m=new my(cu.getInt(0), cu.getString(1),cu.getString(2));
list.add(m);
}

return list;




}