I have data collected by a jsp which spans multiple tables. I am trying to figure out the best way to persist the data.
For example:
TableOne
- TableOneId ( integer-autogenerated )
- MyColumnOne ( varchar(200) )
- MyColumnTwo ( varchar(200) )
TableTwo
- TableTwoId ( integer-autogenerated )
- MyColumnThree ( varchar(200) )
- MyColumnFour ( varchar(200) )
- MyColumnFive ( varchar(200) )
- MyColumnSix ( varchar(200) )
Let's say my jsp has a form with the following fields
ColOneValue:
ColTwoValue:
ColFourValue:
So, I collect all values for TableOne and one value for TableTwo.
Do I:
A) create a separate entity file for TableOne and TableTwo. Use all the values aquired by the jsp, and populate TableOne and TableTwo with the appropriate code?
B) create a view which holds the columns used in the jsp. I would then send the values to the view to be persisted.
C) somehow create a single entity file which references both TableOne and TableTwo. Or references TableOne and only MyColumnFour of TableTwo.
D) ???