本文整理了Java中org.apache.ibatis.annotations.Select类的一些代码示例，展示了Select类的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Select类的具体详情如下：
包路径：org.apache.ibatis.annotations.Select
类名称：Select

Select介绍

暂无

代码示例

代码示例来源：origin: qiurunze123/miaosha

@Select("update order_info set status=0 where id=#{id}")
  public int closeOrderByOrderInfo();
}

代码示例来源：origin: qiurunze123/miaosha

@Select("select g.*,mg.stock_count, mg.start_date, mg.end_date,mg.miaosha_price from miaosha_goods mg left join goods g on mg.goods_id = g.id")
public List<GoodsVo> listGoodsVo();

代码示例来源：origin: yu199195/hmily

/**
   * 根据userId获取用户账户信息
   *
   * @param userId 用户id
   * @return AccountDO account do
   */
  @Select("select id,user_id,balance, freeze_amount from account where user_id =#{userId} limit 1")
  AccountDO findByUserId(String userId);
}

代码示例来源：origin: yu199195/hmily

/**
   * Find by product id inventory do.
   *
   * @param productId the product id
   * @return the inventory do
   */
  @Select("select id,product_id,total_inventory ,lock_inventory from inventory where product_id =#{productId}")
  InventoryDO findByProductId(String productId);
}

代码示例来源：origin: yu199195/hmily

/**
   * Find by user id account do.
   *
   * @param userId the user id
   * @return the account do
   */
  @Select("select id,user_id,balance, freeze_amount from account where user_id =#{userId} limit 1")
  AccountDO findByUserId(String userId);
}

代码示例来源：origin: yu199195/hmily

/**
   * 获取所有的订单
   *
   * @return List<Order>
   */
  @Select("select * from  order")
  List<Order> listAll();
}

代码示例来源：origin: yu199195/hmily

/**
 * Find by product id inventory do.
 *
 * @param productId the product id
 * @return the inventory do
 */
@Select("select id,product_id,total_inventory ,lock_inventory from inventory where product_id =#{productId}")
InventoryDO findByProductId(String productId);

代码示例来源：origin: yu199195/myth

/**
   * 根据商品id找到库存信息
   *
   * @param productId 商品id
   * @return Inventory
   */
  @Select("select * from inventory where product_id =#{productId}")
  Inventory findByProductId(String productId);
}

代码示例来源：origin: yu199195/myth

/**
   * 根据userId获取用户账户信息
   *
   * @param userId 用户id
   * @return AccountDO
   */
  @Select("select * from account where user_id =#{userId}")
  AccountDO findByUserId(String userId);
}

代码示例来源：origin: yu199195/myth

/**
   * 获取所有的订单
   *
   * @return List<Order> list
   */
  @Select("select * from  order")
  List<Order> listAll();
}

代码示例来源：origin: yu199195/myth

/**
   * 根据商品id找到库存信息
   *
   * @param productId 商品id
   * @return Inventory
   */
  @Select("select * from inventory where product_id =#{productId}")
  Inventory findByProductId(String productId);
}

代码示例来源：origin: yu199195/myth

/**
   * List all list.
   *
   * @return the list
   */
  @Select("select * from  order")
  List<Order> listAll();
}

代码示例来源：origin: yu199195/myth

/**
   * 获取所有的订单
   *
   * @return List<Order> list
   */
  @Select("select * from  order")
  List<Order> listAll();
}

代码示例来源：origin: yu199195/myth

/**
   * Find by user id account do.
   *
   * @param userId the user id
   * @return the account do
   */
  @Select("select * from account where user_id =#{userId}")
  AccountDO findByUserId(String userId);
}

代码示例来源：origin: yu199195/myth

/**
   * 根据商品id找到库存信息
   *
   * @param productId 商品id
   * @return Inventory inventory do
   */
  @Select("select * from inventory where product_id =#{productId}")
  InventoryDO findByProductId(String productId);
}

代码示例来源：origin: yu199195/myth

/**
   * 根据userId获取用户账户信息
   *
   * @param userId 用户id
   * @return AccountDO account do
   */
  @Select("select * from account where user_id =#{userId}")
  AccountDO findByUserId(String userId);
}

代码示例来源：origin: G-Joker/WeaponApp

/**
 * 清空所有记录，并重新定义index
 */
@Select("TRUNCATE TABLE taobao")
void deleteAll();

代码示例来源：origin: ChinaSilence/any-video

/**
 * 查询在首页展示的
 */
@Select("SELECT * FROM any_friend_link WHERE `show` = 'YES' ORDER BY id DESC")
List<FriendLink> selectShowEqYesDesc();

代码示例来源：origin: G-Joker/WeaponApp

/**
 * 清空所有记录，并重新定义index
 */
@Select("TRUNCATE TABLE taobao")
void deleteAll();

代码示例来源：origin: codingapi/tx-lcn

@Select("select * from t_tx_exception")
List<TxException> findByRegistrar(Integer registrar);