数据库的增删改查

public class UserDao {
private MySQL ms;
private SQLiteDatabase database;
private ArrayList<Bean> list;
private SQLiteDatabase writableDatabase;
private SQLiteDatabase writableDatabase2;
private SQLiteDatabase writableDatabase3;
private ContentValues values;


public UserDao(Context context){
ms = new MySQL(context);
}
public void insert(String name,String password){
database = ms.getWritableDatabase();
ContentValues values=new ContentValues();
values.put("name", name);
values.put("password", password);
database.insert("student", null, values);
database.close();
}
public ArrayList<Bean> select(){
list = new ArrayList<Bean>();
writableDatabase = ms.getWritableDatabase();
Cursor cursor = writableDatabase.query("student", new String[]{"name","password"}, null, null, null, null, null);
while(cursor.moveToNext())
{
String name = cursor.getString(cursor.getColumnIndex("name"));
String password = cursor.getString(cursor.getColumnIndex("password"));
list.add(new Bean(name, password));
}
return list;

}
public void delete(String name){
writableDatabase2 = ms.getWritableDatabase();
writableDatabase2.delete("student", "name=?", new String[]{name});
writableDatabase2.close();
}
public void update(String name,String uname,String password){
writableDatabase3 = ms.getWritableDatabase();
values = new ContentValues();
values.put("name", uname);
values.put("password", password);
writableDatabase3.update("student", values, "name=?", new String[]{name});
}


}