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
| package data.menu;
import org.xmlpull.v1.XmlPullParser;
import com.example.menu.FilmAdapter;
import com.example.menu.R;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
import android.widget.ListView;
public class DatabaseFilm extends SQLiteOpenHelper {
private SQLiteDatabase db;
private DatabaseFilm databaseFilm;
public DatabaseFilm(Context context, String name,
CursorFactory factory,int version){
super(context, name, factory, version);
databaseFilm = new DatabaseFilm(getBaseContext(), "dbFilm.db", null, 1);
db = databaseFilm.getWritableDatabase();
db.setLockingEnabled(false);
db.execSQL("DROP TABLE IF EXISTS tab_film");
databaseFilm.onCreate(db);
result = db.rawQuery("SELECT * FROM tab_film", null);
int nbrCol = result.getColumnCount();
Log.i("ENI", "Data = " + String.valueOf(nbrCol));
try{
XmlPullParser xmlPullParser=getResources().getXml(R.xml.doc);
while (xmlPullParser.getEventType()!=XmlPullParser.END_DOCUMENT){
if (xmlPullParser.getEventType()==XmlPullParser.START_TAG) {
if (xmlPullParser.getName() .equals("dvd")) {
ContentValues contentValues = new ContentValues();
contentValues.put("cat", xmlPullParser.getAttributeValue(0));
contentValues.put("titre", xmlPullParser.getAttributeValue(1));
contentValues.put("real", xmlPullParser.getAttributeValue(2));
contentValues.put("img", xmlPullParser.getAttributeValue(3));
Log.i("ENI", "Titre = " +contentValues.getAsString("titre"));
}
}
xmlPullParser.next();
}
} catch (Exception e){
Log.i("ENI", "Erreur = " + e.getMessage());
e.printStackTrace();
}
}
@Override
public void onCreate(SQLiteDatabase db) {
String strReq = "CREATE TABLE tab_film (id INTEGER PRIMARY KEY AUTOINCREMENT, cat TEXT, titre TEXT, real TEXT);";
db.execSQL(strReq);
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2){
}
} |
Partager