Fuckit

package JsonToMysql;

import java.io.*;
import java.net.URL;
import java.nio.charset.Charset;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.json.JSONException;
import org.json.JSONObject;

import Constants.KeyReader;

public class jsonMysql {

    private static Connection conn;

    private static String readAll(Reader rd) throws IOException {
        StringBuilder sb = new StringBuilder();
        int cp;
        while ((cp = rd.read()) != -1) {
            sb.append((char) cp);
        }
        return sb.toString();
    }

    public static JSONObject readJsonFromUrl(String url) throws IOException, JSONException {
        InputStream is = new URL(url).openStream();
        try {
            BufferedReader rd = new BufferedReader(new InputStreamReader(is, Charset.forName("UTF-8")));
            String jsonText = readAll(rd);
            JSONObject json = new JSONObject(jsonText);
            return json;
        } finally {
            is.close();
        }
    }

    public static void mysqlCon() {

        try {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost/?autoReconnect=true&useSSL=false";
            String user = "root"; String pass = "abcd1234";
            conn = DriverManager.getConnection(url, user, pass);
            conn.setAutoCommit(false);
        } catch (ClassNotFoundException e) {
            System.err.println(e);
        } catch (SQLException e) {
            System.err.println(e);
        }
    }

    public static void insertField(Object object, Object object2, Object object3, Object object4, Object object5, Object object6, Object object7, Object object8, Object object9, Object object10, Object object11, Object object12, Object object13, Object object14, Object object15, Object object16, Object object17, Object object18, Object object19, Object object20, Object object21, Object object22, Object object23, Object object24, Object object25, Object object26, Object object27, Object object28, Object object29, Object object30, Object object31, Object object32, Object object33, Object object34) {
        int bool1; int bool2; int bool3; int bool4; int bool5;

        try {
            Statement state = conn.createStatement();
            String nameObj = (String)object4; nameObj = nameObj.replace("'", "\\'");

            // 13 25 26 31 32 - 9 10

            if(object13 == "true") { bool1 = 1; } else { bool1 = 0; }
            if(object25 == "true") { bool2 = 1; } else { bool2 = 0; }
            if(object26 == "true") { bool3 = 1; } else { bool3 = 0; }
            if(object31 == "true") { bool4 = 1; } else { bool4 = 0; }
            if(object32 == "true") { bool5 = 1; } else { bool5 = 0; }

            if(findDuplicate((int)object) == true) {
                System.err.println("DUP ERROR! REMOVING DUP ID: " +(int)object);
                state.executeUpdate("DELETE FROM `json_mysqlbase`.`item_data` WHERE `id`='"+object+"'");
                conn.commit();
            }

            if(((int)object9 == 4 && (int)object10 == 0) || ((int)object9 == 4 && (int)object10 == 4)) {
                state.executeUpdate("INSERT INTO `json_mysqlbase`.`item_data` (`id`, `disenchantingSkillRank`, `description`, `name`, `icon`, `stackable`, `itemBind`, `buyPrice`, `itemClass`, `itemSubClass`, `containerSlots`, `inventoryType`, `equippable`, `itemLevel`, `maxCount`, `maxDurability`, `minFactionId`, `minReputation`, `quality`, `sellPrice`, `requiredSkill`, `requiredLevel`, `requiredSkillRank`, `baseArmor`, `hasSockets`, `isAuctionable`, `armor`, `displayInfoId`, `nameDescription`, `nameDescriptionColor`, `upgradable`, `heroicTooltip`, `context`, `artifactId`) VALUES ('"+object+"', '"+object2+"', '"+object3+"', '"+object4+"', '"+object5+"', '"+object6+"', '"+object7+"', '"+object8+"', '"+object9+"', '"+object10+"', '"+object11+"', '"+object12+"', '"+bool1+"', '"+object14+"', '"+object15+"', '"+object16+"', '"+object17+"', '"+object18+"', '"+object19+"', '"+object20+"', '"+object21+"', '"+object22+"', '"+object23+"', '"+object24+"', '"+bool2+"', '"+bool3+"', '"+object27+"', '"+object28+"', '"+object29+"', '"+object30+"', '"+bool4+"', '"+bool5+"', '"+object33+"', '"+object34+"')");
                conn.commit();
            } else {
                System.err.println("ITEMCLASS ERROR! IGNORE ID: " +(int)object);
            }

            //conn.commit();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static boolean findDuplicate(int id) throws SQLException {

        Statement state = conn.createStatement();
        ResultSet rs = state.executeQuery("select * from `json_mysqlbase`.`item_data` where id = " +id);
        conn.commit();

        if (rs.next()) {
            return true;
        } else {
            return false;
        }
    }

    public static void main(String[] args) throws IOException, JSONException {

        mysqlCon(); JSONObject data = null;

        for (int item = 138000; item <= 139000; item++) {

            try {
                data = readJsonFromUrl("https://us.api.battle.net/wow/item/" + item + "?locale=en_US&apikey="+KeyReader.GetKey());
                insertField(data.get("id"), data.get("disenchantingSkillRank"), data.get("description"), data.get("name"), data.get("icon"), data.get("stackable"), data.get("itemBind"), data.get("buyPrice"), data.get("itemClass"), data.get("itemSubClass"), data.get("containerSlots"), data.get("inventoryType"), data.get("equippable"), data.get("itemLevel"), data.get("maxCount"), data.get("maxDurability"), data.get("minFactionId"), data.get("minReputation"), data.get("quality"), data.get("sellPrice"), data.get("requiredSkill"), data.get("requiredLevel"), data.get("requiredSkillRank"), data.get("baseArmor"), data.get("hasSockets"), data.get("isAuctionable"), data.get("armor"), data.get("displayInfoId"), data.get("nameDescription"), data.get("nameDescriptionColor"), data.get("upgradable"), data.get("heroicTooltip"), data.get("context"), data.get("artifactId"));

                bonusStats value1 = new bonusStats(data, item); // bonusStats.java
                value1.bonusStatsManager(conn);
                itemSpells value2 = new itemSpells(data, item); // itemSpells.java
                value2.itemSpellsManager(conn);
                itemSource value3 = new itemSource(data, item); // itemSource.java
                value3.itemSourceManager(conn);
                bonusLists value4 = new bonusLists(data, item); // bonusLists.java
                value4.bonusListsManager(conn);
                availableContexts value5 = new availableContexts(data, item); // availableContexts.java
                value5.availableContextsManager(conn);
                bonusSummary value6 = new bonusSummary(data, item); // bonusSummary.java
                value6.bonusSummaryManager(conn);

                System.out.println("Item id " + data.get("id") + " is OK!");
            } catch (JSONException e) {
                System.out.println("JSONException" +e);
            } catch (FileNotFoundException e) {
                System.out.println("FileNotFoundException: " + item);
            }
        }
    }
}