TechKmn | Fetch Data From Oracle DataBase To Excel , Using | "APACHE POI" | NetBeans | JAVA | SQL | скачать в хорошем качестве

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/ja...) 3-oracle 11g(https://www.oracle.com/technetwork/da...) 4-Apache Poi jars(https://mvnrepository.com/artifact/co... 5-jar for oracle:-https://www.oracle.com/technetwork/ap... 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);} } }