JAVA WORLD

Tuesday, May 5, 2009

Decimal Format

import java.text.DecimalFormat;

public String getCommssion_fmc(String id)
{
double amount=0.0f;
try{
antarik.connection conn=new antarik.connection();
java.sql.Statement st=conn.con.createStatement();
java.sql.ResultSet rs=st.executeQuery("select amount from tblcommision_details where emp_code='"+id+"'");
while(rs.next())
{
String am=rs.getString(1).trim();
amount=amount+Double.parseDouble(am);


DecimalFormat df=new DecimalFormat("#0.00");

String pp=df.format(amount);


amount=Double.parseDouble(pp);
// System.out.println("am: "+am);
//System.out.println("amount: "+amount);
//System.out.println("pp: "+pp);
//System.out.println("amount final: "+amount);
}




}
catch(Exception ex)
{

}

return ""+amount;
}

No comments: