additionally to get the data from the rs.
how I filled my Value Object.
/* this is on my class variables */
//my db tables is sessions
private static final String COLUMN_ID ...
Type: Posts; User: william
additionally to get the data from the rs.
how I filled my Value Object.
/* this is on my class variables */
//my db tables is sessions
private static final String COLUMN_ID ...
There are many ways to program Java and SQL together, you can have the SQL functions do it for you or just gather all the data and write the program for calculation. You have your connection you...
To get the total unit price you just multiply the two columns together. then add all the total unit prices together to have a sum() of unit prices.
quanity * unit price = total unit price;...