ktwmomo

어째건 감사합니다.
&nbsp;

findOne

어찌하다보니까. 아래처럼 하니까 되네요. 어렵다. 소뒷발로 쥐잡음
<pre style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'JetBrains Mono',monospace; font-size: 9.8pt;">@PostMapping(value = "/books/Search_id1") public String searchIdFormList(BookMemberForm form,Model model) { BookMember bookMemberUi = new BookMember(); Optional<BookMember> bookMember = bookMagService.findOne(form.getBookId()); bookMemberUi = bookMember.get(); model.addAttribute("member", bookMemberUi); return "bookMember/bookMemberSingle"; }</pre>
&nbsp;

친절한 답변 감사합니다. 근데 계속해서 질문하게되네요. 미천한 공부라...ㅠ.ㅠ
&nbsp;
<h3>&nbsp; &nbsp; [[[[[ BookMagController ]]]]]</h3>
&nbsp; &nbsp; @PostMapping(value = "/books/Search_id1")
&nbsp; &nbsp; public String searchIdFormList(BookMemberForm form,Model model)&nbsp; {
&nbsp; &nbsp; &nbsp; &nbsp; System.out.println("####&nbsp; BookMagController @PostMapping ===> bookId: " + form.getBookId());
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; model.addAttribute("members",&nbsp; bookMagService.findOne(form.getBookId()));
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; System.out.println("]]]]]] ####&nbsp; BookMagController bookMagService model : " + model);
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; return "bookMember/bookMemberSingle";
&nbsp; &nbsp; }
&nbsp;
<h3>&nbsp; &nbsp; [[[[ BookMagService.java ]]]]]]</h3>
&nbsp; &nbsp; public Optional<BookMember> findOne(Long memberId) {
&nbsp; &nbsp; &nbsp; &nbsp; System.out.println("#### BookMagService ===> bookId: " + memberId);
&nbsp; &nbsp; &nbsp; &nbsp; return bookMemberRepository.findByBookId(memberId);
&nbsp; &nbsp; }
&nbsp;
<h3>&nbsp; &nbsp; [[[[[ bookMemberSingle.html ]]]]]]</h3>
&nbsp; &nbsp; <!DOCTYPE HTML>
 <html xmlns:th="http://www.thymeleaf.org">
 <body>
 <div class="container">
 <div>
 <table>
 <thead>
 <tr>
 <th>도서ID</th>
 <th> 도서명&nbsp; &nbsp; &nbsp; &nbsp; </th>
 <th> 도서십진분류&nbsp; &nbsp;</th>
 <th> 사업자등록번호 </th>
 <th> 출판사&nbsp; &nbsp; &nbsp; &nbsp;</th>
 <th> 저자id&nbsp; &nbsp; &nbsp; &nbsp;</th>
 <th> 저자명&nbsp; </th>
 <th> 출판일&nbsp; &nbsp; &nbsp; &nbsp;</th>
 <th> 가격&nbsp; &nbsp;</th>
 </tr>
 </thead>
 <tbody>
 <tr th:each="member : ${members}">
 <td th:text="${member.bookId}"></td>
 <td th:text="${member.bookName}"></td>
 <td th:text="${member.book_kdc}"></td>
 <td th:text="${member.book_publisher_business_no}"></td>
 <td th:text="${member.book_publisher}"></td>
 <td th:text="${member.book_author_id}"></td>
 <td th:text="${member.book_author}"></td>
 <td th:text="${member.book_make_date}"></td>
 <td th:text="${member.book_price}"></td>
 </tr>
&nbsp;
 </tbody>
 </table>
 </div>
 </div> 
 </body>
 </html>
 
<h3>상기처럼했는데 아래와같은 오류가 나네요? 어떻게 해야할지 감이 안옵니다. </h3>
 
 ####&nbsp; BookMagController @PostMapping ===> bookId: 1001
 #### BookMagService ===> bookId: 1001
 Hibernate: select bookmember0_.book_id as book_id1_0_, bookmember0_.book_name as book_nam2_0_,&nbsp;
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; bookmember0_.book_author as book_aut3_0_, bookmember0_.book_author_id as book_aut4_0_,
 &nbsp; bookmember0_.book_kdc as book_kdc5_0_, bookmember0_.book_make_date as book_mak6_0_,&nbsp;
 &nbsp; bookmember0_.book_price as book_pri7_0_, bookmember0_.book_publisher as book_pub8_0_,&nbsp;
 &nbsp; bookmember0_.book_publisher_business_no as book_pub9_0_ from book_mag bookmember0_&nbsp;
 where bookmember0_.book_id=?
 ]]]]]] ####&nbsp; BookMagController bookMagService model : {bookMemberForm=book.booksmag.controller.BookMemberForm@52983985,&nbsp;
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;org.springframework.validation.BindingResult.bookMemberForm=
 &nbsp; &nbsp;org.springframework.validation.BeanPropertyBindingResult: 0 errors,&nbsp;
 &nbsp; &nbsp;members=Optional[book.booksmag.domain.BookMember@3b5ecc69]}
 2022-06-30 10:57:56.885 ERROR 32896 --- [nio-8080-exec-4] org.thymeleaf.TemplateEngine&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;:&nbsp;
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[THYMELEAF][http-nio-8080-exec-4] Exception processing template "bookMember/bookMemberSingle":&nbsp;
 Exception evaluating SpringEL expression: "member.bookId" (template: "bookMember/bookMemberSingle" - line 22, col 21)
