Android连接数据库

1.activity_main布局

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".MainActivity"
    android:orientation="vertical">

    <Button

        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="@string/createble_db"
        android:onClick="doCreateDB"
        tools:ignore="OnClick" />

    <Button

        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="@string/delet_db"
        android:onClick="doDeleteDB"
        tools:ignore="OnClick" />



</LinearLayout>

2.MainActivity活动

package com.example.database;

import androidx.appcompat.app.AppCompatActivity;

import android.app.Activity;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Toast;

public class MainActivity extends Activity {
    //数据库前缀名
    private final static String DATABASE_NAME_PREFIX="student";
    //文件访问模式
    private final static int MODE= Context.MODE_PRIVATE;
    //数据库计时器
    private int count;
    //SQLite数据库
    private SQLiteDatabase db;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);

        //利用布局文件设置页面
        setContentView(R.layout.activity_main);
        //获取数据库的个数
        count=databaseList().length;
    }
    //创建数据库
    public void doCreateDB(View view){
        //数据库累加
        count++;
        //数据库名
        String dbName= DATABASE_NAME_PREFIX +count +".db";

        try{
            db=openOrCreateDatabase(dbName,MODE,null);
            Toast.makeText(this,"恭喜数据库【"+dbName+"】创建成功!", Toast.LENGTH_LONG).show();
        }catch (Exception e){
            Toast.makeText(this,"遗憾数据库【"+dbName+"】创建失败!",Toast.LENGTH_LONG).show();
        }
    }
    //删除数据库
    public void doDeleteDB(View view){
        //获取数据库名称数组
        String [] dbName=databaseList();
        if (databaseList().length>0){
        //删除数据库，需要遍历的数据库名称
        for (int i=0;i<dbName.length;i++){
            deleteDatabase(dbName[i]);
        }
        //数据库计算器归零
        count=0;
        Toast.makeText(this,"恭喜,数据库删除成功!",Toast.LENGTH_LONG).show();
    }else{
            Toast.makeText(this,"遗憾,没有可删除的数据库!",Toast.LENGTH_LONG).show();
        }
    }

}

3.案例图片