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;
}
Tuesday, May 5, 2009
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment