Java quick reference

Java quick reference

Java is object oriented(OOP) programming language. It is platform independent and can be run on any Operating system (OS) and it requires java interpreter (for bytecode to machine code transfer) in the system.

Java applets are one type of java program which is used within a web page however JSP is used to create web applications like PHP, ASP, JSP for the purpose of creating dynamic web pages. JavaBeans is like VB and it is reusable component and the purpose is to create advanced applications. J2EE is another Java program mainly used for data transfer e.g XML structured data.

Java Object:

Java object is a real world representation with its different state & behavior

Java Class:

Class is representation of objects or it is a template for objects.

Class has data members(attributes) and methods

Java constructors:

Java constructors are for initializing the objects of a class. Constructor name is same as class name and Constructors are invoked when objects are created. every class needs constructor and if we did not create one then the compiler will create default constructor. Java modifiers are not allowed for constructors. constructors cannot return values.

e.g. for parameterized constructor

class abc

{

public abc(int numb, String strval)

 {

  System.out.println(“abc is a parameterized constructor of class abc”);

 }

}

e.g. for default constructor

class abc

{

public abc()

 {

  System.out.println(“abc is a default constructor of class abc”);

 }

}

Java packages:

Java packages are group of similar classes or interfaces. Java packages are kind of containers for java classes.

Accessing a package is done by a) import package.*; or  b) import package.classname; etc

compile java files by “javac -d filename.java”

What is the difference between Web Layer (Presentation Tier) vs Application Layer (Logic Tier) vs Database Layer (Data Tier)

1. Presentation Layer is the interface to outside world e.g. web site.

2. Application Layer is a framework to create the interface to the Web site or Presentation Tier

3. Database Layer is the database and associated logic needed to query details.

Web Layer (Presentation Tier)

Contains Virtual Machines and Physical Machines with OS can be Windows, UNIX or Linux

Contains Apache web Server, Apache tomcat, Sun Java Web Server or MS Internet Information Services (IIS)

Application Layer (Logic Tier)

Contains Virtual Machines and Physical Machines with OS can be Windows, UNIX or Linux

Contains Apache tomcat, Red Hat JBoss, BEA Web Logic or IBM WebSphere app server

Database Layer (Data Tier)

Contains Virtual Machines and Physical Machines with OS can be Windows, UNIX or Linux

Contains SQL or Oracle

String reverse using java script split method

Assume given string ‘str’ value is “welcome”
 
function stringRev(str) {
var splitString = str.split(“”);// Use the reverse() method to reverse the array
var arrayReverse = splitString.reverse(); // equals to [“e”, “m”, “o”, “c”, “l”, “e”, “w”]// Use join() method to join the elements of the array into a string as below in comments
var joinArray = arrayReverse .join(“”); //  [“e”, “m”, “o”, “c”, “l”, “e”, “w”] to “emoclew”//Return the reversed string
return joinArray; // “emoclew”
}stringRev(‘welcome’);

Java quick reference

Java is object oriented(OOP) programming language. It is platform independent and can be run on any Operating system (OS) and it requires java interpreter (for bytecode to machine code transfer) in the system.

Java applets are one type of java program which is used within a web page however JSP is used to create web applications like PHP, ASP, JSP for the purpose of creating dynamic web pages. JavaBeans is like VB and it is reusable component and the purpose is to create advanced applications. J2EE is another Java program mainly used for data transfer e.g XML structured data.

 

Java Object:

Java object is a real world representation with its different state & behavior

Java Class:

Class is representation of objects or it is a template for objects.

Class has data members(attributes) and methods

Java constructors:

Java constructors are for initializing the objects of a class. Constructor name is same as class name and Constructors are invoked when objects are created. every class needs constructor and if we did not create one then the compiler will create default constructor. Java modifiers are not allowed for constructors. constructors cannot return values.

 

e.g. for parameterized constructor

 

class abc

{

public abc(int numb, String strval)

 {

  System.out.println(“abc is a parameterized constructor of class abc”);

 }

}

e.g. for default constructor

 

class abc

{

public abc()

 {

  System.out.println(“abc is a default constructor of class abc”);

 }

}

Java packages:

Java packages are group of similar classes or interfaces. Java packages are kind of containers for java classes.

 Accessing a package is done by a) import package.*; or  b) import package.classname; etc

compile java files by “javac -d filename.java”

How to print alphabets using java programming:

First Method:

char cAlpha = ‘A’;

do {
System.out.println(cAlpha );
cAlpha ++;
} while (cAlpha <= ‘Z’);

Second method :

char cAlpha = ‘a’;

while (cAlpha <= ‘z’) {
System.out.println(cAlpha);
cAlpha ++;
}

Third Method :

class PrintAlphabets
{
public static void main(String args[])
{
char chAlpha;

for( chAlpha= ‘a’ ; chAlpha<= ‘z’ ; chAlpha++ )
System.out.println(chAlpha);
}
}

 

Docker container raspberry pi

Docker container raspberry pi

Docker functions like Virtual machine but has got more merits than Virtual machines. Mainly performance and easiness of implementation. Docker manages the software infrastructure and runs as container containing the software and dependencies.  Docker image can be created which can be a software and its dependencies. This docker image can be deployed to many machine where docker is installed which will be working exactly like the source system where software and dependencies are running.

Raspberry pi is a low cost computer which runs using mobile adaptor power . Raspberry pi has multiple ports which connects to keyboard, mouse to take user inputs and output display can be connected to TV monitor using HDMI cable.

