Mapper2

• 

  (22.12.23)Spring 프레임워크: Mybatis로 Spring과 Oracle 연동하여 게시판, 첨부파일 올리기 BoardVO.java 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 import java.util.ArrayList; import java.util.List; import lombok.AllArgsConstructor; import lombok.Data; import lombok.EqualsAndHashCode; import lombok.NoArgsConstructor; import lombok.ToString; @Data @ToString @EqualsAndHashCode(exclude= {"title","author","regDate","contents","hit","attList"}) @AllArgsConstructor @NoArgsConst.. Framework/Spring Framework 2022. 12. 25.

• 

  (22.12.21)GeneratedKeyHolder 사용하여 PK 저장하기, MyBatis 사용하여 DB에 연결하기 ●●GeneratedKeyHolder 사용하여 KEY값을 정하여 KeyHolder에 저장하기●● 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 public boolean addAndGetPK(Emp emp) { GeneratedKeyHolder kh = new GeneratedKeyHolder(); int rows = jdbcTemplate.update((conn)->{ PreparedStatement pstmt; String sql = "INSERT INTO emp2(empno, ename, deptno, sal, hiredate) " + "VALUES(?,?,?,?,?)"; pstmt = conn.prepareStatement(sql, new String[]{".. Framework/Spring Framework 2022. 12. 21.