Another Id generater method

//////////call method//////////////
SimpleDateFormat sdf = new SimpleDateFormat("ddMMyyyy");

String reqid = new IdGenerator().getDateFormatedNextId("tbl_travel_package_req", "TPR-"+sdf.format(new Date()), "req_id", 3);


////////////////////////////



/////Method defination//////////////
public String getDateFormatedNextId(String tableName,String prefix,String columnName, int padlen)throws Exception
{
//create the connection of database.
int temp=0;
Connection con = null;
try{
con=new DBConnection().getDBConnection();
con.setAutoCommit(false);
Statement stmt=con.createStatement(); // getCon() is the return type of created Connection.
ResultSet rs=stmt.executeQuery("Select max(cast(SUBSTRING_INDEX("+columnName.trim()+",'/',-1) as unsigned int )) from "+tableName.trim()+" where SUBSTRING_INDEX("+columnName.trim()+",'/',1)='"+prefix.trim()+"'");

if(rs.next())
{
String str = rs.getString(1);
if(str != null)
{
temp=Integer.parseInt(str);
}

}

++temp;

String new_no = ""+temp;
prefix +="/";
for(int i = new_no.trim().length();i<padlen;i++)
{
prefix =prefix.trim()+"0";
}
rs.close();
stmt.close();
con.commit();
}catch(Exception e){
if(con != null){
con.rollback();
}
throw e;
}
finally
{
con.setAutoCommit(true);
}

con.close();
next_id=prefix.trim()+(temp);

return next_id;
}

Languge translate using google translation api

///// Use google-api-translate-java-0.92.jar ////////////////

import com.google.api.translate.Language;
import com.google.api.translate.Translate;



Translate.setHttpReferrer("http://kmainfonet.in");
String translatedText = Translate.execute(line, Language.ENGLISH, Language.FRENCH);
System.out.println(translatedText);

Getting text containt out of a web page and translate it in any other language

///// Use google-api-translate-java-0.92.jar ////////////////



import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.IOException;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.InputStreamReader;
import java.io.Reader;
import java.net.URL;
import java.util.List;
import java.util.ArrayList;

import javax.swing.text.html.parser.ParserDelegator;
import javax.swing.text.html.HTMLEditorKit.ParserCallback;
import javax.swing.text.html.HTML.Tag;
import javax.swing.text.MutableAttributeSet;

import com.google.api.translate.Language;
import com.google.api.translate.Translate;

public class HTMLUtils {
private HTMLUtils() {}

public static List<String> extractText(Reader reader) throws IOException {
final ArrayList<String> list = new ArrayList<String>();

ParserDelegator parserDelegator = new ParserDelegator();
ParserCallback parserCallback = new ParserCallback() {
public void handleText(final char[] data, final int pos) {
list.add(new String(data));
}
public void handleStartTag(Tag tag, MutableAttributeSet attribute, int pos) { }
public void handleEndTag(Tag t, final int pos) { }
public void handleSimpleTag(Tag t, MutableAttributeSet a, final int pos) { }
public void handleComment(final char[] data, final int pos) { }
public void handleError(final java.lang.String errMsg, final int pos) { }
};
parserDelegator.parse(reader, parserCallback, true);
return list;
}

public final static void main(String[] args) throws Exception{

URL url = new URL("http://en.wikipedia.org/wiki/Hello");
StringBuilder sb = new StringBuilder();
BufferedReader reader = new BufferedReader(new InputStreamReader(url.openStream()));
BufferedWriter writer = new BufferedWriter(new FileWriter("c:\\data.html"));

String line;
while ((line = reader.readLine()) != null) {
sb.append(line);
writer.write(line);
writer.newLine();
}


FileReader freader = new FileReader("c:\\data.html");
List<String> flines = HTMLUtils.extractText(freader);
System.out.println("Original Text");
for (String fline : flines) {
System.out.println(fline);
}

System.out.println("\n\n\nTranslated Text");
Translate.setHttpReferrer("http://en.wikipedia.org/wiki/Hello");
for (String fline : flines) {
String translatedText = Translate.execute(fline, Language.ENGLISH, Language.FRENCH);
System.out.println(translatedText);
}
}
}