How to arrange Two excel sheets side by Side
Steps
Now to compare 2 Rows in 2 Excel Sheets
If you want the formatting to be applied only for one Column select that column and apply conditional formatting
Instead of
=$A$2:$B$7
it should be
=$A$2:$A$7
in Conditional Rules Formatting Manager
How to Filter cells based on Font Color, Cell Color
How to highlight rows which have different row value of one Column
The Steps are as Below
Below is the way to highlight the rows based on a change in value in the single column.The Column considered is SNo
Steps
In the below image Rows 4 and 7 are highlighted because of mismatch in SNo and 5 is highlighted because of mismatch in fruit name
Checking for Identical rows in two tables with more than one column
=ISNA(MATCH($D2,$A$2:$A$7,FALSE)&MATCH($E2,$B$2:$B$7,FALSE) )
Steps
=MATCH(lookup_value, lookup_array, match_type)
lookup_value – Value you are interested in
lookup_array – Column you want to look for value
match_type – Whether it should be a exact match or approximate match
Match Function
=MATCH(D2,A2:A7,FALSE)
Looks for D2 in the Lookup Array in A2 to A7
Match with Msg
=IFERROR(MATCH(D2,A2:A7,FALSE),"Missing")
In case of Error IFERROR is used to make it display as Missing
Match with ISNA
=ISNA(MATCH(D2,A2:A7,FALSE))
If #N/A then it would be displayed as True
Match with 2 Columns
=MATCH(D2,A2:A7,FALSE)&MATCH(E2,B2:B7,FALSE)
In the above code, we are checking the two columns for uniqueness by using two match function
and using && Operator to display the value as 11 or #N/A
System Path is one which comes when you type cmd in windows->run
Other simple commands are dir,ver,cls
Storing Variable Name
>>set strName=Mugil >>echo %strName%
Typing set and pressing enter will return system variable
>>set
To check for List of Users type
>>set USER
String Cancatenation
>>set strFirstName=Mugil >>set strFirstName=%strFirstName% Vannan
Displays Volumne Info
>>vol D: >>dir /B
Get option of Util
>>dir /?
>>cls /?
Lists folder in Dir with details
>>dir
Lists folder in Dir without details
>>dir /B
Turn off the command executed in Screen
>>echo off
Turn off the Display of Batch Statements when Echo off command activated(Works for Script)
>>@echo off
/A tag will allow us to work with mathematical operation
>>Set /A
/P tag will allow user inputs by prompting msg
>>Set /P
Getting Inputs from Console
@echo off set /p name=Please Enter your name echo. echo Your name is - %name% pause
Labels(Organize code pieces)
:label
Goto(Jumps to Label and starts execution)
goto :label
Comments
rem this is comment :: this is again a comment
Functions
:getSum echo The Sum is Addition of Two Numbers goto :eof
Calling Functions within function
:getMath echo Calling Sum Function call :getSum goto :eof :getSum echo The Sum is Addition of Two Numbers goto :eof
Functions that takes Argument
The below batch script helps to read the selected trailing lines from Log File
@echo off
cls
setlocal EnableDelayedExpansion
set "cmd=findstr /R /N "^^" C:\Users\Mugil\Desktop\test.txt | find /C ":""
for /f %%a in ('!cmd!') do set totalLines=%%a
rem echo "totalLines-"%totalLines%
@set linesToConsider=4
set /a lineToStart="%totalLines%-%linesToConsider%"
rem echo "lineToStart-"%lineToStart%
set content=
for /f "skip=%lineToStart% delims=" %%i in ('type C:\Users\Mugil\Desktop\test.txt') do set content=!content! %%i
@echo "content - "%content%
If NOT "%content%"=="%content:SUCCESS=%" (
echo Build Successful
) else (
echo Build Failed
)
pause
Working with EntityManagerFactory – Best Practices
Java Archives (JAR) A JAR file encapsulates one or more Java classes, a manifest, and a descriptor. JAR files are the lowest level of archive. JAR files are used in J2EE for packaging EJBs and client-side Java Applications.
A WAR (Web Archive) is a module that gets loaded into a Web container of a Java Application Server. A Java Application Server has two containers (runtime environments) – one is a Web container and the other is a EJB container.
The Web container hosts Web applications based on JSP or the Servlets API – designed specifically for web request handling – so more of a request/response style of distributed computing. A Web container requires the Web module to be packaged as a WAR file – that is a special JAR file with a web.xml file in the WEB-INF folder.
An EJB container hosts Enterprise java beans based on the EJB API designed to provide extended business functionality such as declarative transactions, declarative method level security and multiprotocol support – so more of a RPC style of distributed computing. EJB containers require EJB modules to be packaged as JAR files – these have a ejb-jar.xml file in the META-INF folder.
Enterprise applications may consist of one or more modules that can either be Web modules (packaged as a WAR file) or EJB modules (packaged as a JAR file) or both of them. Enterprise applications are packaged as EAR files – these are special JAR files containing an application.xml file in the META-INF folder.
Basically EAR files are a superset containing WAR files and JAR files. Java Application Servers allow deployment of standalone web modules in a WAR file, though internally they create EAR files as a wrapper around WAR files. Standalone web containers such as Tomcat and Jetty do not support EAR files – these are not full fledged Application servers. Web applications in these containers are to be deployed as WAR files only.
In application servers – EAR files contain configurations such as application security role mapping, EJB reference mapping and context root url mapping of web modules.
Apart from Web modules and EJB modules EAR files can also contain connector modules packaged as RAR files and Client modules packaged as JAR files.
Unidirectional – bidirectional relationship provides navigational access in one direction
Parent -----> Child
i.e you can go from parent to child, but you cannot go back from children to parent.
However, if there were no pointer to Parent in Child:
class Child { }
Bidirectional – bidirectional relationship provides navigational access in both directions
Parent <-----> Child
i.e you can go from a Parent to its child, and vice-versa: the parent knows about its child, the child knows about its parent
class Parent {
Child* children;
}
class Child {
Parent* parent;
}
Idle Scenarios
One to One unidirectional Mapping
employee knows the employer
One to One Bidirectional Mapping
employer knows the employee and employee knows the employer
One to Many unidirectional Mapping
employee has a skill in his skill set which is not used by other employees
One to Many bidirectional Mapping
employee has a skill in his skill set which is not used by other employees and
employer knows that employee has this skill in skill set
Many to One unidirectional Mapping
employees knows which employer he is going to work but employer has no idea about employee
employees will have employerId in their entity class but employer has no details of employee
Many to One bidirectional Mapping
Many employees work for one Employer. The employer knows about employee and employee knows about employer
employees will have employerId in their entity class but employer will have empid of employee
Many to Many unidirectional Mapping
Employee knows the employers he has worked for but employers does not know details of employee who worked for them
Many to Many bidirectional Mapping
Employee knows about the employers he has worked for and employers knows about employee who has worked for them.
Eclipse complain about @Override on interface methods?
Using the @Override annotation on methods that implement those declared by an interface is only valid from Java 6 onward. It’s an error in Java 5.
Make sure that your IDE projects are setup to use a Java 6 JRE, and that the “source compatibility” is set to 1.6 or greater. Open the Window > Preferences dialog, and browse to Java > Compiler. There you can set the “Compiler compliance level” to 1.6.
Project->Properties->java compiler->