Docker image is available in Docker official website and Docker can be installed to Raspberry pi(rpi) using terminal of rpi by a single line command.

 

 

Summary of SQL

What are the SQL MAX() and MIN() Functions?

The MAX() function returns the largest value in the selected column.

The MIN() function returns the smallest value in the selected column.

SELECT MAX(Weight) AS LargestWeight

FROM CricketBats ;

SELECT MIN(Weight) AS SmallestWeight

FROM CricketBats ;

What are the SQL AVG(), COUNT() and SUM() Functions

The SQL AVG() function returns the average value in a numeric values column.

e.g.

SELECT AVG(Weight)

FROM Cricketbats;

The SQL COUNT() function returns the number of rows count that matches with a specified criteria.

SELECT COUNT(ProductID)

FROM Cricketbats;

The SQL SUM() function returns the total sum of a numeric values in a specific column.

e.g

SELECT SUM(Weight)

FROM Cricketbats;

What is SQL UPDATE Statement?

The SQL UPDATE statement is used for modifying the existing records in the selected table.

e.g as below:

UPDATE Users

SET UserContactName=’First name Last name’, City=’City1′

WHERE UserID=1;

What is SQL ORDER BY Keyword

The purpose of ORDER BY keyword is to sort the results in ascending or descending order.

example for ascending order

SELECT * FROM Users

ORDER BY State ASC;

or

SELECT * FROM Users

ORDER BY State;

example for descending order

SELECT * FROM Users

ORDER BY State DESC;

What is a NULL Value in SQL?

NULL values can not be compared using operators =, <, or <> so we will need to use the “IS NULL” or “IS NOT NULL” operators instead.

SELECT UserName, UserContactName, Address FROM Persons

WHERE Address IS NULL;

SELECT UserName, UserContactName, Address FROM Persons

WHERE Address IS NOT NULL;

What is SQL INSERT INTO Statement?

The INSERT INTO statement is used for inserting new records to a table.

e.g.

INSERT INTO Users (UserName, UserContactName, UserAddress, City, ZipCode, State, Country)

VALUES (‘Test1′,’Firstname last name’,’address 1, 2,3 ‘,’City namer’,’99999′,’Statename’,’Countryname’);

What is SQL INSERT INTO SELECT Statement?

The SQL INSERT INTO SELECT statement is used for copying data from one table and then to insert to someother table.

e.g. as below:

INSERT INTO Users (UserName, UserCity, Country)

SELECT VendorName, VendorCity, Country FROM Vendors;

What is the SQL DELETE Statement?

The SQL DELETE statement is used for deleting the existing records in the selected table.

e.g as below:

DELETE FROM Users

WHERE UserName=’Firstname1 Lastname1′;

What is AND, OR and NOT Operators in SQL

AND, OR, and NOT operators are combined with the WHERE clause to get the desired filtered results.

e.g

SELECT * FROM Users

WHERE State =’illinois’ AND City=’Chicago’;

SELECT * FROM Users

WHERE City=’Chicago’ OR City=’New York’;

SELECT * FROM Users

WHERE NOT State =’Chicago’;

What is SQL WHERE Clause?

SQL WHERE clause is used to filter records and its added as below

e.g.

SELECT States FROM Users where Usersgroup = ‘1’;

What is the SQL SELECT TOP Clause ?

The SELECT TOP clause is used to specify the number of records to return.

e.g as below:

SELECT TOP 100 * FROM Users;

How to Use WhatsApp in a Web Browser?

Solution:

1) Go to web.whatsapp.com in a web browser on a computer.
2) Then, on your iOS/Android/Windows mobile phone, open WhatsApp and press the Options on top right corner side
3) then press WhatsApp Web from the options.
4) use iOS/Android/Windows mobile phone to scan the QR code shown on the browser on your computer.

Whatsapp tricks & cheats

How to locate important messages in Whatsapp easily?

Solution: WhatsApp selected messages can be starred.

How to do: Hold down the message and select the star icon on top of whatsapp.

Then You can see all your starred messages directly from your WhatsApp homescreen(View contact >> started message)

How to Use WhatsApp in a Web Browser

1) go to web.whatsapp.com in a web browser on a computer.

2) Then, on your iOS/Android/Windows mobile phone, open WhatsApp and press the Options on top right corner side

3) then press WhatsApp Web from the options.

4) use iOS/Android/Windows mobile phone to scan the QR code shown on the browser on your computer.

How to restrict the view on profile photo and personal status in Whatsapp

Solution: Settings > Account > Privacy and press the right sub-menus for profile photo, status etc.

How to turn it off / hide the Last seen time in WhatsApp?

Follow the path Settings > Account > Privacy > Last Seen

How to turn it off / hide the Read Receipts indication.

Settings > Account > Privacy > Read Receipts

How to reference an old message in WhatsApp and wanted to respond to that.

Hold down the message, then press the left arrow on Android/’reply’ button on iOS. Then type the message that you wanted to display as a response to the old message. This is helpful when multiple conversations are happening in a group chat and you want to respond to a particular message.

How to hide the WhatsApp message previews?

Solution: Go to Settings > Notifications > Show Preview, change the settings.

WhatsApp – how to format the text message

             -it-  => it

             *it* =>    it

            ~it~ =>   it

WhatsApp- Sending voice message instead of typing

            In Android phones – tap on mic icon in WhatsApp and record your voice or use Google’s speech to text engine

            In iPhone phones – tap on mic icon in WhatsApp and record your voice

   ...   ...   ...   ...   ...   ...  ...   ...   ...