๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ

(125)
datetimepicker 400์—๋Ÿฌ (์ž๋ฃŒํ˜•) ์ •๋ชจ ๋งŒ๋‚˜๋Š” ์‹œ๊ฐ„์„ ์ •ํ•˜๊ธฐ ์œ„ํ•ด์„œ datetimepicker๋ฅผ ์‚ฌ์šฉํ•ด์•ผ ํ–ˆ๋Š”๋ฐ // JS์ฝ”๋“œ jQuery('#datetimepicker').datetimepicker({ format:'Y-m-d H:i', lang:'ko' }); }); ๊ณ„์† ์ปจํŠธ๋กค๋Ÿฌ๋กœ ๋„˜์–ด๊ฐ€์ง€ ์•Š๊ณ  400์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒ datepicker๋„ ๊ฐ™์€ ์˜ค๋ฅ˜๊ฐ€ ๋‚ฌ์„ ๋•Œ vo์˜ ์ž๋ฃŒํ˜• ๋•Œ๋ฌธ์ด์˜€์œผ๋‹ˆ๊นŒ ๊ฐ™์€ ์ƒํ™ฉ์ด๊ฒ ์ง€ ํ•˜๊ณ  ๊ตฌ๊ธ€๋ง! vo ์˜ Date(java.sql) ํƒ€์ž…์„ LocalDateTime์œผ๋กœ ๋ฐ”๊ฟ”์ฃผ๊ณ  @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm") ์–ด๋…ธํ…Œ์ด์…˜์„ ์‚ฌ์šฉ >> ์ž๋ฃŒํ˜•์„ LocalDateTime์œผ๋กœ ์ง€์ •ํ•˜๋‹ˆ mysql์—์„œ ๋‹ค์‹œ ๊ฐ€์ ธ์˜ฌ ๋•Œ null ๊ฐ’์ด ๋œธ String ํ˜•์œผ๋กœ ๋ฐ”๊พธ๋‹ˆ insert์™€ s..
JOINUS - ์นดํ…Œ๊ณ ๋ฆฌ๋ณ„ ๋ฆฌ์ŠคํŠธ(mapper์—์„œ ํ…Œ์ด๋ธ” ๋‹ค์ค‘ ์กฐ์ธํ•˜๊ธฐ) ์ „์ฒด ํด๋Ÿฝ ๋ฆฌ์ŠคํŠธ์™€ ์นดํ…Œ๊ณ ๋ฆฌ๋ณ„ ํด๋Ÿฝ ๋ฆฌ์ŠคํŠธ๋กœ ๊ตฌ๋ถ„ * Controller - interest_no != null ์ด๋‚˜ interest_no == "" ์ด input String "" ์˜ค๋ฅ˜๊ฐ€ ๋– ์„œ ๊ณ„์† ๊ณ ๋ฏผํ•˜๋‹ค๊ฐ€ ์ฐพ์€ isEmptyํ•จ์ˆ˜(isBlank ํ•จ์ˆ˜๋„ ๊ฐ€๋Šฅ) * DB๊ฐ€ ์„ธ๋ถ„ํ™” ๋˜์–ด ์žˆ์–ด์„œ ๊ณ„์†ํ•ด์„œ JOIN์„ ์จ์•ผ ํ–ˆ๋Š”๋ฐ ๊ตฌ๊ธ€๋งํ•˜๋‹ค๊ฐ€ MAPPER์—์„œ ResultMap๊ณผ selectํ•œ ์ •๋ณด๋ฅผ ์ƒˆ๋กœ์šด VO๋ฅผ ๋งŒ๋“ค์–ด ์ €์žฅํ•˜๋Š” ๋ฐฉ๋ฒ•์œผ๋กœ ์ง„ํ–‰ VO๋Š” ํ…Œ์ด๋ธ”๊ณผ ๋˜‘๊ฐ™์ด ๋งŒ๋“ค์–ด ์คฌ์Œ ClubTotalBean ์„ ์‚ฌ์šฉํ•ด์„œ ๋‚ด๊ฐ€ ๊ฐ€์ ธ์˜ฌ ์ •๋ณด๋“ค์ด ์žˆ๋Š” VO๋“ค์„ ๋„ฃ์–ด์ค€๋‹ค(๋กฌ๋ณต ์‚ฌ์šฉ) ์„œ๋น„์Šค์—์„œ ClubTotalBean์œผ๋กœ List๋ฅผ ๋ฐ›๋Š” ๋ฉ”์„œ๋“œ๋ฅผ ์ƒ์„ฑ ClubDAO๋ฅผ ์ฃผ์ž…๋ฐ›์€ ServiceImpl ์—์„œ dao๋กœ ํ˜ธ์ถœ DAO..
JOINUS - ๊ธฐ๋ณธ ์„ค์ • ์ฃผ์ œ : ์ง€์—ญ๊ธฐ๋ฐ˜ ์†Œ๋ชจ์ž„ ์ปค๋ฎค๋‹ˆํ‹ฐ ํ”Œ๋žซํผ ์ธ์› : 6๋ช… ๊ธฐ๊ฐ„ : 2022.6.27 ~ 2022.7.27 ๊ฐœ๋ฐœํ™˜๊ฒฝ OS : Windows10 Server : Tomcat8.5 Language : Java, JavaScript, HTML5, CSS DB : MySQL8.0 Framework : Spring, MyBatis, Bootstrap Hosting : Cafe24 ETC : Git ๋‚ด๊ฐ€ ๋งก์€ ๊ธฐ๋Šฅ 1. ์†Œ๋ชจ์ž„ ๋ฆฌ์ŠคํŠธ 2. ๋ชจ์ž„ ๊ด€๋ฆฌ ํŽ˜์ด์ง€ 3. ๋ชจ์ž„ ๋‚˜๊ฐ€๊ธฐ 4. ๋ชจ์ž„ ํšŒ์› ๊ฐ•ํ‡ด๊ธฐ๋Šฅ 5. ๋ชจ์ž„์žฅ ๊ถŒํ•œ ๋„˜๊ฒจ์ฃผ๊ธฐ
MYSQL - Error Code : 1175 * ํšŒ์›์„ ์‚ญ์ œํ•˜๋ ค๊ณ  ํ•˜๋Š”๋ฐ ๋ฐœ์ƒํ•œ ์˜ค๋ฅ˜ Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. mysql์—์„œ ๊ธฐ๋ณธ์ ์œผ๋กœ ์…‹ํŒ…ํ•ด ๋†“์€ ์„ค์ • ์ด delete๋Š” ํ•˜๋‚˜์˜ row๋งŒ ๊ฐ€๋Šฅํ•˜๋„๋ก ๋˜์–ด์žˆ๊ธฐ ๋•Œ๋ฌธ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ• : Workbench - edit - Preferences์—์„œ ์•ˆ์ „๋ชจ๋“œ(Safe mode)๋ฅผ ํ•ด์ œํ•œ๋‹ค. >> workbench ์žฌ์‹คํ–‰
Error : ๋™์ ์ฟผ๋ฆฌ <where> ์‚ฌ์šฉ์‹œ ์—๋Ÿฌ org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'interest_no' in 'class java.lang.Integer' org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982) org.springfra..
ERROR: org.springframework.web.context.ContextLoader - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in ServletContext resource [/WEB-INF/spring/root-context.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\Users\Eunb\TeamProject\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtp..
Error : SEVERE: ์ž์‹ ์ปจํ…Œ์ด๋„ˆ๋ฅผ ์‹œ์ž‘ ์ค‘ ์‹คํŒจํ–ˆ์Šต๋‹ˆ๋‹ค. SEVERE: ์ž์‹ ์ปจํ…Œ์ด๋„ˆ๋ฅผ ์‹œ์ž‘ ์ค‘ ์‹คํŒจํ–ˆ์Šต๋‹ˆ๋‹ค. java.util.concurrent.ExecutionException: org.apache.catalina.LifecycleException: ๊ตฌ์„ฑ์š”์†Œ [org.apache.catalina.webresources.StandardRoot@7ec8a38f]์„(๋ฅผ) ์‹œ์ž‘ํ•˜์ง€ ๋ชปํ–ˆ์Šต๋‹ˆ๋‹ค. at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191) at org.apache.catalina.core.ContainerBase.startInternal(ContainerB..
ERROR : org.springframework.web.util.NestedServletException org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalStateException: Optional int parameter 'club_no' is present but cannot be translated into a null value due to being declared as a primitive type. Consider declaring it as object wrapper for the corresponding primitive type. club_no๋ฅผ ๋ฐ›๋Š”๋ฐ null๋กœ ๋ณ€ํ™˜๋จ ํ•ด๊ฒฐ : ์ฃผ์†Œ์ค„์ด๋ž‘ ์„ ์–ธํ•ด์ค€ ๋ณ€์ˆ˜๋ช…์ด๋ž‘ ์ผ์น˜ํ•˜๋Š”์ง€ ํ™•์ธ

๋ฐ˜์‘ํ˜•