Repository and controller

Question

3.00/5 (2 votes)

See more:

I need to get the product repository (where i added a query to fetch productname with I'd because we can't fetch from transaction table ) calling that method into transaction controller response(so that i can show productname in my response) can anyone suggest how should I get it

What I have tried:

I tried declaring method in product by getproductnme and returning it in entity class

Product repo
package com.retailsols.gasstation.repo;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import com.retailsols.gasstation.entity.ProductType;

@Repository
public interface ProductTypeRepository extends JpaRepository<producttype, string=""> {

    
      
      @Query("SELECT p.productName FROM ProductType p WHERE p.productId =:productId")
      String getproductName(@Param("productId") String productId);
    

      

     
}

Entity class:(i need to getproductName it is showing null)
public String getProductName(ProductTypeRepository productRepo) {
        if (productId != null) {
            return productRepository.getproductName(productId);
        }
        return null;

Posted 9-Jun-23 16:42pm

minnon dumbo

Updated 11-Jun-23 1:13am

Andre Oosthuizen

v3

Add a Solution

Comments

Andre Oosthuizen 10-Jun-23 6:08am

Maybe you should post your method code that you tried and show us where it does not work for better understanding. Click on 'Improve Question' and give us more information so that we can understand where you are stuck.

minnon dumbo 18-Jun-23 2:08am

Can u please help me out with the other please

minnon dumbo 12-Jun-23 5:36am

Thank you

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andre Oosthuizen · Accepted Answer · 2023-06-11T01:13:00

1. From what I can see, in your repository your method name is defined as 'getproductName', but in your entity class, you are using 'getProductName', the naming must be identical, update your repository method to -

String getProductName(@Param("productId") String productId);

2. In your entity class, you are injecting the 'ProductTypeRepository' trying to call the 'getproductName' method. This is not the correct way to use a repository in a service or entity class. Repositories should be used in service classes or controllers. You can creat a service class 'ProductService' that uses the 'ProductTypeRepository' to retrieve the product name. You can then inject the 'ProductServic'e into your transaction controller and call the 'getProductName' method to include the product name -

@Service
public class ProductService {

    private final ProductTypeRepository productRepository;

    public ProductService(ProductTypeRepository productRepository) {
        this.productRepository = productRepository;
    }

    public String getProductName(String productId) {
        if (productId != null) {
            return productRepository.getProductName(productId);
        }
        return null;
    }
}

3. Update your transaction controller to include the 'ProductService' -

@RestController
@RequestMapping("/transactions")
public class TransactionController {

    private final ProductService productService;

    public TransactionController(ProductService productService) {
        this.productService = productService;
    }

    @GetMapping("/{transactionId}")
    public ResponseEntity<Transaction> getTransaction(@PathVariable("transactionId") String transactionId) {
        // Your code to fetch the transaction
        Transaction transaction = ...;

        // Get the product name using the ProductService
        String productName = productService.getProductName(transaction.getProductId());

        // Set the product name in the transaction object
        transaction.setProductName(productName);

        // Return the transaction in the response
        return ResponseEntity.ok(transaction);
    }
}

The above code is based on what you gave in your code, you need to adjsut it to run error free depending on the rest of your code.