Advertisement
Guest User

Untitled

a guest
Apr 28th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.29 KB | None | 0 0
  1.             int customerId = selectQueryInt("SELECT id FROM customers ORDER BY id DESC LIMIT 1") + 1;
  2.             int autosaleId = selectQueryInt("SELECT id FROM autosales ORDER BY id DESC LIMIT 1") + 1;
  3.             System.out.println("customer:" + customerId + " autosale:" + autosaleId + " car:" + list.get(5));
  4.             //add customer
  5.             queryString.add("INSERT INTO customers(id,fname,lname,email) VALUES("
  6.                     + customerId + "," + list.get(0) + "," + list.get(1) + "," + list.get(2) + ")");
  7.             //add autosale
  8.             queryString.add("INSERT INTO autosales(id,name,address) VALUES("
  9.                     + autosaleId + "," + list.get(3) + "," + list.get(4) + ")");
  10.             //add order
  11.             queryString.add("INSERT INTO orders(id,customer_id,autosale_id,created_at) VALUES("
  12.                     + orderId + "," + customerId + "," + autosaleId + ",current_date)");
  13.             //add order_cars
  14.             for(int i = 5; i < list.size(); i++){
  15.                 queryString.add("INSERT INTO orders_cars(order_id, car_id) VALUES(" + orderId + "," + list.get(i));
  16.             }
  17. executeQuery(queryString, "add");
  18.  
  19. executeQuery(List<String> queryString, String type) {
  20. .
  21. .
  22. .
  23.             conn.setAutoCommit(false);
  24.             stmt = conn.createStatement();
  25.             for(int i = 0; i < queryString.size(); i++){
  26.                 stmt.executeUpdate(queryString.get(i));
  27.                 System.out.println("insert: " + i);
  28.             }
  29.             conn.commit();
  30. .
  31. .
  32. .
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement