MySQL Database Connectivity - Java for Android App Development

Hey people,
I have a website service that is built upon a MySQL database. I am trying to code an android app for the same, however I am not able to link my app to fetch and throw data at the database?
Can you help me understand the concept better?
My database is set up on a server over the Internet. How can I have my android app fetch data from it directly?
Thanks, in advance
Sent from my HTC Explorer A310e using xda app-developers app

cyberbeast said:
Hey people,
I have a website service that is built upon a MySQL database. I am trying to code an android app for the same, however I am not able to link my app to fetch and throw data at the database?
Can you help me understand the concept better?
My database is set up on a server over the Internet. How can I have my android app fetch data from it directly?
Thanks, in advance
Sent from my HTC Explorer A310e using xda app-developers app
Click to expand...
Click to collapse
I think you have first to create a webpage server side in PHP and you list the content so you can through PHP commands send requests to your db.
xpirt

Thanks for that, xpirt
Is there a way to do that without using an intermediate php script? A more direct method, which can be implemented within the app itself?
The method you explained is what I wanna keep as my last resort.
Sent from my HTC Explorer A310e using xda app-developers app

cyberbeast said:
Thanks for that, xpirt
Is there a way to do that without using an intermediate php script? A more direct method, which can be implemented within the app itself?
The method you explained is what I wanna keep as my last resort.
Sent from my HTC Explorer A310e using xda app-developers app
Click to expand...
Click to collapse
I don't know. I'm a PHP programmer and I know only with this to connect to databases, I'm a newbie in Java so I'm not able to help you
xpirt

Take a look at this link: http://zetcode.com/db/mysqljava/
The one issue that may stop you is if you don't have control over the server OS. Most hosting providers will not let you connect to mysql via internet connections.

Related

Newsgroup App??

Anyone know of any? I hate having to RDP to download stuff
Sent from my Xoom using XDA Premium App
I see a lot of apps but need one that let's me download straight to my xoom...
Sent from my Xoom using XDA Premium App
Hope to see something about this, that'll be awesome. Leeching from Xoom ...nice...!!!
Sent from my Xoom using XDA Premium App
Try nzbair.
Sent from my PC36100 using Tapatalk
dc5guy said:
Try nzbair.
Sent from my PC36100 using Tapatalk
Click to expand...
Click to collapse
How do u makeit work
Sent from my Xoom using XDA Premium App
I got NewzDroid working its sweet
Sent from my Xoom using XDA Premium App
DroidHam said:
Anyone know of any? I hate having to RDP to download stuff
Sent from my Xoom using XDA Premium App
Click to expand...
Click to collapse
I'd like sabnzbd for android, that way it could download straight to the device and repair/extract after the download finishes
GetNZB (from the Market) allows you to download nzbs from nzb.org and upload to an FTP server. I use it for uploading nzbs to my NAS which polls for nzbs in a specific folder then starts downloading.
burden010 said:
GetNZB (from the Market) allows you to download nzbs from nzb.org and upload to an FTP server. I use it for uploading nzbs to my NAS which polls for nzbs in a specific folder then starts downloading.
Click to expand...
Click to collapse
Any news of an app that'll let u download newsgroup files?
DToX69 said:
I'd like sabnzbd for android, that way it could download straight to the device and repair/extract after the download finishes
Click to expand...
Click to collapse
I've got sabnzbd working on my xoom. I installed ubuntu using the guide on this forum (in android developments) once it was working a quick "apt-get sabnzbdplus"gets it installed. Then edit the /etc/default/sabnzbdlus to set the user as root.
Once its running connect to 127.0.0.1:8080 and it'll bring up the wizard.
Tada. ;-)
You can install transmisson this way as well with a quick "apt-get install transmisson-daemon" then connect to 127.0.0.1:9091
i'm looking for an app to open an nzb but download to the phone itself? i tried one last year but cant recall the name. didn't work though
tommo123 said:
i'm looking for an app to open an nzb but download to the phone itself? i tried one last year but cant recall the name. didn't work though
Click to expand...
Click to collapse
The only one I know of is NewzDroid.
EZ Usenet guys. It is for Easynews if you have an account and you can download directly to your Xoom or android device. Works great...free version has 15 days of news and paid is of course more days..
burden010 said:
The only one I know of is NewzDroid.
Click to expand...
Click to collapse
tried it last year and it wasnt good. no trial ver either afaik to test

EXCHANGE on LINUX

