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 | } |
---|