@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()); } }