org.apache.ibatis.annotations.Select.<init>()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(5.6k)|赞(0)|评价(0)|浏览(241)

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

Select.<init>介绍

暂无

代码示例

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

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

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

@Select("select * from miaosha_message where messageid =  #{messageid}  ")
public List<MiaoShaMessageInfo> listMiaoShaMessage(@Param("messageId") String messageId);
@Select("<script>select * from miaosha_message_user where 1=1 <if test=\"messageId !=null \">and messageId = #{messageId} </if></script>")

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

@Select("<script>select * from miaosha_message_user where 1=1 <if test=\"messageId !=null \">and messageId = #{messageId} </if></script>")
public List<MiaoShaMessageUser> listMiaoShaMessageUser(@Param("messageId") String messageId);
@Insert("insert into miaosha_message (id , messageid ,content , create_time ,status,over_time,message_type ,send_type , good_name , price,messageHead)" +

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

@Select("select * from miaosha_user where nickname = #{nickname}")
public MiaoshaUser getByNickname(@Param("nickname") String nickname ) ;

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

@Select("select * from order_info where id = #{orderId}")
public OrderInfo getOrderById(@Param("orderId")long orderId);

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

@Select(" <script> select * from miaosha_message_user mmu , miaosha_message mm where " +
      " mmu.messageid = mm.messageid and  userid=${userId}  <if test=\"status !=null \">and status = #{status} </if></script> ")
  public List<MiaoShaMessageInfo> listMiaoShaMessageByUserId(@Param("userId") long userId,@Param("status")  Integer status );
}

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

@Select("select * from miaosha_order where user_id=#{userNickName} and goods_id=#{goodsId}")
public MiaoshaOrder getMiaoshaOrderByUserIdGoodsId(@Param("userNickName") long userNickName, @Param("goodsId") long goodsId);

代码示例来源:origin: ityouknow/spring-boot-examples

@Select("SELECT * FROM users")
@Results({
    @Result(property = "userSex",  column = "user_sex", javaType = UserSexEnum.class),
    @Result(property = "nickName", column = "nick_name")
})
List<UserEntity> getAll();

代码示例来源:origin: ityouknow/spring-boot-examples

@Select("SELECT * FROM users WHERE id = #{id}")
@Results({
    @Result(property = "userSex",  column = "user_sex", javaType = UserSexEnum.class),
    @Result(property = "nickName", column = "nick_name")
})
UserEntity getOne(Long id);

代码示例来源:origin: ityouknow/spring-boot-examples

@Select("SELECT * FROM users WHERE id = #{id}")
@Results({
    @Result(property = "userSex",  column = "user_sex", javaType = UserSexEnum.class),
    @Result(property = "nickName", column = "nick_name")
})
UserEntity getOne(Long id);

代码示例来源:origin: ityouknow/spring-boot-examples

@Select("SELECT * FROM users")
@Results({
    @Result(property = "userSex",  column = "user_sex", javaType = UserSexEnum.class),
    @Result(property = "nickName", column = "nick_name")
})
List<UserEntity> getAll();

代码示例来源:origin: baomidou/mybatis-plus

@Select("select count(1) from (" +
  "select test_id as id, CAST(#{nameParam} AS VARCHAR) as name" +
  " from h2user " +
  " where age>#{ageFrom} and age<#{ageTo} " +
  ") a")
int selectCountWithParamInSelectItems(Map<String, Object> param);

代码示例来源:origin: baomidou/mybatis-plus

@Select(" select test_id as testId, power(#{ageFrom},2), 'abc?zhazha', CAST(#{nameParam} AS VARCHAR) as name " +
  " from h2user " +
  " where age>#{ageFrom} and age<#{ageTo} ")
List<H2User> selectUserWithParamInSelectStatememt(Map<String, Object> param);

代码示例来源:origin: baomidou/mybatis-plus

@Select("select * from h2user")
  List<Map> mySelectMaps();
}

代码示例来源:origin: baomidou/mybatis-plus

@Select(
  "select a.addr_id as addrId, a.addr_name as addrName from h2address a" +
    " join h2user u on u.test_id=a.test_id and u.test_id=#{userId}"
)
List<H2Addr> getAddrListByUserIdPage(@Param("userId") Long userId, IPage<H2Addr> page);

代码示例来源:origin: baomidou/mybatis-plus

@Select(
  "select a.addr_id as addrId, a.addr_name as addrName from h2address a" +
    " join h2user u on u.test_id=a.test_id and u.test_id=#{userId}"
)
List<H2Addr> getAddrListByUserId(@Param("userId") Long userId);

代码示例来源:origin: ityouknow/spring-boot-examples

@Select("SELECT * FROM users WHERE id = #{id}")
@Results({
  @Result(property = "userSex",  column = "user_sex", javaType = UserSexEnum.class),
  @Result(property = "nickName", column = "nick_name")
})
UserEntity getOne(Long id);

代码示例来源:origin: ityouknow/spring-boot-examples

@Select("SELECT * FROM users")
@Results({
  @Result(property = "userSex",  column = "user_sex", javaType = UserSexEnum.class),
  @Result(property = "nickName", column = "nick_name")
})
List<UserEntity> getAll();

代码示例来源:origin: baomidou/mybatis-plus

@ResultType(MysqlData.class)
  @Select("select * from mysql_data ${ew.customSqlSegment}")
  List<MysqlData> getAll(@Param(Constants.WRAPPER) Wrapper wrapper);
}

代码示例来源:origin: baomidou/mybatis-plus

@SqlParser(filter = true)
@Select("select * from common_data")
List<CommonData> getAllNoTenant();

相关文章

Select类方法