It2EDU

Wednesday, January 25, 2017







                                                                                               


Web socket are introduced in java EE7 JSR 356 is related to web
socket and provides API for creating web socket applications. Web socket is an
application protocol that for a ideas full-duplex communication between two peers
over the TCP protocol. The web socket enables web applications to deliver a
richer user experience.


In web socket   application a web socket end point published
by the server, and the client uses the End points URI to connect to the server.
When the connection is Established Web socket protocol is symmetrical and the
client & server can send messages to Each other when the connection is
open, and they can close the connection at any time. Clients usually connect
only to one server, and servers accept connections from multiple clients.


Web socket protocol has two parts


1) Hand shake


2) Data transfer


Client initiates the hand shake by sending a request to a
web socket end point using its URI. It is comfortable with HTTP-based
infrastructure. The web socket client API specified in JSR356 also enables you
to access remote web socket end points from any JAVA applications.


           Javax.websocket.
Server.


           Javax.Websocket.Endpoint


The java API for web socket enables you to create two kinds
of end points


1.      
Programmatic 
end point


2.      
Annotated end point


Creation of programmatic end point:


End points are instance of endpoint class. This is in the
part of web socket. To create a programmatic end point you extend the Endpoint
class and override its life cycle methods.


To create an annotated end point: By using annotations creating
annotation based end points are created.


After successfully create endpoint deploy these code into a
specific URI in the application.


 So that remote
clients can connect to it.


Steps to create& deploy web socket end point.


1) Create end point class.


2) Implement life cycle methods of the end point.


3) Add business logic to end point.


4)Deploy the end point inside a web application.


 








Wednesday, January 18, 2017









In this article I am going to explain how to compare two excel
sheets data and highlight the missing data. This article is helpful in BPO
industry those who are dealt with finance and insurance sector.





Now a day’s everything automated in this comparison of two excel
sheets is taking too lengthy process and our eyes also gets strained so to
avoid that read the article and practice yourself with a sample data. If you
have any questions let me know.





Here I am using two functions 




VLOOKUP()




       MATCH()





Usage of VLOOKUP() function in excel:





Syntax of Vlookup function: 










First go to formulas tab and select Lookup & Reference
then click on VLOOKUP():



























 Based on the syntax of the function pass the values like below:





Lookup Value - > What is the required value for searching.





Table Array -> Select the range where you want to find the given element.





Column Index -> Column number 





Range Lookup -> True or False













See the below practice excel sheet which contains the data:





 





By Using MATCH() Function:





Match Function Syntax:





 match function





 Go to formulas tab and select Lookup & Reference
then click on MATCH().





Fill the formula columns like below:





Look up value -> What the element you want to search, select that column.





Look up array -> Where you want to search the element select the range.





Match Type -> It is 0,1,-1  0 for exact match 1 or -1 greater than or less than




match function










See the below practice excel sheet which contains the data:





 








PLEASE NOTE : in the above practice sheet NA means no match found.