WON.dev

SELECT mem.userid, userpw, username, enabled, regdate, updatedate, auth FROM tbl_member mem LEFT JOIN tbl_member_auth auth ON mem.userid=auth.userid WHERE mem.userid=#{userid}

(#{pageNum} - 1) * #{amount} ]]> INSERT INTO tbl_board VALUES( seq_board.nextval, #{title}, #{content}, #{writer}, sysdate, sysdate, 0 ) select * from tbl_board where bno=#{bno} delete from tbl_board where bno=#{bno} update tbl_board set title=#{title}, content=#{content}, writer=#{writer}, updateDate = sysdate where bno=#{bno} select count(*) from tbl_board where bno > 0 update tbl_board set re..

INSERT INTO tbl_attach(uuid, uploadPath, fileName, fileType, bno) VALUES( #{uuid}, #{uploadPath}, #{fileName}, '', #{bno} ) delete from tbl_attach where uuid=#{uuid} SELECT * FROM tbl_attach where bno=#{bno} delete tbl_attach where bno=#{bno}

package org.joonzis.service; import org.joonzis.mapper.Sample1Mapper; import org.joonzis.mapper.Sample2Mapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import lombok.Setter; import lombok.extern.log4j.Log4j; @Log4j @Service public class SampleTxServiceImpl impleme..

package org.joonzis.service; public interface SampleTxService { public void addData(String value); }

package org.joonzis.service; import java.util.List; import org.joonzis.domain.Criteria; import org.joonzis.domain.ReplyVO; import org.joonzis.mapper.BoardMapper; import org.joonzis.mapper.ReplyMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import lombok.extern.l..

package org.joonzis.service; import java.util.List; import org.joonzis.domain.Criteria; import org.joonzis.domain.ReplyVO; public interface ReplyService { public List getList(long bno); public ReplyVO get(long rno); public int register(ReplyVO vo); public int remove(long rno); public int modify(ReplyVO vo); }

package org.joonzis.service; import java.util.List; import org.joonzis.domain.BoardAttachVO; import org.joonzis.domain.BoardVO; import org.joonzis.domain.Criteria; import org.joonzis.mapper.BoardAttachMapper; import org.joonzis.mapper.BoardMapper; import org.joonzis.mapper.ReplyMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; i..

package org.joonzis.service; import java.util.List; import org.joonzis.domain.BoardAttachVO; import org.joonzis.domain.BoardVO; import org.joonzis.domain.Criteria; public interface BoardService { public List getList(Criteria cri); public void register(BoardVO vo); public BoardVO get(long bno); public boolean remove(long bno); public boolean modify(BoardVO vo); public int getTotal(); public List ..

package org.joonzis.security.domain; import java.util.Collection; import java.util.stream.Collectors; import org.joonzis.domain.MemberVO; import org.springframework.security.core.GrantedAuthority; import org.springframework.security.core.authority.SimpleGrantedAuthority; import org.springframework.security.core.userdetails.User; import lombok.Getter; @Getter public class CustomUser extends User{..