1 /*
  2  * To change this template, choose Tools | Templates
  3  * and open the template in the editor.
  4  *
  5  */
  6 
  7 package db_adapter;
  8 
  9 /**
 10  *
 11  * @author sameldin
 12  */
 13 import java.io.*;
 14 import java.sql.Connection;
 15 import java.sql.DriverManager;
 16 import java.sql.PreparedStatement;
 17 import java.sql.ResultSet;
 18 import java.sql.SQLException;
 19 import java.util.ArrayList;
 20 import java.util.Hashtable;
 21 import java.util.MissingResourceException;
 22 import java.util.ResourceBundle;
 23 import java.util.Calendar;
 24 import java.util.Date;
 25 import java.text.SimpleDateFormat;
 26 
 27 
 28 //import org.apache.log4j.Logger;
 29 //import org.apache.log4j.PropertyConfigurator;
 30 
 31 import utils.*;
 32 import constants.*;
 33 
 34 
 35 public class SQL_OuterJoin
 36 {
 37     Connection  localConnection = null;
 38 
 39     public SQL_OuterJoin()
 40     {
 41         BD_Connector localBD_Connector = new BD_Connector();
 42         localConnection = localBD_Connector.getConnection();
 43     }
 44      /*
 45      * JOIN is same as INNER JOIN
 46      * Commen interection between the two tables -
 47      */
 48      public int selectINNER_JOIN(String leftTable, String rightTable, long commenID)
 49      {
 50         // SELECT *  FROM   leftTable  INNER JOIN rightTable  ON leftTable.commenID = rightTable.commenID;
 51 
 52         return(Constants.NORMAL_RUN);
 53      }
 54 
 55     /*
 56      * LEFT JOIN is same as LEFT OUTER JOIN
 57      * Left table only with rated values from right table
 58      */
 59      public int selectLEFT_OUTER_JOIN(String leftTable, String rightTable, long commenID)
 60      {
 61         // SELECT *  FROM   leftTable  LEFT OUTER JOIN rightTable  ON leftTable.commenID = rightTable.commenID;
 62 
 63         return(Constants.NORMAL_RUN);
 64      }
 65     /*
 66      * RIGHT JOIN is same as RIGHT OUTER JOIN 
 67      * right table only with the related left table values.
 68      */
 69      public int selectRIGHT_OUTER_JOIN(String leftTable, String rightTable, long commenID)
 70      {
 71         // SELECT *  FROM   leftTable  RIGHT OUTER JOIN rightTable  ON leftTable.commenID = rightTable.commenID;
 72 
 73         return(Constants.NORMAL_RUN);
 74      }
 75     /*
 76      * FULL OUTER JOIN
 77      *
 78      */
 79      public int selectFULL_JOIN(String leftTable, String rightTable, long commenID)
 80      {
 81         // SELECT *  FROM   leftTable  FULL OUTER JOIN rightTable  ON leftTable.commenID = rightTable.commenID;
 82 
 83         return(Constants.NORMAL_RUN);
 84      }
 85     /*
 86      * CROSS JOIN
 87      *
 88      */
 89      public int selectCROSS_JOIN(String LeftTable, String rightTable, long commenID)
 90      {
 91         // SELECT *  FROM   leftTable  CROSS JOIN rightTable  ON leftTable.commenID = rightTable.commenID;
 92 
 93         return(Constants.NORMAL_RUN);
 94      }
 95      /*
 96       *
 97       */
 98      public int selectXXJoin(String employeesTable, String departmentTable, long departmentID)
 99      {
100         //  SELECT *
101         //  FROM   employee
102         //  FULL OUTER JOIN department
103         //  ON employee.DepartmentID = department.DepartmentID;
104         // ORDER BY employee.DepartmentID
105          if(null == localConnection)
106             return(Constants.ERROR_RUN);
107          PreparedStatement  localPreparedStatement  = null;
108          ResultSet          localResultSet          = null;
109          //===================================
110          try
111          {
112             String qryString    = "";
113             String localEmployeesTable      = DatabaseKeysPropertyManager.getParameter(employeesTable);
114             String localDepartmentTable     = DatabaseKeysPropertyManager.getParameter(departmentTable);
115             //=============================
116             qryString   =       "SELECT * FROM "
117                             +   localEmployeesTable
118                             +   " FULL OUTER JOIN "
119                             +   localDepartmentTable
120                             +   " ON "
121                             +   localEmployeesTable
122                             +   "."
123                             +   departmentID
124                             +   " = "
125                             +   localDepartmentTable
126                             +   "."
127                             +   departmentID
128                             +   " ORDER BY "
129                             +   localEmployeesTable
130                             +   "."
131                             +   departmentID
132                             +   ";";
133                 //===============================
134                 localPreparedStatement = localConnection.prepareStatement(qryString);
135                 localResultSet = localPreparedStatement.executeQuery();
136                 ArrayList localXYZArrayList = new ArrayList();
137                 //===========================================
138                 while(localResultSet.next())
139                 {
140 
141                 }
142 
143             localPreparedStatement = localConnection.prepareStatement(qryString);
144             localResultSet = localPreparedStatement.executeQuery();
145 
146          }
147          catch(MissingResourceException eMissingResourceException)
148          {
149             eMissingResourceException.printStackTrace();
150             return(Constants.ERROR_RUN);
151          }
152          catch(SQLException eSQLException)
153          {
154             eSQLException.printStackTrace();
155             return(Constants.ERROR_RUN);
156          }
157         return(Constants.NORMAL_RUN);
158      }
159 
160 }
161 
162