GET LIST FILE IN SERVER AND TRANFER TO DATABASE

import java.io.File;

import java.sql.*;

public class get_file_list 

{

   /**

    * List all the files and folders from a directory

    * @param directoryName to be listed

    */

   public void listFilesAndFolders(String directoryName){

       File directory = new File(directoryName);

       //get all the files from a directory

       File[] fList = directory.listFiles();

       for (File file : fList){

           System.out.println(file.getName());

       }

   }

   /**

    * List all the files under a directory

    * @param directoryName to be listed

    */

   public void listFiles(String directoryName)

    throws SQLException

   {

    int ret_code;

    Connection conn = null;

    conn = DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION=(load_balance=yes)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=e)(failover_mode=(type=select)(method=basic)(retries=32)(delay=4))))", "xx", "xxxxx");

            

       File directory = new File(directoryName);

       //get all the files from a directory

       File[] fList = directory.listFiles();

       for (File file : fList){

           if (file.isFile())

           {

               System.out.println(file.getName());

               String sql2 = "INSERT INTO dir_list_ecm VALUES (?)";

               System.out.println(conn);

          //PreparedStatement pstmt1 = conn.prepareStatement(sql1);

            PreparedStatement pstmt2 = conn.prepareStatement(sql2);

         

            pstmt2.setString(1, file.getName());

            pstmt2.executeUpdate();

            System.out.println("finis");

             pstmt2.close();

            

           }

       }

       conn.close();

   }

   /**

    * List all the folder under a directory

    * @param directoryName to be listed

    */

   public void listFolders(String directoryName){

       File directory = new File(directoryName);

       //get all the files from a directory

       File[] fList = directory.listFiles();

       for (File file : fList){

           if (file.isDirectory()){

               System.out.println(file.getName());

           }

       }

   }

   /**

    * List all files from a directory and its subdirectories

    * @param directoryName to be listed

    */

   public void listFilesAndFilesSubDirectories(String directoryName){

       File directory = new File(directoryName);

       //get all the files from a directory

       File[] fList = directory.listFiles();

       for (File file : fList){

           if (file.isFile()){

               System.out.println(file.getAbsolutePath());

           } else if (file.isDirectory()){

               listFilesAndFilesSubDirectories(file.getAbsolutePath());

           }

       }

   }

   

  

   public static void main (String[] args)  throws SQLException

   {

    get_file_list listFilesUtil = new get_file_list();

       final String directoryLinuxMac ="/backup/ECM_TTQT";

       //Windows directory example

       final String directoryWindows ="D://Works";

       listFilesUtil.listFiles(directoryLinuxMac);

       

   }

}

================================================

Note :  Grant_permission

declare 

begin 

 dbms_java.grant_permission('SYSTEM','java.util.PropertyPermission','*','read');

 dbms_java.grant_permission('SYSTEM','java.net.SocketPermission','*','connect, resolve');

 dbms_java.grant_permission('SYSTEM','java.io.FilePermission','/backup/ECM_TTQT','read');

end;