[스프링부트] 홈페이지 만들기[2] - map 개념, 게시판
1. bbslist : 데이터 가져오기 Bbs.xml select seq, id, ref, step, depth, title, content, wdate, del, readcount from (select row_number()over(order by ref desc, step asc) as rnum, seq, id, ref, step, depth, title, content, wdate, del, readcount from bbs where 1=1 and title like concat('%', #{search}, '%') and del=0 and content like concat('%', #{search}, '%') and del=0 and id=#{search} and del=0 order by ..
2023. 3. 27.
[스프링부트] 홈페이지 만들기[1] - 로그인, 회원가입
1. 백앤드 Member.xml select count(*) from member where id=#{id} insert into member(id, pwd, name, email, auth) values(#{id}, #{pwd}, #{name}, #{email}, 3) select id, name, email from member where id=#{id} and pwd=#{pwd} MemberDao.java package mul.cam.a.dao; import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository; import mul.cam.a.dto.MemberDto; @Mapper @Reposit..
2023. 3. 27.
