Servlets, JSP Pages, SQL, Tomcat help please!
Hi guys,
Basically, I've got this CRUD (Create, Retrieve, Update, Delete) project to code using HTML, JSP, Java servlets as well as an SQL database.
I really need some help as to how best to code this entire program.
I've got a Staff class and several different attributes and I need help on how best the users of my program can manipulate the data in the SQL database via HTML/JSP web pages.
If anyone has an actual program's source code they are willing to share, I would be most grateful. However, seeing as that IS a fairly unreasonable request, I would be just as happy if anyone can provide accurate and in-depth reference material on these topics.
Please don't give me java websites and general tutorials. I need information that is very specific regarding the topics I've mentioned as I only have a couple of weeks to complete the project.
Thank you VERY MUCH in advance.
[933 byte] By [
Rizzeicha] at [2007-11-26 15:44:43]
# 2
Your question is really to broad for a 'forum sized' answer. Here is my take on a condensed answer.
1. sketch (pen and paper) each page you will need. There will be two basic types of pages: user input and application output.
2. for each user input page you will need a servlet to handle the request. Typically the servlet will also be creating one of the output pages.
3. build JSPs for each page and have the JSP get its data from something such as Hashmap pageData;
4. Code everything and pass each jsp a pageData with canned data to test the page and page flow.
5. add business logic to the servlets after you have the pages working.
-=beeky
# 4
> I have done something not completely siml but
> somewhat same.....
>
> i guess u want the html file to enter in the fields
> and then u want to invoke a servlet which will inturn
> make sure everything goes into the SQL database by
> making connections is this wat u want...?
Yes, you've got it quite right.
Thanks for the help you guys. A few problems though. I have NO IDEA what's Hashmap pageData =P
Regarding struts, that's actually going to be taught a lil' later in the course, meaning I shouldn't actually be using the strut approach at this point.
What I actually needed was... in a way, reference sources which (maybe) had sample mini-programs, or some sort of template I could use which satisfies what I've listed.
