Blog Archives

Checkstyle & Maven Tutorial

Step 1: The pom.xml with the checkstyle plugin and properties.



Findbugs and Maven tutorial

Findbugs is an open source project for a static analysis of the Java bytecode to identify potential software bugs.

Findbugs-structure

Step 1: The pom.xml with the findbug & site reporting plugins and properties.



Maven and Cobertura Tutorial

Cobertura is a free code coverage tool, which calculates the percentage of Java code accessed by unit tests.

Step 1: The pom.xml file with the relevant reporting plugins. The properties also shown to set the coverage percentage and to skip code coverage or not.



Notepad++ beginner tutorial

You can download Notepad++ from http://notepad-plus-plus.org/download. It is a very handy productivity boosting tools. Q. Why is Notepad++ is a very handy tool? A.  Notepad++ is a very handy developer…



Notepad++ productivity tips with SQL trigger code example

One of the traits of good developers is that being lazy and this laziness leads to finding productive ways to perform a task. Recently, I had to create a number…



Notepad++ to construct SQL where clause

Lets take a tutorial like scenario to demonstrate power of Notepad++ as a  developer productivity tool. Q. How will you extract rule_name values from a tabular data shown below and…



Notepad++ with the power of regex for productivity tutorial

This post is based on a industrial example where you have a CSV file where you want to add quotes (i.e. “) around it. For example

Convert text like:

To


Another reason you might want to do this in Java is to construct a String array or list as shown below.…



Power of Excel spreadsheet to dynamically generate SQL

When you have some data in tabular (e.g. Excel spreadsheet) format and would like to insert into a database table, you need to write an SQL insert query. Manually writing SQL query for multiple records can be cumbersome. This is where Excel spreadsheet comes in handy as demonstrated below. A single SQL query can be copied down where the formulas get copied with incrementing column numbers.…



Power of SQL as a productivity tool

There are times where you need to generate “INSERT” SQL statements from existing data. For example, you may have a production release ready “Delete” SQL statement as shown below to…



800+ Java & Big Data Interview Q&As

200+ Java & Big Data Tutorials

Top