Find Duplicate Records MySQL Query

Hi All

I know that this is not related Liferay but i came across this useful thing during my development where you can find duplicate record from table and can delete if you need.

SELECT tablename.name FROM tablename
INNER JOIN (SELECT name FROM tablename
GROUP BY name HAVING count(name) > 1) dup_record ON tablename.name = dup_record.name

Read More

Read Files From Folder

Hi All,

You can use below code to read files from specific folders :

import java.io.File;

public class Test {

    /**

     * @param args

     */  

public static void listFilesForFolder(File folder) {

        

        for (File fileEntry : folder.listFiles()) {

            if (fileEntry.isDirectory()) {

                listFilesForFolder(fileEntry);

            } else {

                

                System.out.println(fileEntry.getName());

            }

        }

        System.out.println("Total :" +folder.listFiles().length);

    }

Read More

Malicious code vulnerability - Java Programming

Malicious code vulnerability - Field is a mutable array

Malicious code vulnerability - Field is a mutable Hashtable

Malicious code vulnerability - Field isn't final and can't be protected from malicious code

Malicious code vulnerability - Field isn't final but should be

Malicious code vulnerability - Field should be both final and package protected

Read More

Performance - Java Programming

Performance - Could be refactored into a named static inner class

Performance - Could be refactored into a static inner class

Performance - Explicit garbage collection; extremely dubious except in benchmarking code

Performance - Huge string constants is duplicated across multiple class files

Performance - Inefficient use of keySet iterator instead of entrySet iterator

Performance - Maps and sets of URLs can be performance hogs

Performance - Method allocates a boxed primitive just to call toString

Performance - Method allocates an object, only to get the class object

Read More

Avoid - Java Programming

Avoid Array Loops

Avoid Assert As Identifier

Avoid Calling Finalize

Avoid Catching NPE

Avoid Catching Throwable

Avoid Decimal Literals In Big Decimal Constructor

Avoid Duplicate Literals

Avoid Enum As Identifier

Avoid Instanceof Checks In Catch Clause

Avoid Print Stack Trace

Avoid Rethrowing Exception

Avoid Throwing Null Pointer Exception

Avoid Throwing Raw Exception Types

Read More

Bad practice - Java Programming

Bad practice - Abstract class defines covariant compareTo() method

Bad practice - Abstract class defines covariant equals() method

Bad practice - Certain swing methods needs to be invoked in Swing thread

Bad practice - Check for sign of bitwise operation

Bad practice - Class defines clone() but doesn't implement Cloneable

Bad practice - Class defines compareTo(...) and uses Object.equals()

Bad practice - Class defines equals() and uses Object.hashCode()

Read More