Android SQLite 示例-优快云博客

本文链接：https://blog.youkuaiyun.com/wjh823177094/article/details/54984228

本文提供了一个使用 Android SQLite 进行数据存储的示例，包括创建表、插入数据、查询所有记录及按 ID 查询单条记录的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;


public class DBHomeList {

    private static final String TABLE_NAME = "homeList";

    private static final String TABLE_CREATE = "CREATE TABLE " + TABLE_NAME+ "( _ID INTEGER PRIMARY KEY,CONTENT_ID TEXT ,IMAGE_URI TEXT,TITLE TEXT,SHORT_DESCRIPTION TEXT,CONTENT TEXT);";

    public static void init(SQLiteDatabase db) {
        db.execSQL(TABLE_CREATE);
    }

    public static void clear() {
        DBManager.delete(TABLE_NAME, null, null);
    }

    public static void saveArticle(String contentId,String imageUri,String title,String shortDescription,String content){
        ContentValues contentValues = new ContentValues();
        contentValues.put("CONTENT_ID", contentId);
        contentValues.put("IMAGE_URI", imageUri);
        contentValues.put("TITLE", title);
        contentValues.put("SHORT_DESCRIPTION", shortDescription);
        contentValues.put("CONTENT", content);
        DBManager.insert(TABLE_NAME, null, contentValues);
    }

    public static void getAllArticleList(){
        String sql = "SELECT _ID,CONTENT_ID,IMAGE_URI, TITLE,SHORT_DESCRIPTION,CONTENT FROM "+TABLE_NAME;
        Cursor cursor = DBManager.rawQuery(sql, null);

        String imageUri = "";
        String title = "";
        String shortDescription = "";
        String content = "";
        try {
            if(cursor.moveToFirst()){
                int idxImageUri = cursor.getColumnIndex("IMAGE_URI") ;
                int idxTitle = cursor.getColumnIndex("TITLE") ;
                int idxShortDescription = cursor.getColumnIndex("SHORT_DESCRIPTION") ;
                int idxContent = cursor.getColumnIndex("CONTENT") ;

                do {
                    imageUri = cursor.getString(idxImageUri);
                    title = cursor.getString(idxTitle);
                    shortDescription = cursor.getString(idxShortDescription);
                    content = cursor.getString(idxContent);


                } while (cursor.moveToNext());
            }
        } catch (Exception e) {
        } finally {
            cursor.close();
        }
    }



    public static void getArticleById(String contentId){
        String sql = "SELECT _ID,CONTENT_ID,IMAGE_URI, TITLE,SHORT_DESCRIPTION,CONTENT FROM "+TABLE_NAME+" WHERE CONTENT_ID = ?";
        Cursor cursor = DBManager.rawQuery(sql, new String[]{contentId});

        String imageUri = "";
        String title = "";
        String shortDescription = "";
        String content = "";
         try {
            if(cursor.moveToFirst()){
                int idxImageUri = cursor.getColumnIndex("IMAGE_URI") ;
                int idxTitle = cursor.getColumnIndex("TITLE") ;
                int idxShortDescription = cursor.getColumnIndex("SHORT_DESCRIPTION") ;
                int idxContent = cursor.getColumnIndex("CONTENT") ;

                imageUri = cursor.getString(idxImageUri);
                title = cursor.getString(idxTitle);
                shortDescription = cursor.getString(idxShortDescription);
                content = cursor.getString(idxContent);
            }
        } catch (Exception e) {

        } finally {
            cursor.close();
        }
    }

    public static void deleteArticleById(String contentId){
        DBManager.delete(TABLE_NAME, "CONTENT_ID = ?", new String[]{contentId});
    }

}

我的数据库