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>

I have this problem where I solved it  when my array is not empty.
My issue is whem the array is empty.  I tried to put an condition but it's useless.
I got this error "[ERROR]   CycleSwapTest.testCycleSwapEmptyCaseShift:44 � ArrayIndexOutOfBounds Index 0 o..."

Proceed to CycleSwap class and implement its static methods:

void cycleSwap(int[] array)
Shifts all the elements in the given array to the right by 1 position.
In this case, the last array element becomes first.
For example, 1 3 2 7 4 becomes 4 1 3 2 7.

void cycleSwap(int[] array, int shift)
Shift all the elements in the given array to the right in the cycle manner by shift positions.
Shift value is guaranteed to be non-negative and not bigger than the array length.
For example, 1 3 2 7 4 with a shift of 3 becomes 2 7 4 1 3.
For a greater challenge, try not using loops in your code (not mandatory).

Note that input array may be empty.


Examples
Code Sample:

int[] array = new int[]{ 1, 3, 2, 7, 4 };
CycleSwap.cycleSwap(array);
System.out.println(Arrays.toString(array));
Output:

[4, 1, 3, 2, 7]


Code Sample:

int[] array = new int[]{ 1, 3, 2, 7, 4 };
CycleSwap.cycleSwap(array, 2);
System.out.println(Arrays.toString(array));
Output:

[7, 4, 1, 3, 2]


Code Sample:

int[] array = new int[]{ 1, 3, 2, 7, 4 };
CycleSwap.cycleSwap(array, 5);
System.out.println(Arrays.toString(array));
Output:

[1, 3, 2, 7, 4]

My code is:

<pre>class CycleSwap {
     static void cycleSwap(int[] array) {
        int shift = 1;
 
        reverse(array, 0, array.length - 1);
        reverse(array, shift, array.length - 1);
    }
 
     static void cycleSwap(int[] array, int shift) {
         //shift = shift % array.length;
        reverse(array, 0, array.length - 1);
        reverse(array, 0, shift - 1);
        reverse(array, shift, array.length - 1);
    }
 
    private static void reverse(int[] nums, int i, int j) {
        while (i < j) {
            int temp = nums[i];
            nums[i] = nums[j];
            nums[j] = temp;
            i++;
            j--;
        }
    }
 
    public static void main(String[] args) {
        {
            int[] array = new int[]{1, 3, 2, 7, 4};
            CycleSwap.cycleSwap(array,2);
            System.out.println(Arrays.toString(array));
        }
        {
            int[] array = new int[]{};                                                        // I tried here to put this condition: if (array == null) { 
            CycleSwap.cycleSwap(array);                                               //                                                           System.out.println("0");
            System.out.println(Arrays.toString(array));                         //                                                        }
        }
        {
            int[] array = new int[]{};                                                          // here the same condition from above
            CycleSwap.cycleSwap(array, 3);
            System.out.println(Arrays.toString(array));
        }
 
 
     }
}
 
Output: 
[7, 4, 1, 3, 2]
[]
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0
    at com.epam.rd.autotasks.CycleSwap.reverse(CycleSwap.java:22)
    at com.epam.rd.autotasks.CycleSwap.cycleSwap(CycleSwap.java:16)
    at com.epam.rd.autotasks.CycleSwap.main(CycleSwap.java:43)