package com.fei.mapper;/**
 * @Title: ${file_name}
 * @Package ${package_name}
 * @Description:
 * @author fengzf fengzf@gstarcad.com
 * @date 2019/1/10 15:36
 * @version Vxxx (项目版本)
 * @redmine
 * @update @Description TODO(这里用一句话描述这个方法的作用)
 * @update @author fengzf fengzf@gstarcad.com
 * @update @date 2019/1/10 15:36
 */

import com.fei.entity.User;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @ClassName: UserMapper.java
 * @Description:
 * @author: fengzf fengzf@gstarcad.com
 * @Date: 2019/1/10 15:36
 *
 */
public interface UserMapper {

    @Select("select * from user where user_name=#{userName}")
    @Results({
            @Result(column="user_name", property="userName"),
            @Result(column="reg_time ", property="regTime")
    })
    User findByUserName(String userName);

    @Select("select * from user where user_name=#{userName} or email=#{email}")
    @Results({
            @Result(column="user_name", property="userName"),
            @Result(column="reg_time ", property="regTime")
    })
    User findByUserNameOrEmail(String username, String email);

    @Select("select * from user where nickname=#{nickname}")
    @Results({
            @Result(column="user_name", property="userName"),
            @Result(column="reg_time", property="regTime")
    })
    List<User> findByNickname(String nickname);

}