- 博客(0)
- 资源 (2)
- 收藏
- 关注
android 数据库 小应用
package com.JingTing.DBhelperClass;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DBHelper extends SQLiteOpenHelper {
public DBHelper(Context context)
{
super(context, "data.db", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
String createnotestable="create table datas (_id integer primary key autoincrement,ItemName text,Money float,time datatime)";
db.execSQL(createnotestable);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
db.execSQL("drop table datas if exits");
onCreate(db);
}
public Cursor ExitsData()
{
SQLiteDatabase db = getReadableDatabase();
return db.rawQuery("select * from datas",null);
}
public Cursor SumMoney()
{
SQLiteDatabase db = getReadableDatabase();
return db.rawQuery("select SUM(Money) as SumAll from datas",null);
}
public Cursor ExitsIncome()
{
SQLiteDatabase db = getReadableDatabase();
return db.rawQuery("select * from datas where Money>0",null);
}
public Cursor SumInCome()
{
SQLiteDatabase db = getReadableDatabase();
return db.rawQuery("select SUM(Money) as SumInCome from datas where Money>0",null);
}
public Cursor ExitsExpenditure()
{
SQLiteDatabase db = getReadableDatabase();
return db.rawQuery("select * from datas where Money<0",null);
}
public Cursor SumExpenditure()
{
SQLiteDatabase db = getReadableDatabase();
return db.rawQuery("select SUM(Money) as SumExpenditure from datas where Money<0",null);
}
public Cursor SelectAllItem()
{
SQLiteDatabase db = getReadableDatabase();
return db.rawQuery("select * from datas order by time desc",null);
}
public long insertData(String ItemName,int Money,String time)
{
SQLiteDatabase DB=getWritableDatabase();
ContentValues values=new ContentValues();
values.put("ItemName", ItemName);
values.put("Money", Money);
values.put("time", time);
return DB.insert("datas", null, values);
}
}
2015-07-18
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人