crate a website development in JSP

[rajvaishnav1989]

Hello,
i am develop website in jsp as per our final year project rule of college.my project is public transportation.i am creating site for it.
now my problem is to create database for bus train and flight ticket reservation..
how can i create database for it and also journey table for it..

table-station
station id(p)
station name

journey-table
journey-id(p)

train-table
train-id

seat-table
seat id(p)
train id(f)
seattype(p)

journey-table
train-journey(p)
journey id(f)
train id(f)

journey station-table
journeyid (f)
stationid(f)

i have to match source to destination by users and available train details how it is possible..??plz send me reply

i want to do this
source station=
destination=
and get available trains list
and also ticket price calculation....

[jwenting]

it's easy to create a database.
Just follow the installation instructions for your chosen database engine, and then read the manual on how to use it.

[rajvaishnav1989]

but sir i can create database but i want to use in jsp page how it is possible i dont know how to plan journey and how to manage data of tables.......so plz help me

[jwenting]

time to run through some tutorials about Java before you start thinking about such things.
If you had, you'd have known at least what you need to use, and have some idea as to where to find more information.

Sun/Oracle have good tutorials...

[rajvaishnav1989]

hello sir if u have any link for tutorial plz give mr i ill refer that...........
ThanX in advance...

[brynFlew]

you could use jsp+javaBean

Here is a tutorial:
http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/JSPBeans2.html

Here is a O'Riley book:
http://books.google.com/books?id=15wp6fmAy4sC&lpg=PP1&dq=head%20first%20servlets%20and%20jsp%202nd%20edition&pg=PP1#v=onepage&q&f=false

Here is an example of form processing(make sure it implements Serializable):
http://www.exampledepot.com/egs/javax.servlet.jsp/myform.jsp.html

good luck