Solved

Select components for Java web database application

Posted on 2004-03-24
3
149 Views
Last Modified: 2013-11-24
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.
0
Comment
Question by:andem
3 Comments
 
LVL 14

Assisted Solution

by:Tommy Braas
Tommy Braas earned 100 total points
ID: 10671921
Apache is a pure webserver. Tomcat is a webserver and a JSP/Servlet container. Apache and Tomcat can be integrated, not recommended though. JNDI is used for lookingup services, I doubt you will need it for your project, but it is worth looking into. JDBC is used for connecting to databases (e.g. mySQL).

Plan:
1. Learn J2SE
2. Learn J2EE
3. Choose JSP/Servlet container based on your needs (you might even need an EJB container)
4. Plan, analyze and design your application
5. Deploy your application internally first, then externally

Any and all URLs in a web application can be password protected (user authentication and authorization).
0
 
LVL 3

Accepted Solution

by:
eicheled earned 150 total points
ID: 10672155
If it were me :-)

I would use Tomcat (with or without Apache). If you are not serving a bunch of static content outside of your dynamically created data, there is not much gain in using both (and integrating them to work together can be a challenge).

I would use MySQL as a database (it's simple, free, and handles most things a basic end-user application might need).

I would use JSP. Tomcat and JSP go hand in hand, and JSP's are easier to write than servlets. In your JSP's you will produce the HTML that your end-users see based on the information from your DB.

To talk to the db (MySQL or whatever you choose) you will need JDBC (most DB's supply the necessary Java classes you need as a jar file) which you will need to use to allow your JSP's (which are being served by Tomcat) to talk to your db.

Just my $.02
0
 

Author Comment

by:andem
ID: 10677292
Thanks to both of you for your help.
Orangehead911, your succinct overview of the process reminds me of what a large task I've elected to take on and clearly delineates the broad path for me.
Eicheled, you have given me just what I wanted- a suggestion of specifically which of the myriad options I might use to accomplish this. I had thought that Tomcat had to be used as a part of Apache (the ignorance is deep!). I will definitely go the Tomcat route as almost all will be database driven dynamic content. I already have a MySQL database so there is no question there of what to use. I have downloaded  Connector/J from the MySQL site and plan to use JSPs based on your recommendation. Thinning out the forest so that I can actually see the trees is so helpful! I know I have a lot of work ahead but should now be able to approach it in a more efficient manner.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
windows explorer path to command prompt 5 54
Convert from a json string array to a Java object 3 53
Is there a simpler dropbox system? 10 34
What browser will run Java? 7 66
I had a project requirement for a displaying a user workbench .This workbench would consist multiple data grids .In each grid the user will be able to see a large number of data. These data grids should allow the user to 1. Sort 2. Export the …
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question