This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JSP and the fly likes showing variable field from database. table. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » JSP
Bookmark "showing variable field from database. table. " Watch "showing variable field from database. table. " New topic
Author

showing variable field from database. table.

Harshal Gurav
Ranch Hand

Joined: May 29, 2008
Posts: 151
Hi All Javarancher,
Kindly give me some guidelines regarding below issue.
I am developing Student feedback system to provide feedback about faculty to in institution.
Now I have three tables in database :
1.Questionid containing column as id, questionid-description, type
2.event table containing column eventid ,eventdescription,questioned-description(contain same data as like questionid-description from Questionid table ) publish , targetgroup.
3.QuestionBank table contain column questionno., questionedid-description(contain same data as like questionid-description from Questionid table),question-name, option-A,option-B, option-c,option-d, and Other.

Now when particular user log in, it will shows welcometoevent.jsp page contains the event-desription from event table which has column publish=�yes�.
When user click on particular event, in next question-fill.jsp it should show all the question available in QuestionBank related to that particular question-id.
The question in multiple choice- form like
1.Question-description
a.option-a
b.option-b like.
Now can any one assist me how to show this variable no. of question with 4-option in question-fill.jsp page page as no. of question for particular event may varies from 20 to 60 .

Here is an my welcometoevent.jsp page:showing all event has publish="yes".

Kindly assist me.
Thanks and Regards
Harshal
[ July 17, 2008: Message edited by: Harshal Gurav ]
Harshal Gurav
Ranch Hand

Joined: May 29, 2008
Posts: 151
Hi,
can any one help me to push Forward.
Thanks in advance
Regards
Harshal
Rajkumar balakrishnan
Ranch Hand

Joined: May 29, 2008
Posts: 445

What you need to do? When i run your JSP page it shows all the data's in the DB and i don't know what you expect to do? .... Please clear my doubt..


Never try to be a hard-worker. Be a smart-worker.
My Blog
Harshal Gurav
Ranch Hand

Joined: May 29, 2008
Posts: 151
Hi Rajkumar,
See in first jsp page I am displaying the data from event description column available in event table. The table has one column questionid-description which is also included in other two table namely Questionid and Questionbank:
Questionbank table contains various question for particular question-id-description
Take e.g.
In questionbank table
Questionid description- feedback about abc course held during may-2008
(The above information is also in questionid and eventide table)
questionbank structure like:
like for particular Q-id-descr there may be vaiable no.of question and from evevtid table there is an various event related to Q-id-descr.
Now when I click on the particular event then in next page I am trying to show all the Qname In following format:
Now how can i dispay the above page for variable no. of question in the same format?
Hope this will help you for understanding.

Thanks and regards
Harshal
Rajkumar balakrishnan
Ranch Hand

Joined: May 29, 2008
Posts: 445

Harshal, I hope this link may help you...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: showing variable field from database. table.