Android-记账本（五）- 数据库

最新推荐文章于 2024-03-12 20:50:08 发布

小明的博客

最新推荐文章于 2024-03-12 20:50:08 发布

阅读量6.6k

点赞数 2

分类专栏： android学习笔记

本文链接：https://blog.csdn.net/sb_Ihateyou/article/details/77571784

版权

android学习笔记专栏收录该内容

32 篇文章 0 订阅

订阅专栏

package com.example.administrator.jizhangbook;

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

/**
 * Created by Administrator on 2017/8/2.
 */

public class DatabaseHeper extends SQLiteOpenHelper{

    public static final String COST_TITLE = "cost_title";
    public static final String COST_DATE = "cost_date";
    public static final String COST_MONEY = "cost_money";
    public static final String COST = "cost";

    public DatabaseHeper(Context context) {
        super(context, "daily", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table if not exists cost(" +
                "id integer primary key, " +
                "cost_title varchar, " +
                "cost_money varchar" +
                "cost_date varchar, )");
    }
    public void insertCost(CostBean costBean)
    {
        SQLiteDatabase database=getWritableDatabase();
        ContentValues cv=new ContentValues();
        cv.put(COST_TITLE,costBean.costTitle);
        cv.put(COST_MONEY,costBean.costMoney);
        cv.put(COST_DATE,costBean.costDate);
        database.insert(COST,null,cv);
    }
    public Cursor getAllCostData()
    {
        SQLiteDatabase database=getWritableDatabase();
        return database.query("cost",null,null,null,null,null,COST_DATE+ " ASC");
    }

    public void deleteAllData()
    {
        SQLiteDatabase database=getWritableDatabase();
        database.delete(COST,null,null);
    }

    public void deleteOne(CostBean costBean)
    {
        SQLiteDatabase database=getWritableDatabase();
        database.delete(COST,"COST_TITLE = ? and COST_MONEY = ? and COST_DATE = ?", new String[]{""+costBean.costTitle,""+costBean.costMoney,""+costBean.costDate});
    }

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

    }
}