๐Ÿ‘จ‍๐Ÿ’ป kimtongting
article thumbnail
๋ฌด๋ฃŒ SQL DB Tool ์ถ”์ฒœ DBeaver / ๋ฌด๋ฃŒ DB ๊ด€๋ฆฌํˆด DBeaver ์„ค์น˜
๐Ÿ› IDE & DevOps/DBeaver 2020. 8. 30. 00:51

์ฒซ ๊ฐœ๋ฐœ์„ ์‹œ์ž‘ํ•  ๋ฌด๋ ต.. ๋‚˜๋Š” ์ˆ˜๋งŽ์€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์ ‘ํ•˜๋ฉด์„œ ๊ฐ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ํŠนํ™”๋œ ํˆด์„ ๋ฐ›๋‹ค๊ฐ€ ์–ด๋Š์ƒˆ 5๊ฐœ ์ด์ƒ์˜ ํˆด์„ ๋ณด๊ณ  ๊ฒฝ์•…์„ ๊ธˆ์น˜ ๋ชปํ–ˆ๋‹ค. ๊ทธ๋Ÿฌ๋‹ค ์ฐพ์€ ๋ฌด๋ฃŒ SQL DB ํˆด์ธ DBeaver ์ด๊ฒƒ์€ ์ตœ๊ณ ์˜ ๋ฐœ๊ฒฌ์ด์—ˆ๋‹ค. ์„ค์น˜๋งํฌ -> (https://dbeaver.io/download/) ๊พธ์ค€ํžˆ ์—…๋ฐ์ดํŠธ ํ•˜๊ณ  ์žˆ์œผ๋ฉฐ, ๋ฌด๋ ค free and open source ๋ผ๊ณ  ๋˜์–ด์žˆ๋‹ค. ํฌ.. ๊ทธ๋ฆฌ๊ณ  ์บ๋ฆญํ„ฐ๊ฐ€ ๋„˜ ๊ท€์—ฝ๋‹ค.. ์œ„ ๋งํฌ๋กœ ์ด๋™์ด ์™„๋ฃŒ๋˜๋ฉด ๊ฐ OS์— ๋งž๋Š” ๋ฒ„์ „์„ ์„ค์น˜ํ•ด์ฃผ๊ณ , ์‹คํ–‰์‹œํ‚ค๋ฉด, ์•„๋ž˜์™€ ๊ฐ™์€ ํ™”๋ฉด์ด ๋‚˜์˜จ๋‹ค. ์ตœ์‹ ๋ฒ„์ „์€ ํ•œ๊ธ€ํ™”๋ฅผ ์ง€์›ํ•œ๋‹ค ํ๋ญ‡.. ๋ฐ”๋กœ ์—ฌ๋Ÿฌ๋ถ„์ด ์‚ฌ์šฉํ•˜์‹ค ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์„ ํƒํ•˜๋Š” ๊ณณ์ด์ฃ . ์˜ˆ๋ฅผ ๋“ค์–ด ์ฒซ ๋ฒˆ์งธ์— ์žˆ๋Š” PostgreSQL์„ ์˜ˆ์ œ๋กœ ์‚ดํŽด๋ณผ๊นŒ์š”? ์œ„์—์„œ๋ถ€ํ„ฐ Host /..

article thumbnail
Flutter ์ž๋™์™„์„ฑ

Flutter๋Š” ์ฃผ๋กœ Android Studio IDE์—์„œ ๊ฐœ๋ฐœ๋œ๋‹ค. ๋‹จ์ˆœํ•œ ๊ฒƒ์„ ์ฐพ๊ณ  ๋ฐ˜๋ณต์ ์ธ ์ผ์„ ์‹ซ์–ดํ•˜๋Š” ๊ฐœ๋ฐœ์ž๋“ค์€ ๋Š˜ ์ž๋™์™„์„ฑ์„ ์ฐพ๊ฒŒ๋œ๋‹ค. ํด๋ž˜์Šค๋ฅผ ์ƒ์„ฑํ•  ๋•Œ, ์ผ์ผํžˆ ์น˜์ง€ ์•Š๋”๋ผ๋„ ์ž๋™์™„์„ฑ์ด ๋˜๋ฉด ์–ผ๋งˆ๋‚˜ ์ข‹์„๊นŒ.. ๋งˆ์น˜ java์˜ public static void main(String[] args)๊ณผ ๊ฐ™์ด ๋ง์ด๋‹ค. ๋ฌผ๋ก  ๋‹น์—ฐํžˆ ์ง€์›ํ•œ๋‹ค. stateless widget์ด๋‚˜ stateful widget์„ ์ด์šฉํ•  ๋•Œ, ์œ ์šฉํ•˜๋‹ค. #1. StateLess stless + Enter ์ด ๋ช…๋ น์–ด๋ฅผ ์น˜๊ฒŒ ๋˜๋ฉด, ์ด๋ ‡๊ฒŒ ์ž๋™์™„์„ฑ์ด ์ด๋ฃจ์–ด์ง€๊ณ , #2. StateFul stful + Enter ์ด ๋ช…๋ น์–ด๋ฅผ ์น˜๊ฒŒ ๋˜๋ฉด, ์ด๊ฒƒ ๋˜ํ•œ ์ž๋™์™„์„ฑ์ด ์ด๋ฃจ์–ด์ง„๋‹ค.

article thumbnail
IntelliJ ์œ ์šฉํ•œ ํ”Œ๋Ÿฌ๊ทธ์ธ / Android Studio ์œ ์šฉํ•œ ํ”Œ๋Ÿฌ๊ทธ์ธ / Flutter ์œ ์šฉํ•œ ํ”Œ๋Ÿฌ๊ทธ์ธ

IntelliJ๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด์„œ ๊ฐ„๋‹จํ•˜๊ฒŒ ์œ ์šฉํ•œ ํ”Œ๋Ÿฌ๊ทธ์ธ์„ ์†Œ๊ฐœํ•˜๋ฉฐ ์ •๋ฆฌํ•ด๋ดค๋‹ค. ์—†์„ ๋• ๋ชฐ๋ž์ง€๋งŒ ์žˆ์œผ๋‹ˆ๊นŒ ๋„ˆ๋ฌด ๋งŒ์กฑ์Šค๋Ÿฌ์šด ํ”Œ๋Ÿฌ๊ทธ์ธ๋“ค.. ์œ„์—์„œ๋ถ€ํ„ฐ ์ˆœ์ฐจ์ ์œผ๋กœ, 1. CodeGlance ์šฐ์ธก ์ƒ๋‹จ์— ์ฝ”๋“œ์˜ ๋ฏธ๋‹ˆ๋งต์„ ์ œ๊ณตํ•ด์ค€๋‹ค. ์Šคํฌ๋กค์— ๋”ฐ๋ผ ํ•จ๊ป˜ ์›€์ง์ธ๋‹ค. ์ฝ”๋“œ๊ฐ€ ๊ธธ ์ˆ˜๋ก ๋น›์„ ๋ฐœํ•œ๋‹ค. 2. Grep Console ์ดํด๋ฆฝ์Šค์—์„œ๋„ ์œ ๋ช…ํ•œ ํ”Œ๋Ÿฌ๊ทธ์ธ์œผ๋กœ, ์ฝ˜์†”๋กœ๊ทธ์—์„œ ๋‚ด๊ฐ€ ์›ํ•˜๋Š” ๋กœ๊ทธ๋‚˜ ๋กœ๊ทธ ๋ ˆ๋ฒจ ๋ณ„ ์ƒ‰์ƒ์„ ์ง€์ •ํ•  ์ˆ˜ ์žˆ๋‹ค. ์ƒ‰์ƒ์„ ์ง€์ •ํ•จ์œผ๋กœ ์ฝ˜์†” ๋กœ๊ทธ์˜ ๊ฐ€๋…์„ฑ์„ ํ›จ์”ฌ ๋” ์ข‹๊ฒŒ ํ•  ์ˆ˜ ์žˆ๋‹ค. 3. iBATIS/MyBatis mini-plugin iBATIS/MyBatis ๋ฅผ ์‚ฌ์šฉํ•˜๋Š” ๊ฐœ๋ฐœ์ž๋“ค์—๊ฒŒ ์œ ์šฉํ•œ ํ”Œ๋Ÿฌ๊ทธ์ธ์ด๋‹ค. -Mapper.xml๋กœ ๋ฐ”๋กœ ์ด๋™ํ•  ์ˆ˜ ์žˆ๋‹ค. (Ctrl + T) -Mapper.java๋กœ ๋ฐ”๋กœ ..

article thumbnail
IntelliJ ๋ฐ”๋กœ ๋กœ๋”ฉ๋˜์ง€ ์•Š๊ฒŒํ•˜๊ธฐ / IntelliJ ์‹คํ–‰์‹œ ์ตœ๊ทผ ์ข…๋ฃŒํ•œ ํ”„๋กœ์ ํŠธ ๋ฐ”๋กœ ์‹คํ–‰๋˜์ง€ ์•Š๊ฒŒ ํ•˜๊ธฐ

ํ”„๋กœ์ ํŠธ๋ฅผ ์–ด๋Š์ •๋„ ์ง„ํ–‰ํ•˜๊ณ  ์ข…๋ฃŒ ํ›„, ๋‹ค์‹œ ์‹คํ–‰ํ•˜๋ฉด ํ•ญ์ƒ ๋งˆ์ง€๋ง‰์œผ๋กœ ์ข…๋ฃŒํ•œ ํ”„๋กœ์ ํŠธ๊ฐ€ ์ž๋™ ์‹คํ–‰๋œ๋‹ค. ๊ฐœ๋ฐœ๋‹จ๊ณ„๋ฅผ ์šฐ์„ ์‹œํ•˜๋Š” IDE ํŠน์„ฑ์ƒ ์‹คํ–‰ ์‹œ ๋งŽ์€ ๋ฆฌ์†Œ์Šค๋ฅผ ์†Œ๋น„ํ•˜๊ธฐ ๋•Œ๋ฌธ์— PC์˜ CPUํ• ๋‹น๋Ÿ‰ ๋ฐ ๋ฉ”๋ชจ๋ฆฌ ์ ์œ ๋„๊ฐ€ ๋†’์•„, ์‚ฌ์–‘์ด ๋‚ฎ์€ PC๋Š” ํ”„๋ฆฌ์ง• ํ˜„์ƒ์ด ๋ฐœ์ƒํ•œ๋‹ค. ์œˆ๋„์šฐ ๊ธฐ์ค€ File-Settings์„ ์„ ํƒ ํ›„, Appearance & Behaviour -> System Settings ๋ฉ”๋‰ด๋กœ ์ด๋™ํ•œ๋‹ค. Mac ๊ธฐ์ค€ ์ขŒ์ธก ์ƒ๋‹จ IntelliJ IDEA-Preferences๋ฅผ ์„ ํƒ ํ›„, Appearance & Behaviour -> System Settings ๋ฉ”๋‰ด๋กœ ์ด๋™ํ•œ๋‹ค. ๊ทธ ํ›„, Project ๋ž€์˜ Reopen projects on startup ์ฒดํฌ๋ฐ•์Šค์—์„œ ๊ธฐ๋ณธ ๊ฐ’์œผ๋กœ ๋˜์–ด์žˆ๋Š” ์ฒดํฌ์ƒํƒœ๋ฅผ ํ•ด..

article thumbnail
IntelliJ spring mvc ๋งŒ๋“ค๊ธฐ / ์ธํ…”๋ฆฌ์ œ์ด spring mvc ํ”„๋กœ์ ํŠธ ๋งŒ๋“ค๊ธฐ

์ดํด๋ฆฝ์Šค๋‚˜ STS๋ฅผ ์ด์šฉํ•˜์—ฌ Spring ํ”„๋กœ์ ํŠธ๋ฅผ ๊ฐ„์ ‘์ด๋ผ๋„ ๊ฒฝํ—˜ํ•œ ๋ถ„๋“ค์„ ์œ„ํ•ด, ์ „์„ธ๊ณ„ ๋ฟ๋งŒ ์•„๋‹ˆ๋ผ ์‹ค๋ฌด์—์„œ๋„ ๋งŽ์ด ์“ฐ์ด๊ณ  ์žˆ๋Š” IntelliJ๋ฅผ ์ด์šฉํ•ด์„œ Spring MVC ํ”„๋กœ์ ํŠธ๋ฅผ ๋งŒ๋“ค์–ด๋ณด์ž. ๋จผ์ € ์ง„ํ–‰ํ•˜๊ธฐ์— ์•ž์„œ, IntelliJ(๋งํฌ)์˜ ์„ค์น˜๋ฅผ ์™„๋ฃŒํ•œ๋‹ค. IntelliJ๋Š” JetBrains ์‚ฌ์—์„œ ๋งŒ๋“  ๋ธ”๋ผ๋ธ”๋ผ..๊ฒฐ๋ก ์€ ๊ฐœ๋ฐœ์— ๋„์›€์„ ์ฃผ๋Š” Windows, Mac, Linux ์—์„œ ์‚ฌ์šฉ๊ฐ€๋Šฅํ•œ IDE์ด๋‹ค. ์—ฌ๊ธฐ์„œ Tip. ๋งŒ์•ฝ ์—ฌ๋Ÿฌ๋ถ„์ด ํ•™๊ต ๋ฉ”์ผ์„ ๋ณด์œ ํ•˜๊ณ  ์žˆ๋Š” ํ•™์ƒ์ด๋ผ๋ฉด.. ๋งค๋…„ ๊ฐฑ์‹ ์„ ํ†ตํ•ด ๋ฌด๋ฃŒ๋กœ ์‚ฌ์šฉ๊ฐ€๋Šฅํ•˜๋‹ค. ๊ทธ๋ ‡์ง€ ์•Š์œผ๋ฉด ๊ฝค๋‚˜ ๊ธˆ์•ก์„ ์ง€๋ถˆํ•˜๊ณ  ์‚ฌ์šฉํ•˜์—ฌ์•ผ ํ•œ๋‹ค.

article thumbnail
java Collections / ์ž๋ฐ” ์ปฌ๋ ‰์…˜

์ปฌ๋ ‰์…˜์€ ๋‹ค์ˆ˜์˜ ๋ฐ์ดํ„ฐ๋ฅผ ๋‹ค๋ฃจ๋Š”๋ฐ ๊ต‰์žฅํžˆ ์„ฌ์„ธํ•˜๊ณ  ๋‹ค์–‘ํ•˜๊ฒŒ ํด๋ž˜์Šค๋“ค๋กœ ๊ตฌํ˜„๋˜์–ด ์ œ๊ณต๋˜๊ณ  ์žˆ๋‹ค. ์ธํ„ฐํŽ˜์ด์Šค์™€ ๋‹คํ˜•์„ฑ์„ ์ด์šฉํ•ด ๊ฐ์ฒด์ง€ํ–ฅ์  ์„ค๊ณ„๋ฅผ ํ†ตํ•œ ํ‘œ์ค€ํ™”๊ฐ€ ์™„์„ฑ๋˜์–ด ์žˆ์–ด, ์šฐ๋ฆฌ ์„ ๋ฐฐ ํ”„๋กœ๊ทธ๋ž˜๋จธ๋“ค์ด ๋จธ๋ฆฌ๋ฅผ ์‹ธ๋งค๊ณ  ๊ณ ์ƒํ•˜์…จ๋˜ ๊ฒƒ๋“ค์„ ํ˜„์žฌ ์šฐ๋ฆฌ๋“ค์€ ํŽธํ•˜๊ฒŒ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋‹ค.. ๋‚˜์ค‘์— ๊ธฐํšŒ๊ฐ€ ๋œ๋‹ค๋ฉด ์ปฌ๋ ‰์…˜ ํ”„๋ ˆ์ž„์›์˜ ์‹ค์ œ์†Œ์Šค๋ฅผ ๋ถ„์„ํ•ด ๋ณด์ž. ๊ฐ์ฒด์ง€ํ–ฅ์ ์ธ ์„ค๊ณ„๋Šฅ๋ ฅ์„ ํ–ฅ์ƒ์‹œํ‚ค๋Š”๋ฐ ํฐ ๋„์›€์ด ๋  ๊ฒƒ์ด๋‹ค. Collectionํ”„๋ ˆ์ž„์›์˜ ํ•ต์‹ฌ ์ธํ„ฐํŽ˜์ด์Šค ์ธํ„ฐํŽ˜์ด์Šค ํŠน์ง• List ์ˆœ์„œ๊ฐ€ ์žˆ๋Š” ๋ฐ์ดํ„ฐ์˜ ์ง‘ํ•ฉ. ๋ฐ์ดํ„ฐ์˜ ์ค‘๋ณต์„ ํ—ˆ์šฉํ•œ๋‹ค. ๊ตฌํ˜„)ArrayList, LinkedList, Stack, Vector etc.. Set ์ˆœ์„œ๋ฅผ ์œ ์ง€ํ•˜์ง€ ์•Š๋Š” ๋ฐ์ดํ„ฐ์˜ ์ง‘ํ•ฉ. ๋ฐ์ดํ„ฐ์˜ ์ค‘๋ณต์„ ํ—ˆ์šฉํ•˜์ง€ ์•Š๋Š”๋‹ค. ๊ตฌํ˜„)HashSet, TreeSet..