&nbsp;
 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'&nbsp;
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- maybe not public or not valid?
&nbsp;
<h3>타입이 안맞다는것 같은데요?</h3>
<h3>cannot be found on object of type 'java.util.Optional'&nbsp;</h3>

<pre style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'JetBrains Mono',monospace; font-size: 9.8pt;">public class BookMember { private String bookName;</pre>
<pre style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'JetBrains Mono',monospace; font-size: 9.8pt;">Optional<BookMember> findByBookName(String bookName);</pre>
상기처럼 했더니 에러는 안나네요.&nbsp;&nbsp;
감사합니다. 코볼세데라 어렵네요 ㅋㅋ
개념이 안잡힘
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

에러 문의

<pre data-ke-type="codeblock"> "findBy" 이후에 엔티티의 속성 이름을 붙이다. 이 속성 이름은 첫 글자는 대문자로 한다. </pre>
상기처럼&nbsp;
<pre style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'JetBrains Mono',monospace; font-size: 9.8pt;">Optional<BookMember> findByBook_name(String book_name);</pre>
으로 바꾸고 BookMember에도 book_name인데
<pre style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'JetBrains Mono',monospace; font-size: 9.8pt;">private String book_name; </pre>
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' 으로 인식되나요?&nbsp;&nbsp;
"_"를 쓰면 안되나요?
귀찬게 해서 죄송합니다.
&nbsp;
&nbsp;

name이라는 필드는 필수로 있어야하나요?
테이블 구성이&nbsp;
CREATE TABLE BOOK_MAG
(BOOK_ID NUMBER(13) PRIMARY KEY,&nbsp;
&nbsp;BOOK_NAME VARCHAR(255),
&nbsp;BOOK_KDC NUMBER(3),
&nbsp;BOOK_PUBLISHER_BUSINESS_NO&nbsp; NUMBER(10),
&nbsp;BOOK_PUBLISHER&nbsp; VARCHAR(255),
&nbsp;BOOK_AUTHOR_ID NUMBER(9),
&nbsp;BOOK_AUTHOR&nbsp; VARCHAR(255),
&nbsp;BOOK_MAKE_DATE DATE,
&nbsp;BOOK_PRICE NUMBER(13)
&nbsp;
&nbsp;);
이런데요?

빠른 답변&nbsp; 감사합니다.
BookMember에
<pre style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'JetBrains Mono',monospace; font-size: 9.8pt;">@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),</pre>
상기 처럼 되있고
SpringDataJpaBookMemberRepository에&nbsp;
<pre style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'JetBrains Mono',monospace; font-size: 9.8pt;">public interface SpringDataJpaBookMemberRepository extends JpaRepository<BookMember,Long>, BookMemberRepository { @Override Optional<BookMember> findByName(String book_name); }</pre>
상기처럼 했는데도 동일 에러 나오는데요? 어떻게해야할지 모르겠어요?
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'!
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

<pre style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'JetBrains Mono',monospace; font-size: 9.8pt;">@Entity @Table(name="book_mag") public class BookMember {</pre>
@Table을 추가해주니 되네요
&nbsp;

BOOK_MAG is not mapped 오류 문의

<pre style="background-color: #2b2b2b; color: #a9b7c6; font-family: 'JetBrains Mono',monospace; font-size: 9.8pt;">spring.datasource.url=jdbc:h2:tcp://localhost/~/test spring.datasource.driver-class-name=org.h2.Driver spring.datasource.username=sa</pre>
상기처럼 추가했는데 동일에러 납니다.
&nbsp;

Wrong user name or password ?

윈도우 사용자* File -> Setting&nbsp; 에 들어같는데&nbsp;<span style="background-color: #ffffff; color: #212529; font-family: Pretendard, -apple-system, BlinkMacSystemFont, system-ui, Roboto, 'Helvetica Neue', 'Segoe UI', 'Apple SD Gothic Neo', 'Noto Sans KR', 'Malgun Gothic', 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol', sans-serif; font-size: 18px;">Preferences를 못 찿겠어요?

ktwmomo

Posts