Adobe Flex MVC Pattern

Comparing date in SQLServer

DATEDIFF(DAY, START_DATE, END_DATE) = 0
AND
DATEDIFF(MONTH, START_DATE, END_DATE) = 0
AND
DATEDIFF(YEAR, START_DATE, END_DATE) = 0

Adding a Date to a date in SQL Server

DATEADD(DAY, No of days to add, date_to_which_days_are_added)




Example:



DATEADD(DAY, 1, START_DATE)

Intalling Jars in your local Maven repository

Command:

mvn install:install-file -Dfile= -DgroupId= \
    -DartifactId= -Dversion= -Dpackaging=

The above command will install jar file into your local ~/.m2 directory.

Example:

mvn install:install-file -Dfile=sqljdbc4.jar -DgroupId=com.microsoft.jdbcdriver -DartifactId=sqljdbc4 -Dversion=4.0 -Dpackaging=jar

Java event-driven programming

Netty, MINA

Rounding in Java

public static double Round(double Rval, int Rpl) {
double power = Math.pow(10,Rpl);
Rval = Rval * power;
double tmp = new BigDecimal(Rval).setScale(0, BigDecimal.ROUND_HALF_UP).doubleValue();
return (double)tmp/power;
}

MD5 checksum on a file in Linux.

Installing MD5SUM package:

$ apt-get update
$ apt-get install coreutils

Generate checksum file
$ md5sum transaction.log > MDSSS

Check the checksum:

$ cat MDSSS
ae43fda27bf612e2d7128c3072220078 transaction.log