I wish to produce a database application, written in Java, which will be used to provide use of database information to a pool of about 50 users. I want them to be able to use the application via their browser. Most users will be on an intranet but I want it to be accessible to a few outside the office via internet connection. In trying to plan this project,the more I've researched the problem, the more lost I've become between Apache- Tomcat- Java- JSP- Servlets- JNDI- JDC Connector- and my MySQL database. I know I need a more complex solution than JDO, but I'm really confused about what I need besides Apache server, Java, and the mySQL database. I know there is no single path but I'm makng little progress in choosing. If someone could outline a reasonable plan for this project, I think I could direct my own study more effectively. (I know this could have been done more simply with PHP and mySQL, but I want to use the opportunity to learn Java and OOP.)
Thanks for any help.