String sql = "SELECT * FROM item";
         String vsql = "SELECT * FROM company";
    try (
            Connection conn = DBUtil.getConnection(DBType.MYSQL);
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(sql); // get all the vehicle data

        ){
            VehicleInventory vi = new VehicleInventory();
            vi.setVehicleName(vNameTxb.getText());

            while(rs.next()){

                vi.setItemName(rs.getString("name"));// set just vehicle name to vehicleInventory object.

                Statement vstmt = conn.createStatement();
                ResultSet vrs = stmt.executeQuery(vsql);// get item names respect to vehicle
              while(vrs.next()){
                  vi.setCompanyName(vrs.getString("name"));
                if(VehicleInventoryTable.insert(vi)){ // insert the item names against vehicle

                }
              }
            }

    } catch (SQLException ex) {
        JOptionPane.showMessageDialog(null, ex.getMessage(), "Error", JOptionPane.ERROR_MESSAGE);
    }