728x90
๋ฐ˜์‘ํ˜•

์ „์ฒด ๊ธ€ 1364

dbeaver์—์„œ ๊ธ€๊ผด ํฌ๊ธฐ ์กฐ์ •ํ•˜๋Š” ๋‹จ์ถ•ํ‚ค

DBeaver์—์„œ ๊ธ€๊ผด ํฌ๊ธฐ๋ฅผ ์กฐ์ •ํ•˜๋Š” ๋‹จ์ถ•ํ‚ค๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค:๊ธ€๊ผด ํฌ๊ธฐ ํ‚ค์šฐ๊ธฐ: Ctrl + + (์ˆซ์ž ํŒจ๋“œ์˜ + ํ‚ค)๊ธ€๊ผด ํฌ๊ธฐ ์ค„์ด๊ธฐ: Ctrl + - (์ˆซ์ž ํŒจ๋“œ์˜ - ํ‚ค)๊ธฐ๋ณธ ํฌ๊ธฐ๋กœ ์ดˆ๊ธฐํ™”: Ctrl + 0 (์ˆซ์ž ํŒจ๋“œ์˜ 0 ํ‚ค)์œ„ ๋‹จ์ถ•ํ‚ค๊ฐ€ ์ž‘๋™ํ•˜์ง€ ์•Š๋Š” ๊ฒฝ์šฐ, ์•„๋ž˜์™€ ๊ฐ™์ด ์„ค์ •์„ ํ†ตํ•ด ๊ธ€๊ผด ํฌ๊ธฐ๋ฅผ ๋ณ€๊ฒฝํ•  ์ˆ˜๋„ ์žˆ์Šต๋‹ˆ๋‹ค.DBeaver ์„ค์ •์œผ๋กœ ์ด๋™: Window > PreferencesEditors > Text Editors์—์„œ Font ์„น์…˜์„ ์ฐพ์€ ํ›„, ์›ํ•˜๋Š” ๊ธ€๊ผด ํฌ๊ธฐ๋ฅผ ์„ค์ •

IT์ง€์‹ 2024.11.02

[Error]required a bean of type '*' that could not be found

Parameter 0 of constructor in *(service) required a bean of type '*'(repository) that could not be found. ์ด ์˜ค๋ฅ˜๋Š” ์ผ๋ฐ˜์ ์œผ๋กœ Spring์ด ๋นˆ์„ ์ฐพ์„ ์ˆ˜ ์—†์„ ๋•Œ ๋ฐœ์ƒํ•ฉ๋‹ˆ๋‹ค SysEdocRepository. ํ™•์ธํ•ด์•ผ ํ•  ๋ช‡ ๊ฐ€์ง€ ์ผ๋ฐ˜์ ์ธ ๋ฌธ์ œ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค. @Repository ์–ด๋…ธํ…Œ์ด์…˜ ๋นผ๋œจ๋ ค์„œ ๋ฐœ์ƒ

Error 2024.10.28

[JAVA] List ์„ ์–ธ๋งŒ ํ•˜๊ธฐ, ์„ ์–ธํ•˜๊ณ  ์ดˆ๊ธฐํ™” ํ•˜๊ธฐ ์ฐจ์ด

1.List leadMtrmList = new ArrayList();์„ ์–ธ ๋ฐ ์ดˆ๊ธฐํ™” : ์ด ์ค„์€ ๋ช…๋ช…๋œ ๊ฐ์ฒด List์˜ ๋ฅผ ์„ ์–ธ ํ•˜๊ณ  ๋™์‹œ์— ์ƒˆ .๋กœ ์ดˆ๊ธฐํ™”ํ•ฉ๋‹ˆ๋‹ค .ResLeadMtrmListDTOleadMtrmListArrayList์‚ฌ์šฉ๋ฒ• : leadMtrmList์ดˆ๊ธฐํ™”๋˜์—ˆ๊ธฐ ๋•Œ๋ฌธ์— ์š”์†Œ๋ฅผ ์ถ”๊ฐ€, ์ œ๊ฑฐ ๋˜๋Š” ์กฐ์ž‘ํ•˜๋Š” ๋ฐ ์ฆ‰์‹œ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.๋ฉ”๋ชจ๋ฆฌ ํ• ๋‹น : ์ด new ArrayList()๋ถ€๋ถ„์€ ์‚ฌ์šฉํ•  ์ค€๋น„๊ฐ€ ๋œ ๋นˆ ๋ชฉ๋ก์„ ๋ฉ”๋ชจ๋ฆฌ์— ์ƒ์„ฑํ•ฉ๋‹ˆ๋‹ค.2.List leadMtrmList;์„ ์–ธ๋งŒ ํ•ด๋‹น : ์ด ์ค„์€ ๋ชฉ๋ก์„ ์„ ์–ธ๋งŒ leadMtrmListํ•˜๊ณ  List์ดˆ๊ธฐํ™”ํ•˜์ง€๋Š” ์•Š์Šต๋‹ˆ๋‹ค.์‚ฌ์šฉ๋ฒ•leadMtrmList : ์ดˆ๊ธฐํ™”ํ•˜์ง€ ์•Š๊ณ  ์‚ฌ์šฉํ•˜๋ ค๊ณ  ํ•˜๋ฉด ์ƒˆ ์ธ์Šคํ„ด์Šค๊ฐ€ ํ• ๋‹น๋  ๋•Œ๊นŒ์ง€ NullPointerException๊ทธ..

