本文整理了Java中org.apache.ibatis.annotations.Select.<init>()
方法的一些代码示例,展示了Select.<init>()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Select.<init>()
方法的具体详情如下:
包路径:org.apache.ibatis.annotations.Select
类名称: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();
内容来源于网络,如有侵权,请联系作者删除!