hello friends wnat ot create sqlite databse query write below code that
public class dbhandler extends sqliteopenhelper { // static variables // database version private static final int database_version = 1; // database name private static final string database_name = "abc"; // contacts table name private static final string table_contacts = "user"; // contacts table columns names private static final string key_id = "id"; private static final string key_email = "email"; private static final string key_name = "pin"; private static final string key_ph_no = "key"; public dbhandler(context context) { super(context, database_name, null, database_version); system.out.println("call"); } // creating tables @override public void oncreate(sqlitedatabase db) { string create_contacts_table = "create table " + table_contacts + "(" + key_id + " integer primary key," + key_email + " text,"+ key_name + " text," + key_ph_no + " text" + ")"; db.execsql(create_contacts_table); } // upgrading database @override public void onupgrade(sqlitedatabase db, int oldversion, int newversion) { // drop older table if existed db.execsql("drop table if exists " + table_contacts); // create tables again oncreate(db); } }
main.java
public class androidsqlitetutorialactivity extends activity { /** called when activity first created. */ @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); databasehandler db = new databasehandler(this); } }
when run above code not create database in file explore option of emulator idea how can solve? suggestions applicable
you can find created database, named
in
/data/data/<your-application-package-name>/databases/<your-database-name>
pull out using file explorer , rename have .db3 extension use in sqliteexplorer
use file explorer of ddms navigate emulator directory.
Comments
Post a Comment