Page History

In this article, we will show you on how to show images from form upload field by using the JDBC Datalist Database Binder.

Figure 1: Image in a listing

This is what we want to achieve, as shown in Figure 1 above.

We will need to get the path to the image first, as shown in Figure 2 above.

Figure 2: Getting the URL of the image

Then, in the Datalist, we will need to construct the img html tag, mimicking the image URL path. In this case, we are using the default database and writing the SQL based on MySQL database.

SELECT id, c_title, c_image, concat("<img src='http://localhost:8080/jw/web/client/app/imageInList/1/form/download/sample/", id, "/", c_image, ".'/>") as 'image',
concat("<img src='http://localhost:8080/jw/web/client/app/imageInList/1/form/download/sample/", id, "/", c_image, ".thumb.jpg'/>") as 'imagethumb' FROM app_fd_sample

...

You can download sample app used in this article for your reference.