File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
How to insert a single order row and multiple order detail rows into order details table?
Joined: Aug 02, 2012
Aug 22, 2013 00:20:43
The issue is accuracy. Could you show me the SQL of this query?
OrderID CustomerID EmployeeID PurchaseDate PurchaseTime PurchaseDate Reason
OrderDetailID OrderID ProductID GrossSales Quantity Discount NetSales WarrantyExpirationDate
author & internet detective
Joined: May 26, 2003
Aug 23, 2013 08:05:23
How about you write the SQL and we provide comments on it? We like to help people learn here and giving you the whole code doesn't feel like that.
As a hint, take a look at updateBatch() so all the SQL goes in under the same transaction.
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: How to insert a single order row and multiple order detail rows into order details table?
Sun's feelings about stored procedures
TableModel issue in JTable
JTable Row Deletion
[eckel] on string initialization
compare csv data with table rows
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015