@Override
public void addToOrdersDB(Order o) {
try {
// create a mysql database connection
OrderValidator.orderDataIsValid(o);
// Class.forName(JDBC_DRIVER);
Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
// the mysql insert statement
String query =
" insert into ordersdb (id, dateAndTime, addr1, addr2, addr34, distance, orderCost,"
+ " customerPhone, customerName, carNumber, carDriver, isDone)"
+ " values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
// create the mysql insert preparedstatement
PreparedStatement preparedStmt = conn.prepareStatement(query);
preparedStmt.setInt(1, o.getId());
preparedStmt.setTimestamp(2, o.getDateAndTime());
preparedStmt.setString(3, o.getAddr1());
preparedStmt.setString(4, o.getAddr2());
preparedStmt.setString(5, o.getAddr34());
preparedStmt.setFloat(6, o.getDistance());
preparedStmt.setFloat(7, o.getOrderCost());
preparedStmt.setString(8, o.getCustomerPhone());
preparedStmt.setString(9, o.getCustomerName());
preparedStmt.setString(10, o.getCarNumber());
preparedStmt.setString(11, o.getCarDriver());
preparedStmt.setBoolean(12, o.getIsDone());
preparedStmt.execute();
conn.close();
} catch (Exception e) {
System.err.println("---> Got an exception during inserting to DB!");
System.err.println(e.getMessage());
}
}
