ktwmomo
Reviews Written
2
Average Rating
5.0
Posts
Q&A
findOne
์ด์งธ๊ฑด ๊ฐ์ฌํฉ๋๋ค.
- 0
- 4
- 380
Q&A
findOne
์ด์ฐํ๋ค๋ณด๋๊น. ์๋์ฒ๋ผ ํ๋๊น ๋๋ค์. ์ด๋ ต๋ค. ์๋ท๋ฐ๋ก ์ฅ์ก์ @PostMapping(value = "/books/Search_id1")public String searchIdFormList(BookMemberForm form,Model model) { BookMember bookMemberUi = new BookMember(); Optional bookMember = bookMagService.findOne(form.getBookId()); bookMemberUi = bookMember.get(); model.addAttribute("member", bookMemberUi); return "bookMember/bookMemberSingle";}
- 0
- 4
- 380
Q&A
findOne
์น์ ํ ๋ต๋ณ ๊ฐ์ฌํฉ๋๋ค. ๊ทผ๋ฐ ๊ณ์ํด์ ์ง๋ฌธํ๊ฒ๋๋ค์. ๋ฏธ์ฒํ ๊ณต๋ถ๋ผ...ใ .ใ [[[[[ BookMagController ]]]]] @PostMapping(value = "/books/Search_id1") public String searchIdFormList(BookMemberForm form,Model model) { System.out.println("#### BookMagController @PostMapping ===> bookId: " + form.getBookId()); model.addAttribute("members", bookMagService.findOne(form.getBookId())); System.out.println("]]]]]] #### BookMagController bookMagService model : " + model); return "bookMember/bookMemberSingle"; } [[[[ BookMagService.java ]]]]]] public Optional findOne(Long memberId) { System.out.println("#### BookMagService ===> bookId: " + memberId); return bookMemberRepository.findByBookId(memberId); } [[[[[ bookMemberSingle.html ]]]]]] ๋์ID ๋์๋ช ๋์์ญ์ง๋ถ๋ฅ ์ฌ์ ์๋ฑ๋ก๋ฒํธ ์ถํ์ฌ ์ ์id ์ ์๋ช ์ถํ์ผ ๊ฐ๊ฒฉ ์๊ธฐ์ฒ๋ผํ๋๋ฐ ์๋์๊ฐ์ ์ค๋ฅ๊ฐ ๋๋ค์? ์ด๋ป๊ฒ ํด์ผํ ์ง ๊ฐ์ด ์์ต๋๋ค. #### BookMagController @PostMapping ===> bookId: 1001 #### BookMagService ===> bookId: 1001 Hibernate: select bookmember0_.book_id as book_id1_0_, bookmember0_.book_name as book_nam2_0_, bookmember0_.book_author as book_aut3_0_, bookmember0_.book_author_id as book_aut4_0_, bookmember0_.book_kdc as book_kdc5_0_, bookmember0_.book_make_date as book_mak6_0_, bookmember0_.book_price as book_pri7_0_, bookmember0_.book_publisher as book_pub8_0_, bookmember0_.book_publisher_business_no as book_pub9_0_ from book_mag bookmember0_ where bookmember0_.book_id=? ]]]]]] #### BookMagController bookMagService model : {bookMemberForm=book.booksmag.controller.BookMemberForm@52983985, org.springframework.validation.BindingResult.bookMemberForm= org.springframework.validation.BeanPropertyBindingResult: 0 errors, members=Optional[book.booksmag.domain.BookMember@3b5ecc69]} 2022-06-30 10:57:56.885 ERROR 32896 --- [nio-8080-exec-4] org.thymeleaf.TemplateEngine : [THYMELEAF][http-nio-8080-exec-4] Exception processing template "bookMember/bookMemberSingle": Exception evaluating SpringEL expression: "member.bookId" (template: "bookMember/bookMemberSingle" - line 22, col 21) org.thymeleaf.exceptions.TemplateProcessingException: Exception evaluating SpringEL expression: "member.bookId" (template: "bookMember/bookMemberSingle" - line 22, col 21) rg.springframework.expression.spel.SpelEvaluationException: EL1008E: Property or field 'bookId' cannot be found on object of type 'java.util.Optional' - maybe not public or not valid? ํ์ ์ด ์๋ง๋ค๋๊ฒ ๊ฐ์๋ฐ์? cannot be found on object of type 'java.util.Optional'
- 0
- 4
- 380
Q&A
์๋ฌ ๋ฌธ์
public class BookMember { private String bookName; Optional findByBookName(String bookName); ์๊ธฐ์ฒ๋ผ ํ๋๋ ์๋ฌ๋ ์๋๋ค์. ๊ฐ์ฌํฉ๋๋ค. ์ฝ๋ณผ์ธ๋ฐ๋ผ ์ด๋ ต๋ค์ ใ ใ ๊ฐ๋ ์ด ์์กํ
- 0
- 10
- 550
Q&A
์๋ฌ ๋ฌธ์
"findBy" ์ดํ์ ์ํฐํฐ์ ์์ฑ ์ด๋ฆ์ ๋ถ์ด๋ค. ์ด ์์ฑ ์ด๋ฆ์ ์ฒซ ๊ธ์๋ ๋๋ฌธ์๋ก ํ๋ค. ์๊ธฐ์ฒ๋ผ Optional findByBook_name(String book_name); ์ผ๋ก ๋ฐ๊พธ๊ณ BookMember์๋ book_name์ธ๋ฐ private String book_name; Failed to create query for method public abstract java.util.Optional book.booksmag.repository.SpringDataJpaBookMemberRepository.findByBook_name(java.lang.String)! No property 'book' found for type 'BookMember'! ์ Book_name์ด ์๋๊ณ 'book' ์ผ๋ก ์ธ์๋๋์? "_"๋ฅผ ์ฐ๋ฉด ์๋๋์? ๊ท์ฐฌ๊ฒ ํด์ ์ฃ์กํฉ๋๋ค.
- 0
- 10
- 550
Q&A
์๋ฌ ๋ฌธ์
name์ด๋ผ๋ ํ๋๋ ํ์๋ก ์์ด์ผํ๋์? ํ ์ด๋ธ ๊ตฌ์ฑ์ด CREATE TABLE BOOK_MAG (BOOK_ID NUMBER(13) PRIMARY KEY, BOOK_NAME VARCHAR(255), BOOK_KDC NUMBER(3), BOOK_PUBLISHER_BUSINESS_NO NUMBER(10), BOOK_PUBLISHER VARCHAR(255), BOOK_AUTHOR_ID NUMBER(9), BOOK_AUTHOR VARCHAR(255), BOOK_MAKE_DATE DATE, BOOK_PRICE NUMBER(13) ); ์ด๋ฐ๋ฐ์?
- 0
- 10
- 550
Q&A
์๋ฌ ๋ฌธ์
๋น ๋ฅธ ๋ต๋ณ ๊ฐ์ฌํฉ๋๋ค. BookMember์ @Entity@Table(name="book_mag")public class BookMember { // @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Id private Long book_id; //BOOK_ID NUMBER(13) PRIMARY KEY private String book_name; //BOOK_NAME VARCHAR(255), private Long book_kdc; //BOOK_KDC NUMBER(3), ์๊ธฐ ์ฒ๋ผ ๋์๊ณ SpringDataJpaBookMemberRepository์ public interface SpringDataJpaBookMemberRepository extends JpaRepository,Long>, BookMemberRepository { @Override Optional findByName(String book_name);} ์๊ธฐ์ฒ๋ผ ํ๋๋ฐ๋ ๋์ผ ์๋ฌ ๋์ค๋๋ฐ์? ์ด๋ป๊ฒํด์ผํ ์ง ๋ชจ๋ฅด๊ฒ ์ด์? Failed to create query for method public abstract java.util.Optional book.booksmag.repository.SpringDataJpaBookMemberRepository.findByName(java.lang.String)! No property 'name' found for type 'BookMember'!
- 0
- 10
- 550
Q&A
BOOK_MAG is not mapped ์ค๋ฅ ๋ฌธ์
@Entity@Table(name="book_mag")public class BookMember { @Table์ ์ถ๊ฐํด์ฃผ๋ ๋๋ค์
- 0
- 1
- 424
Q&A
Wrong user name or password ?
spring.datasource.url=jdbc:h2:tcp://localhost/~/testspring.datasource.driver-class-name=org.h2.Driverspring.datasource.username=sa ์๊ธฐ์ฒ๋ผ ์ถ๊ฐํ๋๋ฐ ๋์ผ์๋ฌ ๋ฉ๋๋ค.
- 16
- 5
- 5.5K
Q&A
Preferences ์ด๋ป๊ฒ ๋ค์ด๊ฐ์ผ ํ๋์?
์๋์ฐ ์ฌ์ฉ์* File -> Setting ์ ๋ค์ด๊ฐ๋๋ฐ Preferences๋ฅผ ๋ชป ์ฐฟ๊ฒ ์ด์?
- 0
- 3
- 338




