SQLite是AndroidSDK自带的数据库,微型,轻量,占用资源低;
除了使用自身的 insert、update 、delete等还可以使用execSQL这种嵌入SQL语法进行数据库操作;
db=SQLiteDatabase.openOrCreateDatabase("/data/databases/1.db",null);//创建或打开数据库
import android.database.sqlite.SQLiteBDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public calss MyDatabase extends SQLiteOpenHelper /*定义数据表*/
{
private final String parameterIt="("+"id integer primary key autoincrement/*自增*/ ,"+"name varchar,"+"age varchar"+")";
public void OnCreate(SQLiteBDatabase db)
{
db.execSQL("CREATE TABLE"+ParameterIT+parameterIt);
}
}
SQLiteOpenHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,"test_carson");
SQLiteDatabase sqliteDatabase = dbHelper.getReadableDatabase(); /*创建数据表*/
or SQLiteDatabase sqliteDatabase = dbHelper.getWritableDatabase();
sqliteDatabase.update("user", values, "id=?", new String[] { "1" });
sqliteDatabase.insert(tablename,null,values);
sqliteDatabase.delete("user", "id=?", new String[]{"1"});
查询时使用cursor作为返回,查询函数为query or rawquery
String sql="SELECT * FROM"+tablename+"WHERE TestDate=?"+"OR ItemName=?"+"OR ReagentLot=?"+"OR SampleName=?"+"OR SampleNumber=?" /*匹配查询/
cursor = myDatabase.getReadableDatabase().rawQuery(sql, new String[]{'%' + searchText + '%', '%' + searchText + '%', '%'
+ searchText + '%', '%' + searchText + '%', '%' + searchText + '%' }); /*模糊查询/
通过ddms 查看data文件下创建的数据db文件