android数据库增删改查操作

//定义一个类

public class Mysqlite extends SQLiteOpenHelper {

    public Mysqlite(Context context) {
        //参数2 数据库名字
        super(context, "nihao.db", null, 1);
    }

    //创建表  数字必须用integer
    @Override
    public void onCreate(SQLiteDatabase db) {
     db.execSQL("create table user(name varchar(40))");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

//DAO层执行增删改查操作

public class Mydao {
    //定义创建库和表的类
    private  Mysqlite mysqlite;

    public Mydao(Context context) {
        mysqlite = new Mysqlite(context);
    }

     public  void addsql(String s){

         SQLiteDatabase writableDatabase = mysqlite.getWritableDatabase();
         ContentValues cv=new ContentValues();
         cv.put("name",s);

         writableDatabase.insert("user",null,cv);
         writableDatabase.close();

     }
     public List<String>  selcet(){
         List<String> list=new ArrayList<String >();
         SQLiteDatabase writableDatabase = mysqlite.getWritableDatabase();
         Cursor user = writableDatabase.query("user", null, null, null, null, null, null);
         String name=null;
        while (user.moveToNext()){
             name= user.getString(0);
             list.add(name);
        }
         return list;
     }

public void delete(String name1){
    SQLiteDatabase database = mysqlite.getWritableDatabase();
    database.delete("user", "name=?", new String[]{name1+""});

    database.close();
}
   
//查询的数据的代码
public Boolean cha(String name){
    SQLiteDatabase database = mysql.getWritableDatabase();
    Cursor cursor = database.rawQuery("select * from user1 where names='"+name+"'" , null);
    return cursor.moveToNext();
}