article thumbnail
Teachable machine / teachable machine ์‚ฌ์šฉํ•˜๊ธฐ

https://teachablemachine.withgoogle.com/train Teachable Machine Train a computer to recognize your own images, sounds, & poses. A fast, easy way to create machine learning models for your sites, apps, and more – no expertise or coding required. teachablemachine.withgoogle.com Teachable Machine ๊ตฌ๊ธ€์—์„œ ๋งŒ๋“  ๋ฌด๋ฃŒ ๋จธ์‹ ๋Ÿฌ๋‹ ์‚ฌ์ดํŠธ์ด๋‹ค.. ํ˜„์žฌ ์›น์บ ๊ณผ ์ด๋ฏธ์ง€๋กœ ๊ตฌ๋ถ„๋˜์–ด ์žˆ๋Š”๋ฐ ๊ต‰์žฅํžˆ ์žฌ๋ฐŒ๋‹ค. Teachable Machine ๋Œ€์‹œ๋ณด๋“œ Class1 ๊ณผ Class2๋Š” ๋ถ„๋ฅ˜๋ผ๊ณ  ๋ณด๋ฉด๋˜๊ณ ..

article thumbnail
java excel download ์ž๋ฐ” ์—‘์…€ ๋‹ค์šด๋กœ๋“œ

//์—‘์…€๋‹ค์šด๋กœ๋“œ ์‹œ์ž‘ @Override public void list_excel(ModelAndView mav) { Mapmap=mav.getModelMap(); HttpServletRequest request=(HttpServletRequest)map.get("request"); String searchType=request.getParameter("searchType"); String searchData=request.getParameter("searchData"); /* ๊ฒ€์ƒ‰์กฐ๊ฑด */ mav.addObject("searchType",searchType); mav.addObject("searchData",searchData); String sDate=request.getParameter("sDate"..