无法编译通过的javabean

以下是源代码：
--------------------------------------------------------------------------------------------------------------------------------------------------------
import java.sql.*;
import java.util.*;
import java.io.*;
import com.jsp.util.*;

public class ProductBean
{
private Connection con;
public ProductBean()
{
this.con=DataBaseConnection.getConnection();
  }
                public Collection getAllProduct()throws Exception
{
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select * from Products");
Collection ret=new ArrayList();
while(rst.next())
{
Product temp=new Product();
temp.setProductId(rst.getString("productid"));
temp.setCategoryId(rst.getString("category"));
temp.setName(rst.getString("name"));
temp.setDescription(rst.getString("descn"));
temp.setProducer(rst.getString("producer"));
temp.setPrice(rst.getFloat("price"));
                                                temp.setzs(rst.getInt("zs"));
temp.setyinshua(rst.getSting("yinshua"));
temp.setadr(rst.getString("adr"));
temp.setys(rst.getInt("ys"));
temp.setyc(rst.getString("yc"));
temp.setyz(rst.getInt("yz"));
temp.setkb(rst.getString("kb"));
twmp.setemail(rst.getString("email"));

ret.add(temp);
}
con.close();
return ret;
}


public Collection getProductByCategory(String categoryId)throws Exception
{
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select * from Products where category='"+categoryId+"'");
Collection ret=new ArrayList();
while(rst.next())
{
Product temp=new Product();
temp.setProductId(rst.getString("productid"));
temp.setCategoryId(rst.getString("category"));
temp.setName(rst.getString("name"));
temp.setDescription(rst.getString("descn"));
temp.setProducer(rst.getString("producer"));
temp.setPrice(rst.getFloat("price"));
            temp.setzs(rst.getInt("zs"));
temp.setyinshua(rst.getSting("yinshua"));
temp.setadr(rst.getString("adr"));
temp.setys(rst.getInt("ys"));
temp.setyc(rst.getString("yc"));
temp.setyz(rst.getInt("yz"));
temp.setkb(rst.getString("kb"));
temp.setemail(rst.getString("email"));

ret.add(temp);
}
con.close();
return ret;
}


public void addProduct(Product product)throws Exception
{

PreparedStatement pstmt=con.prepareStatement("insert into products values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
pstmt.setString(1,product.getProductId());
pstmt.setString(2,product.getCategoryId());
pstmt.setString(3,product.getName());
pstmt.setString(4,product.getProducer());
pstmt.setFloat(5,product.getPrice());
pstmt.setString(6,product.getDescription());
pstmt.setInt(7,product.getzs());
pstmt.setString(8,product.getyinshua());
pstmt.setString(9,product.getadr());
pstmt.setInt(10,product.getys());
pstmt.setString(11,product.getyc());
pstmt.setInt(12,product.getyz());
pstmt.setString(13,product.getkb());
pstmt.setString(14,product.getemail());
pstmt.execute();

}


public void modifyProduct(Product product)throws Exception
{

PreparedStatement pstmt=con.prepareStatement("update products set category=?,name=?, producer=?,price=?,descn=? where productid=?");
pstmt.setString(1,product.getCategoryId());
pstmt.setString(2,product.getName());
pstmt.setString(3,product.getProducer());
pstmt.setFloat(4,product.getPrice());
pstmt.setString(5,product.getDescription());
pstmt.setString(6,product.getProductId());
pstmt.setInt(7,product.getzs());
pstmt.setString(8,product.getyinshua());
pstmt.setString(9,product.getadr());
pstmt.setInt(10,product.getys());
pstmt.setString(11,product.getyc());
pstmt.setInt(12,product.getyz());
pstmt.setString(13,product.getkb());
pstmt.setString(14,product.getemail());
pstmt.execute();
}


public void deleteProduct(String productId)throws Exception
{
Statement stmt=con.createStatement();
stmt.execute("delete from products where productid='"+productId+"'");
}


public Product getProductInfo(String productId)throws Exception
{

Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select * from products where productid='"+productId+"'");
Product product=null;
while(rst.next())
{
product=new Product();
product.setProductId(rst.getString("productid"));
product.setCategoryId(rst.getString("category"));
product.setName(rst.getString("name"));
product.setDescription(rst.getString("descn"));
product.setProducer(rst.getString("producer"));
product.setPrice(rst.getFloat("price"));
               product.setzs(rst.getInt("zs"));
product.setyinshua(rst.getSting("yinshua"));
product.setadr(rst.getString("adr"));
product.setys(rst.getInt("ys"));
product.setyc(rst.getString("yc"));
product.setyz(rst.getInt("yz"));
product.setkb(rst.getString("kb"));
product.setemail(rst.getString("email"));

}
return product;
}
}

以上是我做的一个用于处理事物逻辑的javabean，包括了对商品操作的一系列操作，前几次编译运行非常正常，可是昨天我对程序的属性进行了一些修改之后
编译就无法通过了，具体什么原因我不清楚，分析了几次代码觉得没有什么问题
所以请大家帮忙
注意：包com.jsp.uti里面是一个解决数据库连接的工具类l

代码太长，建议自行解决。
：）））））））））））））） -------------------- 因我的生命就有若微尘，躺卧于街头或结伴同行，也不介意做个自由人，无必须要紧。

[em043]

代码太长，建议自行解决。：））））））））））））））--------------------因我的生命就有若微尘，躺卧于街头或结伴同行，也不介意做个自由人，无必须要紧。

太没良心了你：）
白帮助你转帖子了
哭 -------------------- 再努力一把吧，要毕业了~~~~~~~~~

把编译的错误信息贴出来看看！！

呵呵 [ 2004-12-08 11:13:50 W 修改 ]