wood burning stoves 2.0*
The moose likes JSP and the fly likes How to store option format  value in database in jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Reply locked New topic
Author

How to store option format value in database in jsp

Harshal Gurav
Ranch Hand

Joined: May 29, 2008
Posts: 151
Hi,
I have one jsp page containing 2o questions retrieved from table along with its possible four-option answer in this manner:
Question1:
Option-a
Option-b
Option-c
Option-d
All the options are in radio button form. I am trying to store the result of these question test in my final output table:
Structure of this table is:

Eventide -> int(2)->data from another event table->getting value in update table
Question id ->int(2) ->data from questionbank table-> getting value in update table

Serialno ->int(3) ->no. from questionbank table
Answer -> varchar(2) -> value of the option selected from below question page>
So structure of final table will be:
Event-id question-id serial-no answer
Same Same 1 a/b/c/d
For all For all 2 a/b/c/d
Question question 3 a/b/c/d



So, How it is possible to store the result of all question with answer equals to one of the four options in the same row of questioned.
Is there required in looping in my insertdata.jsp page.
Here questioned is same for all questions:
Here is fillquestion.jsp page:


And here is an my insertdata.jsp page
I am not sure about the code written in this page, kindly provide update


Thanks and Regards
Harshal

Thanks in advance
Amit Ghorpade
Bartender

Joined: Jun 06, 2007
Posts: 2716
    
    6

Please do not post the same question multiple times.


SCJP, SCWCD.
|Asking Good Questions|
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to store option format value in database in jsp
 
Similar Threads
Error occured while initialising for loop:
Session management problem
Sending Email from jsp page
How to retrive data two times from database in sinble jsp page.
How to store answer available in option form in database table?