try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@dilbert.humber.ca:1521:grok", "YOUR_USERNAME", "YOUR_PASS");

            Statement statement = conn.createStatement();
            ResultSet resultSet;

            for (int i = 0; i < orderItems.size(); i++){

                totalCost += orderItems.get(i).getPrice() * orderItems.get(i).getCount();

                statement = conn.createStatement();
                resultSet = statement.executeQuery (
                    "INSERT INTO orders( client_id, item_ids, counts, price)\n"
                    +"  VALUES( "+clientId+", '"+orderItems.get(i).getId()+"', '"+orderItems.get(i).getCount()+"', '"+totalCost+"' )"
                );
                System.out.println("Added order with row: " + resultSet.getRow());
            }

            if (resultSet != null)
                resultSet.close();
            statement.close();
            conn.close();

        } catch (Exception e) {
            System.out.println(e.getMessage() + " " + e);
        }