package com.example.myapplication;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
// 设置数据库的增删改查
public class DAO {
private static final String TAG = "DAO";
private final DatabaseHelper mHelper;
public DAO(Context context){
//创建数据库
mHelper = new DatabaseHelper(context);
}
public void insert(){
SQLiteDatabase db = mHelper.getWritableDatabase();
//API进行操作
ContentValues values = new ContentValues();
//添加数据
values.put("_id",2);
values.put("name","larrypage");
values.put("salary",1);
values.put("phone",119);
values.put("address","CHN");
db.insert(Constants.TABLE_NAME,null,values);
db.close();
}
public void delete(){
SQLiteDatabase db = mHelper.getWritableDatabase();
String sql = "delete from "+Constants.TABLE_NAME+" where age = 60";
db.execSQL(sql);
db.close();
}
public void update(){
SQLiteDatabase db = mHelper.getWritableDatabase();
String sql = "update "+Constants.TABLE_NAME+" set salary =2 where age =60";
db.execSQL(sql);
db.close();
}
public void query(){
SQLiteDatabase db = mHelper.getWritableDatabase();
String sql = "select *from "+Constants.TABLE_NAME;
Cursor cursor = db.rawQuery(sql,null);
while (cursor.moveToNext()){
int index = cursor.getColumnIndex("name");
String name = cursor.getString(index);
Log.d(TAG,"搜索的名称是:"+ name);
}
cursor.close();
db.close();
}
}
数据库创建成功,增删改查失败,没有报错但没有效果;
测试类无法继承AndroidTestCase
您的每一个用心回答,都会让这个世界变得更美好一些!