Java

ResultSet rs = stmt.executeQuery("SELECT Column FROM Table WHERE Condition");

package Chrome;
//CHROME
import java.io.File;
import java.io.FileFilter;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.FilenameFilter;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.chrome.ChromeOptions;


public class ValidateInput {

public static void main(String[] args) throws Throwable {
// TODO Auto-generated method stub

// String filePath=System.getProperty("user.dir")+"\\UP.xlsx";
//File src = new File(filePath);    
//System.out.println(filePath);
File src = new File("C:\\Users\\Z246379\\Documents\\TestDataFolder\\ValidateInput.xlsx");          
FileInputStream fis = new FileInputStream(src);        



XSSFWorkbook wb = new XSSFWorkbook(fis);        
XSSFSheet Sheet1 = wb.getSheetAt(0);
int i1 = 2;
//Username
String data0 = Sheet1.getRow(2).getCell(0).getStringCellValue();
//Password    
String data01 = Sheet1.getRow(2).getCell(1).getStringCellValue();
//Case ID
String caseID = Sheet1.getRow(i1).getCell(2).getStringCellValue();
// Description
String Desc = Sheet1.getRow(2).getCell(3).getStringCellValue();
//Internal Claim File
String ICF = Sheet1.getRow(1).getCell(4).getStringCellValue();
String CRPT = Sheet1.getRow(1).getCell(5).getStringCellValue();

// final String caseID1 = caseID1;




//Chrome driver code

 System.out.println("Called openBrowser");
 String exePath = System.getProperty("user.dir")+"\\chromedriver.exe";
 System.setProperty("webdriver.chrome.driver", exePath);
 ChromeOptions options = new ChromeOptions();
 options.setExperimentalOption("useAutomationExtension", false);
 options.addArguments("start-maximized");
 options.addArguments("--no-sandbox");
 options.addArguments("--disable-extensions-except");
 options.addArguments("disable-extensions");
 //options.setExperimentalOption("useAutomationExtension", false); 
 WebDriver driver = new ChromeDriver(options);
 driver.get("https://client.abc.com");


 //Logging in       
 driver.findElement(By.xpath("//input[@id='userid']")).sendKeys(data0);
 driver.findElement(By.xpath("//body[@class='no-nav']/div[@id='wrapper']/header[@class='header']/div[@class='container']/div[@class='menu']/div[@class='drop']/div[@class='login-form']/form[@method='POST']/div[2]/input[1]")).sendKeys(data01);
 driver.findElement(By.xpath("//input[@value='Sign In']")).click();
 Thread.sleep(2000);
 //Navigate to Validate Input
 driver.findElement(By.xpath("//span[@class='wpsNavLevel2'][contains(text(),'EZ-Test')]")).click();
 Thread.sleep(3000);
 driver.get("https://ezt.abc.com/Test/inputFiles/selectValidateInput/selectValidateInput.xhtml");

 while (caseID != null)
      {

  caseID = Sheet1.getRow(i1).getCell(2).getStringCellValue();
  //Input Validate Input stuff

  driver.findElement(By.xpath("//input[@id='mainForm:caseId']")).sendKeys(caseID);
driver.findElement(By.xpath("//input[@id='mainForm:testBedDesc']")).sendKeys(Desc);
  driver.findElement(By.xpath("//select[@id='mainForm:customRptOptions']")).sendKeys(ICF);
 driver.findElement(By.xpath("//span[@id='mainForm:customReportLabel']")).click();




  File dir = new File("C:\\Users\\Z333379\\Documents\\Test beds");
  FilenameFilter filter = new FilenameFilter() {
  public boolean accept (File dir, String name) { 
   return name.startsWith(caseID); //this is where i get the error. its not letting me make case ID a variable. but i really need the starts with stuff
   } 
 }; 
 String[] children = dir.list(filter);
 if (children == null) {
    System.out.println("Either dir does not exist or is not a directory"); 
 } else { 
   for (int i=0; i< children.length; i++) {
   String filename = children[i];
   System.out.println(filename);
        driver.findElement(By.xpath("//input[@id='mainForm:comprehensive']")).sendKeys("C:\\Users\\Z246379\\Documents\\Test beds\\" + filename);
    } 
 } 

 driver.findElement(By.xpath("//button[@id='mainForm:reset']")).click();


 i1=i1+1;
      }

  }
}

Hello everyone, I have a list of Objects, whose attributes include a BLOB object, taken from a database, how can I display the image in JSP?

This is the servlet code with which I take objects from the DB

<pre lang="Java">				
               while(rs.next()) {
			    	Rapportino rapp = new Rapportino();
					String nome_operaio = rs.getString("nome_operaio");
					String cognome_operaio = rs.getString("cognome_operaio");
					String ruolo_operaio = rs.getString("ruolo_operaio");
					Date data = rs.getDate("data");
					String luogo = rs.getString("luogo");
					Blob foto = rs.getBlob("file");
					

					rapp.setNome_operaio(nome_operaio);
					rapp.setCognome_operaio(cognome_operaio);
					rapp.setRuolo_operaio(ruolo_operaio);
					rapp.setData(data);
					rapp.setLuogo(luogo);
					rapp.setFoto(foto);
					
					rapportini.add(rapp);
				}

				request.setAttribute("rapportini", rapportini);
		        request.getRequestDispatcher("rapportino.jsp").forward(request,response);

And this is the jsp, for now I have not implemented the code for the BLOB

<pre lang="HTML"><pre>
<% List<Rapportino> rapportini = (List<Rapportino>)request.getAttribute("rapportini");%>
<!DOCTYPE html>
<html>
	<head>
	<meta charset="ISO-8859-1">
	<title>Rapportini</title>
	</head>
	<body>
		<h1>Rapportino:</h1>
		<table>
		  <c:forEach items="${rapportini}" var="rapp">
		    <tr>
		      <td><c:out value="${rapp}" /></td>
		    </tr>
		  </c:forEach>
		</table>
		<a href="homepage_admin.jsp">Torna alla home</a>
	</body>
</html>