import java.util.ArrayList;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
public class Dao {
private Sqliteopen sqliteopen;
private Context context;
private ArrayList<User> list=new ArrayList<User>();
public Dao(Context context){
this.context=context;
sqliteopen = new Sqliteopen(context);
}
public void add(String reference,String title,String gent){
if(exyou(title)){
return;
}
SQLiteDatabase db = sqliteopen.getWritableDatabase();
db.execSQL("insert into ceshi8(reference,title,gent) values(?,?,?)", new Object[]{reference,title,gent});
db.close();
}
private boolean exyou(String title) {
SQLiteDatabase db = sqliteopen.getWritableDatabase();
Cursor cursor = db.rawQuery("select * from ceshi8 where title=?",new String []{title});
if(cursor.moveToNext()){
return true;
}else {
return false;
}
}
public ArrayList<User> getTitle(String gent,String title) {
SQLiteDatabase db = sqliteopen.getWritableDatabase();
Cursor cursor = db.rawQuery("select * from ceshi8 where gent=? and title like ?",new String[]{gent,"%"+title+"%"});
while(cursor.moveToNext()){
String reference = cursor.getString(cursor.getColumnIndex("reference"));
String titlee = cursor.getString(cursor.getColumnIndex("title"));
list.add(new User(reference, titlee));
}
return list;
}
}