package com.sanmi.db;
import java.util.ArrayList;
import java.util.List;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import com.sanmi.data.KaoShiYi;
public class CuoTiService {
private static Context context;
public CuoTiService(Context context1){
if(context1 == null) {
throw new IllegalArgumentException("参数Context不允许为null!!!");
}
this.context=context1;
}
//科目一 添加错题的方法
public boolean insertData(String cuoti_id){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
boolean flag=false;
ContentValues values=new ContentValues();
String selectID=selectData(cuoti_id);
if(selectID==null || selectID.equals("")){
values.put("cuoti_id", cuoti_id);
long temp=sqLiteDatabase.insert("noright", null, values);
sqLiteDatabase.close();
if(temp>0){
flag=true;
}
return flag;
}else{
if(cuoti_id.equals(selectID)){
flag=false;
return flag;
}else{
long temp=sqLiteDatabase.insert("noright", null, values);
sqLiteDatabase.close();
if(temp>0){
flag=true;
}
return flag;
}
}
}
//科目一 条件查询数据库,错题id如果已经存在,则不保存
public static String selectData(String cuoid){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
String oneCuo = null;
Cursor cursor=sqLiteDatabase.query("noright", null, "cuoti_id=?", new String[]{cuoid}, null, null, null);
if(cursor.moveToNext()){
oneCuo=cursor.getString(cursor.getColumnIndex("cuoti_id"));
}
sqLiteDatabase.close();
cursor.close();
return oneCuo;
}
//科目一 条件查询数据库,返回所有错题id
public static List<String> cuotiData(){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
String oneCuo = null;
List<String> oneCuos = new ArrayList<String>();
Cursor cursor=sqLiteDatabase.query("noright", null, null, null, null, null, null);
if(cursor.moveToFirst()) {
for(; !cursor.isAfterLast(); cursor.moveToNext()) {
oneCuo=cursor.getString(cursor.getColumnIndex("cuoti_id"));
oneCuos.add(oneCuo);
}
}
cursor.close();
sqLiteDatabase.close();
return oneCuos;
}
//科目一已做题id
public static boolean insertYiZuoData(String yizuoid) {
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
boolean flag=false;
ContentValues values=new ContentValues();
String selectID=selectYiZuoId(yizuoid);
if(selectID==null || selectID.equals("")){
values.put("yizuoti_id", yizuoid);
long temp=sqLiteDatabase.insert("yizuoti", null, values);
sqLiteDatabase.close();
if(temp>0){
flag=true;
}
return flag;
}else{
if(yizuoid.equals(selectID)){
flag=false;
return flag;
}else{
long temp=sqLiteDatabase.insert("yizuoti", null, values);
sqLiteDatabase.close();
if(temp>0){
flag=true;
}
return flag;
}
}
}
//科目一 条件查询数据库,已做题id如果已经存在,则不保存
public static String selectYiZuoId(String yizuoid){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
String oneyizuo = null;
Cursor cursor=sqLiteDatabase.query("yizuoti", null, "yizuoti_id=?", new String[]{yizuoid}, null, null, null);
if(cursor.moveToNext()){
oneyizuo=cursor.getString(cursor.getColumnIndex("yizuoti_id"));
}
cursor.close();
sqLiteDatabase.close();
return oneyizuo;
}
//科目1 条件查询字段,返回整个字段数据,list
public List<String> getyizuo(){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
String oneyizuo = null;
List<String> oneyizuos=new ArrayList<String>();
Cursor cursor=sqLiteDatabase.query("yizuoti", null, null, null, null, null, null);
if(cursor.moveToFirst()) {
for(; !cursor.isAfterLast(); cursor.moveToNext()) {
oneyizuo=cursor.getString(cursor.getColumnIndex("yizuoti_id"));
oneyizuos.add(oneyizuo);
}
}
cursor.close();
sqLiteDatabase.close();
return oneyizuos;
}
//科目1 条件查询错题ID,删除某个错题
public boolean deleteYi(int id){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
boolean flag=false;
int temp=sqLiteDatabase.delete("noright", "cuoti_id=?", new String[]{String.valueOf(id)});
if(temp>0){
flag=true;
}
sqLiteDatabase.close();
return flag;
}
//************************************************
//科目四 添加错题的方法
public boolean insertDataSi(String cuoti_id){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
boolean flag=false;
ContentValues values=new ContentValues();
String selectID=CuoTiService.selectDataSi(cuoti_id);
if(selectID==null || selectID.equals("")){
values.put("cuoti_id", cuoti_id);
long temp=sqLiteDatabase.insert("norightSi", null, values);
sqLiteDatabase.close();
if(temp>0){
flag=true;
}
return flag;
}else{
if(cuoti_id.equals(selectID)){
flag=false;
return flag;
}else{
long temp=sqLiteDatabase.insert("norightSi", null, values);
sqLiteDatabase.close();
if(temp>0){
flag=true;
}
return flag;
}
}
}
//科目4 条件查询数据库,错题id如果已经存在,则不保存
public static String selectDataSi(String cuoid){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
String oneCuo = null;
Cursor cursor=sqLiteDatabase.query("norightSi", null, "cuoti_id=?", new String[]{cuoid}, null, null, null);
if(cursor.moveToNext()){
oneCuo=cursor.getString(cursor.getColumnIndex("cuoti_id"));
}
sqLiteDatabase.close();
cursor.close();
return oneCuo;
}
//科目4 条件查询数据库,返回所有错题id
public static List<String> cuotiDatasi(){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
String oneCuo = null;
List<String> oneCuos = new ArrayList<String>();
Cursor cursor=sqLiteDatabase.query("norightSi", null, null, null, null, null, null);
if(cursor.moveToFirst()) {
for(; !cursor.isAfterLast(); cursor.moveToNext()) {
oneCuo=cursor.getString(cursor.getColumnIndex("cuoti_id"));
oneCuos.add(oneCuo);
}
}
cursor.close();
sqLiteDatabase.close();
return oneCuos;
}
//科目4 条件查询错题ID,删除某个错题
public boolean deleteSi(int id){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
boolean flag=false;
int temp=sqLiteDatabase.delete("norightSi", "cuoti_id=?", new String[]{String.valueOf(id)});
if(temp>0){
flag=true;
}
sqLiteDatabase.close();
return flag;
}
//科目4已做题id
public static boolean insertYiZuoDataSi(String yizuoidSi) {
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
boolean flag=false;
ContentValues values=new ContentValues();
String selectID=CuoTiService.selectYiZuoId(yizuoidSi);
if(selectID==null || selectID.equals("")){
values.put("yizuotisi_id", yizuoidSi);
long temp=sqLiteDatabase.insert("yizuotisi", null, values);
sqLiteDatabase.close();
if(temp>0){
flag=true;
}
return flag;
}else{
if(yizuoidSi.equals(selectID)){
flag=false;
return flag;
}else{
long temp=sqLiteDatabase.insert("yizuotisi", null, values);
sqLiteDatabase.close();
if(temp>0){
flag=true;
}
return flag;
}
}
}
//科目4 条件查询数据库,已做题id如果已经存在,则不保存
public static String selectYiZuoIdSi(String yizuoidSi){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
String oneyizuo = null;
Cursor cursor=sqLiteDatabase.query("yizuotisi", null, "yizuotisi_id=?", new String[]{yizuoidSi}, null, null, null);
if(cursor.moveToNext()){
oneyizuo=cursor.getString(cursor.getColumnIndex("yizuotisi_id"));
}
sqLiteDatabase.close();
cursor.close();
return oneyizuo;
}
//科目4条件查询字段,返回整个字段数据,list
public List<String> getyizuosi(){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
String oneyizuo = null;
List<String> oneyizuos=new ArrayList<String>();
Cursor cursor=sqLiteDatabase.query("yizuotisi", null, null, null, null, null, null);
if(cursor.moveToFirst()) {
for(; !cursor.isAfterLast(); cursor.moveToNext()) {
oneyizuo=cursor.getString(cursor.getColumnIndex("yizuotisi_id"));
oneyizuos.add(oneyizuo);
}
}
cursor.close();
sqLiteDatabase.close();
return oneyizuos;
}
/**
* 考试记录 科目一
*/
public boolean insertKaoShiYi(KaoShiYi kaoshiyi){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
boolean flag=false;
ContentValues values=new ContentValues();
values.put("chengji", kaoshiyi.getChengji());
//values.put("beizhu", kaoshiyi.getBqinfo());
values.put("use_time", kaoshiyi.getUse_time());
values.put("riqi", kaoshiyi.getRiqi());
long temp=sqLiteDatabase.insert("jiluyi", null, values);
if(temp>0){
flag=true;
}
sqLiteDatabase.close();
return flag;
}
/**
* 考试记录 科目4
*/
public boolean insertKaoShiSi(KaoShiYi kaoshiyi){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
boolean flag=false;
ContentValues values=new ContentValues();
values.put("chengji", kaoshiyi.getChengji());
//values.put("beizhu", kaoshiyi.getBqinfo());
values.put("use_time", kaoshiyi.getUse_time());
values.put("riqi", kaoshiyi.getRiqi());
long temp = sqLiteDatabase.insert("jilusi", null, values);
if(temp>0){
flag=true;
}
sqLiteDatabase.close();
return flag;
}
//查询 科目一
public ArrayList<KaoShiYi> selectYi(){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
ArrayList<KaoShiYi> yiList=new ArrayList<KaoShiYi>();
Cursor cursor=sqLiteDatabase.query("jiluyi", null, null, null, null, null, null);
while(cursor.moveToNext()){
int id=cursor.getInt(cursor.getColumnIndex("id"));
String chengji=cursor.getString(cursor.getColumnIndex("chengji"));
//String beizhu=cursor.getString(cursor.getColumnIndex("beizhu"));
String use_time=cursor.getString(cursor.getColumnIndex("use_time"));
String riqi=cursor.getString(cursor.getColumnIndex("riqi"));
KaoShiYi yi=new KaoShiYi();
yi.setId(id);
yi.setChengji(chengji);
yi.setUse_time(use_time);
yi.setRiqi(riqi);
yiList.add(yi);
}
cursor.close();
sqLiteDatabase.close();
return yiList;
}
//查询 科目4
public ArrayList<KaoShiYi> selectSi(){
DBOpenHelper dbOpenHelper=new DBOpenHelper(context);
SQLiteDatabase sqLiteDatabase=dbOpenHelper.getWritableDatabase();
ArrayList<KaoShiYi> yiList=new ArrayList<KaoShiYi>();
Cursor cursor=sqLiteDatabase.query("jilusi", null, null, null, null, null, null);
while(cursor.moveToNext()){
int id=cursor.getInt(cursor.getColumnIndex("id"));
String chengji=cursor.getString(cursor.getColumnIndex("chengji"));
//String beizhu=cursor.getString(cursor.getColumnIndex("beizhu"));
String use_time=cursor.getString(cursor.getColumnIndex("use_time"));
String riqi=cursor.getString(cursor.getColumnIndex("riqi"));
KaoShiYi yi=new KaoShiYi();
yi.setId(id);
yi.setChengji(chengji);
yi.setUse_time(use_time);
yi.setRiqi(riqi);
yiList.add(yi);
}
cursor.close();
sqLiteDatabase.close();
return yiList;
}
}