java - How to use My Sqlite Database in Android -
i using database in application, make database in sqlite browser , tried in application guide link, , when try in eclipse running project phone , application success call database in case try copy apk application folder bin in android , install it.. when install apk file application error cannot call database.. , never call database again.. please me.. here code :
databasehelper.java
public class databasehelper extends sqliteopenhelper{ //the android's default system path of application database. private static string db_path = "/data/data/com.apps.visitkuningan/databases/"; private static string db_name = "db_keterangan.sqlite3"; private sqlitedatabase mydatabase; private final context mycontext; /** * constructor * takes , keeps reference of passed context in order access application assets , resources. * @param context */ public databasehelper(context context) { super(context, db_name, null, 1); this.mycontext = context; } /** * creates empty database on system , rewrites own database. * */ public void createdatabase() throws ioexception{ boolean dbexist = checkdatabase(); if(dbexist){ //do nothing - database exist }else{ //by calling method , empty database created default system path //of application gonna able overwrite database our database. this.getreadabledatabase(); try { copydatabase(); } catch (ioexception e) { throw new error("error copying database"); } } } /** * check if database exist avoid re-copying file each time open application. * @return true if exists, false if doesn't */ private boolean checkdatabase(){ sqlitedatabase checkdb = null; try{ string mypath = db_path + db_name; checkdb = sqlitedatabase.opendatabase(mypath, null, sqlitedatabase.open_readonly); }catch(sqliteexception e){ //database does't exist yet. } if(checkdb != null){ checkdb.close(); } return checkdb != null ? true : false; } /** * copies database local assets-folder created empty database in * system folder, can accessed , handled. * done transfering bytestream. * */ private void copydatabase() throws ioexception{ //open local db input stream inputstream myinput = mycontext.getassets().open(db_name); // path created empty db string outfilename = db_path + db_name; //open empty db output stream outputstream myoutput = new fileoutputstream(outfilename); //transfer bytes inputfile outputfile byte[] buffer = new byte[1024]; int length; while ((length = myinput.read(buffer))>0){ myoutput.write(buffer, 0, length); } //close streams myoutput.flush(); myoutput.close(); myinput.close(); } public void opendatabase() throws sqlexception{ //open database string mypath = db_path + db_name; mydatabase = sqlitedatabase.opendatabase(mypath, null, sqlitedatabase.open_readonly); } @override public synchronized void close() { if(mydatabase != null) mydatabase.close(); super.close(); } @override public void oncreate(sqlitedatabase db) { } @override public void onupgrade(sqlitedatabase db, int oldversion, int newversion) { } // add public helper methods access , content database. // return cursors doing "return mydatabase.query(....)" it'd easy // create adapters views. } this code using query :
public class ketwisata extends activity{ intent arah; string tampilarah; string tempat; bundle bundel2 = new bundle(); cursor cur; cursor cur2; @override protected void oncreate(bundle savedinstancestate) { // todo auto-generated method stub super.oncreate(savedinstancestate); this.requestwindowfeature(window.feature_no_title); setcontentview(r.layout.ket_data); string tampil = getintent().getextras().getstring("key"); imageview img1 = (imageview) findviewbyid(r.id.gambar); textview nama = (textview) findviewbyid(r.id.nama); textview alamat = (textview) findviewbyid(r.id.alamat); textview keterangan = (textview) findviewbyid(r.id.keterangan); button arahkan = (button) findviewbyid(r.id.arahkan); // create database databasehelper mydbhelper = new databasehelper( this.getapplicationcontext()); mydbhelper = new databasehelper(this); sqlitedatabase db = mydbhelper.getreadabledatabase(); arahkan.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { startactivity(arah); } }); if(tampil.equalsignorecase("wis_balongdalem")) { img1.setbackgroundresource(r.drawable.wis_balong); nama.settext("balong dalem"); tempat="balong dalem"; tampilarah ="balong dalem"; } if(tampil.equalsignorecase("wis_curugbangkong")) { img1.setbackgroundresource(r.drawable.wis_bangkong); nama.settext("curug bangkong"); tempat="curug bangkong"; tampilarah ="curug bangkong"; } if(tampil.equalsignorecase("wis_buperciberem")) { img1.setbackgroundresource(r.drawable.wis_ciberem); nama.settext("bumi perkemahan cibeureum"); tempat="bumi perkemahan cibeureum"; tampilarah ="bumi perkemahan cibeureum"; } if(tampil.equalsignorecase("wis_cibulan")) { img1.setbackgroundresource(r.drawable.wis_cibulan); nama.settext("wisata cibulan"); tempat="cibulan"; tampilarah ="cibulan"; } if(tampil.equalsignorecase("wis_balongcicerem")) { img1.setbackgroundresource(r.drawable.wis_situ); nama.settext("situ cicereum"); tempat="situ ciceureum"; tampilarah ="situ ciceureum"; } if(tampil.equalsignorecase("wis_balongcigugur")) { img1.setbackgroundresource(r.drawable.wis_cigugur); nama.settext("wisata cigugur"); tempat="wisata cigugur"; tampilarah ="wisata cigugur"; } if(tampil.equalsignorecase("wis_curugcilengkrang")) { img1.setbackgroundresource(r.drawable.wis_cilengkrang3); nama.settext("lembah cilengkrang"); tempat="lembah cilengkrang"; tampilarah ="lembah cilengkrang"; } if(tampil.equalsignorecase("wis_cipari")) { img1.setbackgroundresource(r.drawable.wis_cipari2); nama.settext("taman purbakala cipari"); tempat="taman purbakala cipari"; tampilarah ="taman purbakala cipari"; } if(tampil.equalsignorecase("wis_balongdarmaloka")) { img1.setbackgroundresource(r.drawable.wis_darmaloka2); nama.settext("balong darmaloka"); tempat="balong darmaloka"; tampilarah ="balong darmaloka"; } if(tampil.equalsignorecase("wis_linggarjati")) { img1.setbackgroundresource(r.drawable.wis_linggarjat2i); nama.settext("linggarjati indah"); tempat="linggarjati indah"; tampilarah ="linggarjati indah"; } if(tampil.equalsignorecase("wis_guamaria")) { img1.setbackgroundresource(r.drawable.wis_guamaria); nama.settext("gua maria"); tempat="gua maria"; tampilarah ="gua maria"; } if(tampil.equalsignorecase("wis_gedungnaskah")) { img1.setbackgroundresource(r.drawable.wis_muslinggar2); nama.settext("gedung perundingan linggarjati"); tempat="gedung perundingan linggarjati"; tampilarah ="gedung perundingan linggarjati"; } if(tampil.equalsignorecase("wis_buperpalutungan")) { img1.setbackgroundresource(r.drawable.wis_palutungan2); nama.settext("bumi perkemahan palutungan"); tempat="bumi perkemahan palutungan"; tampilarah ="bumi perkemahan palutungan"; } if(tampil.equalsignorecase("wis_buperpaniis")) { img1.setbackgroundresource(r.drawable.wis_paniis2); nama.settext("bumi perkemahan paniis"); tempat="bumi perkemahan paniis"; tampilarah ="bumi perkemahan paniis"; } if(tampil.equalsignorecase("wis_paseban")) { img1.setbackgroundresource(r.drawable.wis_paseban); nama.settext("gedung merapat lima"); tempat="gedung merapat lima"; tampilarah ="gedung merapat lima"; } if(tampil.equalsignorecase("wis_makamvanbeck")) { img1.setbackgroundresource(r.drawable.wis_makamvanbeck); nama.settext("situs makam van beck"); tempat="situs makam van beck"; tampilarah ="situs makam van back"; } if(tampil.equalsignorecase("wis_sanggariang")) { img1.setbackgroundresource(r.drawable.wis_sanggariang2); nama.settext("sanggariang"); tempat="sanggariang"; tampilarah ="sanggariang"; } if(tampil.equalsignorecase("wis_sangkanurip")) { img1.setbackgroundresource(r.drawable.wis_sangkanurip); nama.settext("sangkanurip alami"); tempat="sangkanurip alami"; tampilarah ="sangkanurip alami"; } if(tampil.equalsignorecase("wis_curugsidomba")) { img1.setbackgroundresource(r.drawable.wis_sidomba2); nama.settext("sidomba"); tempat="sidomba"; tampilarah ="sidomba"; } if(tampil.equalsignorecase("wis_talagaremis")) { img1.setbackgroundresource(r.drawable.wis_talagaremis2); nama.settext("talagaremis"); tempat="talagaremis"; tampilarah ="talagaremis"; } if(tampil.equalsignorecase("wis_tngc")) { img1.setbackgroundresource(r.drawable.wis_tngc); nama.settext("taman nasional gunung ciremai"); tempat="taman nasional gunung ciremai"; tampilarah ="taman nasional gunung ciremai"; } if(tampil.equalsignorecase("wis_wadukdarma")) { img1.setbackgroundresource(r.drawable.wis_waduk); nama.settext("waduk darma"); tempat="waduk darma"; tampilarah ="waduk darma"; } if(tampil.equalsignorecase("wis_tirtaagung")) { img1.setbackgroundresource(r.drawable.wis_tirtaagung); nama.settext("tirta agung mas"); tempat="tirta agung mas"; tampilarah ="tirta agung mas"; } if(tampil.equalsignorecase("wis_sangkanaqua")) { img1.setbackgroundresource(r.drawable.wis_sangkanaqua); nama.settext("sangkan resort aqua park"); tempat="sangkan resort aqua park"; tampilarah ="sangkan resort aqua park"; } if(tampil.equalsignorecase("wis_talaganilem")) { img1.setbackgroundresource(r.drawable.wis_talaganilem); nama.settext("talaga nilem"); tempat="talaga nilem"; tampilarah ="talaga nilem"; } cur = db.rawquery("select keterangan keterangan_wis nama_tempat='" + tempat + "';", null); cur2 = db.rawquery("select alamat keterangan_wis nama_tempat='" + tempat + "';", null); cur.movetoposition(0); cur2.movetoposition(0); keterangan.append(cur.getstring(0)); alamat.append(cur2.getstring(0)); // close mydbhelper.close(); bundel2.putstring("key", tampilarah); arah = new intent(ketwisata.this, arahkan.class); arah.putextras(bundel2); } } please me guys.. !!
when run eclipse phone perform build before deploying phone. after put database assets perform build before copying apk file bin or else copying apk file built before copied database
Comments
Post a Comment