安卓中创建数据库和基本增删改查
public class SqliteHelper extends SQLiteOpenHelper{
/*** 1.上下文
* 2.数据库名字
* 3.工厂游标
* 4.版本号
* @param context
*/
public SqliteHelper(Context context) {
super(context, "Person.db", null, 1);
// TODO Auto-generated constructor stub
}
//创建 创建表 只要创建成功 只会执行一次
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("create table person(id integer primary key autoincrement," +
"name text," +
"sex text)");
}
//升级数据库
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
----------------------------------------------------------------------------------------------
以下是简单的增删改查:
public class UserDao {
private SqliteHelper helper;
private SQLiteDatabase sb;
public UserDao(Context context){
helper = new SqliteHelper(context);
sb = helper.getReadableDatabase();
}
//添加
public boolean add(String name,String age){
ContentValues values = new ContentValues();
//1.key 字段名 2.要进行添加的值
values.put("name", name);
values.put("age", age);
//1. 表名 2.要进行添加的列 3. 添加的值
long insert = sb.insert("user", null, values );
if(insert!=-1){
return true;
}else{
return false;
}
}
//查询
public String select(){
/**
* table, 表名
* columns, 查询列
* selection, 条件
* selectionArgs,条件的值
* groupBy,组查询
* having, 子查询
* orderBy 顺序 升序 降序
*/
Cursor query = sb.query("user", null, null, null, null, null, null);
StringBuffer stringBuffer = new StringBuffer();
while (query.moveToNext()) {
String name = query.getString(query.getColumnIndex("name"));
String age = query.getString(query.getColumnIndex("age"));
stringBuffer.append(name+"----"+age);
}
return stringBuffer.toString();
}
//删除
public boolean delete(String name){
/**
* 1.表名
* 2.条件
* 3.条件的值
*/
int delete = sb.delete("user", "name = ?", new String[]{name});
if(delete!=-1){
return true;
}else{
return false;
}
}
public boolean update(String name,String age,String tj){
/**
* table, 表名
* values,要修改的值
* whereClause, 条件
* whereArgs 条件的值
*/
ContentValues values = new ContentValues();
values.put("name", name);
values.put("age", age);
int update = sb.update("user", values, "name = ?", new String[]{tj});
if(update!=-1){
return true;
}else{
return false;
}
}
}