google maps - Connection sqlite in android studio -
hye there,
my project read latitute , longitute in sqlite database. first of all, cant connect connection database sqlite. , second after connection succeed , dont know how loop data in google map.
example 1 data in database:
_id dateoc timeoc location latitude longitude
1 5-11-1961 4.30am ringlet, cameron highlands,pahang 4.415895 101.383082
thanks in advance helping me, appreciate that, sincerely, hafizul reza
private googlemap mmap; // might null if google play services apk not available. @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_maps); setupmapifneeded(); } @override protected void onresume() { super.onresume(); setupmapifneeded(); } private void setupmapifneeded() { // null check confirm have not instantiated map. if (mmap == null) { // try obtain map supportmapfragment. mmap = ((supportmapfragment) getsupportfragmentmanager().findfragmentbyid(r.id.map)) .getmap(); // check if successful in obtaining map. if (mmap != null) { setupmap(); } } } private void setupmap() { int = 1; if(i==1){ sqlitedatabase mydb = null; string tablename = "landslide"; //string data=""; mydb = this.openorcreatedatabase("landslide", mode_private, null); cursor c = mydb.rawquery("select * " + tablename, null); double column1 = c.getcolumnindex("latitude"); double column2 = c.getcolumnindex("longitude"); //int column3 = c.getcolumnindex("location"); mmap.addmarker(new markeroptions().position(new latlng(column1 , column2)).title("zasss")); } //loop through results //do { //data =data +a+"|"+b+"\n"; // }while(c.movetonext()); //} //double lat = 4.415895; //double lng = 101.383082; else //mmap.addmarker(new markeroptions().position(new latlng(column1, column2)).title("column3")); mmap.addmarker(new markeroptions().position(new latlng(3.37376388889, 101.615391667)).title("kg. sri serendah")); } }
you need create database file shown below:
public class sqlitedatabaseadapter extends activity { sqlitehelper helper; sqlitedatabase db, db1; long id, id1, id2; public sqlitedatabaseadapter(context context) { helper = new sqlitehelper(context); } // inserting data database public long insertdata(string task_name, string contact_name, string contact_number, string description, string remarks, string date, string time, string est_comp_date, string est_comp_time, string act_comp_date, string act_comp_time, string notify_date, string notify_time) { db = helper.getwritabledatabase(); contentvalues contentvalues = new contentvalues(); contentvalues.put(sqlitehelper.task_name, task_name); contentvalues.put(sqlitehelper.contact_name, contact_name); contentvalues.put(sqlitehelper.contact_number, contact_number); //contentvalues.put(sqlitehelper.contact_email, contact_email); contentvalues.put(sqlitehelper.description, description); contentvalues.put(sqlitehelper.remarks, remarks); contentvalues.put(sqlitehelper.date, date); contentvalues.put(sqlitehelper.time, time); contentvalues.put(sqlitehelper.estimated_completion_date, est_comp_date); contentvalues.put(sqlitehelper.estimated_completion_time, est_comp_time); contentvalues.put(sqlitehelper.actual_completion_date, act_comp_date); contentvalues.put(sqlitehelper.actual_completion_time, act_comp_time); contentvalues.put(sqlitehelper.notify_date, notify_date); contentvalues.put(sqlitehelper.notify_time, notify_time); id = db.insert(sqlitehelper.table_name, null, contentvalues); log.d("pana", "the value of id " + id); db.close(); return id; } public cursor getalldata() { db = helper.getwritabledatabase(); string[] columns = {sqlitehelper.uid, sqlitehelper.task_name, sqlitehelper.contact_name, sqlitehelper.contact_number, //sqlitehelper.contact_email, sqlitehelper.description, sqlitehelper.remarks, sqlitehelper.date, sqlitehelper.time, sqlitehelper.estimated_completion_date, sqlitehelper.estimated_completion_time, sqlitehelper.actual_completion_date, sqlitehelper.actual_completion_time, sqlitehelper.notify_date, sqlitehelper.notify_time}; cursor cursor = db.query(sqlitehelper.table_name, columns, null, null, null, null, null); stringbuffer buffer = new stringbuffer(); while (cursor.movetonext()) { int cid = cursor.getint(0); string taskname = cursor.getstring(1); string est_comp_time = cursor.getstring(6); buffer.append(cid + " " + taskname + " " + est_comp_time + "\n"); } if (cursor != null) { cursor.movetofirst(); } return cursor; } //obtain single row public task gettask(string id) { log.d("pana", "the value of id " + string.valueof(id)); db = helper.getreadabledatabase(); string[] columns = {sqlitehelper.uid, sqlitehelper.task_name, sqlitehelper.contact_name, sqlitehelper.contact_number, sqlitehelper.description, sqlitehelper.remarks, sqlitehelper.date, sqlitehelper.time, sqlitehelper.estimated_completion_date, sqlitehelper.estimated_completion_time, sqlitehelper.actual_completion_date, sqlitehelper.actual_completion_time, sqlitehelper.notify_date, sqlitehelper.notify_time}; cursor cursor = db.query(sqlitehelper.table_name, columns, sqlitehelper.uid + "= ?", new string[]{string.valueof(id)}, null, null, null, null); if (cursor != null) cursor.movetofirst(); task task = new task(cursor.getstring(1), cursor.getstring(2), cursor.getstring(3), cursor.getstring(4), cursor.getstring(5), cursor.getstring(6), cursor.getstring(7), cursor.getstring(8), cursor.getstring(9), cursor.getstring(10), cursor.getstring(11), cursor.getstring(12), cursor.getstring(13)); cursor.close(); return task; } } class sqlitehelper extends sqliteopenhelper { public static final string database_name = "task_management_database"; public static final string table_name = "datatable"; public static final string uid = "_id"; public static final string task_name = "task_name"; public static final string contact_name = "contact_name"; public static final string contact_number = "contact_number"; public static final string contact_email = "contact_email"; public static final string description = "description"; public static final string remarks = "remarks"; public static final string date = "date"; public static final string time = "time"; public static final string estimated_completion_date = "estcompdate"; public static final string estimated_completion_time = "estcomptime"; public static final string actual_completion_date = "actcompdate"; public static final string actual_completion_time = "actcomptime"; public static final string notify_date = "notifydate"; public static final string notify_time = "notifytime" public static final int database_version = 1; public static final string sub_task_number = "sub_task_number"; public static final string create_table = " create table " + table_name + "(" + uid + " integer primary key autoincrement, " + task_name + " varchar(250) unique," + contact_name + " varchar(250)," + contact_number + " varchar(250)," + contact_email + " varchar(250)," + description + " varchar(250), " + remarks + " varchar(250)," + date + " varchar(250)," + time + " varchar(250)," + estimated_completion_date + " varchar(250), " + estimated_completion_time + " varchar(250), " + actual_completion_date + " varchar(250), " + actual_completion_time + " varchar(250), " + notify_date + " varchar(250), " + notify_time + " varchar(250), " );"; public static final string drop_table = "drop table if exists" + table_name; // private context context; public sqlitehelper(context context) { // todo auto-generated constructor stub super(context, database_name, null, database_version); } // method executed first @override public void oncreate(sqlitedatabase db) { try { db.execsql(create_table); } catch (sqlexception e) { // todo auto-generated catch block e.printstacktrace(); } } @override public void onupgrade(sqlitedatabase db, int oldversion, int newversion) { // todo auto-generated method stub try { db.execsql(drop_table); } catch (sqlexception e) { // todo auto-generated catch block e.printstacktrace(); } oncreate(db); } } i have shown sample example of creating database in android, how insert data , how read data. need follow , modify per application. inner class extends sqliteopenhelper , attributes accessed main class.
hope helps you.
Comments
Post a Comment