
public ProductBean searchinfom(String username){
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rst = null;
// ProductBean product = new ProductBean();
List<ProductBean> productList=new ArrayList<ProductBean>();
try{
conn = dataSource.getConnection();
pstmt = conn.prepareStatement("SELECT * FROM userproduct WHERE username like ?");
pstmt.setString(1,"%"+username+"%");
rst = pstmt.executeQuery();
while(rst.next()){
ProductBean product=new ProductBean();
product.setUsername(rst.getString("username"));
product.setProduct_id(rst.getString("product_id"));
product.setFaddress(rst.getString("faddress"));
product.setSaddress(rst.getString("saddress"));
product.setWeight(rst.getDouble("weight"));
product.setPrice(rst.getDouble("price"));
productList.add(product);
//return product;
}//else{
//return null;
//}
}catch(SQLException se){
System.out.println("SQLException:"+se.getMessage());
return null;
}finally{
try{
conn.close();
}catch(SQLException se){
}
}
return null;
}
}
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rst = null;
// ProductBean product = new ProductBean();
List<ProductBean> productList=new ArrayList<ProductBean>();
try{
conn = dataSource.getConnection();
pstmt = conn.prepareStatement("SELECT * FROM userproduct WHERE username like ?");
pstmt.setString(1,"%"+username+"%");
rst = pstmt.executeQuery();
while(rst.next()){
ProductBean product=new ProductBean();
product.setUsername(rst.getString("username"));
product.setProduct_id(rst.getString("product_id"));
product.setFaddress(rst.getString("faddress"));
product.setSaddress(rst.getString("saddress"));
product.setWeight(rst.getDouble("weight"));
product.setPrice(rst.getDouble("price"));
productList.add(product);
//return product;
}//else{
//return null;
//}
}catch(SQLException se){
System.out.println("SQLException:"+se.getMessage());
return null;
}finally{
try{
conn.close();
}catch(SQLException se){
}
}
return null;
}
}

public class QueryInformServlet extends HttpServlet{
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
String username = request.getParameter("username");
ProductDao productdao = new ProductDao();
ProductBean product = productdao.searchinfom(username);
ArrayList<ProductBean> productList=null;
productList =new ArrayList<ProductBean>();
//if(!productList.isEmpty()){
request.getSession().setAttribute("productList",productList);
RequestDispatcher view = request.getRequestDispatcher("/displayinform.jsp");
view.forward(request, response);
//}else{
// RequestDispatcher view = request.getRequestDispatcher("/error.jsp");
// view.forward(request, response);
// }
}
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
String username = request.getParameter("username");
ProductDao productdao = new ProductDao();
ProductBean product = productdao.searchinfom(username);
ArrayList<ProductBean> productList=null;
productList =new ArrayList<ProductBean>();
//if(!productList.isEmpty()){
request.getSession().setAttribute("productList",productList);
RequestDispatcher view = request.getRequestDispatcher("/displayinform.jsp");
view.forward(request, response);
//}else{
// RequestDispatcher view = request.getRequestDispatcher("/error.jsp");
// view.forward(request, response);
// }
}
}

<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.util.* ,com.bean.ProductBean"%>
<html>
<body>
<table border=1>
<tr><td>用户名</td><td>商品号</td><td>发货地</td><td>收货地</td><td>重量</td><td>价格</td></tr>
<% ArrayList<ProductBean> productList=(ArrayList<ProductBean>)session.getAttribute("productList");
for(ProductBean product:productList)
{
%>
<tr><td><%= product.getUsername() %></td>
<td><%= product.getProduct_id() %></td>
<td><%= product.getFaddress() %></td>
<td><%= product.getSaddress() %></td>
<td><%= product.getWeight() %></td>
<td><%= product.getPrice() %></td>
</tr>
<%
}
%>
</table>
</body>
</html>
<%@ page import="java.util.* ,com.bean.ProductBean"%>
<html>
<body>
<table border=1>
<tr><td>用户名</td><td>商品号</td><td>发货地</td><td>收货地</td><td>重量</td><td>价格</td></tr>
<% ArrayList<ProductBean> productList=(ArrayList<ProductBean>)session.getAttribute("productList");
for(ProductBean product:productList)
{
%>
<tr><td><%= product.getUsername() %></td>
<td><%= product.getProduct_id() %></td>
<td><%= product.getFaddress() %></td>
<td><%= product.getSaddress() %></td>
<td><%= product.getWeight() %></td>
<td><%= product.getPrice() %></td>
</tr>
<%
}
%>
</table>
</body>
</html>
[ 本帖最后由 霜月逐华 于 2015-6-28 23:19 编辑 ]