if somebody wants to use 'exchange activesync' with push on a LINUX Postfix server, i can tell you how to do that.
I have it running on several 1and1 servers for several customers.
Hi
Could He useful Tor know how to do this
Sent from my A500 using XDA Premium App

Need help with code..URGENT

I am building an app for which I need data from device's internal google calendar..how do I fetch and convert the list of events fetched to RSS?..
App is almost ready..please help
Sent from my ST15i using XDA App
Where are you at currently with this? Any completed parts of this, or are you looking for it 'all'?

Mobile device ID

How does one change it? I looked with build prop but no luck.
Sent from my Nexus 4 using xda app-developers app
Tunderpimp said:
How does one change it? I looked with build prop but no luck.
Sent from my Nexus 4 using xda app-developers app
Click to expand...
Click to collapse
Talking bout the Android Device ID or something different? (Titanium Backup usually lets you generate a new one, or restore one from a previous backup).
kbeezie said:
Talking bout the Android Device ID or something different? (Titanium Backup usually lets you generate a new one, or restore one from a previous backup).
Click to expand...
Click to collapse
When I get work emails from co workers it says the type of phone they are using. When they get one from me it says android and some numbers. It's the mobile device ID
Sent from my Nexus 4 using xda app-developers app
Tunderpimp said:
When I get work emails from co workers it says the type of phone they are using. When they get one from me it says android and some numbers. It's the mobile device ID
Sent from my Nexus 4 using xda app-developers app
Click to expand...
Click to collapse
Where exactly does it say this, maybe you're thinking of email signatures or such, and it would depend on the type of email client. Normally your actual android device ID isn't just arbitrarily transmitted in an email.
kbeezie said:
Where exactly does it say this, maybe you're thinking of email signatures or such, and it would depend on the type of email client. Normally your actual android device ID isn't just arbitrarily transmitted in an email.
Click to expand...
Click to collapse
It's not a signature and it's not the android device ID, they don't match. My work email pulls it off the phone. It even shows it when I set up the email. I did some research and that's how I found out it's called a mobile device ID.
Sent from my Nexus 4 using xda app-developers app
Tunderpimp said:
It's not a signature and it's not the android device ID, they don't match. My work email pulls it off the phone. It even shows it when I set up the email. I did some research and that's how I found out it's called a mobile device ID.
Sent from my Nexus 4 using xda app-developers app
Click to expand...
Click to collapse
So you're using an app specific for work then I'm guessing. If you got access to the original rom where the ID is correct, you can install titanium backup from the play store there. Then backup the settings (under preference there's a way to save the titanium backup settings to the SD Card/media space), then restore new rom, install titanium backup again, point it to the sdcard/external for it's backup, and you may be prompted with a prompt that your android ID differs from the other, and given the opportunity to restore it from backup (however bear in midn you may have to reinstall some applications that are dependent on your new ID).
There may be an easier way, but it's just weird that you have a work email that would work based off that.
It's not a host name I just tried that too.
Sent from my Nexus 4 using xda app-developers app
Sent from my U.S. Cellular© Smartphone,
Sent from my iPhone, Sent from my Verizon Wireless 4G LTE Smartphone here are some examples I found.
My emails say sent from my Androidc random numbers right after androidc
Tunderpimp said:
Sent from my U.S. Cellular© Smartphone,
Sent from my iPhone, Sent from my Verizon Wireless 4G LTE Smartphone here are some examples I found.
My emails say sent from my Androidc random numbers right after androidc
Click to expand...
Click to collapse
That looks very much like a setting you jsut set in the app/email client. Just like the iPhone has that, it's in the settings. What email client are you using, should be just like the XDA/Tapatalk app where you can modify the manual signature.
kbeezie said:
That looks very much like a setting you jsut set in the app/email client. Just like the iPhone has that, it's in the settings. What email client are you using, should be just like the XDA/Tapatalk app where you can modify the manual signature.
Click to expand...
Click to collapse
It's the stock email app that comes with the phone its yellow and white.
Sent from my Nexus 4 using xda app-developers app
Tunderpimp said:
It's the stock email app that comes with the phone its yellow and white.
Sent from my Nexus 4 using xda app-developers app
Click to expand...
Click to collapse
Oh just the standard ol email app. Double check the settings of that app , On the message list -> menu -> settings -> Tap account -> Signature
(by default nothing shows in the signature area when I send myself a test email thru my yahoo account, nor nothing in the mail headers to designate operating system)
Unless of course you're saying that it's being performed serverside.
How about in developers options their is one called device hostname and it can be edited, by default my devices all say Android-some random numbers and letters.
Sent from my Nexus 4 using xda app-developers app
illgodson said:
How about in developers options their is one called device hostname and it can be edited, by default my devices all say Android-some random numbers and letters.
Sent from my Nexus 4 using xda app-developers app
Click to expand...
Click to collapse
The mobile device id is different in the Stock email app vs the touchwiz email app. Anyone know how to change the stock mobile device id?

[Q] Restart service after kill

Hi I want to start my service after it is killed by the user or the system.
I thought about creating a second app and monitor if the service is running and if not then start it.
The problem I have with that is
- I need two apps
- It drains more battery
I hope you can help me find the best solution for my problem
Yeah, I think if you override the onDestroy method on your service class, and then you can send a broadcast from there.
In your broadcast receiver you can start the service again.
Though i have never tried it myself, i think this should work.
Tell me how it goes
Happy coding!! :thumbup:
Sent from my GT-P3100 using XDA Free mobile app
hiphop12ism said:
Yeah, I think if you override the onDestroy method on your service class, and then you can send a broadcast from there.
In your broadcast receiver you can start the service again.
Though i have never tried it myself, i think this should work.
Tell me how it goes
Happy coding!! :thumbup:
Sent from my GT-P3100 using XDA Free mobile app
Click to expand...
Click to collapse
I thought about that too but unfortunately when the app is stopped by the user the onDestroy methode is not called...
Sent from my SM-N9005 using XDA Premium 4 mobile app
If yu are using android version less than 4.4.2 then returning start sticky should do it
Sent from my GT-P3100 using XDA Free mobile app
hiphop12ism said:
If yu are using android version less than 4.4.2 then returning start sticky should work
Sent from my GT-P3100 using XDA Free mobile app
Click to expand...
Click to collapse
That is only if the system stops the service not if the user does....
Sent from my SM-N9005 using XDA Premium 4 mobile app
Rick Clephas said:
That is only if the system stops the service not if the user does....
Click to expand...
Click to collapse
I believe there is no such way... otherwise android would be very insecure for malware that just does this . You can only restart your service once the user restarts your activity, there should not be another way (and START_STICKY for the system of course). And please don't do two apps which listen for each other, if the user willingly kills your service they usually have a reason and expect that your app is not working right until they restart it.
SimplicityApks said:
I believe there is no such way... otherwise android would be very insecure for malware that just does this . You can only restart your service once the user restarts your activity, there should not be another way (and START_STICKY for the system of course). And please don't do two apps which listen for each other, if the user willingly kills your service they usually have a reason and expect that your app is not working right until they restart it.
Click to expand...
Click to collapse
I have heard that a lot but does that mean that all the security apps available on the play store can be killed by the user? :what:
Sent from my SM-N9005 using XDA Premium 4 mobile app
Rick Clephas said:
I have heard that a lot but does that mean that all the security apps available on the play store can be killed by the user? :what:
Click to expand...
Click to collapse
Sure, why not? I could uninstall my firewall on my PC if I wasn't using Ubuntu and thus don't really need one
SimplicityApks said:
Sure, why not? I could uninstall my firewall on my PC if I wasn't using Ubuntu and thus don't really need one
Click to expand...
Click to collapse
Well that is a pitty. I really thought I had seen an app that could do that...
Sent from my SM-N9005 using XDA Premium 4 mobile app
Look this app says it can't be killed by task managers https://play.google.com/store/apps/details?id=com.domobile.applock
Sent from my SM-N9005 using XDA Premium 4 mobile app
Rick Clephas said:
Look this app says it can't be killed by task managers https://play.google.com/store/apps/details?id=com.domobile.applock
Click to expand...
Click to collapse
Just an idea, it might be possible when your app is a Device Admin with the APIs that you get with that. Though you have to read it yourself, I have no clue about how it works.
SimplicityApks said:
Just an idea, it might be possible when your app is a Device Admin with the APIs that you get with that. Though you have to read it yourself, I have no clue about how it works.
Click to expand...
Click to collapse
Thanks I will look at that. Most people have my app as Device Admin because that way it can't be uninstalled
Sent from my SM-N9005 using XDA Premium 4 mobile app
Well I found the solution.
When device admin is enabled the app can't be force-stopped or uninstalled. Then the user can only stop the service and then the onDestroy methode is called so then I can restart the service again. Tanks guys :thumbup:
Sent from my SM-N9005 using XDA Premium 4 mobile app

Categories

Resources