Last change
on this file since fc7ec52 was fc7ec52, checked in by darkopopovski <darkopopovski39@…>, 22 months ago |
all files
|
-
Property mode
set to
100644
|
File size:
1.2 KB
|
Rev | Line | |
---|
[fc7ec52] | 1 | package com.example.demo.repository;
|
---|
| 2 |
|
---|
| 3 | import com.example.demo.model.Movie;
|
---|
| 4 | import com.example.demo.model.User;
|
---|
| 5 | import org.springframework.data.jpa.repository.JpaRepository;
|
---|
| 6 | import org.springframework.data.jpa.repository.Query;
|
---|
| 7 | import org.springframework.data.repository.query.Param;
|
---|
| 8 | import org.springframework.stereotype.Repository;
|
---|
| 9 |
|
---|
| 10 | import java.util.List;
|
---|
| 11 | import java.util.Optional;
|
---|
| 12 |
|
---|
| 13 | @Repository
|
---|
| 14 | public interface UserRepository extends JpaRepository<User, String> {
|
---|
| 15 |
|
---|
| 16 |
|
---|
| 17 | @Query(value="select * from users where user_username=? AND user_password=?",nativeQuery = true)
|
---|
| 18 | Optional<User> findByUsernameAndPassword(String user_username, String user_password);
|
---|
| 19 |
|
---|
| 20 | @Query(value="select * from users where user_username=?",nativeQuery = true)
|
---|
| 21 | Optional<User> findByUsername(String user_username);
|
---|
| 22 |
|
---|
| 23 | // @Query(value="select u.user_username,u.user_password from users as u where user_username=? AND user_password=?",nativeQuery = true)
|
---|
| 24 | // List<User> findByUsernameAndPassword(String user_username, String user_password);
|
---|
| 25 | //
|
---|
| 26 | // @Query(value="select u.user_username from users as u where user_username=?",nativeQuery = true)
|
---|
| 27 | // Optional<User> findByUsername(String s);
|
---|
| 28 |
|
---|
| 29 | }
|
---|
Note:
See
TracBrowser
for help on using the repository browser.