对SpringData Jpa 的 @Query和select的理解

时间:2025-02-15 21:12:06
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);
}