Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

showing variable field from database. table.

 
Harshal Gurav
Ranch Hand
Posts: 151
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 151
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
can any one help me to push Forward.
Thanks in advance
Regards
Harshal
 
Rajkumar balakrishnan
Ranch Hand
Posts: 445
Android Eclipse IDE Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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..
 
Harshal Gurav
Ranch Hand
Posts: 151
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 445
Android Eclipse IDE Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Harshal, I hope this link may help you...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic