3回答

翔仔

2018-03-20

已采纳

同学好，非常浅显的一个问题

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactorya' defined in class path resource [spring/spring-dao.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [C:\Users\Administrator\IdeaProjects\o2o\target\classes\mapper\ShopDao.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'shopMap'.  Cause: java.lang.ClassNotFoundException: Cannot find class: shopMap

找不到shopMap的class,在ShopDao.xml mapper里面 请仔细和视频核对

0

1

静水流深3932456

非常感谢！

2018-03-20

共1条回复

静水流深3932456

提问者

2018-03-20

<?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.o2o.dao.ShopDao">
    <resultMap type="com.o2o.entity.Shop" id="shopMap">
        <id column="shop_id" property="shopId" />
        <result column="shop_name" property="shopName" />
        <result column="shop_desc" property="shopDesc" />
        <result column="shop_addr" property="shopAddr" />
        <result column="phone" property="phone" />
        <result column="shop_img" property="shopImg" />
        <result column="priority" property="priority" />
        <result column="create_time" property="createTime" />
        <result column="last_edit_time" property="lastEditTime" />
        <result column="enable_status" property="enableStatus" />
        <result column="advice" property="advice" />
        <association property="area" column="area_id"
                     javaType="com.o2o.entity.Area">
            <id column="area_id" property="areaId" />
            <result column="area_name" property="areaName" />
        </association>
        <association property="shopCategory" column="shop_category_id"
                     javaType="com.o2o.entity.ShopCategory">
            <id column="shop_category_id" property="shopCategoryId" />
            <result column="shop_category_name" property="shopCategoryName" />
        </association>
        <association property="owner" column="user_id"
                     javaType="com.o2o.entity.PersonInfo">
            <id column="user_id" property="userId" />
            <result column="name" property="name" />
        </association>
    </resultMap>
    <select id="queryByShopId" resultType="shopMap" parameterType="Long">
    SELECT
    s.shop_id,
   s.shop_name,
    s.shop_desc,
   s.shop_addr,
   s.phone,
   s.shop_img,
   s.priority,
   s.create_time,
   s.last_edit_time,
   s.enable_status,
   s.advice,
   a.area_id,
   a.area_name,
   sc.shop_category_id,
   sc.shop_category_name
   FROM
   o2o.tb_shop s,
   o2o.tb_area a ,
   o2o.tb_shop_category sc
   WHERE
   a.area_id=a.area_id
   AND
    s.shop_category_id=sc.shop_category_id
    AND
    s.shop_id=#{shopId}
</select>

    <insert id="insertShop" useGeneratedKeys="true" keyColumn="shop_id"
            keyProperty="shopId">
        INSERT INTO
        tb_shop(owner_id, area_id, shop_category_id,
        shop_name, shop_desc, shop_addr,
        phone, shop_img, priority,
        create_time, last_edit_time, enable_status,
        advice)
        VALUES
        (#{owner.userId},#{area.areaId},#{shopCategory.shopCategoryId},#{shopName},
        #{shopDesc},#{shopAddr},#{phone},#{shopImg},#{priority},
        #{createTime},#{lastEditTime}, #{enableStatus},#{advice})
    </insert>
    <update id="updateShop" parameterType="com.o2o.entity.Shop">
        update tb_shop
        <set>
            <if test="shopName != null">shop_name=#{shopName},</if>
            <if test="shopDesc != null">shop_desc=#{shopDesc},</if>
            <if test="shopAddr != null">shop_addr=#{shopAddr},</if>
            <if test="phone != null">phone=#{phone},</if>
            <if test="shopImg != null">shop_img=#{shopImg},</if>
            <if test="priority != null">priority=#{priority},</if>
            <if test="lastEditTime != null">last_edit_time=#{lastEditTime},</if>
            <if test="enableStatus != null">enable_status=#{enableStatus},</if>
            <if test="advice != null">advice=#{advice},</if>
            <if test="area != null">area_id=#{area.areaId},</if>
            <if test="shopCategory != null">shop_category_id=#{shopCategory.shopCategoryId}</if>
        </set>
        where shop_id=#{shopId}
    </update>
</mapper>

没有问题啊

0

3

翔仔

回复

静水流深3932456

：）不错，一定先定位了错误，同学你看这里你提供了方便大家找到错误的信息，也是个不错的办法，但是要是能够更进一步，把信息贴百度谷歌解决一下就更完美了：）

2018-03-20

共3条回复

静水流深3932456

提问者

2018-03-20

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <!-- 注入数据库连接池 -->
    <property name="dataSource" ref="dataSource" />
    <!-- 配置MyBaties全局配置文件:mybatis-config.xml -->
    <property name="configLocation" value="classpath:mybatis-config.xml" />
    <!-- 扫描entity包 使用别名 -->
    <property name="typeAliasesPackage" value="com.o2o.entity" />
    <!-- 扫描sql配置文件:mapper需要的xml文件 -->
    <property name="mapperLocations" value="classpath:mapper/*.xml" />
</bean>

0

0