//将查询到的数据封装到ArrayList中,这是查询操作,
public static ArrayList getProductList()
{
String query = "select * from product";
Connection con = ();
ArrayList el = new ArrayList();
try{
Statement stmt = ();
ResultSet rs = (query);//查询结果放在结果集中
while(())//结果集遍历
{
int ID = ("id");
String productNO = ("productNO").trim();
String productIntroduce = ("productIntroduce").trim();
Product product = ();//product的javabean
(ID);
(productNO);
(productIntroduce);
(product);
}
();
();
();
return el;
}
catch(Exception e)
{
();
return null;
}
}
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
<%
ArrayList el = (ArrayList)();//将查询结果传到jsp
Iterator iter = ();
while(())
{
Product product = (Product)();
%>
<%=()%><p>//输出查询到的结果
<%=() %>
<a href=<%="/EC/Admin/product/edit_product.jsp?product_/EC/Admin/product/delete_product.jsp?product_{if(confirm('确定删除吗?')){return true;}return false;}">[删除]</a>
<%
}
%>