954,545 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Android: Import data in excel to mySQL database using java

My project scope is on android forensic.

1. After extracting all the information from an android phone, the information is saved to an excel file. Currently, I'm trying to transfer all the data saved in the excel file to MySQL database in Java.

2. After which, implement a feature that sorts all the data extracted in a time-based(earliest to latest timing)order, like a timeline. And I'm unsure how to go about implementing this. Thanks

Current platform used:Eclipse/SQL

androidf
Newbie Poster
15 posts since Jan 2012
Reputation Points: 10
Solved Threads: 0
 

1) In same time as you add these data to Excel you can call a method to save it also in database (You know you have these data in some sort of object which is once used to store it in excel, but you can reuse it and forward to database)

2) What sort you looking for, just by name, type, date some specific info? Is this all gone be run on Android device or is it also desktop application?

peter_budo
Code tags enforcer
Moderator
15,436 posts since Dec 2004
Reputation Points: 2,806
Solved Threads: 902
 

1. Will attempt to transfer data by reusing the method. Thanks:)

2. It is an desktop application. The desktop application is already done, it can extract all the data from the phone such as messages, call logs and more android apps. Once data from the phone is extracted, I would like to sort all the extracted data by the Type, Timestamp(date/time), remote party and description of the application.

androidf
Newbie Poster
15 posts since Jan 2012
Reputation Points: 10
Solved Threads: 0
 

I though this was entirely Android based project and that was reason why I asked to post in Mobile Development. I'm moving this post to Java section as it is more appropriate.

From your other post I had feeling that you been trying to create some sort of forensic tool, but above sounds more as analysis. You may want to look into Solr use.

peter_budo
Code tags enforcer
Moderator
15,436 posts since Dec 2004
Reputation Points: 2,806
Solved Threads: 902
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: