org.apache.ibatis.annotations.Param Java Examples

@Update( "update yx_user set status = #{status} where uid = #{id}")
void updateOnstatus(@Param("status") int status, @Param("id") int id);
 

@Select("SELECT COUNT(*) > 0 " +
        "FROM configurationApplications " +
        "WHERE configurationApplications.applicationId=#{id}")
boolean isApplicationUsedInConfigurations(@Param("id") Integer applicationId);
 

@Delete("DELETE FROM uploadedFiles WHERE id = #{id}")
void deleteFile(@Param("id") int fileId);
 

List<Group> getAllGroupsByValue(@Param("customerId") int customerId,
@Param("value") String value,
@Param("userId") Integer userId);
 

public WxActGoldeneggsPrizes queryByActIdAndAwardId(@Param("actId")String actId,
@Param("awardsId")String awardsId);
 

public List<Map<String, Object>> triggerCountByDay(@Param("from") Date from,
@Param("to") Date to);
 

List<PointLogBi> listPointLogBi(@Param(value = "pointTableName") String pointTableName,
@Param(value = "param") ListPointLogParam param);
 

/**
 * 根据用户名 以及 状态统计
 *
 * @param userName
 * @param userStatus
 * @return
 */
Long countByUserNameAndStatus(@Param("userName") String userName, @Param("status") Integer userStatus);
 

/**
 * 保存用户
 *
 * @param user 用户
 * @return 成功 - {@code 1} 失败 - {@code 0}
 */
int saveUser(@Param("user") User user);
 

/**
 * 根据记录id更新资产
 *
 * @param id
 * @param money
 * @return
 */
int updateRechargeById(@Param("id") Long id, @Param("money") BigDecimal money);
 

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table dts_del_picture
 *
 * @mbg.generated
 * @project https://github.com/itfsw/mybatis-generator-plugin
 */
List<DtsDelPicture> selectByExampleSelective(@Param("example") DtsDelPictureExample example, @Param("selective") DtsDelPicture.Column ... selective);
 

/**
 * 通过关键字查询出字典表
 * @param table
 * @param text
 * @param code
 * @param keyword
 * @return
 */
@Deprecated
public List<DictModel> queryTableDictItems(@Param("table") String table,@Param("text") String text,@Param("code") String code,@Param("keyword") String keyword);
 

/**
 * 根据status查询多条记录
 *
 * @param userStatus
 * @return
 */
List<SystemUser> findByStatus(@Param("status") Integer userStatus);
 

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table litemall_ad
 *
 * @mbg.generated
 */
LitemallAd selectOneByExampleSelective(@Param("example") LitemallAdExample example, @Param("selective") LitemallAd.Column ... selective);
 

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table litemall_region
 *
 * @mbg.generated
 */
int updateByExampleSelective(@Param("record") LitemallRegion record, @Param("example") LitemallRegionExample example);
 

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table dts_goods
 *
 * @mbg.generated
 */
int updateByExampleSelective(@Param("record") DtsGoods record, @Param("example") DtsGoodsExample example);
 

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table litemall_groupon_rules
 *
 * @mbg.generated
 */
int logicalDeleteByExample(@Param("example") LitemallGrouponRulesExample example);
 

/**
 * 批量创建
 */
int insertList(@Param("list")List<PmsProductAttributeValue> productAttributeValueList);
 

/**
 * 根据角色Id获得用户
 *
 * @param roleId 角色Id
 * @param user 条件
 * @param page 分页信息
 * @return 用户列表
 */
List<User> findByRoleIdAndCondition(@Param("roleId") Long roleId,
                                    @Param("user") User user, Page page);
 

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table litemall_collect
 *
 * @mbg.generated
 * @project https://github.com/itfsw/mybatis-generator-plugin
 */
int logicalDeleteByExample(@Param("example") LitemallCollectExample example);
 

/**
 * 校验部门名称是否唯一
 * 
 * @param deptName 部门名称
 * @param parentId 父部门ID
 * @return 结果
 */
public SysDept checkDeptNameUnique(@Param("deptName") String deptName, @Param("parentId") Long parentId);
 

/**
  * 通过用户账号查询用户信息
 * @param username
 * @return
 */
public SysUser getUserByName(@Param("username") String username);
 

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table litemall_role
 *
 * @mbg.generated
 * @project https://github.com/itfsw/mybatis-generator-plugin
 */
int logicalDeleteByExample(@Param("example") LitemallRoleExample example);
 

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table litemall_collect
 *
 * @mbg.generated
 * @project https://github.com/itfsw/mybatis-generator-plugin
 */
LitemallCollect selectByPrimaryKeySelective(@Param("id") Integer id, @Param("selective") LitemallCollect.Column ... selective);
 

/**
 * 订单入库时候，根据商品名和仓库名找到库存记录
 * @param goodsName
 * @param repositoryName
 * @return
 */
Stock queryStockByGoodsNameAndRepositoryName(@Param("goodsName")String goodsName,@Param("repositoryName")String repositoryName);
 

int updateByExample(@Param("record") PmsProductCategory record, @Param("example") PmsProductCategoryExample example); 

int updateByExample(@Param("record") SmsDescription record, @Param("example") SmsDescriptionExample example); 

int updateByExampleSelective(@Param("record") UmsRolePermissionRelation record, @Param("example") UmsRolePermissionRelationExample example); 

int updateByExampleSelective(@Param("record") DmsNonDrugItemRecord record, @Param("example") DmsNonDrugItemRecordExample example); 

void updateBranchTransactionToCommitted(@Param("xid") String xid, @Param("branchId") Long branchId);