android数据库SQLlite

最新推荐文章于 2025-01-10 19:43:20 发布

活泼的码农

最新推荐文章于 2025-01-10 19:43:20 发布

阅读量256

点赞数

CC 4.0 BY-SA版权

分类专栏： android 文章标签： android

本文链接：https://blog.youkuaiyun.com/qq_38753275/article/details/86559803

android 专栏收录该内容

10 篇文章

订阅专栏

android的数据库创建数据库方法

package com.guo.xiangmu.sql;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class SQLlite extends SQLiteOpenHelper {
    public SQLlite(Context context) {
        super(context, "bw.db", null, 1);

    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table bw (id integer primary key autoincrement,news_tiele TEXT,pic_url TEXT)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

dao层：

package com.guo.xiangmu.sql;

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

import com.qy.channel.db.DBUtil;

public class Dao {


    private final SQLiteDatabase db;

    public Dao(Context context) {
        SQLlite sqLlite = new SQLlite(context);
        db = sqLlite.getWritableDatabase();

    }
    public Cursor select( String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy){

        return db.query(  table,  columns, selection,  selectionArgs,  groupBy, having, orderBy);
    }
    //添加
    public  long add(String table, String nullColumnHack, ContentValues values){

        return  db.insert( table,  nullColumnHack,  values);
    }