jTable问题 [英] jTable Problem

问题描述

嗨 我只是想用Java做某事.我使用JDBC和MySql连接，用Java编写了一个小程序.我正在使用Netbeans 6.9
这是我的数据库结构-

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

现在，我有一个表格，可以在其中输入2位乘客的记录.并将它们存储在表中.在此之后，我想根据jTable中的PNR号查看预订机票的历史记录，但是我不知道如何在表格的无菌行中显示同一PNR的不同乘客的记录.
我的程序将所有乘客显示在单行中.
有人可以帮我吗?
我希望我能清楚地解决我的问题.

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.

推荐答案

拆分表.

每张票仅可容纳一名乘客.预订可以是一张或多张票.

Booking

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

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

然后，您的报告将使用字段booking_no将两个表连接起来.

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

这篇关于jTable问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！