Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- int customerId = selectQueryInt("SELECT id FROM customers ORDER BY id DESC LIMIT 1") + 1;
- int autosaleId = selectQueryInt("SELECT id FROM autosales ORDER BY id DESC LIMIT 1") + 1;
- System.out.println("customer:" + customerId + " autosale:" + autosaleId + " car:" + list.get(5));
- //add customer
- queryString.add("INSERT INTO customers(id,fname,lname,email) VALUES("
- + customerId + "," + list.get(0) + "," + list.get(1) + "," + list.get(2) + ")");
- //add autosale
- queryString.add("INSERT INTO autosales(id,name,address) VALUES("
- + autosaleId + "," + list.get(3) + "," + list.get(4) + ")");
- //add order
- queryString.add("INSERT INTO orders(id,customer_id,autosale_id,created_at) VALUES("
- + orderId + "," + customerId + "," + autosaleId + ",current_date)");
- //add order_cars
- for(int i = 5; i < list.size(); i++){
- queryString.add("INSERT INTO orders_cars(order_id, car_id) VALUES(" + orderId + "," + list.get(i));
- }
- executeQuery(queryString, "add");
- executeQuery(List<String> queryString, String type) {
- .
- .
- .
- conn.setAutoCommit(false);
- stmt = conn.createStatement();
- for(int i = 0; i < queryString.size(); i++){
- stmt.executeUpdate(queryString.get(i));
- System.out.println("insert: " + i);
- }
- conn.commit();
- .
- .
- .
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement