i'm trying put value edittext database , value database.
i tried store values in database when button clicked in activity follows:
import android.app.activity; import android.os.bundle; import android.view.view; import android.view.view.onclicklistener; import android.widget.button; import android.widget.edittext; public class hjhj extends activity implements onclicklistener { private edittext txt,txt1; button b; string nam; string ag; /** called when activity first created. */ @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.main); txt = (edittext) findviewbyid(r.id.edittext01); txt1= (edittext) findviewbyid(r.id.edittext02); b=(button) this.findviewbyid(r.id.button01); b.setonclicklistener(this); } @override public void onclick(view v) { // todo auto-generated method stub nam=txt.gettext().tostring(); ag=txt1.gettext().tostring(); new detailsopenhelper(this); } } detailsopenhelper:
import android.content.contentvalues; import android.database.cursor; import android.database.sqlexception; import android.database.sqlite.sqlitedatabase; import android.database.sqlite.sqliteopenhelper; public class detailsopenhelper extends sqliteopenhelper{ private static string database_name="employeedatabase"; private static final int database_version = 2; private static final string details_table_name = "employeedetails"; private static string nam; private static string ag; static string name=nam; static string age=ag; private string key_rowid; private static final string details_table_create = "create table " + details_table_name + " (" + name + " text, " + age + " text);"; private sqliteopenhelper msql; private sqlitedatabase db; public detailsopenhelper(hjhj hjhj){ super(hjhj, database_name, null,database_version ); // todo auto-generated constructor stub } @override public void oncreate(sqlitedatabase db) { // todo auto-generated method stub db.execsql(details_table_create); } @override public void onupgrade(sqlitedatabase db, int oldversion, int newversion) { // todo auto-generated method stub db.execsql("details_table_if_not_exists"); oncreate(db); } public void open() throws sqlexception { detailsopenhelper msql = new detailsopenhelper(null); db = msql.getwritabledatabase(); } private void adddetails( string nam, string ag) { sqlitedatabase db = msql.getwritabledatabase(); contentvalues values = new contentvalues(); values.put(name, nam); //values.put(time, system.currenttimemillis()); values.put(age, ag); db.insert(details_table_name, null, values); } public cursor getalldetails() { return db.query(details_table_name, new string[] { key_rowid, name, age }, null, null, null, null, null, null); } public boolean updatedetails(long rowid, string nam, string ag) { contentvalues args = new contentvalues(); args.put(name, nam); args.put(age, ag); return db.update(details_table_name, args, key_rowid + "=" + rowid, null) > 0; } } i want store , retrieve values when click button. please can me if know this. have tried lot.
also, how view database command prompt?
reminderdbadopter.java (simply java class) package com.studentdemo; import java.util.arraylist; import java.util.list; import android.content.contentvalues; import android.content.context; import android.database.cursor; import android.database.sqlexception; import android.database.sqlite.sqlitedatabase; import android.database.sqlite.sqliteopenhelper; public class remindersdbadapter { private static class databasehelper extends sqliteopenhelper { databasehelper(context context) { super(context, database_name, null, database_version); } @override public void oncreate(sqlitedatabase db) { db.execsql(database_create); } @override public void onupgrade(sqlitedatabase db, int oldversion, int newversion) { // not used, upgrade database alter // scripts } } private static final string database_name = "studinfo"; private static final string database_table = "student"; private static final int database_version = 1; public static final string username= "title"; public static final string rollnum = "id"; private databasehelper mdbhelper; private sqlitedatabase mdb; private static final string database_create = "create table " + database_table + "(" + rollnum + " integer primary key autoincrement, " + username + " text not null);"; private final context mctx; public remindersdbadapter(context ctx) { this.mctx = ctx; } public remindersdbadapter open() throws sqlexception { mdbhelper = new databasehelper(mctx); mdb = mdbhelper.getwritabledatabase(); return this; } public void close() { mdbhelper.close(); } public long createreminder(string title) { contentvalues initialvalues = new contentvalues(); initialvalues.put(username, title); return mdb.insert(database_table, null, initialvalues); } public boolean deletereminder(long rowid) { return mdb.delete(database_table, rollnum + "=" + rowid, null) > 0; } public cursor fetchallreminders() { return mdb.query(database_table, new string[] {rollnum,username}, null, null, null, null, null); } public cursor fetchreminder(long rowid) throws sqlexception { cursor mcursor = mdb.query(true, database_table, new string[] {rollnum, username, }, rollnum + "=" + rowid, null, null, null, null, null); if (mcursor != null) { mcursor.movetofirst(); } return mcursor; } public boolean updatereminder(long rowid, string title) { contentvalues args = new contentvalues(); args.put(username, title); return mdb.update(database_table, args,rollnum + "=" + rowid, null) > 0; } // sqliteopenhelper class omitted brevity // code goes here. } remindereditactivity (main activity) package com.studentdemo; import android.app.activity; import android.database.cursor; import android.os.bundle; import android.view.view; import android.widget.button; import android.widget.edittext; import android.widget.toast; public class remindereditactivity extends activity { private remindersdbadapter mdbhelper; private edittext mtitletext; private button mconfirmbutton; private long mrowid; @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); mdbhelper = new remindersdbadapter(this); setcontentview(r.layout.reminder_edit); mtitletext = (edittext) findviewbyid(r.id.title); setmconfirmbutton((button) findviewbyid(r.id.confirm)); mrowid = savedinstancestate != null ? savedinstancestate.getlong(remindersdbadapter.rollnum): null; registerbuttonlistenersandsetdefaulttext(); } private void registerbuttonlistenersandsetdefaulttext() { { mconfirmbutton.setonclicklistener(new view.onclicklistener() { public void onclick(view view) { savestate(); setresult(result_ok); toast.maketext(remindereditactivity.this, getstring(r.string.hello), toast.length_short).show(); finish(); } }); } } private void setrowidfromintent() { if (mrowid == null) { bundle extras = getintent().getextras(); mrowid = extras != null ? extras.getlong(remindersdbadapter.rollnum) : null; } } @override protected void onpause() { super.onpause(); mdbhelper.close(); } @override protected void onresume() { super.onresume(); mdbhelper.open(); setrowidfromintent(); populatefields(); } // date picker, button click events, , buttontext updating, createdialog // left out brevity // go here ... private void populatefields() { if (mrowid != null) { cursor reminder = mdbhelper.fetchreminder(mrowid); startmanagingcursor(reminder); mtitletext.settext(reminder.getstring( reminder.getcolumnindexorthrow(remindersdbadapter.username))); } } @override protected void onsaveinstancestate(bundle outstate) { super.onsaveinstancestate(outstate); outstate.putlong(remindersdbadapter.rollnum, mrowid); } private void savestate() { string title = mtitletext.gettext().tostring(); if (mrowid == null) { long id = mdbhelper.createreminder(title); if (id > 0) { mrowid = id; } } else { mdbhelper.updatereminder(mrowid, title); } } public void setmconfirmbutton(button mconfirmbutton) { this.mconfirmbutton = mconfirmbutton; } public button getmconfirmbutton() { return mconfirmbutton; } } reminder_edit.xml <?xml version="1.0" encoding="utf-8"?> <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="fill_parent"> <textview android:id="@+id/label" android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="write student information:"/> <edittext android:id="@+id/title" android:layout_width="fill_parent" android:layout_height="wrap_content" android:background="@android:drawable/editbox_background" android:layout_below="@id/label"/> <button android:id="@+id/confirm" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_below="@id/title" android:layout_alignparentright="true" android:layout_marginleft="10dip" android:text="save" /> </relativelayout> run program can find database 1.click start button in window 2.choose run 3.type adb shell(before set path of adb in mycomputer properties c:\program files\android\android-sdk-windows\platforms) 4.then type cd data cd data cd packagename cd databases sqlite3 studinfo .tables find ur table name 
Comments
Post a Comment