how to accessing sqlite database from java class

Question

I have created sqlite database using phonegap. I am able to access that databse within the javascript. But I want access that sqlitedatabase from java class. It is possible?

Is phone gap that web development thing? If so you'll need to load your sqlite stuff through code that is then compiled. There's loads of stuff about this online: vogella.de/articles/AndroidSQLite/article.html — ingh.am
– ingh.am, Commented Jan 23, 2012 at 9:41
Are you really accessing your database through javascript though? This seems rather insecure but I'm not experienced enough with phone gap to say it for sure... — ingh.am
– ingh.am, Commented Jan 23, 2012 at 9:42

NovusMobile · Accepted Answer · 2012-01-23 09:52:32Z

1

For PhoneGap --SQLite you can use Pluggin available on GIT HUB. there is javafile also.please check out the link:Sqlite Database

answered Jan 23, 2012 at 9:52

NovusMobile

1,8332 gold badges22 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stephen Quan · Accepted Answer · 2012-01-23 09:40:43Z

1

I don't know about PhoneGap compatibility, but, as far as Android, WebView control and JavaScript is concern, you do have a solution.

You should consider using WebView's addJavascriptInterface.. This will expose any of your Java objects as a JavaScript object. So, you could create a class that encapsulate the SQLite functionality you want expose and sent it through.

answered Jan 23, 2012 at 9:40

Stephen Quan

27.9k4 gold badges101 silver badges94 bronze badges

Comments

Siva Natarajan · Accepted Answer · 2012-01-23 10:27:27Z

1

As said above in the answer by BicycleDude. U need to create a class and expose it and use it inside javascript.

http://groups.google.com/group/phonegap/browse_thread/thread/eb9c4a350482f86f

This link contains the reference to make toast inside javascript.U can use this similarly to access database.One problem is how u handle the returned cursor.may be u can use JSON

answered Jan 23, 2012 at 10:27

Siva Natarajan

1,4293 gold badges27 silver badges48 bronze badges

2 Comments

rams Over a year ago

thanks for your reply. but I am getting null pointer exception at appview in the following code WebView appView = (WebView) findViewById(R.id.webView1); MyToaster toaster = new MyToaster(this, appView); appView.addJavascriptInterface(toaster,"MyToaster");

Siva Natarajan Over a year ago

just follow that it works perfectly fine for me. WebView appView = (WebView) findViewById(R.id.webView1); is not required i think

Collectives™ on Stack Overflow

how to accessing sqlite database from java class

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related