我们可以参考一下相关语句
新建SaucerSQLiteOpenHelper 类去继承 SQLiteOpenHelper
查找:
Cursor cursor = db.rawQuery("select * from 表名 where 字段名=?", new
String[]{"数据"});
删除:
db.delete("表名", "字段名1=? and 字段名2= ?", new String[]{"数据1","数据2"});
public class SaucerSQLiteOpenHelper extends SQLiteOpenHelper {
private static final String TAG = "SaucerSQLiteOpenHelper";
private Context mcontext;
public static final String saucer_info = "create table saucer_info("
+ "id integer primary key autoincrement,"
+ "saucer_name text,"
+ "saucer_cremtetimes text,"
+ "saucer_endtimes text)";
public SaucerSQLiteOpenHelper(Context context, String name,
SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
this.mcontext = context;
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(saucer_info);
Log.i(TAG, "创建成功");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
查找出某一条数据
SaucerSQLiteOpenHelper saucerSQLiteOpenHelper = new
SaucerSQLiteOpenHelper(MainActivity.this, "saucer.db", null, 3);
SQLiteDatabase db = saucerSQLiteOpenHelper.getWritableDatabase();
Cursor cursor = db.rawQuery("select * from saucer_info where saucer_name=?", new
String[]{"123334"});
System.out.println("总数" + cursor1.getCount());
if (cursor1.getCount() > 0) {
System.out.println("数据已经存在");
//检测时间
while (cursor1.moveToNext()) {
String a=cursor1.getString(cursor1.getColumnIndex("saucer_cremtetimes"));
Stirng b=cursor1.getString(cursor1.getColumnIndex("saucer_endtimes"));
}
System.out.println("saucer_cremtetimes" + a);
System.out.println("saucer_endtimes==" + b);
/*不用之后,要释放资源*/
cursor.close();
db.close();
}
SaucerSQLiteOpenHelper saucerSQLiteOpenHelper = new
SaucerSQLiteOpenHelper(MainActivity.this, "saucer.db", null, 3);
SQLiteDatabase db = saucerSQLiteOpenHelper.getWritableDatabase();
/*实例化内容值*/
ContentValues values = new ContentValues();
/*在values中添加内容*/
values.put("saucer_cremtetimes", not1);
values.put("saucer_endtimes", not1);
/*修改条件*/
String whereClause = "saucer_name=?";
/*修改添加参数*/
String[] whereArgs = {carId};
/*修改*/
db.update("saucer_info", values, whereClause, whereArgs);
db.close();
在MainActivity一个名为“saucer.adb” 数据库名,“saucer_info”表名(命名随你自己喜欢,本文仅供参考)
db.update() 中 “values”代表相关字段的内容修改成的新数据,“whereClause” 找到字段名 XXXX=?的信息,“whereArgs”表中已经存在的一条数据信息,然后调用update修改。
这样的话,修改一条数据就可以了,更多用法根据个人的实际需要来使用即可。
如果还是不太了解Android sqlite的创建可以看我的另一篇文章:https://blog.csdn.net/qq_36771930/article/details/88695335,
还有其他的更好的方式,也可以在评论区留意,我们一起探讨交流学习。