Helmi

book_ex 계정 생성 후 각 게시물마다 고유 번호 필요 - 시퀀스 통해 이런 작업 처리 create sequence seq_board; 테이블 생성 regdate : 생성시간 create table tbl_board( bno NUMBER(10,0), title varchar2(200) NOT NULL, content varchar2(2000) NOT NULL, writer varchar2(50) NOT NULL, regdate date default sysdate, updatedate date default sysdate ); 데이터 추가 insert into tbl_board(bno, title, content, writer) values (seq_board.nextval, '테스트제목', '테스트..

1. java 버전 수정 11 5.2.7.RELEASE 1.6.10 1.6.6 2. spring-jdbc, spring-test 추가 org.springframework spring-webmvc ${org.springframework-version} org.springframework spring-test ${org.springframework-version} org.springframework spring-jdbc ${org.springframework-version} 3. MyBatis 사용 예정 - HikariCP, MyBatis, mybatis-spring, Log4jdbc 추가 com.zaxxer HikariCP 5.0.1 org.mybatis mybatis 3.5.11 org.mybatis m..

쿼리 메소드 Sample 및 JPQL snippet Keyword Sample JPQL snippet And findByLastnameAndFirstname ... where X.lastname = ?1 and X.firstname = ?2 Or findByLastnameOrFirstname ... where X.lastname = ?1 or X.firstname = ?2 Is, Equals finfByFirstname findByFirstnameIs findByFirstnameEquals ... where X.firstname = ?1 Between findByStartDateBetween ...where X.startDate between ?1 amd ?2 LessThan findByAgeLessTh..

package com.shop.repository; //기존 임포트 생략 import java.util.list; @SpringBootTest @TestPropertySource(locations="classpath:application-test.properties") class ItemRepositoryTests { @Autowired ItemRepository itemRepository; //코드 생략 public void createItemList2() { for(int i=1; i