Android SQLite 使用方法（含完整案例）

最新推荐文章于 2025-05-07 16:43:13 发布

Jere_Chen

最新推荐文章于 2025-05-07 16:43:13 发布

阅读量7.4k

点赞数 21

分类专栏： Android 数据存储文章标签： Android SQLite 简单Demo

本文链接：https://blog.csdn.net/jerechen/article/details/102772731

版权

1. Demo展示

2. 实现方法

2.1 定义数据库的结构

2.2 使用SQLiteHelper来创建数据库

3. 注意事项

1. Demo展示

Demo 案例：实现联系人列表功能，我们可以增加联系人，修改联系人，删除联系人，以及根据联系人的名字查询该联系人的功能，如下图所示：

2. 实现方法

app 的结构如下：（源码见 -> Android_SQLite_Learning）

2.1 定义数据库的结构

package com.jere.android_sqlite_learning.model;

/**
 * @author jere
 */
public class BusinessCard {
    public static final String TABLE_NAME = "BusinessCard";
    public static final String COLUMN_ID = "id";
    public static final String COLUMN_AVATAR = "avatar";
    public static final String COLUMN_NAME = "name";
    public static final String COLUMN_GENDER = "gender";
    public static final String COLUMN_TELEPHONE = "telephone";
    public static final String COLUMN_ADDRESS = "address";

    public static final String CREATE_TABLE = "CREATE TABLE " + TABLE_NAME + "("
            + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
            + COLUMN_NAME + " TEXT,"
            + COLUMN_GENDER + " INTEGER,"
            + COLUMN_AVATAR + " INTEGER,"
            + COLUMN_TELEPHONE + " TEXT,"
            + COLUMN_ADDRESS + " TEXT"
            + ")";

    private int id;
    private int avatar;
    private String name;
    private String telephone;
    //true:male, false:female
    private boolean gender;
    private String address;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getAvatar() {
        return avata