sql - Insert data into multiple tables in single transaction in jdbc -

-

मेरे पास एक टेबल है ऑर्डर जिसमें फ़ील्ड ऑर्डरिड | स्थिति | cid |

और अन्य तालिका Order_Details

ओडर_विवरण _id | आदेश_आईडी | आइटम आईडी

मैं चाहता हूं दोनों लेन-देन में एकल लेनदेन में मान सम्मिलित करें जैसे कि कोई ग्राहक एक आदेश रखता है ताकि ऑर्डर आईडी उत्पन्न हो और उस order_id को Order and Order_Details तालिका में डाला जाना चाहिए। लेकिन मैं जेडीबीसी में कैसे करूं ??

आप इसे false पर autocommit सेटिंग कर सकते हैं: < pre> dbConnection.setAutoCommit (गलत); // एक लेनदेन ब्लॉक शुरू करने के लिए // अपने यहाँ दो सम्मिलित करते हैं dbConnection.commit (); // एक लेनदेन ब्लॉक समाप्त करने के लिए

पूर्ण उदाहरण के लिए यहां एक नज़र डालें:

Comments

Post a Comment

Popular posts from this blog

c# - Roxy file manager in MVC doesn't accept session path -

-
Hi friends I've downloaded a file manager for my MVC project. So I added to my project and everything works fine but everyone can use this product I mean everyone can type urls and upload files to my host !!!! This filemanager has a Jason config file, as you can see here: {"FILES_ROOT": "Fileman / Upload "," "File_type_kenny": "file", "THUMBS_VIEW_WIDTH": "140", "THUMBS_VIEW_HEIGHT": "120", "PREVIEW_THUMB_WIDTH": "300", "PREVIEW_THUMB_HEIGHT": "200", "MAX_IMAGE_WIDTH": "0" "ASP_net / Main.Shex? A = Created", " Dealederer ":" ASP_net / MAN.assx "ADELEDED IR "," MOVEDIR ":" ASP_net / Main.Shex? A = MoVEDIR "," Copdier ":" ASP_net / Main.Shex? A = Copdier "," Richie Dar ":" ASP_net / Main ASP_net / main.hex? A = Upload "," Downlo...
Read more

php - proc_open Too many open files in long running Symfony Console app -

-
I have created a console app with a SIM console console component. It was going to run for 5 hours but after running 2 hours I have a proc_open (): Many open files in the pipeline error Symfony \ Component \ Console \ Application.php On-line 985. I tried to gc_collect_cycles in my code, but got the same error. Is this a Symphonic Console component bug or should I not run any app for this long time (but I have to)? This problem relates to: Obviously you have many resources in your app It's not a symphony console bug, but it's a PHP bug. You can modify your program by using another programming language to open fewer files.
Read more

c# - Show a huge number of data in DevExpress GridView -

-
With 3000 lines I have a DevExpress grid view and each row has 10 as extensions (this means that when I have 30000 loads in grid load items to load) All data loads It takes a long time to do so, then there is a way to show example 100 lines, and when I use the automatic filter, do I show the lines I want? Example I tried to leave and take (using LINQ), but what I actually see for it Also want to use the automatic filter of the grid. Public Static Binding List & lt; Patient & gt; GetObjectUsingLinq (string sql = "", int skipCount = 0, int lekton = 0) {var gsData = GetDataContext (); Var query = (to choose q.nom q with GS dataApotate order); Return new compulsory list & lt; Patient & gt; (LinqHelper.DoSortPaginate (Query, "" Leave, Techcount) .Oolist ()); } and to call it on the grid listPatient = patients.getObjectUsingLinq (); myGrid.DataSource = listPatient; If you need to display large amounts of records in the grid control, ...
Read more