package com.hyrt.report.service;
import java.util.HashMap;
import java.util.Map;
import com.hyrt.cei.application.CeiApplication;
import com.hyrt.cei.db.DataHelper;
import com.hyrt.cei.db.SqliteHelper;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
public class FileService {
//app中找
private DataHelper dataHelper;
public FileService(CeiApplication context) {
dataHelper = context.dataHelper;
}
/**
* ��ȡÿ���߳��Ѿ����ص��ļ�����
* @param path
* @return
*/
public Map<Integer, Integer> getData(String path){
SQLiteDatabase db = dataHelper.dbHelper.getReadableDatabase();
Cursor cursor = db.rawQuery("select threadid, downlength from filedownlog where downpath=?", new String[]{path});
Map<Integer, Integer> data = new HashMap<Integer, Integer>();
while(cursor.moveToNext()){
data.put(cursor.getInt(0), cursor.getInt(1));
}
cursor.close();
//db.close();
return data;
}
/**
* ����ÿ���߳��Ѿ����ص��ļ�����
* @param path
* @param map
*/
public void save(String path, Map<Integer, Integer> map){//int threadid, int position
SQLiteDatabase db = dataHelper.dbHelper.getWritableDatabase();
db.beginTransaction();
try{
for(Map.Entry<Integer, Integer> entry : map.entrySet()){
db.execSQL("insert into filedownlog(downpath, threadid, downlength) values(?,?,?)",
new Object[]{path, entry.getKey(), entry.getValue()});
}
db.setTransactionSuccessful();
}finally{
db.endTransaction();
}
// db.close();
}
/**
* ʵʱ����ÿ���߳��Ѿ����ص��ļ�����
* @param path
* @param map
*/
public void update(String path, Map<Integer, Integer> map){
SQLiteDatabase db = dataHelper.dbHelper.getWritableDatabase();
db.beginTransaction();
try{
for(Map.Entry<Integer, Integer> entry : map.entrySet()){
db.execSQL("update filedownlog set downlength=? where downpath=? and threadid=?",
new Object[]{entry.getValue(), path, entry.getKey()});
}
db.setTransactionSuccessful();
}finally{
db.endTransaction();
}
// db.close();
}
/**
* ���ļ�������ɺ�ɾ���Ӧ�����ؼ�¼
* @param path
*/
public void delete(String path){
SQLiteDatabase db = dataHelper.dbHelper.getWritableDatabase();
db.execSQL("delete from filedownlog where downpath=?", new Object[]{path});
//db.close();
}
}