First let me state where i am coming from. The last time i have done any serious programming was in my last 2 years of high school where i went to a vocational school to learn computer programming, that was 4 and a half years ago. At school we covered VB, VB.net C++, java and basic html and intro to OOP. I also placed 16th place at a national programming competition in Texas for java. Anyway after school i went into the Marine Corps where i currently do intel and work on computers daily but i haven't touched my programming skills since school and i have pretty much forgotten everything.
I am currently going to be getting out after my last deployment where i will have time to start playing catchup before i goto college and go back to my first passion programming. My goal by the end of my deployment is to be able to recreate our database that i created in Access that we use to track a wide breadth of information and pull up reports.
My goal is two fold first use java as a front end and a mysql backend to store data and i need a way to display reports (this function may not happen dependant on time). second after the first part is done is to create the front end in a fully dynamic webpage system with multiple user logins with varying access to data entry and manipulation. This is my end state on what i want to be able to create.
(Program Description) The database in its current form is in Access, and on the main page has 3 buttons, journal entry (enter in incidents), personality tracker(obvious) and facility tracker. they both have numerous fields to enter in descriptions date/time and whatnot, the last 2 have the ability to insert a picture. For the journal enty one i can pull up various reports based on time and various other fields that i need.
Dilemma is since i wont have constant internet i need a good amount of books to cover what i need to learn so my question for you all is which series of books do need to accomplish my end state based on my past experience. thanks for any help.
Defiantly some good info but the only problem is i want be able to work on this with internet access i will have maybe a few minutes a day to use the internet. This is why i am looking for specifics on which series of books i should get.
Below is list of books that i was recommended to me on Sun's developer forum if anyone could give any second opinions on it that would be great.