package ;
import ;
import ;
import ;
import ;
/**
* 用户Repository接口
*
* @author xhz
*
*/
public interface UserRepository extends JpaRepository<User, Integer>, JpaSpecificationExecutor<User> {
/**
* 通过用户名和密码查询用户信息
* SELECT * FROM XHZ_USER U WHERE U.USER_NAME=?1 AND =?2
* 不能用实体传参数,只能用list传参数
* @param userName
* @param password
* @return
*/
@Query(value = "SELECT * FROM XHZ_USER U WHERE U.USER_NAME=?1 AND =?2")
public User selectUserInfoByUserNameAndPassword(String userName, String password);
@Query(value = "SELECT * FROM XHZ_USER WHERE USER_NAME=?1 AND PASSWORD=?2")
public User selectUserInfoByUserNameAndPassword(String userName, String password);
}