前言
- SQLite数据库操作在Android开发中非常常用
- 今天我将带大家全面了解关于SQLite数据库的操作(增、删、查、改)
目录
![目录](https://i-blog.csdnimg.cn/blog_migrate/697d0cefa246949540f102344890c3ed.webp?x-image-process=image/format,png)
1. SQLite数据库介绍
2. SQLiteOpenHelper类介绍
- 定义:SQLiteOpenHelper是一个辅助类
- 作用:管理数据库(创建、增、修、删) & 版本的控制。
- 使用过程:通过创建子类继承SQLiteOpenHelper类,实现它的一些方法来对数据库进行操作。
在实际开发中,为了能够更好的管理和维护数据库,我们会封装一个继承自SQLiteOpenHelper类的数据库操作类,然后以这个类为基础,再封装我们的业务逻辑方法。
- SQLiteOpenHelper类的数据库操作方法介绍
方法名 | 作用 | 备注 |
---|
onCreate() | 创建数据库 | 创建数据库时自动调用 |
onUpgrade() | 升级数据库 | |
close() | 关闭所有打开的数据库对象 | |
execSQL() | 可进行增删改操作, 不能进行查询操作 | |
query()、rawQuery() | 查询数据库 | |
insert() | 插入数据 | |
delete() | 删除数据 | |
getWritableDatabase() | 创建或打开可以读/写的数据库 | 通过返回的SQLiteDatabase对象对数据库进行操作 |
getReadableDatabase() | 创建或打开可读的数据库 | 同上 |
3. 常见数据库使用
数据库操作无外乎:“增删查改”:
- 对于“增、删、改(更新)”这类对表内容变换的操作,需先调用getWritableDatabase()获得一个可写数据库对象,在执行的时候调用通用的execSQL(String sql)或或对应的操作API方法:insert()、delete()、update()
- 对“查”,需要调用getReadableDatabase()获得一个可读的数据库对象,然后使用query()或rawQuery()方法
查询数据库不能使用execSQL方法
下面我将一一介绍。
3.1 创建数据库
- 涉及的方法有onCreate()、getWritableDatabase()、getReadableDatabase()
- 具体代码如下:
假设DatabaseHelper类是SQLiteOpenHelper的子类
DatabaseHelper.java
@Override
public void onCreate(SQLiteDatabase db) {
String sql = "create table person(id integer primary key autoincrement,name varchar(64),address varchar(64))";
db.execSQL(sql);
*MainActivity.java*
SQLiteOpenHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
"test_carson");
SQLiteDatabase sqliteDatabase = dbHelper.getReadableDatabase();
3.2 插入数据
- 步骤:创建并打开数据库(可读/写)、插入数据
- 涉及方法:getWritableDatabase()、insert()
insert()也可以使用excelSQL()代替
- 具体代码如下:
SQLiteOpenHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
"test_carson",2);
SQLiteDatabase sqliteDatabase = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("id", 1);
values.put("name", "yangyz");
sqliteDatabase.insert("user", null, values);
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
3.3 修改数据(升级数据库)
- 涉及的方法有onUpgrade()、getWritableDatabase()、update()
- 具体代码如下:
DatabaseHelper.Java
private static final int DATABASE_VERSION = 1;
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
String sql = "alter table person add sex varchar(8)";
db.execSQL(sql);
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
MainActivity.java
DatabaseHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
"test_carson", 2);
SQLiteDatabase sqliteDatabase = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("name", "zhangsan");
sqliteDatabase.update("user", values, "id=?", new String[] { "1" });
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
3.4 删除数据
- 步骤:创建并打开数据库(可读/写)、删除数据
- 涉及方法:getWritableDatabase()、delete()
delete()也可以使用excelSQL()代替
- 具体代码如下:
SQLiteOpenHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
"test_carson",2);
SQLiteDatabase sqliteDatabase = dbHelper.getWritableDatabase();
sqliteDatabase.delete("user", "id=?", new String[]{"1"});
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
3.5 查询数据
- 步骤:创建并打开数据库(可读)、查询数据
- 涉及方法:getReadableDatabase()、query() 或 rawQuery(),介绍如下:
db.rawQuery(String sql, String[] selectionArgs);
db.query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy);
db.query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit);
db.query(String distinct, String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit);
c.move(int offset);
c.moveToFirst();
c.moveToLast();
c.moveToPosition(int position);
c.moveToPrevious();
c.moveToNext();
c.isFirst();
c.isLast();
c.isBeforeFirst();
c.isAfterLast();
c.isNull(int columnIndex);
c.isClosed();
c.getCount();
c.getPosition();
c.getColumnIndex(String columnName);
c.getString(int columnIndex);
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
SQLiteOpenHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
"test_carson",2);
SQLiteDatabase sqliteDatabase = dbHelper.getReadableDatabase();
Cursor cursor = sqliteDatabase.query("user", new String[] { "id",
"name" }, "id=?", new String[] { "1" }, null, null, null);
while (cursor.moveToNext()) {
id = cursor.getString(cursor.getColumnIndex("id"));
name = cursor.getString(cursor.getColumnIndex("name"));
}
private ArrayList<Map<String, String>> cursor2list(Cursor cursor) {
ArrayList<Map<String, String>> list = new ArrayList<Map<String,String>>();
while(cursor.moveToNext()){
Map<String, String> map = new HashMap<String, String>();
map.put("tittle", cursor.getString(1));
map.put("content", cursor.getString(2));
list.add(map);
}
return list;
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
3.6 关闭数据库
当我们完成了对数据库的操作后,记得调用SQLiteDatabase的close()方法释放数据库连接,否则容易出现SQLiteException。
SQLiteOpenHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
"test_carson");
SQLiteDatabase sqliteDatabase = dbHelper.getReadableDatabase();
sqliteDatabase.close();
3.7 删除数据库
SQLiteOpenHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
"test_carson");
SQLiteDatabase sqliteDatabase = dbHelper.getReadableDatabase();
deleteDatabase("test.db");
特别注意
其实对于上述所有的数据库操作(除了“查询”),我们都可以使用下列方法代替:
db.executeSQL(String sql);
db.executeSQL(String sql, Object[] bindArgs);
个人建议都使用SQL语句,因为:
- SQL语句较为通用;
- 使用insert()、delete()、query()方法具备多个参数,使用复杂
4. 实例Demo
- Demo描述:创建数据库并对数据库进行操作(增、删、查、改)
- 实现步骤:
- 实现子类继承SQLiteOpenHelper类(复写onCreat()、onUpgrade())
- 在MainActivity里实现需要进行的数据库操作(增、删、查、改)
4.1 具体代码如下:
建议先下载Demo再进行阅读:Carson的Github:DataBase_Demo
步骤1:实现子类继承SQLiteOpenHelper类(复写onCreat()、onUpgrade())
MySQLiteOpenHelper.java
package scut.carson_ho.database_demo;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
* Created by Carson_Ho on 16/11/18.
*/
public class MySQLiteOpenHelper extends SQLiteOpenHelper {
private static Integer Version = 1;
public MySQLiteOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory,
int version) {
super(context, name, factory, version);
}
public MySQLiteOpenHelper(Context context,String name,int version)
{
this(context,name,null,version);
}
public MySQLiteOpenHelper(Context context,String name)
{
this(context, name, Version);
}
@Override
public void onCreate(SQLiteDatabase db) {
System.out.println("创建数据库和表");
String sql = "create table user(id int primary key,name varchar(200))";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
System.out.println("更新数据库版本为:"+newVersion);
}
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
步骤2:在MainActivity里实现需要进行的数据库操作(增、删、查、改)
MainActivity.java
package scut.carson_ho.database_demo;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.view.View;
import android.widget.Button;
public class MainActivity extends AppCompatActivity implements View.OnClickListener {
private Button instablish;
private Button insert;
private Button upgrade;
private Button modify;
private Button delete;
private Button query;
private Button delete_database;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
instablish = (Button) findViewById(R.id.instablish);
insert = (Button) findViewById(R.id.insert);
upgrade = (Button) findViewById(R.id.upgrade);
modify = (Button) findViewById(R.id.modify);
delete = (Button) findViewById(R.id.delete);
query = (Button) findViewById(R.id.query);
delete_database = (Button) findViewById(R.id.delete_database);
instablish.setOnClickListener(this);
insert.setOnClickListener(this);
upgrade.setOnClickListener(this);
modify.setOnClickListener(this);
delete.setOnClickListener(this);
query.setOnClickListener(this);
delete_database.setOnClickListener(this);
}
@Override
public void onClick(View v) {
switch (v.getId()) {
case R.id.instablish:
MySQLiteOpenHelper dbHelper = new MySQLiteOpenHelper(this,"test_carson");
SQLiteDatabase sqliteDatabase = dbHelper.getWritableDatabase();
break;
case R.id.upgrade:
MySQLiteOpenHelper dbHelper_upgrade = new MySQLiteOpenHelper(this,"test_carson",2);
SQLiteDatabase sqliteDatabase_upgrade = dbHelper_upgrade.getWritableDatabase();
break;
case R.id.insert:
System.out.println("插入数据");
MySQLiteOpenHelper dbHelper1 = new MySQLiteOpenHelper(this,"test_carson",2);
SQLiteDatabase sqliteDatabase1 = dbHelper1.getWritableDatabase();
ContentValues values1 = new ContentValues();
values1.put("id", 1);
values1.put("name", "carson");
sqliteDatabase1.insert("user", null, values1);
sqliteDatabase1.close();
break;
case R.id.query:
System.out.println("查询数据");
MySQLiteOpenHelper dbHelper4 = new MySQLiteOpenHelper(MainActivity.this,"test_carson",2);
SQLiteDatabase sqliteDatabase4 = dbHelper4.getReadableDatabase();
Cursor cursor = sqliteDatabase4.query("user", new String[] { "id",
"name" }, "id=?", new String[] { "1" }, null, null, null);
String id = null;
String name = null;
while (cursor.moveToNext()) {
id = cursor.getString(cursor.getColumnIndex("id"));
name = cursor.getString(cursor.getColumnIndex("name"));
System.out.println("查询到的数据是:"+"id: "+id+" "+"name: "+name);
}
sqliteDatabase4.close();
break;
case R.id.modify:
System.out.println("修改数据");
MySQLiteOpenHelper dbHelper2 = new MySQLiteOpenHelper(MainActivity.this,"test_carson", 2);
SQLiteDatabase sqliteDatabase2 = dbHelper2.getWritableDatabase();
ContentValues values2 = new ContentValues();
values2.put("name", "zhangsan");
sqliteDatabase2.update("user", values2, "id=?", new String[]{"1"});
sqliteDatabase2.close();
break;
case R.id.delete:
System.out.println("删除数据");
MySQLiteOpenHelper dbHelper3 = new MySQLiteOpenHelper(MainActivity.this,"test_carson",2);
SQLiteDatabase sqliteDatabase3 = dbHelper3.getWritableDatabase();
sqliteDatabase3.delete("user", "id=?", new String[]{"1"});
sqliteDatabase3.close();
break;
case R.id.delete_database:
System.out.println("删除数据库");
MySQLiteOpenHelper dbHelper5 = new MySQLiteOpenHelper(MainActivity.this,
"test_carson",2);
SQLiteDatabase sqliteDatabase5 = dbHelper5.getReadableDatabase();
deleteDatabase("test_carson");
break;
default:
break;
}
}
}
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
- 202
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
- 202
步骤3:在主布局文件设置按钮控制数据库的操作
activity_main.xml
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:paddingBottom="@dimen/activity_vertical_margin"
android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
tools:context="scut.carson_ho.database_demo.MainActivity">
<Button
android:id="@+id/instablish"
android:layout_centerHorizontal="true"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="创建数据库"/>
<Button
android:id="@+id/upgrade"
android:layout_below="@+id/instablish"
android:layout_centerHorizontal="true"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="更新数据库"/>
<Button
android:id="@+id/insert"
android:layout_below="@+id/upgrade"
android:layout_centerHorizontal="true"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="插入数据"/>
<Button
android:id="@+id/modify"
android:layout_centerHorizontal="true"
android:layout_below="@+id/insert"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="修改数据"/>
<Button
android:id="@+id/query"
android:layout_centerHorizontal="true"
android:layout_below="@+id/modify"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="查询数据"/>
<Button
android:id="@+id/delete"
android:layout_centerHorizontal="true"
android:layout_below="@+id/query"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="删除数据"/>
<Button
android:id="@+id/delete_database"
android:layout_centerHorizontal="true"
android:layout_below="@+id/delete"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="删除数据库"/>
</RelativeLayout>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
4.2 测试结果
![测试结果](https://i-blog.csdnimg.cn/blog_migrate/6152fb108399f6f2df784bc45547c054.webp?x-image-process=image/format,png)
4.3 Demo下载地址
Carson的Github地址:DataBase_Demo