xindeDao

import java.util.ArrayList;


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


public class DataDao {
private Context context;
private MySQLite lite;
private ArrayList<Datas> list;
public DataDao(Context context) {
super();
this.context = context;
this.lite = new MySQLite(context);
list=new ArrayList<Datas>();
}

public void add(String title, String reference, String type){
SQLiteDatabase db = lite.getWritableDatabase();
db.execSQL("insert into data (title,reference,type) values (?,?,?)",new Object[]{title,reference,type});
db.close();
}

public ArrayList<Datas> selectAll(){
SQLiteDatabase db = lite.getWritableDatabase();
Cursor cursor = db.rawQuery("select * from data", new String[]{});
while(cursor.moveToNext()){
String title = cursor.getString(cursor.getColumnIndex("title"));
String reference = cursor.getString(cursor.getColumnIndex("reference"));
String type = cursor.getString(cursor.getColumnIndex("type"));
list.add(new Datas(reference, title, type));
}
db.close();
return list;
}

public ArrayList<Datas> selectTitle(String title, String type){
SQLiteDatabase db = lite.getWritableDatabase();
Cursor cursor = db.rawQuery("select * from data where type=? and title like ?", new String[]{type,"%"+title+"%"});
while(cursor.moveToNext()){
String titles = cursor.getString(cursor.getColumnIndex("title"));
String reference = cursor.getString(cursor.getColumnIndex("reference"));
String types = cursor.getString(cursor.getColumnIndex("type"));
list.add(new Datas(reference, titles, types));
}
db.close();
return list;
}
}