File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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.
 
Similar Threads
Error occured while initialising for loop:
How to retrive data two times from database in sinble jsp page.
How to store answer available in option form in database table?
Sending Email from jsp page
How to store option format value in database in jsp