Java Netbean Only one line gets written into a file

[emyk]

I am trying to write oracle database select returns into an excel file. The script only wirites one line (first/last row ) into the file. I am trying to figure out what am I doing wrong here to get all the returned rows data written into the file.

package writefilestoexcel;

import java.awt.Label;
import java.io.FileNotFoundException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.stream.XMLStreamException;
import javax.xml.transform.TransformerException;
import org.xml.sax.SAXException;
import java.io.*;
import java.io.File;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;


public class writefilestoexcel {
   

    /**
     * @param args the command line arguments
     */
     public static void main(String argv[]) throws FileNotFoundException, XMLStreamException, IOException, ParserConfigurationException, ClassNotFoundException, SQLException, SAXException, TransformerException, InterruptedException {

      try { 
          String inputfile = ("C:/NewExcelFile1.xls") ;
          File filename = new File(inputfile);
         

        HSSFWorkbook workbook=new HSSFWorkbook();


Object UNIT = "Please Enter 5 Digit ID";
        String LocidInputDialog = javax.swing.JOptionPane.showInputDialog(
              UNIT);
System.out.println(LocidInputDialog);
Class.forName("oracle.jdbc.driver.OracleDriver");
                   String url = "jdbc:oracle:thin:@dbserver:1535:database1";  
 Connection conn = DriverManager.getConnection(url,"ID","PASSWORD"); 
               java.sql.Statement s=conn.createStatement();
ResultSet rs; 
HSSFSheet sheet =  workbook.createSheet("LID");  
HSSFRow rowhead=   sheet.createRow((short)0);
        rowhead.createCell((short) 0).setCellValue("US_NAME");
        rowhead.createCell((short) 1).setCellValue("US_ABREV");
        rowhead.createCell((short) 2).setCellValue("GR_NAME");
        rowhead.createCell((short) 3).setCellValue("Email");
rs = s.executeQuery("select * from us_locations ");

FileOutputStream fileOut =  new FileOutputStream(filename);
 
while ( rs.next() ) { 
String LID = rs.getString("LOCID" ) + (",");
String USNAME = rs.getString("US_NAME" ) + (",");
String USABREV = rs.getString("US_ABREV" )+ (",");
String GRNAME = rs.getString("GR_NAME" );

 

        HSSFRow row=   sheet.createRow((short)1);
        row.createCell((short) 0).setCellValue(LID);
        row.createCell((short) 1).setCellValue(USNAME);
        row.createCell((short) 2).setCellValue(USABREV);
        row.createCell((short) 3).setCellValue(GRNAME);
       

System.out.println(LID + USNAME + USABREV + GRNAME); 



} 
workbook.write(fileOut);
fileOut.close();




        System.out.println("Your excel file has been generated!");
conn.close(); 

} catch (Exception e) { 
System.err.println("Got an exception! "); 
System.err.println(e.getMessage()); 
}
     }
}

[emyk]

i have fixed my issue. I needed to initialize the loop and added a line at the end to increment the return. All working fine now.

I am trying to write oracle database select returns into an excel file. The script only wirites one line (first/last row ) into the file. I am trying to figure out what am I doing wrong here to get all the returned rows data written into the file.

package writefilestoexcel;

import java.awt.Label;
import java.io.FileNotFoundException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.stream.XMLStreamException;
import javax.xml.transform.TransformerException;
import org.xml.sax.SAXException;
import java.io.*;
import java.io.File;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;


public class writefilestoexcel {
   

    /**
     * @param args the command line arguments
     */
     public static void main(String argv[]) throws FileNotFoundException, XMLStreamException, IOException, ParserConfigurationException, ClassNotFoundException, SQLException, SAXException, TransformerException, InterruptedException {

             int nRow = 1;
            String strQuery = null;
            Connection con = null;            
            HSSFRow row;
            HSSFCell cell;
      try { 
          String inputfile = ("C:/NewExcelFile1.xls") ;
          File filename = new File(inputfile);
         

        HSSFWorkbook workbook=new HSSFWorkbook();


Object UNIT = "Please Enter 5 Digit ID";
        String LocidInputDialog = javax.swing.JOptionPane.showInputDialog(
              UNIT);
System.out.println(LocidInputDialog);
Class.forName("oracle.jdbc.driver.OracleDriver");
                   String url = "jdbc:oracle:thin:@dbserver:1535:database1";  
 Connection conn = DriverManager.getConnection(url,"ID","PASSWORD"); 
               java.sql.Statement s=conn.createStatement();
ResultSet rs; 
HSSFSheet sheet =  workbook.createSheet("LID");  
HSSFRow rowhead=   sheet.createRow((short)0);
        rowhead.createCell((short) 0).setCellValue("US_NAME");
        rowhead.createCell((short) 1).setCellValue("US_ABREV");
        rowhead.createCell((short) 2).setCellValue("GR_NAME");
        rowhead.createCell((short) 3).setCellValue("Email");
rs = s.executeQuery("select * from us_locations ");

FileOutputStream fileOut =  new FileOutputStream(filename);
 
while ( rs.next() ) { 
String LID = rs.getString("LOCID" ) + (",");
String USNAME = rs.getString("US_NAME" ) + (",");
String USABREV = rs.getString("US_ABREV" )+ (",");
String GRNAME = rs.getString("GR_NAME" );

 

        row=   sheet.createRow((short)nRow);
        row.createCell((short) 0).setCellValue(LID);
        row.createCell((short) 1).setCellValue(USNAME);
        row.createCell((short) 2).setCellValue(USABREV);
        row.createCell((short) 3).setCellValue(GRNAME);
      nRow++
System.out.println(LID + USNAME + USABREV + GRNAME); 



} 
workbook.write(fileOut);
fileOut.close();




        System.out.println("Your excel file has been generated!");
conn.close(); 

} catch (Exception e) { 
System.err.println("Got an exception! "); 
System.err.println(e.getMessage()); 
}
     }
}