my-batis-config.xml에 경로를 선택해줬는데 찾지 못하는거같습니다.

Question

package kopo.poly.repository; import java.util.List; import java.util.Map; import kopo.poly.dto.BusinessMenubarDTO; import kopo.poly.dto.MemberDTO; import kopo.poly.dto.PictureDTO; import kopo.poly.mybatis.MemberMapper; import lombok.extern.slf4j.Slf4j; import org.apache.ibatis.session.SqlSession; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Component; import org.springframework.stereotype.Controller; import org.springframework.stereotype.Repository; import kopo.poly.dto.BusinessDTO; import org.apache.ibatis.session.SqlSession; @Repository @Slf4j public class MemberDao { private final SqlSession sqlSession; @Autowired public MemberDao(SqlSession sqlSession) { this.sqlSession = sqlSession; System.out.println("MemberDao SqlSession On -> " + this.sqlSession); } public int insertMember(MemberDTO member) throws Exception { return sqlSession.getMapper(MemberMapper.class).insertMember(member); } public int insertBusiness(BusinessDTO business, int picNum) throws Exception { business.setPic_num(picNum); return sqlSession.getMapper(MemberMapper.class).insertBusiness(business); } public MemberDTO selectMemberOne(String email) throws Exception { return sqlSession.getMapper(MemberMapper.class).selectMemberOne(email); } public BusinessDTO selectBusinessOne(String bu_email) throws Exception { return sqlSession.getMapper(MemberMapper.class).selectBusinessOne(bu_email); } public int memberTelCount(String tel) throws Exception { return sqlSession.getMapper(MemberMapper.class).memberTelCount(tel); } public int businessTelCount(String bu_tel) throws Exception { return sqlSession.getMapper(MemberMapper.class).businessTelCount(bu_tel); } public int updateBusiness(BusinessDTO business) throws Exception { return sqlSession.getMapper(MemberMapper.class).updateBusiness(business); } public List selectPic(int pic_num) throws Exception { return sqlSession.getMapper(MemberMapper.class).selectPic(pic_num); } public List getMenubar() { return sqlSession.getMapper(MemberMapper.class).getMenubar(); } public int passwordResetMember(Map map) { return sqlSession.getMapper(MemberMapper.class).passwordResetMember(map); } public int passwordResetBusiness(Map map) { return sqlSession.getMapper(MemberMapper.class).passwordResetBusiness(map); } } 이렇게 입력했는데 ***************************APPLICATION FAILED TO START***************************Description:Parameter 0 of constructor in kopo.poly.repository.MemberDao required a bean of type 'org.apache.ibatis.session.SqlSession' that could not be found.Action:Consider defining a bean of type 'org.apache.ibatis.session.SqlSession' in your configuration. 다음과 같은 에러가 뜹니다.. 어떻게 해결해야할까요?? 그리고 ```java 기능을 알려주신 'Clickin'님께 감사드립니다. https://okky.kr/questions/1428193#answer-664544

Clickin · Answer

왜 자꾸 DAO 에러난다고 DAO만 올리실까요 에러의 원인은 SqlSession이 정의되지 않은거고 DAO는 그 영향을 받았을 뿐인데요mybatis-config.xml만 덜렁 만들어놓는다고 자동으로 만들어지는 게 아닌데 계속 SqlSession이나 SqlSessionFactory 설정은 안보여주시는걸 보면 문제의 원인 파악이 덜 되신 듯한데그냥 프로젝트 전체를 깃헙에 올려서 링크 거시는 게 나아보입니다.프로젝트 전체 링크 올려주시면 한번 살펴보겠습니다.

Clickin · Answer

퇴근해서 좀 살펴봤는데요 여러모로 문제가 많습니다....사용하는 DTO 소스 커밋 안됨Collection Raw 타입으로 사용mybatis-spring-boot-starter로 자동세팅 사용하여서 존재하지 않는 SqlSession을 가져다 쓰고있음Mapper Interface에 @Mapper 어노테이션 없고 @MapperScan이 메인에 있지도 않아서 mybatis가 Mapper를 찾아올 방도가 없음AdminMapper는 이렇게 변경하시고package kopo.poly.mybatis; import java.util.List; import java.util.Map; import kopo.poly.dto.BookingDTO; import kopo.poly.dto.BusinessDTO; import kopo.poly.dto.ReviewDTO; import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; import org.apache.ibatis.annotations.Update; @Mapper public interface AdminMapper { // 미승인 사업자 목록 @Select(" SELECT * " + " FROM (SELECT rownum AS num, business.* FROM business where approval='0') " + " WHERE num between #{startPage} and #{endPage} " + " ORDER BY pic_num ") List notApprovalBuList(Map map); @Select("SELECT count(*) FROM business WHERE approval='0' ") int notApprovalBuCount(); @Update("UPDATE business SET approval ='1' WHERE bu_email = #{bu_email} ") int businessApproval(String bu_email); @Delete("DELETE FROM business WHERE bu_email = #{bu_email} ") int deleteBusiness(String bu_email); // 사업자 월별 매출 @Select("select sum(bo.price) price from booking bo where checkin like '____'||#{mon}||'%' ") BookingDTO selectSales(Map map); // 지역별 월별 매출 @Select("select sum(bo.price) price " + " from business bu, booking bo " + " where bu.bu_title = bo.bu_title and bu.bu_address like #{area}||'%' and bo.checkin like '____'||#{month}||'%' ") BookingDTO selectAreaSales(Map map); // 카테고리별 월별 매출 @Select("select sum(bo.price) price, bu.bu_id " + " from business bu, booking bo " + " where bu.bu_title = bo.bu_title and bu.bu_id like #{bu_id}||'%' and bo.checkin like '____'||#{month}||'%' " + " group by bu.bu_id order by bu.bu_id ") BookingDTO categorySales(Map map); @Select("SELECT r.*, b.bu_title, b.ro_name FROM review r, booking b WHERE r.report='1' and r.bo_num = b.bo_num") List reportedReview(); } AdminDAO는 이렇게 변경하시면 되겠네요package kopo.poly.repository; import java.util.HashMap; import java.util.List; import java.util.Map; import kopo.poly.dto.BookingDTO; import kopo.poly.dto.BusinessDTO; import kopo.poly.dto.ReviewDTO; import kopo.poly.mybatis.AdminMapper; import lombok.RequiredArgsConstructor; import org.springframework.stereotype.Repository; @Repository @RequiredArgsConstructor public class AdminDao { private final Map map = new HashMap<>(); private final AdminMapper adminMapper; public List notApprovalBuList(int startPage, int endPage) throws Exception { map.clear(); map.put("startPage", startPage); map.put("endPage", endPage); return adminMapper.notApprovalBuList(map); // adminMapper.notApprovalBuList(map); } public BookingDTO categorySales(Map map) { return adminMapper.categorySales(map); } public BookingDTO selectAreaSales(Map map) throws Exception { return adminMapper.selectAreaSales(map); } public int businessApproval(String bu_email) throws Exception { return adminMapper.businessApproval(bu_email); } public int businessApprovalCancel(String bu_email) throws Exception { return adminMapper.deleteBusiness(bu_email); } public int notApprovalBuCount() throws Exception { return adminMapper.notApprovalBuCount(); } public BookingDTO selectSales(Map map) { return adminMapper.selectSales(map); } public List reportedReview() throws Exception { return adminMapper.reportedReview(); } } 보니까 다른 팀원분은 Mapper 어노테이션을 잘 사용하셨던데 그분한테 여쭤보셨으면 되지 않았을까요

my-batis-config.xml에 경로를 선택해줬는데 찾지 못하는거같습니다.

2개의 답변

기타 목록