Web tier: servlets, JSP, Web frameworks: automatically generation the roll number

  1. automatically generation the roll number (3 messages)

    hi ,
    i want to know how to automatically generate a roll no from the oracle table(roll no,name, etc ..) ,when i am filling a form(a roll no is already assigned) . also the steps required to connect to oracle database using jdbc & jsp .
  2. Do you need to generate sequence number for the oracle ...explain clearly what type of roll number do you want.Regarding JDBC connection go to any tutorial u will get the code to connect to the database..if still not able to do it..then let me know ..I will send you the code
  3. hi, please try to use sequences in oracle and in the insert statement you have to use sequencename.nextval to generate the next number.

  4. U can create a sequence & on the trigger on insert in that use the sequence & update the roll number field.