[fc7ec52] | 1 | package com.example.demo.repository;
|
---|
| 2 |
|
---|
| 3 | import com.example.demo.model.Movie;
|
---|
| 4 | import org.springframework.data.jpa.repository.JpaRepository;
|
---|
| 5 | import org.springframework.data.jpa.repository.Modifying;
|
---|
| 6 | import org.springframework.data.jpa.repository.Query;
|
---|
| 7 | import org.springframework.data.repository.CrudRepository;
|
---|
| 8 | import org.springframework.stereotype.Repository;
|
---|
| 9 |
|
---|
| 10 | import java.util.List;
|
---|
| 11 | import java.util.Optional;
|
---|
| 12 |
|
---|
| 13 | @Repository
|
---|
| 14 | public interface MovieRepository extends JpaRepository<Movie, Integer> {
|
---|
| 15 | @Query(value = "select * from Movie where movie_id=?",nativeQuery = true)
|
---|
| 16 | Optional<Movie> findAllByID(Integer movie_id);
|
---|
| 17 |
|
---|
| 18 | @Modifying
|
---|
| 19 | @Query(value ="delete from Movie where movie_name=?;",nativeQuery = true)
|
---|
| 20 | void deleteMovieByName(String movie_name);
|
---|
| 21 | //@Override
|
---|
| 22 | //@Query(value = "delete from Table where movie_id=?", nativeQuery = true)
|
---|
| 23 | //void deleteByName(String name);
|
---|
| 24 |
|
---|
| 25 | @Query(value="select * from MovieProjection where movie_id=? ",nativeQuery = true)
|
---|
| 26 | List<Movie> ViewByID(Integer movie_id);
|
---|
| 27 |
|
---|
| 28 | @Query(value ="select movie_name from Movie where movie_name=?",nativeQuery = true)
|
---|
| 29 | Optional<Movie> findByName(String movie_name);
|
---|
| 30 |
|
---|
| 31 |
|
---|
| 32 | @Query(value="select * from Movie where movie_name=?",nativeQuery = true)
|
---|
| 33 | Optional<Movie> findAllByName(String s);
|
---|
| 34 | } |
---|