์ „์ฒด ๊ธ€

์ „์ฒด ๊ธ€

    [2020-02-20 ์—๋Ÿฌ๊ธฐ๋ก] ์•ˆ๋“œ๋กœ์ด๋“œ/JAVA

    Handler+๋ทฐํŽ˜์ด์ €๋กœ Fragment ์ „ํ™˜์‹œ ์ƒ๊ธด ์—๋Ÿฌ E/AndroidRuntime: FATAL EXCEPTION: main Process: ํ”„๋กœ์ ํŠธ๋ช…, PID: 10835 android.view.WindowManager$BadTokenException: Unable to add window -- token android.os.BinderProxy@9e8b19e is not valid; is your activity running? at android.view.ViewRootImpl.setView(ViewRootImpl.java:679) at android.view.WindowManagerGlobal.addView(WindowManagerGlobal.java:342) at android.view.W..

    [2020-01-15 ์—๋Ÿฌ๊ธฐ๋ก] ์•ˆ๋“œ๋กœ์ด๋“œ YouTube API ๊ตฌํ˜„ํ•˜๋‹ค ์ƒ๊ธด ์—๋Ÿฌ

    Youtube API Key ์žฌ๋ฐœ๊ธ‰ ํ›„ ์ธ์ฆ์‹œ๋„ ํ–ˆ์„๋•Œ ํ˜„์ƒ (null : 403 Forbidden { "code" : 403, "errors" : [ { "domain" : "usageLimits", "message" : "The request did not specify any Android package name or signing-certificate fingerprint. Please ensure that the client is sending them or use the API Console to update your key restrictions.", "reason" : "ipRefererBlocked", "extendedHelp" : "https://console.developers.goo..

    [Android Studio] INSTALL_PARSE_FAILED_NO_CERTIFICATES / INSTALL_FAILED_OLDER_SDK

    [Android Studio] INSTALL_PARSE_FAILED_NO_CERTIFICATES / INSTALL_FAILED_OLDER_SDK

    1. ํ˜„์ƒ adb๋กœ ์—ฐ๊ฒฐํ•œ ๊ธฐ๊ธฐ์— apk๊ฐ€ ์„ค์น˜๋˜์ง€ ์•Š์•˜๋‹ค. ๊ธฐ๊ธฐ์ƒํƒœ adb ์—ฐ๊ฒฐ ํ›„, ๋””๋ฒ„๊น…์„ ํ–ˆ์„๋•Œ ๋–ด๋˜ ์—๋Ÿฌโ–ผ adb install apkํŒŒ์ผ๋ช….apk ํ–ˆ์„๋•Œ ๋–ด๋˜ ์—๋Ÿฌโ–ผ ๊ตฌ๊ธ€๋งx100 ํ•ด์„œ ๋‚˜์˜ค๋Š” ๊ธ€๋กœ๋Š” ๋‚ด ํ˜„์ƒ์„ ํ•ด๊ฒฐํ•  ์ˆ˜ ์—†์—ˆ๋‹ค... 2. ํ•ด๊ฒฐ๋ฐฉ๋ฒ• [sdk์ตœ์†Œ๋ฒ„์ „(minSdk)์„ adb๊ธฐ๊ธฐ์™€ ๋งž์ถฐ์ค€๋‹ค] ๋นŒ๋“œํ•˜๋ ค๋Š” ๊ธฐ๊ธฐ(adb๋กœ ์—ฐ๊ฒฐ๋œ ๊ธฐ๊ธฐ)์˜ ์ตœ์†Œ sdk๋ฒ„์ „๊ณผ ๋งž์ถฐ์ค€๋‹ค. ๋‚ด๊ฒฝ์šฐ 23์— ๋งž์ถฐ์ค˜์•ผ ํ–ˆ๋‹ค. build.gradle์— ๋“ค์–ด๊ฐ„๋‹ค. minSdkVersion๋ฅผ ๋ณธ์ธ์˜ ์ตœ์†Œ๋ฒ„์ „์— ๋งž๊ฒŒ ์ˆ˜์ •. android { compileSdkVersion 29 buildToolsVersion "29.0.2" defaultConfig { applicationId "com.example.prac" minSdkV..

    HTTP ์„œ๋ฒ„ ์‘๋‹ต ์ฝ”๋“œ (Response Code) ์ •๋ฆฌ_2(100๋ฒˆ~500๋ฒˆ)

    HTTP ์ƒํƒœ ์ฝ”๋“œ HTTP ์‘๋‹ต ์ƒํƒœ ์ฝ”๋“œ๋Š” ํŠน์ • HTTP ์š”์ฒญ์ด ์„ฑ๊ณต์ ์œผ๋กœ ์™„๋ฃŒ๋˜์—ˆ๋Š”์ง€ ์•Œ๋ ค์ค๋‹ˆ๋‹ค. ์‘๋‹ต์€ 5๊ฐœ์˜ ๊ทธ๋ฃน์œผ๋กœ ๋‚˜๋ˆ„์–ด์ง‘๋‹ˆ๋‹ค: ์ •๋ณด๋ฅผ ์ œ๊ณตํ•˜๋Š” ์‘๋‹ต, ์„ฑ๊ณต์ ์ธ ์‘๋‹ต, ๋ฆฌ๋‹ค์ด๋ ‰ํŠธ, ํด๋ผ์ด์–ธํŠธ ์—๋Ÿฌ, ๊ทธ๋ฆฌ๊ณ  ์„œ๋ฒ„ ์—๋Ÿฌ. ์ƒํƒœ ์ฝ”๋“œ๋Š” section 10 of RFC 2616์— ์ •์˜๋˜์–ด ์žˆ์Šต๋‹ˆ๋‹ค. ์ •๋ณด ์‘๋‹ต 100 Continue ์ด ์ž„์‹œ์ ์ธ ์‘๋‹ต์€ ์ง€๊ธˆ๊นŒ์ง€์˜ ์ƒํƒœ๊ฐ€ ๊ดœ์ฐฎ์œผ๋ฉฐ ํด๋ผ์ด์–ธํŠธ๊ฐ€ ๊ณ„์†ํ•ด์„œ ์š”์ฒญ์„ ํ•˜๊ฑฐ๋‚˜ ์ด๋ฏธ ์š”์ฒญ์„ ์™„๋ฃŒํ•œ ๊ฒฝ์šฐ์—๋Š” ๋ฌด์‹œํ•ด๋„ ๋˜๋Š” ๊ฒƒ์„ ์•Œ๋ ค์ค๋‹ˆ developer.mozilla.org ์ •๋ณด ์‘๋‹ต (๋ฆฌํ€˜์ŠคํŠธ๋ฅผ ๋ฐ›๊ณ , ์ฒ˜๋ฆฌ ์ค‘์— ์žˆ์Œ) 100 Continue ์ด ์ž„์‹œ์ ์ธ ์‘๋‹ต์€ ์ง€๊ธˆ๊นŒ์ง€์˜ ์ƒํƒœ๊ฐ€ ๊ดœ์ฐฎ์œผ๋ฉฐ ํด๋ผ์ด์–ธํŠธ๊ฐ€ ๊ณ„์†ํ•ด์„œ ์š”์ฒญ์„ ํ•˜๊ฑฐ๋‚˜ ์ด๋ฏธ ์š”์ฒญ์„ ์™„๋ฃŒํ•œ ๊ฒฝ์šฐ์—๋Š” ๋ฌด์‹œํ•ด๋„ ๋˜..

    [ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/์ฟผ๋ฆฌ๋ฌธ ์—ฐ์Šต] String, Date

    1. ๋ฃจ์‹œ์™€ ์—˜๋ผ ์ฐพ๊ธฐ ์ฝ”๋”ฉํ…Œ์ŠคํŠธ ์—ฐ์Šต - ๋ฃจ์‹œ์™€ ์—˜๋ผ ์ฐพ๊ธฐ | ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ANIMAL_INS ํ…Œ์ด๋ธ”์€ ๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๋“ค์–ด์˜จ ๋™๋ฌผ์˜ ์ •๋ณด๋ฅผ ๋‹ด์€ ํ…Œ์ด๋ธ”์ž…๋‹ˆ๋‹ค. ANIMAL_INS ํ…Œ์ด๋ธ” ๊ตฌ์กฐ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์œผ๋ฉฐ, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE๋Š” ๊ฐ๊ฐ ๋™๋ฌผ์˜ ์•„์ด๋””, ์ƒ๋ฌผ ์ข…, ๋ณดํ˜ธ ์‹œ์ž‘์ผ, ๋ณดํ˜ธ ์‹œ์ž‘ ์‹œ ์ƒํƒœ, ์ด๋ฆ„, ์„ฑ๋ณ„ ๋ฐ ์ค‘์„ฑํ™” ์—ฌ๋ถ€๋ฅผ ๋‚˜ํƒ€๋ƒ…๋‹ˆ๋‹ค. NAME TYPE NULLABLE ANIMAL_ID VARCHAR(N) FALS programmers.co.kr [์ •๋‹ต ์ ‘์–ด๋†“์Œ] ๋”๋ณด๊ธฐ -- ์ฝ”๋“œ๋ฅผ ์ž…๋ ฅํ•˜์„ธ์š” SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE FROM ANIMAL_I..

    [ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/์ฟผ๋ฆฌ๋ฌธ ์—ฐ์Šต] JOIN

    1. ์—†์–ด์ง„ ๊ธฐ๋ก ์ฐพ๊ธฐ ์ฝ”๋”ฉํ…Œ์ŠคํŠธ ์—ฐ์Šต - ์—†์–ด์ง„ ๊ธฐ๋ก ์ฐพ๊ธฐ | ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ANIMAL_INS ํ…Œ์ด๋ธ”์€ ๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๋“ค์–ด์˜จ ๋™๋ฌผ์˜ ์ •๋ณด๋ฅผ ๋‹ด์€ ํ…Œ์ด๋ธ”์ž…๋‹ˆ๋‹ค. ANIMAL_INS ํ…Œ์ด๋ธ” ๊ตฌ์กฐ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์œผ๋ฉฐ, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE๋Š” ๊ฐ๊ฐ ๋™๋ฌผ์˜ ์•„์ด๋””, ์ƒ๋ฌผ ์ข…, ๋ณดํ˜ธ ์‹œ์ž‘์ผ, ๋ณดํ˜ธ ์‹œ์ž‘ ์‹œ ์ƒํƒœ, ์ด๋ฆ„, ์„ฑ๋ณ„ ๋ฐ ์ค‘์„ฑํ™” ์—ฌ๋ถ€๋ฅผ ๋‚˜ํƒ€๋ƒ…๋‹ˆ๋‹ค. NAME TYPE NULLABLE ANIMAL_ID VARCHAR(N) FALS programmers.co.kr [์ •๋‹ต ์ ‘์–ด๋†“์Œ] ๋”๋ณด๊ธฐ -- ์ฝ”๋“œ๋ฅผ ์ž…๋ ฅํ•˜์„ธ์š” SELECT A.ANIMAL_ID, A.NAME FROM ANIMAL_OUTS AS A LEFT..

    [ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/์ฟผ๋ฆฌ๋ฌธ ์—ฐ์Šต] IS NULL

    1. ์ด๋ฆ„์ด ์—†๋Š” ๋™๋ฌผ์˜ ์•„์ด๋”” ์ฝ”๋”ฉํ…Œ์ŠคํŠธ ์—ฐ์Šต - ์ด๋ฆ„์ด ์—†๋Š” ๋™๋ฌผ์˜ ์•„์ด๋”” | ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ANIMAL_INS ํ…Œ์ด๋ธ”์€ ๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๋“ค์–ด์˜จ ๋™๋ฌผ์˜ ์ •๋ณด๋ฅผ ๋‹ด์€ ํ…Œ์ด๋ธ”์ž…๋‹ˆ๋‹ค. ANIMAL_INS ํ…Œ์ด๋ธ” ๊ตฌ์กฐ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์œผ๋ฉฐ, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE๋Š” ๊ฐ๊ฐ ๋™๋ฌผ์˜ ์•„์ด๋””, ์ƒ๋ฌผ ์ข…, ๋ณดํ˜ธ ์‹œ์ž‘์ผ, ๋ณดํ˜ธ ์‹œ์ž‘ ์‹œ ์ƒํƒœ, ์ด๋ฆ„, ์„ฑ๋ณ„ ๋ฐ ์ค‘์„ฑํ™” ์—ฌ๋ถ€๋ฅผ ๋‚˜ํƒ€๋ƒ…๋‹ˆ๋‹ค. NAME TYPE NULLABLE ANIMAL_ID VARCHAR(N) FALS programmers.co.kr [์ •๋‹ต ์ ‘์–ด๋†“์Œ] ๋”๋ณด๊ธฐ -- ์ฝ”๋“œ๋ฅผ ์ž…๋ ฅํ•˜์„ธ์š” SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME..

    [Eclipse/MVN] ๊ฐ™์€ ๋„คํŠธ์›Œํฌ ๋ง ๋‚ด์—์„œ IP:8080ํฌํŠธ ์ ‘์† ์•ˆ๋˜๋˜ ํ˜„์ƒ

    [Eclipse/MVN] ๊ฐ™์€ ๋„คํŠธ์›Œํฌ ๋ง ๋‚ด์—์„œ IP:8080ํฌํŠธ ์ ‘์† ์•ˆ๋˜๋˜ ํ˜„์ƒ

    1. ํ™˜๊ฒฝ eclipse neon.1, apache tomcat 8.0 2. ํ˜„์ƒ ์„œ๋ฒ„ ์ œ๋Œ€๋กœ Run๋˜๊ณ , ํ”„๋กœ์ ํŠธ์— ์—๋Ÿฌ๋‚˜ Exception๋„ ์—†์—ˆ๋Š”๋ฐ ๊ฐ™์€ ๋„คํŠธ์›Œํฌ ๋ง ๋‚ด๋ถ€์—์„œ local IP:8080์œผ๋กœ ์ ‘์†์ด ์•ˆ๋˜๋˜ ํ˜„์ƒ 3. ํ•ด๊ฒฐ๋ฐฉ๋ฒ• ๊ธฐ์กด์— ์˜ฌ๋ผ๊ฐ€์žˆ๋˜ ์„œ๋ฒ„ Deleteํ•˜๊ณ  ์ƒˆ๋กœ ์˜ฌ๋ฆฌ๋‹ˆ๊นŒ ํ•ด๊ฒฐ๋ฌ๋‹ค.(๊ฒฐ๊ตญ ์ •ํ™•ํ•œ ์›์ธ์€ ์•Œ ์ˆ˜ ์—†์—ˆ์Œ)

    [๋ฐฑ์ค€/c++] 11657 - ํƒ€์ž„๋จธ์‹ 

    ๋ฌธ์ œ 11657๋ฒˆ: ํƒ€์ž„๋จธ์‹  ์ฒซ์งธ ์ค„์— ๋„์‹œ์˜ ๊ฐœ์ˆ˜ N (1 ≤ N ≤ 500), ๋ฒ„์Šค ๋…ธ์„ ์˜ ๊ฐœ์ˆ˜ M (1 ≤ M ≤ 6,000)์ด ์ฃผ์–ด์ง„๋‹ค. ๋‘˜์งธ ์ค„๋ถ€ํ„ฐ M๊ฐœ์˜ ์ค„์—๋Š” ๋ฒ„์Šค ๋…ธ์„ ์˜ ์ •๋ณด A, B, C (1 ≤ A, B ≤ N, -10,000 ≤ C ≤ 10,000)๊ฐ€ ์ฃผ์–ด์ง„๋‹ค. www.acmicpc.net ํ’€์ด ๋ถ„๋ฅ˜ : ๋ฒจ๋งŒ-ํฌ๋“œ ์•Œ๊ณ ๋ฆฌ์ฆ˜ ์ตœ๋‹จ๊ฑฐ๋ฆฌ ์ฐพ๊ธฐ + ์Œ์˜ ๊ฐ€์ค‘์น˜ ์ด๋ฏ€๋กœ ๋ฒจ๋งŒํฌ๋“œ ์•Œ๊ณ ๋ฆฌ์ฆ˜์„ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค. ์ฝ”๋“œ(O((n^2)*m) *O((n^2)*m์ด ์•„๋‹ˆ๋ผ๋ฉด ์•Œ๋ ค์ฃผ์„ธ์š”. ๊ฐ์‚ฌํ•ฉ๋‹ˆ๋‹ค(--)(__)*

    [Git/๋งํฌ] Sourcetree crash report & remote: Permission to ์—๋Ÿฌ

    1. Sourcetree crash report ํ•ด๊ฒฐ๋ฐฉ๋ฒ• ์†Œ์ŠคํŠธ๋ฆฌ ์ปค๋ฐ‹ ์˜ค๋ฅ˜ - ํ”„๋กœ๊ทธ๋žจ ์ข…๋ฃŒ ํ˜„์ƒ(Sourcetree crash report) git์œผ๋กœ ์—ฐ๋™๋œ ์†Œ์ŠคํŠธ๋ฆฌ์—์„œ ์ปค๋ฐ‹ ๋ฒ„ํŠผ ๋ˆ„๋ฅธ ์ˆœ๊ฐ„ ํ”„๋กœ๊ทธ๋žจ์ด ์ข…๋ฃŒ ๋˜๋ฉด์„œ Report ์ฐฝ์ด ๋œจ๋Š” ํ˜„์ƒ์ด ์žˆ์—ˆ์Šต๋‹ˆ๋‹ค.. ์„ธํŒ… ํ™˜๊ฒฝ์€ GitLab ๊ณผ Sourcetree ์—ฐ๋™์ž…๋‹ˆ๋‹ค. (์†Œ์ŠคํŠธ๋ฆฌ ์„ค์ •์ด ๊ผฌ์ธ๊ฑฐ ๊ฐ™์Œ.. ์ด๊ฒƒ ๋•Œ๋ฉ” 1์‹œ.. teerjwi21.tistory.com 2. remote: Permission to ์—๋Ÿฌ ํ•ด๊ฒฐ๋ฐฉ๋ฒ• [๊นƒํ—ˆ๋ธŒ(Github)] 21. remote: Permission to ์—๋Ÿฌ remote: Permission to gitest01/gitest01.github.io.git denied to xxxx. fatal: unable to a..

    [Inspiration/๋‹คํ] ์šฐ๋ฆฌ๋Š” ์™œ ๋Œ€ํ•™์— ๊ฐ€๋Š”๊ฐ€(1,4~6)

    1๋ถ€ ์–ด๋ฉ”์ด์ง• ๋ฐ์ด *2~3๋ถ€๋Š” ์ €์ž‘๊ถŒ ๋ฌธ์ œ๋กœ ์—…๋กœ๋“œํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. 4๋ถ€ ์–ด๋ฉ”์ด์ง• ๋ฐ์ด โ…ก 5๋ถ€ ๋ง๋ฌธ์„ ํ„ฐ๋ผ 6๋ถ€ ์ƒ๊ฐ์„ ํ„ฐ๋ผ

    [ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/์ฟผ๋ฆฌ๋ฌธ ์—ฐ์Šต] GROUP BY

    1. ๊ณ ์–‘์ด์™€ ๊ฐœ๋Š” ๋ช‡ ๋งˆ๋ฆฌ ์žˆ์„๊นŒ ์ฝ”๋”ฉํ…Œ์ŠคํŠธ ์—ฐ์Šต - ๊ณ ์–‘์ด์™€ ๊ฐœ๋Š” ๋ช‡ ๋งˆ๋ฆฌ ์žˆ์„๊นŒ | ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ANIMAL_INS ํ…Œ์ด๋ธ”์€ ๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๋“ค์–ด์˜จ ๋™๋ฌผ์˜ ์ •๋ณด๋ฅผ ๋‹ด์€ ํ…Œ์ด๋ธ”์ž…๋‹ˆ๋‹ค. ANIMAL_INS ํ…Œ์ด๋ธ” ๊ตฌ์กฐ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์œผ๋ฉฐ, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE๋Š” ๊ฐ๊ฐ ๋™๋ฌผ์˜ ์•„์ด๋””, ์ƒ๋ฌผ ์ข…, ๋ณดํ˜ธ ์‹œ์ž‘์ผ, ๋ณดํ˜ธ ์‹œ์ž‘ ์‹œ ์ƒํƒœ, ์ด๋ฆ„, ์„ฑ๋ณ„ ๋ฐ ์ค‘์„ฑํ™” ์—ฌ๋ถ€๋ฅผ ๋‚˜ํƒ€๋ƒ…๋‹ˆ๋‹ค. NAME TYPE NULLABLE ANIMAL_ID VARCHAR(N) FALS programmers.co.kr [์ •๋‹ต ์ ‘์–ด๋†“์Œ] ๋”๋ณด๊ธฐ SELECT ANIMAL_TYPE, COUNT(ANIMAL_TYPE) AS 'count' FR..