Techie Zona

  ; com.hiteshagrawal pacote;

 ; javax.naming importação .*;
 ; importação java.sql .*;
 ; javax.sql importação .*;
 ; import java.io. *;

 public class final ConnectionManager (
         null ; DataSource ds = null privado;

         público getDatabaseInstance ConnectionManager () (
            null ; Context ctx = null;
            null ; String datasource = null;
            is = null ; java. io. InputStream is = null;

            null != ds ) { if (null! = ds) (
                ds de retorno;
            )

            try (
                InitialContext ( ) ; ctx = new InitialContext ();
                null == ctx ) { if (null == ctx) (
                     ( "Context is null. Error in connecting to the datasource." ) ; throw new Exception ("O contexto é nulo. Erro na conexão com a fonte de dados.");
                )

	        . getResourceAsStream ( "jdbc" ) ; = é DbConnection. classes. getResourceAsStream ("jdbc");
	        is == null ) { if (é == null) (
		  DataSource ) ctx. lookup ( "java:comp/env/jdbc/test" ) ; ds = (DataSource) ctx. lookup (java ": comp / env / jdbc / test");
	       { Else ()
		 String ( convertStreamToString ( is ) ) . trim ( ) ; datasource = new String (convertStreamToString (is)). trim ();
		 DataSource ) ctx. lookup ( datasource ) ; ds = (DataSource) ctx. datasource lookup ();
	      )
           ( Exception e ) { ) Catch (Exception e) (
	      ; e. printStackTrace ();
           )
           ds de retorno;	
       )

       getDatabaseConnection ( ) { público getDatabaseConnection Connection () (
	 null ; Connection con = null;
	 try (
	       ( ) ; con = ds. getConnection ();
	 ( Exception e ) { ) Catch (Exception e) (
	         ; e. printStackTrace ();
	 )
	 con retorno;
      )	

      convertStreamToString ( InputStream is ) { convertStreamToString private String (InputStream is) (
	 new BufferedReader ( new InputStreamReader ( is ) ) ; BufferedReader leitor = new BufferedReader (novo InputStreamReader (is));
	 StringBuilder ( ) ; StringBuilder StringBuilder sb = new ();
 	 null ; String linha = null;
	 try (
	      line = reader. readLine ( ) ) != null ) { while ((linha = leitor. readLine ())! = null) (
	          line + " \n " ) ; sb. append (linha + "\ n");
	      )  
         ( IOException e ) { ) Catch (IOException e) (
	      ; e. printStackTrace ();
	 { Finally ()
	     try (
	       ; é. close ();
	    ( IOException e ) { ) Catch (IOException e) (
	       ; e. printStackTrace ();
	    )
	 )
	 ( ) ; sb retorno. toString ();
      )
 )