新创的cola项目不知道为啥mapper和xml对不上,等后面解决了回来填坑
mybatis-confg
<?xml version="1.0" encoding="UTF-8" ?>
<!-- mybatis的配置文件 -->
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<mappers>
<mapper resource="mybatis/customer-mapper.xml"/>
</mappers>
</configuration>
xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.iquantex.pims.service.customer.mapper.CustomerMapper">
<select id="getById" resultType="com.iquantex.pims.service.customer.CustomerDO" >
select * from customer where customer_id = #{id}
</select>
<resultMap type="com.iquantex.pims.service.customer.CustomerDO" id="customerMap">
<result property="customerId" column="emp_no"/>
<result property="memberId" column="salary"/>
<result property="globalId" column="from_date"/>
</resultMap>
</mapper>
mapper
package com.iquantex.pims.service.customer.mapper;
import com.iquantex.pims.service.customer.CustomerDO;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
@Mapper
@Repository
public interface CustomerMapper{
CustomerDO getById(String customerId);
}
结构: