missing return statement ?
Hi All,
my following code gives me compile time error:
says missing return statement..
package constructionapp.blayer;
import constructionapp.ProductSpecificationBean;
import constructionapp.PSearchBean;
import constructionapp.Connect;
import java.util.*;
import java.sql.*;
publicclass BlayerPShow{
public BlayerPShow(){
}
public HashMap showProduct(int companyid,int productid,String productname)throws Exception{
Connect connect =new Connect();
Connection con =null;
PreparedStatement pstmt =null;
ResultSet rs =null;
String query="SELECT DISTINCT COMPANY.COMPANY_NAME,COMPANY_LOGO,PRODUCT_MASTER.PRODUCT_ID,COMPANY.COMPANY_ID, "+
"PRODUCT_MASTER.PRODUCT_CATEGORY,PRODUCT_MASTER.PRODUCT_TYPE,PRODUCT_MASTER.PRODUCT_STYLE, "+
"PRODUCT_DETAIL.PRODUCT_FINISH,PRODUCT_DETAIL.PRODUCT_COLOR,PRODUCT_DETAIL.PRODUCT_APPLICATION,PRODUCT_DETAIL.PRODUCT_SHAPE, "+
"PRODUCT_DETAIL.PRODUCT_NAME,PRODUCT_DETAIL.PRODUCT_SIZE,PRODUCT_DETAIL.PRODUCT_PICTURE,PRODUCT_DETAIL.PRODUCT_DISCRIPTION,PRODUCT_DETAIL.PRODUCT_WARRANTY "+
"FROM COMPANY INNER JOIN PRODUCT_MASTER ON COMPANY.COMPANY_ID=PRODUCT_MASTER.COMPANY_ID LEFT OUTER JOIN PRODUCT_DETAIL ON "+
"PRODUCT_MASTER.PRODUCT_ID=PRODUCT_DETAIL.PRODUCT_ID WHERE COMPANY.COMPANY_ID=? AND PRODUCT_MASTER.PRODUCT_ID=? "+
"AND PRODUCT_DETAIL.PRODUCT_NAME=?";
try{
con = connect.openCon();
pstmt=con.prepareStatement(query);
pstmt.setInt(1,companyid);
pstmt.setInt(2,productid);
pstmt.setString(3,productname);
rs=pstmt.executeQuery();
while(rs.next()){
HashMap productMap =new HashMap();
ProductSpecificationBean obj =newProductSpecificationBean();
int product_id=rs.getInt("PRODUCT_ID");
obj.setPname(rs.getString("PRODUCT_NAME"));
obj.setPcategory(rs.getString("PRODUCT_CATEGORY"));
obj.setPtype(rs.getString("PRODUCT_TYPE"));
obj.setPstyle(rs.getString("PRODUCT_STYLE"));
obj.setPfinish(rs.getString("PRODUCT_FINISH"));
obj.setPcolor(rs.getString("PRODUCT_COLOR"));
obj.setPapplication(rs.getString("PRODUCT_APPLICATION"));
obj.setPshape(rs.getString("PRODUCT_SHAPE"));
obj.setPsize(rs.getString("PRODUCT_SIZE"));
obj.setPdescription(rs.getString("PRODUCT_DISCRIPTION"));
obj.setPwarranty(rs.getString("PRODUCT_WARRANTY"));
productMap.put(new Integer(product_id),obj);
}// end while
}// end try
catch(Exception e){
System.out.println("construction.com ERROR1 in constructionapp.blayer.BlayerPSearch "+e);
}finally{
rs.close();
pstmt.close();
connect.closeCon();
System.out.println("connection closed");
}// end finally
return productMap;
}// end method
}
So please tell me what should I do to remove my this errror..
Please reply soon.
Thanks in advance.
Amitindia
