public DbConnection() throws IOException, SQLException { Properties props = Util.loadProperties(PROPERTIES_FILENAME); String dbUrl = Util.getPropertyNotNull(props, "db_url"); String dbName = Util.getPropertyNotNull(props, "db_name"); String dbUser = Util.getPropertyNotNull(props, "db_user"); String dbPw = Util.getPropertyNotNull(props, "db_pw"); debugMode = Boolean.parseBoolean(Util.getPropertyNotNull(props, "db_debug_mode")); if (debugMode) { LOGGER.warning("DATABASE DEBUG MODE ACTIVE"); } con = DriverManager.getConnection(dbUrl, dbUser, dbPw); Statement st = con.createStatement(); // Switch to the chosen DB st.executeUpdate("USE " + dbName); // Ensure UTF8 is used (so Korean characters are handled correctly) st.executeUpdate("SET NAMES utf8"); st.close(); connected = true; getInsertId = prepare("SELECT last_insert_id()", null); }