Inserting data from jsp form to multiple tables !

Hi,

I want to insert data from jsp form to two tables

tables are

(1)Form

formId (PK)

deptName

(2)Data

formId (FK)

sNo

description

itemCode

and the problem is that i want to save information form a jsp form to above two tables and i have only one form.

so how do i insert data from a jsp form to multiple tables.

[397 byte] By [khan_vu2007a] at [2007-11-27 8:51:08]

«« regarding ConcurrentLinkedQueue
»» Multi thread

# 1

You already know what your form in the jsp will be and what fields they are. You also already know what your database looks like. Using one form, you should be able to break the data down, and give it certain ids and/or names, so that when the form is submitted, you retrieve the correct values corresponding to a specific field and insert it.

Unless there is something else I am not catching, this seems pretty straight forward.

kdajania at 2007-7-12 21:03:47 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Inserting data from jsp form to multiple tables !

Database Connectivity Hot Topic

Database Connectivity

All Classified