mybatis注解的写法

mybatis注解的写法

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;
import java.math.BigDecimal;

@Mapper
@Component
public interface OrderDao{
	@Insert("insert into t_order (price,user_id,status) values (#{price},#{userId},#{status})")
	public int insertOrder (@Param("price")BigDecimal price,
													@Param("userId")Long userId,
													@Param("status")String status);

	//根据Id列表查询订单
  @Select("<script>" +
				"select" +
				"from t_ order t" +
				there t. order_id in" +
				"<foreach collection='orderIds'open='('separator=',' close=')' item='id'>" +
					"#{id}"+
					"</foreach>" +
				"</script> ")
	List<Map> selectOrderbyIds (@Paranm("orderIds") List<Long> orderIds);
   
   //关于主键的声明
	 @Insert("insert into product_info(store,info_Id,product_nane,spec,region_code,price)" +
values (#{storeInfoId},#{productNane},#{spec},#{regi onCode},#{price})*)
@Options(useGeneratedKeys =true,keyProperty ="productInfoId",keyColunn="product_info_id")
	int insertProductInfo(ProductInfo productInfo);
)