jTable Problem

Question

0.00/5 (No votes)

See more:

Hi I am just trying to do somthing in Java. I wrote a small programm in Java using JDBC connecting with MySql. I am using Netbeans 6.9
Here is my database structure -

Field       Type 	Null	Default   Description
pnr_no      int(7) 	No                 PNR No.
t_no  	    int(4) 	Yes 	NULL      Train No.
t_name      varchar(30) Yes 	NULL      Train Name
s_frm  	    varchar(30) Yes 	NULL      Station From
s_to  	    varchar(30) Yes 	NULL      Station To
j_date      date 	Yes 	NULL      Journey Date
class  	    varchar(10) Yes 	NULL      Class
p1name      varchar(30) Yes 	NULL      Passenger 1 Name
p1age  	    tinyint(2) 	Yes 	NULL      Passenger 1 Age
p1sex  	    char(1) 	Yes 	NULL      Passenger 1 Sex
p1sc  	    varchar(3) 	Yes	NULL      Passenger 1 Senior Citizen
p1berth     char(1) 	Yes 	NULL      Passenger 1 Berth
p2name      varchar(30) Yes 	NULL      Passenger 2 Name
p2age  	    int(2) 	Yes 	NULL      Passenger 2 Age
p2sex  	    char(1) 	Yes 	NULL      Passenger 2 Sex
p2sc  	    varchar(3) 	Yes 	NULL      Passenger 2 Senior Citizen
p2berth     char(1) 	Yes 	NULL      Passenger 2 Berth

Now I have a form where in I am entering records fro 2 passenger. And storing them in table. After this I want to see the history of booked ticket on basis on PNR No. in jTable but I don't know how to display records of different passengers of same PNR in saperate rows of table.
My program is displaying all passengers in singal row.
Can any one help me?
I hope I am clear on my problem.

Posted 29-Jan-11 21:41pm

vishal deb

Updated 29-Jan-11 21:53pm

Richard MacCutchan

v2

Add a Solution

Comments

DaveAuld 1-Feb-11 15:08pm

Would it be not better to have a Passenger Table and link the Passenger ID's to a Journey?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nagy Vilmos · Answer 1 · 2011-07-15T05:41:00

Split the table.

Each ticket is for one and only one passenger. A booking can be for one or more tickets.

Booking

Field       Type 	Null	Default   Description
booking_no  int(7) 	No                Booking No.
t_no  	    int(4) 	Yes 	NULL      Train No.
t_name      varchar(30) Yes 	NULL      Train Name
s_frm  	    varchar(30) Yes 	NULL      Station From
s_to  	    varchar(30) Yes 	NULL      Station To
j_date      date 	Yes 	NULL      Journey Date
class  	    varchar(10) Yes 	NULL      Class

Ticket

Field       Type 	Null	Default   Description
booking_no  int(7) 	No                Booking No.
pnr_no      int(7) 	No                PNR No.
p_name      varchar(30) Yes 	NULL      Passenger Name
p_age  	    tinyint(2) 	Yes 	NULL      Passenger Age
p_sex  	    char(1) 	Yes 	NULL      Passenger Sex
p_sc  	    varchar(3) 	Yes	NULL      Passenger Senior Citizen
p_berth     char(1) 	Yes 	NULL      Passenger Berth

Your report then joins the two tables using the field booking_no.