本文共 1661 字，大约阅读时间需要 5 分钟。

1.先创建一个SQLiteOpenHelper

2.调用sqliteopenhelper.getReadableDatabase()得到数据库

3.操作

insert

search

4.例子如下：

//integer表示整形//real表示浮点//text表示文本//blob表示二进制public class MydatabaseHelper extends SQLiteOpenHelper {    private Context context;    public static String TABLE_SQL = "create table word (" +            "_id integer primary key autoincrement," +            "english text," +            "chinese text)";    public MydatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {        super(context, name, null, version);        this.context = context;        Log.i("mydate" , "123456");    }    @Override    public void onCreate(SQLiteDatabase db) {        db.execSQL(TABLE_SQL);        Toast.makeText(context, "sqlite数据库创建成功", Toast.LENGTH_SHORT).show();        Log.i("mydate" , "123456onCreate");    }    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {    }}

public class MainActivity extends AppCompatActivity {    Button alert;    MydatabaseHelper dbhelper;    SQLiteDatabase db;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_main);        dbhelper = new MydatabaseHelper(this , "DanCi.db" , null , 1);        alert = (Button) findViewById(R.id.alert);        alert.setOnClickListener(new View.OnClickListener() {            @Override            public void onClick(View v) {                Log.i("mydate" , "onclick");                dbhelper.getReadableDatabase(); //得到数据库操作类(.getWritableDatabase())                Log.i("mydate" , "onclick2222");            }        });    }}

转载地址：https://liuyan.blog.csdn.net/article/details/79872061 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！