JAVA 2024.10.27

[JAVA] 4์ž๋ฆฌ ๋ฌธ์ž์—ด์„ HH:mmํ˜•์‹์œผ๋กœ ๋ณ€ํ™˜

DateTimeFormatter ์‚ฌ์šฉimport java.time.LocalDate;import java.time.LocalTime;import java.time.format.DateTimeFormatter;import java.util.List;import java.util.stream.IntStream;public void updateMtDtRangeWithDateAndTime(List leadMtrmList, List ldMtrmList) { // Define date and time formatters DateTimeFormatter dateInputFormatter = DateTimeFormatter.ofPattern("yyyyMMdd"); DateTimeFormatter dat..

JAVA 2024.10.26

[SPRING] ์Šค์ผ€์ฅด๋Ÿฌ ํ…Œ์ŠคํŠธ

ํ…Œ์ŠคํŠธ๋ฅผ ์œ„ํ•œ ํฌ๋ก  ํ‘œํ˜„์‹ ๋‹จ์ถ•ํ…Œ์ŠคํŠธ๋ฅผ ์œ„ํ•ด "0 */1 * * * *"์œผ๋กœ ๋ณ€๊ฒฝํ•˜๋ฉด 1๋ถ„๋งˆ๋‹ค ๋ฉ”์„œ๋“œ๊ฐ€ ์‹คํ–‰๋˜์–ด ๋กœ๊ทธ ์ถœ๋ ฅ ์—ฌ๋ถ€๋ฅผ ๋น ๋ฅด๊ฒŒ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

JAVA/SPRING 2024.10.24

[DB][MySQL] ๋‚ ์งœ+์‹œ๊ฐ„ ๋ฌธ์ž์—ด๊ณผ ๋‚ ์งœ๋ฌธ์ž์—ด ๋น„๊ตํ•˜๊ธฐ

SELECT '์„ค์น˜' AS ๋ถ„๋ฅ˜, EO_RQ_TP AS ์š”์ฒญ์œ ํ˜•, CUST_CD, CT.CUST_NM AS ๊ณ ๊ฐ์‚ฌ, CR_CD, CR.CR_SCD AS ๊ณ ๊ฐ๋ฒˆํ˜ธ, EO_STAT_TP AS ์š”์ฒญ์ƒํƒœ, STR_TO_DATE(CONCAT(RQ1_DT, RQ1_TM), '%Y%m%d%H%i') AS ์™„๋ฃŒ์š”์ฒญ์ผ -- ๋‚ ์งœ์™€ ์‹œ๊ฐ„์„ ๊ฒฐํ•ฉํ•˜์—ฌ ๋ณ€ํ™˜FROM T_EO JOIN CUSTOMER_TABLE CT ON T_EO.CUST_CD = CT.CUST_CD -- ๊ณ ๊ฐ์‚ฌ ์ •๋ณด JOINJOIN CUSTOMER_RELATION_TABLE CR ON T_EO.CR_CD = CR.CR_CD -- ๊ณ ๊ฐ๋ฒˆํ˜ธ ์ •๋ณด JOINWHERE RS_USER_CD = ๋กœ๊ทธ์ธ์œ ์ € -- ๋กœ๊ทธ์ธํ•œ ..

DB 2024.10.23
728x90
๋ฐ˜์‘ํ˜•