//class JavaTemplate1
//PostGreSQL_StoredFunction2
package javatemplate1;

import java.sql.Connection;  
import java.sql.ResultSet;  
import java.sql.SQLException;
import java.sql.Statement;  
import java.util.logging.Level;
import java.util.logging.Logger;

public class JavaTemplate1 {
       public static void main(String[] args) {
        // TODO code application logic here
       System.out.println("main block executing ");
       ExternalClass1 extclass1 = new ExternalClass1();
       //get connection from external class
       Connection connect = extclass1.createConnection();
       String query = " select show_text1() ";
       //
      Statement st = null;// query statement support
       ResultSet rs = null;// active connection database result
       // 
		try {
                    st = connect.createStatement();
                    rs = st.executeQuery(query); 
                    while(rs.next())
                    {
                       System.out.println(rs.getObject(1));
                       System.out.println(rs.getString(1));
                    }
    
		} catch (Exception e) {
			System.out.println(e.toString());
		}
	}
}
// ExternalClass1
// JPanel and display output in embeddded Graphics

package javatemplate1;

import java.awt.Color;
import java.awt.Graphics;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JPanel;

/**
 *
 * @author Manas9
 */
public class ExternalClass1 extends JPanel{
    String str1=null; 
      ExternalClass2 extclass = new ExternalClass2();
    @Override
 public void paintComponent(Graphics g) {
super.paintComponent( g );
      // draw the face
     g.setColor( Color.YELLOW ); 
     g.fillOval( 10, 10, 200, 200 );
      //
     g.drawArc(5, 10, 20, 30, 50,100);
      // draw the eyes
      g.setColor( Color.BLACK );
      g.fillOval( 55, 65, 30, 30 );
      g.fillOval( 135, 65, 30, 30 );
      // draw the mouth
      g.fillOval( 50, 110, 120, 60 );
      // "touch up" the mouth into a smile
      g.setColor( Color.YELLOW );
      g.fillOval( 50, 120, 120, 40 );
      //Ceate uneven ey6borws
      g.drawRoundRect(50, 50, 150, 250,50, 150);
      g.setColor( Color.RED);
       //topleft 50, topheight 25, wide 50,
       //height object 10,round  60 and 30,  , 
    g.fillRoundRect(50, 25,50,10,60 ,20);
    g.fillRoundRect(125,25,50,10,30 ,60);
        try {
            g.drawString( loaddata(),75, 145 );// embedding text
        } catch (SQLException ex) {
            Logger.getLogger(ExternalClass1.class.getName()).log(Level.SEVERE, null, ex);
        }
    
   } // end method paintComponent
  private String loaddata() throws SQLException
{
    Connection connect = extclass.createConnection();
       String query = " select show_text1() ";
       //
      Statement st = null;// query statement support
       ResultSet rs = null;// active connection database result
       // Creating Callable Statement
		try {
                    st = connect.createStatement();
                    rs = st.executeQuery(query); 
                    while(rs.next())
                    {
                       System.out.println(rs.getObject(1));
                       System.out.println(rs.getString(1));
                       str1 = rs.getString(1);
                       // will have "Hello World" Text 
                    }
    
		} catch (Exception e) {
			System.out.println(e.toString());
		}
                finally{
                     connect.close();
                     System.out.println("connection closed" ); 
                }
               
    return str1; 
}

 }


 //class ExternalClass2
 // Creating and Returning connection object
package javatemplate1;

import java.sql.Connection;
import java.sql.DriverManager;

/**
 *
 * @author Manas9
 */
public class ExternalClass2 {
    Connection cnn= null;
     String dbURL = "jdbc:postgresql://localhost:5432/pgsdemo1";
      String user = "postgres"; String pwd = "postgre_manas9";
      // Creating a function to get a connection
	public Connection createConnection() {
		 System.out.println("Connection Object Created");
		// checking connection
		if (cnn != null) {
			System.out.println("Can't creaate a connection");
			return cnn;
		} else {
		try {
		// Getting connection
		cnn = DriverManager.getConnection(dbURL,user,pwd);
			} catch (Exception e) {
				System.out.println(e.toString());
			}
		}
		return cnn;
	}

}