How to read Excel file in Java with jxl.jar?

/*Reading Excel file (with default locale) with jxl.jar file ,you can use file object to read file in workbook settings*/
public void processExcelFile(InputStream fileInput)throws Exception {
WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale("en", "EN"));
Workbook workbook = Workbook.getWorkbook(fileInput, ws);
//Workbook workbook = Workbook.getWorkbook(file, ws);
//Cell[] headCells = sheet.getRow(0);
for (row = 1; row < sheet.getRows(); row++) {
String errorStr = "";
Cell[] cells = sheet.getRow(row);
System.out.println("column1 value:"+cells[0].getContents());
System.out.println("column2 value:"+cells[1].getContents());
System.out.println("column3 value:"+cells[2].getContents());
}
}
To download jxl.jar file go through this link
http://www.docjar.com/jar/jxl-2.6.jar

How to Sort HashMap or Map in java?

/* Sorting Map and return LinkedHashMap, u can send HashMap implemented Object but it should a map like
Map map = new HashMap();
ma p = sortHashMapByValues(map);
*/
public LinkedHashMap sortHashMapByValues(Map passedMap) {
List mapKeys = new ArrayList(passedMap.keySet());
List mapValues = new ArrayList(passedMap.values());
Collections.sort(mapValues);
Collections.sort(mapKeys);

LinkedHashMap sortedMap =
new LinkedHashMap();

Iterator valueIt = mapValues.iterator();
while (valueIt.hasNext()) {
Object val = valueIt.next();
Iterator keyIt = mapKeys.iterator();

while (keyIt.hasNext()) {
Object key = keyIt.next();
String comp1 = passedMap.get(key).toString();
String comp2 = val.toString();

if (comp1.equals(comp2)){
passedMap.remove(key);
mapKeys.remove(key);
sortedMap.put((String)key, val);
break;
}

}

}
return sortedMap;
}

Sql server pagination query

select* from ( SELECT ROW_NUMBER() OVER (ORDER BY ja.AppName) AS RowNumber, ja.* from Applicant ja )a where a.RowNumber <= uplt and a.RowNumber > lowlt

how to use ACEGI filter

CONVERT_URL_TO_LOWERCASE_BEFORE_COMPARISON
PATTERN_TYPE_APACHE_ANT
/javascript/**=#NONE#
/css/**=#NONE#
/images/**=#NONE#
/sounds.*=#NONE#
/secureimg=#NONE#
/**/tmplt.*=#NONE#
/**/.*popup.xhtml=securityFilter
/**/*.jsp=securityFilter
/**/*.xhtml=channelProcessingFilter,httpSessionContextIntegrationFilter,logoutFilter,casProcessingFilter,basicProcessingFilter,exceptionTranslationFilter,filterInvocationInterceptor,securityFilter
/**=httpSessionContextIntegrationFilter,logoutFilter,casProcessingFilter,basicProcessingFilter,exceptionTranslationFilter,filterInvocationInterceptor,securityFilter

Force authentication with Java Mail API

package com;

import java.util.Properties;

import javax.mail.Authenticator;
import javax.mail.MessagingException;
import javax.mail.PasswordAuthentication;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.MimeMessage;

import org.springframework.mail.javamail.MimeMessageHelper;

public class EmailTest {

/**
* @param args
*/
public static void main(String[] args) {
try {
String[] strarr = { "recipient@email.addresses" };
postMail(strarr, "Test u", "Test Mesage", "from@email.address", false);
System.out.println("Mail sent!...");
} catch (MessagingException e) {
e.printStackTrace();
}

}
public static void postMail(String recipients[], String subject, String message, String from, boolean isHtml) throws MessagingException {
boolean debug = false;

// Set the host smtp address
Properties props = new Properties();
props.put("mail.smtp.host","hostipaddr");
String hostEmail = "admin@mail.com";
String pwd = "password";
// create some properties and get the default Session
// Session session = Session.getDefaultInstance(props, null);
Session session = Session.getInstance(props, new ForcedAuthenticator(hostEmail,pwd));
session.setDebug(debug);

// create a message
MimeMessage msg = new MimeMessage(session);

MimeMessageHelper mimeMessageHelper = new MimeMessageHelper(msg);

mimeMessageHelper.setTo(recipients);
mimeMessageHelper.setFrom(from);
mimeMessageHelper.setSubject(subject);
mimeMessageHelper.setReplyTo(from);
mimeMessageHelper.setText(message, isHtml);

Transport.send(mimeMessageHelper.getMimeMessage());
}
}
class ForcedAuthenticator extends Authenticator {
String username;
String password;
public ForcedAuthenticator(String username, String password) {
this.username = username;
this.password = password;
}
@Override
public PasswordAuthentication getPasswordAuthentication() {
return new PasswordAuthentication(this.username, this.password);
}
}