select
-
03. Querydsl 기본 문법BackEnd/Querydsl 2021. 7. 17. 15:36
1. Querydsl 기본 문법 package com.spring.querydsl; import com.querydsl.jpa.impl.JPAQueryFactory; import org.junit.jupiter.api.BeforeEach; import org.junit.jupiter.api.Test; import org.springframework.boot.test.context.SpringBootTest; import org.springframework.transaction.annotation.Transactional; import com.spring.querydsl.entity.Member; import com.spring.querydsl.entity.QMember; import com.spring...
-
02. 게시판 (테이블 생성)Spring Web Project/2. 게시판 (Board) 2020. 11. 24. 13:11
00. Select Database > use mysql; 01. Create Table create table tbl_board ( bno INT NOT NULL AUTO_INCREMENT, title VARCHAR(200) NOT NULL, content TEXT NULL, writer VARCHAR(50) NOT NULL, regdate TIMESTAMP NOT NULL DEFAULT now(), viewcnt INT DEFAULT 0, PRIMARY KEY (bno)); 02. Table 생성 확인 select * from tbl_board; 03. Insert data insert into tbl_board(title, content, writer) values ('제목', '내용', 'User..