Monday 15 May 2017

Java - Reading the text content from file with out loop through

Reading the text content from file with out loop through.

Sample Program:
import java.io.IOException;
import java.nio.charset.Charset;
import java.nio.file.Files;
import java.nio.file.Paths;

public class ReadFile {
public static void main(String[] args) throws IOException {
byte[] encoded = Files.readAllBytes(Paths.get("C:\\filename.txt"));
String fileContent = new String(encoded, Charset.defaultCharset());

System.out.println(fileContent);
}
}


Reading the text content from File using 'while' loop.

Sample Program:
import java.io.BufferedReader;
import java.io.FileReader;

public class Read2File {
public static void main(String[] args) {
try {
FileReader fileReader = new FileReader("C:\\filename.txt");
BufferedReader bufferedReader = new BufferedReader(fileReader);
String fileLine = null;
StringBuffer temp = new StringBuffer();
while((fileLine = bufferedReader.readLine()) != null) {
                              temp.append(fileLine+"\n");
                        }
System.out.println(temp);
bufferedReader.close();
   fileReader.close();
}catch (Exception e) {
e.printStackTrace();
}
}
}

Monday 1 May 2017

Java - Reading the text content(xml/json) with out loop through 'InputStreamReader'

Reading the text content(xml/json) with out loop through 'InputStreamReader'.

Prerequisite:
Requires java 8 to execute below program

Sample Program:
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.stream.Collectors;

public class Test8WsGet {

public static void main(String[] args) {
try {

URL url = new URL("http://thomas-bayer.com/sqlrest/CUSTOMER/2/");
HttpURLConnection connection = (HttpURLConnection) url.openConnection();
connection.setRequestMethod("GET");
connection.setRequestProperty("Accept", "application/json");

if (connection.getResponseCode() != 200) {
throw new RuntimeException("Failed with HTTP error code : " + connection.getResponseCode());
}

String responseXml;
System.out.println("Response xml from Server .... \n");

BufferedReader bufferReader = new BufferedReader(new InputStreamReader(connection.getInputStream()));
responseXml = bufferReader.lines().collect(Collectors.joining("\n"));

System.out.println(responseXml);

connection.disconnect();
} catch (Exception e) {
e.printStackTrace();

}
}
}
Troubleshooting :
If you are executing above program using maven(i.e. pom.xml) then add below maven-compiler-plugin
Reference: https://maven.apache.org/plugins/maven-compiler-plugin/examples/set-compiler-source-and-target.html
    <plugins>
      <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>3.6.1</version>
        <configuration>
          <source>1.8</source>
          <target>1.8</target>
        </configuration>
      </plugin>
    </plugins>


Reading the text content(xml/json) from 'InputStreamReader' using 'while' loop.

Sample Program:
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;

public class TestWsGet {

public static void main(String[] args) {
try {

URL url = new URL("http://thomas-bayer.com/sqlrest/CUSTOMER/2/");
HttpURLConnection connection = (HttpURLConnection) url.openConnection();
connection.setRequestMethod("GET");
connection.setRequestProperty("Accept", "application/json");

if (connection.getResponseCode() != 200) {
throw new RuntimeException("Failed with HTTP error code : " + connection.getResponseCode());
}

String responseXml;
System.out.println("Response xml from Server .... \n");

BufferedReader br = new BufferedReader(new InputStreamReader((connection.getInputStream())));
while ((responseXml = br.readLine()) != null) {
System.out.println(responseXml);
}

connection.disconnect();
} catch (Exception e) {
e.printStackTrace();
}
}
}

Saturday 7 January 2017

VBScripts Fundamentals - Part1


Using concatenate, "&_" and "vbcrlf" in VB Script

Watch Video
 
Prerequisite:
http://automation-home.blogspot.in/2017/01/vb-script-basic-example.html
 
Using concatenate, "&_" and "vbcrlf" in VB Script
- Concatenate using plus sign(+) and ampersand (&).

- String in multiple lines using "&_" and ''+_''.
   ex: Sql query as string

- To print in different lines use "vbcrlf" (it is like '\n').
    ex: "Hello welcome" --> "Hello" &vbcrlf& "welcome"
    References: http://powerasp.net/content/new/vbscript-constants.asp 
                        http://www.asciitable.com/

Thursday 5 January 2017

VB Script Basic Example

Watch Video


Writing the VB Script in
- Notepad
- Notepad++
      https://notepad-plus-plus.org/download/v7.3.html
- VbsEdit
      http://www.vbsedit.com/

Saving the file
Save the file  as <<File Name>>.vbs

Execution the VB Script.
- Command Prompt
- Editor
- Double click on VB Script file