스프링부트 마이바티스 연동

스프링부트 마이바티스 연동

나중에 다시 헤메지 않도록 작성해둔다.

pom.xml

의존성 객체 추가

org.mybatis.spring.boot mybatis-spring-boot-starter 2.2.0 mysql mysql-connector-java runtime

mybatis-config.xml

mapper가 스캔할 경로들 미리 설정

application.properties

DB Connection을 위한 환경 설정

spring.datasource.type=com.zaxxer.hikari.HikariDataSource spring.datasource.url=jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8&serverTimezone;=UTC spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.username=root spring.datasource.password=0000 mybatis.config-location=classpath:mybatis-config.xml spring.servlet.multipart.maxFileSize=5MB spring.servlet.multipart.maxRequestSize=5MB image.root.path=/images image.default.path=/default

AdminUserMapper.java

인터페이스를 @Mapper로 등록

@Mapper public interface AdminUserMapper { AdminUser login(AdminUser param); int doubleCheck(String id); int join(AdminUser user); List adminUserList(AdminUser param); AdminUser detail(int pk); int deleteAdmin(AdminUser adminUser); int updateAdmin(AdminUser adminUser); }

AdminUserMapper.xml

: 매우 중요! 패키지명 반드시 정확히 일치해야 함.

SELECT pk, id, name, date_format(joinDate,'%Y-%m-%d %H:%i:%s') as joinDate, del, date_format(delDate,'%Y-%m-%d %H:%i:%s') as delDate FROM AdminUser WHERE 1=1 AND id LIKE CONCAT('%', #{id}, '%') AND date_format(joinDate,'%Y-%m-%d') BETWEEN #{startDt} AND #{endDt} ORDER BY joinDate desc SELECT pk, id, name, date_format(joinDate,'%Y-%m-%d %H:%i:%s') as joinDate, del, date_format(delDate,'%Y-%m-%d %H:%i:%s') as delDate FROM AdminUser WHERE pk = ${pk} SELECT pk, id, password, del FROM AdminUser WHERE id = #{id} SELECT count(pk) FROM AdminUser WHERE id = #{id} INSERT INTO AdminUser ( id, password, name, del, joinDate ) VALUES( #{id}, #{password}, #{name}, 'N', now() ) UPDATE AdminUser SET del='Y', delDate = NOW() WHERE 1=1 AND pk IN , #{item} UPDATE AdminUser SET name=#{name} , password = #{password} WHERE pk = #{pk}

from http://coding-plant.tistory.com/3 by ccl(A) rewrite - 2021-12-08 11:27:26