TechKmn | Fetch Data From Oracle DataBase To Excel , Using | "APACHE POI" | NetBeans | JAVA | SQL |

To fetch data from oracle to excel ,we need to download....
1-netbeans(https://netbeans.org/downloads/)
2-jdk(https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html)
3-oracle 11g(https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html)
4-Apache Poi jars(https://mvnrepository.com/artifact/commons-lang/commons-lang/2.6)...https://mvnrepository.com/artifact/org.apache.poi/poi/3.9
5-jar for oracle:-https://www.oracle.com/technetwork/apps-tech/jdbc-112010-090769.html

CODE:-

import java.io.File;
import java.io.FileOutputStream;
import java.sql.*;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
class ExcelDatabase {
public static void main(String args[]) throws SQLException{
try{
//step1 load the driver class
Class.forName("oracle.jdbc.driver.OracleDriver");

//step2 create the connection object
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","SYSTEM","SYSTEM");

//step3 create the statement object
Statement stmt=con.createStatement();

//step4 execute query
ResultSet resultSet=stmt.executeQuery("select * from EMPLOYE_TABLE");
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet spreadsheet = workbook.createSheet("employe db");

XSSFRow row = spreadsheet.createRow(1);
XSSFCell cell;
cell = row.createCell(1);
cell.setCellValue("EMPLOYEE_ID");
cell = row.createCell(2);
cell.setCellValue("EMPLOYEE_NAME");
cell = row.createCell(3);
cell.setCellValue("EMPLOYEE_ADD");
cell = row.createCell(4);
cell.setCellValue("EMPLOYEE_CONTACTNO");
cell = row.createCell(5);
cell.setCellValue("EMPLOYEE_STATUS");
cell = row.createCell(6);
cell.setCellValue("EMPLOYEE_SALARY");

int i = 2;

while(resultSet.next())
{
row = spreadsheet.createRow(i);
cell = row.createCell(1);
cell.setCellValue(resultSet.getInt("EMPLOYEE_ID"));
cell = row.createCell(2);
cell.setCellValue(resultSet.getString("EMPLOYEE_NAME"));
cell = row.createCell(3);
cell.setCellValue(resultSet.getString("EMPLOYEE_ADD"));
cell = row.createCell(4);
cell.setCellValue(resultSet.getString("EMPLOYEE_CONTACTNO"));
cell = row.createCell(5);
cell.setCellValue(resultSet.getString("EMPLOYEE_STATUS"));
cell = row.createCell(6);
cell.setCellValue(resultSet.getString("EMPLOYEE_SALARY"));
i++;
}

FileOutputStream out = new FileOutputStream(new File("exceldatabase.xlsx"));
workbook.write(out);
out.close();
System.out.println("exceldatabase.xlsx written successfully");



//con.close();

}catch(Exception e){ System.out.println(e);}

}
}