There is no getter for property named '

There is no getter for property named '_goods' i报错

来源：7-2 Mybatis注解开发方式（下）

小老哥丶

2020-07-31 23:26:03

接口类：

package com.imooc.mybatis.dao;

import com.imooc.mybatis.entity.Goods;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectKey;

import java.util.List;

public interface GoodsDAo {
    //使用Select注释编写sql语句并将@Param映射的变量名称以#{变量名称}填写
    @Select("select * from t_goods where current_price between #{min} and #{max} limit 0,#{limit}")
    //定义需要传入的变量，并用@Param映射给一个名称,方法的返回类型，就是select语句的返回类型
    public List<Goods> selectByPriceRange(@Param("min") float a, @Param("max") float z, @Param("limit") int limit);

    @Insert("insert  t_goods(title,sub_title,original_cost,current_price,discount,is_free_delivery,category_id) values(#{_goods.title},#{_goods.subTitle},#{_goods.originalCost},#{_goods.currentPrice},#{_goods.discount},#{_goods.isFreeDelivery},#{_goods.categoryId})")
    // * SelectKey数据回显查询主键
    //statement代表执行用来查询的语句
    //before代表执行的顺序是在sql语句之前（true）还是之后（false）
    //keyProperty="goodsId"，代表那个属性是主键
    //resultType=Integer.class，代表返回的主键类型,要写包装对象的类对象
    @SelectKey(statement = "select last_insert_id()",before = false,keyProperty="goodsId",resultType=Integer.class)
    public int insert(Goods goods);
}

测试类：

@Test
    public void testInsert() throws Exception {
            SqlSession sqlSession=null;
            try{
                sqlSession=MyBatisUtils.openSession();

                Goods goods1=new Goods();
                goods1.setTitle("注释添加");
                goods1.setSubTitle("副标题");
                goods1.setOriginalCost(180f);
                goods1.setCurrentPrice(160f);
                goods1.setDiscount(0.5f);
                goods1.setIsFreeDelivery(1);
                goods1.setCategoryId(43);
//                执行后返回本次插入的记录数
                GoodsDAo goodsDao=sqlSession.getMapper(GoodsDAo.class);
                int num=goodsDao.insert(goods1);
                System.out.println(num);
                sqlSession.commit();
                System.out.println(goods1.getGoodsId());
            }catch (Exception e){
                if(sqlSession!=null){
                    sqlSession.rollback();
                }
                throw e;
            }finally {
                MyBatisUtils.closeSession(sqlSession);
            }
}

写回答

6回答