public List getUpdate() {
// TODO Auto-generated method stub
List<ProductBean> productList = new ArrayList<ProductBean>();
String sql = "select * from productdb";
try {
DbTrans tools = new DbTrans(sql);
ResultSet rs = tools.executeQuery();
while(rs.next()){
ProductBean product = new ProductBean();
product.setProductId(rs.getInt("productId"));
product.setProductName(rs.getString("productName"));
product.setProductPrice(rs.getDouble("productPrice"));
product.setProductDesc(rs.getString("productDesc"));
product.setProductImg(rs.getString("productImg"));
productList.add(product);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return productList;