Forums Register Login

Many-to-many probelm help

+Pie Number of slices to send: Send
hi all,
i have an application where you can create category and add products and save to Database.
i have order table and product table where you can create product (all product created goes here) and i also have link table order_product table.
now my problem is if i place a order which has for instance with 2 products i want only order and link table to be saved like,

order table ------ order_product------ product table
1 1 2 1
2 1 3 2
3 2 2 3

so when i submit order I'll have product id's i.e 2,3,2 using these product ID i need to update link table and order table.
is there a way to do this? please help
+Pie Number of slices to send: Send
Your problem description is not clear to me. Can you
describe the table contents in more detail? Thanks.

Jim ... ...
+Pie Number of slices to send: Send
sorry
order table ------
1
2
3
order_product- this is link table with order_id and product_id
1 2
1 3
2 2
product table
1
2
3
wen i submit order i'll have product id's so i need to save product details like order id 1 will have product id 1,2.
+Pie Number of slices to send: Send
hi can anyone help me in this problem as struck and need it urgently
+Pie Number of slices to send: Send
Sounds like a basic ManyToMany relationship. Don't see an issue? What ORM are you using?
In JPA you just use a ManyToMany mapping.
+Pie Number of slices to send: Send
thanks for the reply the problem here is wen i save order object then order,order_product,product table will be updated i already have product id so only thing i need to update is order,order_product am using hibernate and MSQL, i dont want product table to be updated
+Pie Number of slices to send: Send
What do you have so far? Maybe it's time to look at some code.

Jim ... ...
+Pie Number of slices to send: Send


I love a good mentalist. And so does this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1156 times.
Similar Threads
Factory Home Questions
ordering values in Arraylist
help regarding EJB-QL
FileReader and FileWriter
JavaScript in Servlets
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 02:55:20.