package com.example.db.dao;
import java.util.ArrayList;
import java.util.List;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import com.example.db.NoteSQLiteOpenHelper;
import com.example.note.domain.NoteBean;
public class NoteDao {
//因为任何一个操作都是需要得到NoteSQLiteOpenHelper helper
//把他放在构造方法里面初始化
/*
* 记账本的流
* name:花销的名称
* money:花销的金额
* */
private NoteSQLiteOpenHelper helper;
public void NoteDao(Context context){
helper = new NoteSQLiteOpenHelper(context);
}
public void add(String name , float money){
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("insert into account (name,money)values(?,?)", new Object[]{name,money});
db.close();
}
public void delete(int id){
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("select * from account where id = ?", new Object[]{id});
db.close();
}
public void update(int id , float newmoney){
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("update account set money = ? where id = ?", new Object[]{newmoney , id});
db.close();
}
public List<NoteBean> findAll(){
SQLiteDatabase db = helper.getReadableDatabase();
List<NoteBean> noteBeans = new ArrayList<NoteBean>();
//获取到数据库查询的结果游标
Cursor cursor = db.rawQuery("select * from account",null);
cursor.moveToNext();
while(cursor.moveToNext()){
int id = cursor.getInt(0);
String name = cursor.getString(1);
float money = cursor.getFloat(2);
NoteBean bean = new NoteBean(id,money,name);
noteBeans.add(bean);
bean = null;
}
db.close();
return noteBeans;
}
}
import java.util.ArrayList;
import java.util.List;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import com.example.db.NoteSQLiteOpenHelper;
import com.example.note.domain.NoteBean;
public class NoteDao {
//因为任何一个操作都是需要得到NoteSQLiteOpenHelper helper
//把他放在构造方法里面初始化
/*
* 记账本的流
* name:花销的名称
* money:花销的金额
* */
private NoteSQLiteOpenHelper helper;
public void NoteDao(Context context){
helper = new NoteSQLiteOpenHelper(context);
}
public void add(String name , float money){
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("insert into account (name,money)values(?,?)", new Object[]{name,money});
db.close();
}
public void delete(int id){
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("select * from account where id = ?", new Object[]{id});
db.close();
}
public void update(int id , float newmoney){
SQLiteDatabase db = helper.getWritableDatabase();
db.execSQL("update account set money = ? where id = ?", new Object[]{newmoney , id});
db.close();
}
public List<NoteBean> findAll(){
SQLiteDatabase db = helper.getReadableDatabase();
List<NoteBean> noteBeans = new ArrayList<NoteBean>();
//获取到数据库查询的结果游标
Cursor cursor = db.rawQuery("select * from account",null);
cursor.moveToNext();
while(cursor.moveToNext()){
int id = cursor.getInt(0);
String name = cursor.getString(1);
float money = cursor.getFloat(2);
NoteBean bean = new NoteBean(id,money,name);
noteBeans.add(bean);
bean = null;
}
db.close();
return noteBeans;
}
}