Spring JDBC | Java Community | Help. Code. Learn. | Page 1

tulip wren Jun 12, 2024, 4:30 AM

#

I have added a image into My Database! But Now I don't know how to retrieve it from database and show it on my frontend. Can Anyone Help ?

raven tulipBOT Jun 12, 2024, 4:30 AM

#

⌛ This post has been reserved for your question.

Hey @tulip wren! Please use /close or the Close Post button above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

serene surge Jun 12, 2024, 5:00 AM

#

How did you add the image to your DB?

tulip wren Jun 12, 2024, 5:10 AM

#

serene surge How did you add the image to your DB?

Using MultipartFile Library

#

@serene surge

serene surge Jun 12, 2024, 5:26 AM

#

tulip wren Using MultipartFile Library

Can you show the relevant code?

tulip wren Jun 12, 2024, 5:28 AM

#

Yehh sure

#

    public String registration(@Valid @ModelAttribute("finderUserPojo") MovieFinderUserPojo finderUserPojo,
            BindingResult bindingResult, HttpSession httpSession, Model model,
            @RequestParam("file") MultipartFile file) {

        if (bindingResult.hasErrors()) {
            System.out.println(bindingResult.getErrorCount());
            return "register";
        }

        try {
            String email = finderUserPojo.getEmail();

            MovieFinderUser existingUser = finderUserImp.findByEmail(email);
            

            if (existingUser != null && existingUser.getPassword().equals(finderUserPojo.getPassword())) {
                return "registeredusers";
            }
            
            MovieFinderUser finderUser = new MovieFinderUser(finderUserPojo.getName(), finderUserPojo.getEmail(),
                    finderUserPojo.getPassword(), finderUserPojo.getFavouriteMovie(),
                    finderUserPojo.getFavouriteGenre(), file.getBytes() );

            if (!file.isEmpty()) {
                httpSession.setAttribute("User", finderUser);
                finderService.addUser(finderUser);

                // store the bytes somewhere
                return "userregistered";

            } else {
                return "register";
            }

        }
    catch(Exception e)
    {
        e.printStackTrace();
        return "register";
    }
}``` Here is the controller

#

@serene surge

serene surge Jun 12, 2024, 5:39 AM

#

tulip wren ```@PostMapping("/registration") public String registration(@Valid @ModelAtt...

That doesn't store the bytes anywhere, right?

tulip wren Jun 12, 2024, 5:39 AM

#

no it stores the bytes in database

serene surge Jun 12, 2024, 5:40 AM

#

or does finderService.addUser() do that?

serene surge Jun 12, 2024, 5:40 AM

#

tulip wren no it stores the bytes in database

How?

tulip wren Jun 12, 2024, 5:40 AM

#

serene surge or does `finderService.addUser()` do that?

from this

serene surge Jun 12, 2024, 5:40 AM

#

retrieving probably works somewhat similar to storing

tulip wren Jun 12, 2024, 5:40 AM

#

        System.out.println("it passed the service layer");
        return finderUserImp.saveUser(finderUser);
    }```

serene surge Jun 12, 2024, 5:41 AM

#

tulip wren ```public int addUser(MovieFinderUser finderUser) { System.out.println("...

Now what's findUserImp?

tulip wren Jun 12, 2024, 5:41 AM

#

its the implemented class of dao interface

#

@serene surge

serene surge Jun 12, 2024, 5:52 AM

#

tulip wren its the implemented class of dao interface

Can you show that?

tulip wren Jun 12, 2024, 5:53 AM

#


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

@Repository
public class MovieFinderUserImp implements Dao {

    @Autowired
    private JdbcTemplate jdbcTemplate;
    
    
    @Override
    public int saveUser(MovieFinderUser finderUser) {
        String query = "INSERT INTO moviefinderuser (name, email, passoword , favouriteMovie , favouriteGenre , image) VALUES (?, ?, ? , ?, ? , ?)";
        int updatedLine = jdbcTemplate.update(query,finderUser.getName() , finderUser.getEmail(), finderUser.getPassword() , finderUser.getFavouriteMovie() , finderUser.getFavouriteGenre() , finderUser.getImage());
        System.out.println("It Passed THe Repo layer");
        return updatedLine;
    }


    @Override
    public MovieFinderUser findByEmail(String email) {
        String query = "SELECT * FROM moviefinderuser where email = ?";
        MovieFinderUser finderUser = jdbcTemplate.queryForObject(query, new RowMapperObj() ,email );
        return finderUser;
    }


    ```

serene surge Jun 12, 2024, 5:55 AM

#

What does finderUser.getImage() return? A byte[]?

tulip wren Jun 12, 2024, 5:58 AM

#

Where ?

#


    private String name;

    private String email;

    private String password;

    private String favouriteMovie; // Changed from favoriteMovie

    private String favouriteGenre; // Changed from favoriteGenre
    
    private byte[] image;

    public MovieFinderUser() {
    }

    public MovieFinderUser(String name, String email, String password, String favouriteMovie, String favouriteGenre , byte[] image) {
        this.name = name;
        this.email = email;
        this.password = password;
        this.favouriteMovie = favouriteMovie;
        this.favouriteGenre = favouriteGenre;
        this.image = image;
    }

    public byte[] getImage() {
        return image;
    }

    public void setImage(byte[] image) {
        this.image = image;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getFavouriteMovie() { // Changed from getFavoriteMovie
        return favouriteMovie;
    }

    public void setFavouriteMovie(String favouriteMovie) { // Changed from setFavoriteMovie
        this.favouriteMovie = favouriteMovie;
    }

    public String getFavouriteGenre() { // Changed from getFavoriteGenre
        return favouriteGenre;
    }

    public void setFavouriteGenre(String favouriteGenre) { // Changed from setFavoriteGenre
        this.favouriteGenre = favouriteGenre;
    }```

tulip wren Jun 12, 2024, 6:02 AM

#

serene surge What does `finderUser.getImage()` return? A `byte[]`?

yehh yeeh

serene surge Jun 12, 2024, 6:02 AM

#

then you can probably use Spring JDBC to execute a SELECT statement

#

and that can get the image as a byte[]

tulip wren Jun 12, 2024, 6:03 AM

#

u mean like this Select image from table where email = ?

#

@serene surge

serene surge Jun 12, 2024, 6:13 AM

#

yes

tulip wren Jun 12, 2024, 6:14 AM

#

serene surge yes

and then how to convert the byte into string for the proper image ?

serene surge Jun 12, 2024, 6:16 AM

#

why convert it to a String?

tulip wren Jun 12, 2024, 6:17 AM

#

bcz what the data is coming is in byte form and i want it to be a image !

serene surge Jun 12, 2024, 6:21 AM

#

well images are binary data

#

i.e. bytes

serene surge Jun 12, 2024, 6:21 AM

#

tulip wren ```package com.moviefindercontrollers.model; import org.springframework.beans.f...

you are also using a byte[] here

tulip wren Jun 12, 2024, 6:22 AM

#

serene surge you are also using a byte[] here

yehh

#

bro tell me what to do ? @serene surge

serene surge Jun 12, 2024, 6:27 AM

#

Just use the byte[]?

#

byte[] seems fine to me

tulip wren Jun 12, 2024, 6:30 AM

#

serene surge byte[] seems fine to me

hmm like i succesfully getting the bytes of the image but now what to do to convert it from byte to a inage ? thats my question

serene surge Jun 12, 2024, 6:32 AM

#

What format do you want for the image?

tulip wren Jun 12, 2024, 6:33 AM

#

JPEG or Png Anything

serene surge Jun 12, 2024, 6:37 AM

#

it is a jpeg or png or whatever stored in a byte[]

tulip wren Jun 12, 2024, 6:38 AM

#

serene surge it is a jpeg or png or whatever stored in a byte[]

its a jpeg that was stored in byte []

serene surge Jun 12, 2024, 6:41 AM

#

So what's the issue about that?

tulip wren Jun 12, 2024, 6:42 AM

#

i think u dont get my question i mean i succesfully decode the image to byte from my DB alright and now i want to show that image which i decode into byte in my jsp page then how could i do it ?

serene surge Jun 12, 2024, 6:43 AM

#

oh ok

tulip wren Jun 12, 2024, 6:43 AM

#

yehh

serene surge Jun 12, 2024, 6:43 AM

#

you could convert it to base64 and include it in the JSP

#

or you could create another endpoints, one for getting the image

#

and the JSP has a <img> loading the image from that endpoint

tulip wren Jun 12, 2024, 6:44 AM

#

serene surge you could convert it to base64 and include it in the JSP

i have to convert it into base64 in my controller or my jsp page

serene surge Jun 12, 2024, 6:45 AM

#

https://docs.oracle.com/en/java/javase/21/docs/api/java.base/java/util/Base64.Encoder.html#encodeToString(byte[])

Base64.Encoder (Java SE 21 & JDK 21)

declaration: module: java.base, package: java.util, class: Base64, class: Encoder

tulip wren Jun 12, 2024, 7:01 AM

#

Successfully decode it but getting this <img src="data:image/jpeg;base64," alt="User Image"> in the img tag when checking it from devtools .. and the image is not there as well

#

@serene surge

#

#

My Jsp ``` <div class="container">
<h1>User Profile</h1>

         <c:if test="${not empty image}">
    <img src="data:image/jpeg;base64,${image}" alt="User Image" />
</c:if>```

serene surge Jun 12, 2024, 7:03 AM

#

tulip wren My Jsp ``` <div class="container"> <h1>User Profile</h1> ...

is image the base64? string

tulip wren Jun 12, 2024, 7:03 AM

#

yehh

#

    public String registration(@Valid @ModelAttribute("finderUserPojo") MovieFinderUserPojo finderUserPojo,
            BindingResult bindingResult, HttpSession httpSession, Model model,
            @RequestParam("file") MultipartFile file) {

        if (bindingResult.hasErrors()) {
            System.out.println(bindingResult.getErrorCount());
            return "register";
        }

        try {
            String email = finderUserPojo.getEmail();

            MovieFinderUser existingUser = finderUserImp.findByEmail(email);
            

            if (existingUser != null && existingUser.getPassword().equals(finderUserPojo.getPassword())) {
                return "registeredusers";
            }
            
            byte[] image = file.getBytes();
            String base64EncodedImage = Base64.getEncoder().encodeToString(image);
            
            MovieFinderUser finderUser = new MovieFinderUser(finderUserPojo.getName(), finderUserPojo.getEmail(),
                    finderUserPojo.getPassword(), finderUserPojo.getFavouriteMovie(),
                    finderUserPojo.getFavouriteGenre(), base64EncodedImage.getBytes());
            
            

            if (!file.isEmpty()) {
                httpSession.setAttribute("User", finderUser);
                httpSession.setAttribute("image", base64EncodedImage);
                model.addAttribute("image", base64EncodedImage);
                finderService.addUser(finderUser);

                // store the bytes somewhere
                return "userregistered";

            } else {
                return "register";
            }

        }
    catch(Exception e)
    {
        e.printStackTrace();
        return "register";
    }
}```

#

here is the controller

serene surge Jun 12, 2024, 7:04 AM

#

and it isn't the empty string?

tulip wren Jun 12, 2024, 7:04 AM

#

    public String profile(HttpSession session, Model model) {

        if (session.getAttribute("isLoggedIn") == null) {
            return "redirect:/login";
        }

        String email = (String) session.getAttribute("email");
        MovieFinderUser userInfo = finderUserImp.findByEmail(email);
        String image = (String) session.getAttribute("image");
        
        session.setAttribute("image", image);
        session.setAttribute("userInfo", userInfo);
        model.addAttribute(userInfo);
        model.addAttribute("image", image);

        System.out.println(userInfo.toString());
        return "profile";

    }``` the profile

#

ok done i got it @serene surge

serene surge Jun 12, 2024, 7:10 AM

#

tulip wren ``` @GetMapping("/profile") public String profile(HttpSession session, Model...

Can you try viewing image there using a debugger?

serene surge Jun 12, 2024, 7:10 AM

#

tulip wren ok done i got it <@358291050957111296>

Does it work?

tulip wren Jun 12, 2024, 7:10 AM

#

heyy i am getting one more doubt that like i want to fetch the third party API and i succesfully fetched it from restTemplate but how to convert the JSON into String Object can i use GSON library for it ?

tulip wren Jun 12, 2024, 7:11 AM

#

serene surge Does it work?

yehh i was retriving it in the wrong way ! i was retriving it in the register Controller where it was saving not in the loggedIn controller where the query is actually working hidethepain

serene surge Jun 12, 2024, 7:12 AM

#

tulip wren heyy i am getting one more doubt that like i want to fetch the third party API a...

you can - or you could use something else

tulip wren Jun 12, 2024, 7:14 AM

#

serene surge you can - or you could use something else

This is what i have done ```package com.moviefindercontrollers.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.client.RestTemplate;

@Service
public class ApiService {

private static final String API_KEY = "private";
private static final String BASE_URL = "http:/private/";

@Autowired
private RestTemplate restTemplate;

public String fetchDataFromApi(String parameter) {
    String url = BASE_URL + "?apikey=" + API_KEY + "&t=" + parameter + "&plot=full";
    
    return restTemplate.getForObject(url, String.class);
}

}

#

?

#

@serene surge

serene surge Jun 12, 2024, 7:38 AM

#

tulip wren This is what i have done ```package com.moviefindercontrollers.service; import ...

I think RESTTemplate can convert to objects if wanted

tulip wren Jun 12, 2024, 7:47 AM

#

serene surge I think RESTTemplate can convert to objects if wanted

do u have any doucmentation related to it

serene surge Jun 12, 2024, 7:55 AM

#

tulip wren do u have any doucmentation related to it

https://javadoc.io/doc/org.springframework/spring-web/6.1.5/org/springframework/web/client/RestTemplate.html#class-description

tulip wren Jun 12, 2024, 7:57 AM

#

Hey I Suddenly Starts to get this Several ports (8005, 8080) required by Tomcat v9.0 Server at localhost are already in use. The server may already be running in another process, or a system process may be using the port. To start this server you will need to stop the other process or change the port number(s).

#

@serene surge

serene surge Jun 12, 2024, 7:58 AM

#

Does your program run twice?

tulip wren Jun 12, 2024, 7:58 AM

#

now i have already closed it and closed the ecplise as well

#

and after that i got this

near relic Jun 12, 2024, 9:33 AM

#

Try to restart your computer.

#

(if the tomcat run as a windows service you will have this problem after restart too)

near relic Jun 12, 2024, 10:13 AM

#

     * Respond to the request of the photo by the user's id.
     *
     * @param userId The url-parameter holding the user's id
     * @param request The request will injected by spring, never <code>null</code>
     * @return The photo or the answer that the photo in the browser's cache did not change
     */
    @GetMapping("/profilePhoto.jpeg")
    public ResponseEntity<byte[]> sendProfilePhotoToBrowser(@RequestParam("userId") long userId, HttpServletRequest request) {
        var existingUser = finderUserImp.findById(userId);
        byte[] decodedImage = Base64.getDecoder().decode(existingUser.getImage());
        var dbEtag = "" + '"' + Objects.hash(decodedImage) + '"';
        var browsersEtag = request.getHeader(HttpHeaders.IF_NONE_MATCH);

        // do not send if browser already have the image
        ResponseEntity<byte[]> result;
        if (dbEtag.equals(browsersEtag)) {
            result = new ResponseEntity<>(HttpStatus.NOT_MODIFIED);
        } else {
            var headers = new HttpHeaders();
            headers.setETag(dbEtag);
            headers.setContentLength(decodedImage.length);

            // the browser will correct it
            headers.setContentType(MediaType.IMAGE_JPEG);
            result = new ResponseEntity<>(decodedImage, headers, HttpStatus.OK);
        }
        return result;
    }
``` try this

#

The jsp-part might look like this: <img src="profilePhoto.jpeg?userId=${user.id}" />

serene surge Jun 12, 2024, 1:54 PM

#

near relic ``` /** * Respond to the request of the photo by the user's id. * ...

A userId parameter to the GetMapping?

near relic Jun 12, 2024, 1:55 PM

#

Yes, considerations?

serene surge Jun 12, 2024, 2:07 PM

#

near relic Yes, considerations?