关于#android#的问题,如何解决?

package com.example.liusipeng20220606;

import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;

public class MainActivity extends Activity {

private SQLiteDatabase db= null;

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    try {
         db=SQLiteDatabase.
                 openOrCreateDatabase("/mnt/sdcard/stu0.db", null);
    } catch (Exception e) {
        // TODO: handle exception
        e.printStackTrace();
    }
    createTable(db);
    insert(db,"zx","01");
    insert(db,"cc","02");
    insert1(db,"dd","03");
    insert1(db,"ee","04");
    Log.i("aa","bb");
    query(db);
    

// Log.i("aaa",bbbbb");
// delete(db,"01");
// delete(db,"02");
// query(db);

    update(db,"01","001");
    Log.i("aaa","bbbbb");
    query(db);
}


private void insert(SQLiteDatabase db, String sname, String snumber) {
    // 实例化常用值
    ContentValues cValue =new ContentValues();
    //添加用户名
    cValue.put("sname",sname);
    //添加密码
    cValue.put("snumber",snumber);
    //调用insert()方法插入数据
    db.insert("usertable", null, cValue);
    
}

private void insert1(SQLiteDatabase db, String sname ,String snumber) {
    // TODO Auto-generated method stub
          String sql="insert into usertable(sname,snumber) values('"+sname+"','"+snumber+"')";
        db.execSQL(sql);
}

private void query(SQLiteDatabase db) {
    // TODO Auto-generated method stub
    Cursor cursor=db.query(false, "usertable",new String[]{"_id","sname","snumber"
            
    }, null, null, null, null, null, null);
    if(cursor.moveToFirst()){
        for(int i=0;i<cursor.getColumnCount();i++){
            int id =cursor.getInt(0);
            String sname =cursor.getString(1);
            String snumber =cursor.getString(2);
            Logpackage com.example.liusipeng20220606;

import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;

public class MainActivity extends Activity {

private SQLiteDatabase db= null;

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    try {
         db=SQLiteDatabase.
                 openOrCreateDatabase("/mnt/sdcard/stu0.db", null);
    } catch (Exception e) {
        // TODO: handle exception
        e.printStackTrace();
    }
    createTable(db);
    insert(db,"zx","01");
    insert(db,"cc","02");
    insert1(db,"dd","03");
    insert1(db,"ee","04");
    Log.i("aa","bb");
    query(db);
    

// Log.i("aaa","bbbbb");
// delete(db,"01");
// delete(db,"02");
// query(db);

    update(db,"01","001");
    Log.i("aaa","bbbbb");
    query(db);
}


private void insert(SQLiteDatabase db, String sname, String snumber) {
    // 实例化常用值
    ContentValues cValue =new ContentValues();
    //添加用户名
    cValue.put("sname",sname);
    //添加密码
    cValue.put("snumber",snumber);
    //调用insert()方法插入数据
    db.insert("usertable", null, cValue);
    
}

private void insert1(SQLiteDatabase db, String sname ,String snumber) {
    // TODO Auto-generated method stub
          String sql="insert into usertable(sname,snumber) values('"+sname+"','"+snumber+"')";
        db.execSQL(sql);
}

private void query(SQLiteDatabase db) {
    // TODO Auto-generated method stub
    Cursor cursor=db.query(false, "usertable",new String[]{"_id","sname","snumber"
            
    }, null, null, null, null, null, null);
    if(cursor.moveToFirst()){
        for(int i=0;i<cursor.getColumnCount();i++){
            int id =cursor.getInt(0);
            String sname =cursor.getString(1);
            String snumber =cursor.getString(2);
            Log

img

img

img


对数据库的操作,放到多线程