1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
| public class BddAdapt {
private static final int BASE_VERSION = 1;
private static final String BASE_NOM = "verbes.db";
private static final String TABLE_VERBES = "table_verbes";
private static final String COLONNE_ID = "id";
private static final int COLONNE_ID_ID = 0;
private static final String COLONNE_INF ="inf";
private static final int COLONNE_INF_ID= 1;
private static final String COLONNE_PRET = "pret";
private static final int COLONNE_PRET_ID= 2;
private static final String COLONNE_PARTPASS = "partpass";
private static final int COLONNE_PARTPASS_ID= 3;
private static final String COLONNE_TRAD = "trad";
private static final int COLONNE_TRAD_ID= 4;
private static final String[] REQ_ALLCOLONNE = {COLONNE_ID,COLONNE_INF,COLONNE_PRET,COLONNE_PARTPASS,COLONNE_TRAD};
private SQLiteDatabase maBDD;
private BDD bddHelper;
public BddAdapt(Context context) {
// TODO Auto-generated constructor stub
bddHelper = new BDD(context, BASE_NOM,null,BASE_VERSION);
// this.open();
// bddHelper.onCreate(maBDD);
}
public SQLiteDatabase open(){
maBDD = this.bddHelper.getWritableDatabase();
return this.maBDD;
}
public void close()
{
this.maBDD.close();
}
public String colonneModif(String[] allColonne){
String req = "";
for(int i=0;i<allColonne.length;i++){
req+=allColonne[i];
if(i !=allColonne.length-1 )
req+=",";
}
return req;
}
public long Insert(Verbes v){
ContentValues cv = new ContentValues();
cv.put(COLONNE_INF,v.getInf());
cv.put(COLONNE_PARTPASS,v.getPartPass());
cv.put(COLONNE_PRET,v.getPret());
cv.put(COLONNE_TRAD,v.getTrad());
return this.maBDD.insert(TABLE_VERBES,null,cv);
// String sql = "INSERT INTO "+TABLE_VERBES+" ("+colonneModif(REQ_ALLCOLONNE)+") VALUES ("+null+","+v.getInf()+","+v.getPret()+","+v.getPartPass()+","+v.getTrad()+")" ;
//
// this.maBDD.execSQL(sql);
}
private Verbes cursorToVerbe(Cursor c){
if(c.getCount()==0){
return null;
}
Verbes v = new Verbes();
v.setInf(c.getString(COLONNE_INF_ID));
v.setPartPass(c.getString(COLONNE_PARTPASS_ID));
v.setPret(c.getString(COLONNE_PRET_ID));
v.setTrad(c.getString(COLONNE_TRAD_ID));
v.setId(c.getInt(COLONNE_ID_ID));
c.close();
return v;
}
public Verbes getVerbesByTrad(String trad){
//String[] args = new String[] {COLONNE_ID,COLONNE_INF,COLONNE_PRET,COLONNE_PARTPASS,COLONNE_TRAD};
Cursor c =this.maBDD.query(TABLE_VERBES, new String[] {COLONNE_ID,COLONNE_INF,COLONNE_PRET,COLONNE_PARTPASS,COLONNE_TRAD},COLONNE_TRAD+" LIKE "+trad , null,null, null,null);
//Cursor c =this.maBDD.query(TABLE_VERBES,new String[] {COLONNE_ID,COLONNE_INF,COLONNE_PRET,COLONNE_PARTPASS,COLONNE_TRAD},null,null, null,COLONNE_TRAD+" LIKE "+trad, null);
//Cursor c = this.maBDD.query(TABLE_VERBES, args, null, null,null,COLONNE_TRAD+" LIKE "+trad,null);
return cursorToVerbe(c);
}
public Verbes getVerbesById(int id){
Cursor c = this.maBDD.query(TABLE_VERBES, REQ_ALLCOLONNE, null, null,null,COLONNE_ID+" = " +id,null);
return cursorToVerbe(c);
}
public ArrayList<Verbes> getAllVerbes()
{
Cursor c = this.maBDD.query(TABLE_VERBES, REQ_ALLCOLONNE, null, null,null,null,null);
return cursorToAllVerbes(c);
}
private ArrayList<Verbes> cursorToAllVerbes(Cursor c) {
// TODO Auto-generated method stub
if(c.getCount() == 0){
return new ArrayList<Verbes>(0);
}
ArrayList<Verbes> list = new ArrayList<Verbes>(c.getCount());
c.moveToFirst();
do{
Verbes v = new Verbes();
v.setId(c.getInt(COLONNE_ID_ID));
v.setInf((c.getString(COLONNE_INF_ID)));
v.setPartPass(c.getString(COLONNE_PARTPASS_ID));
v.setPret(c.getString(COLONNE_PRET_ID));
v.setTrad(c.getString(COLONNE_TRAD_ID));
list.add(v);
}while(c.moveToNext());
c.close();
return list;
}
public SQLiteDatabase getMaBDD() {
return maBDD;
}
} |
