这是servlet:
public class OrderListServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException{
List<Order> list = new ArrayList<Order>();
OrderDAO dao=new OrderDAOImpl();
String sql = "select * from order";
response.setContentType("text/html");
try {
list = dao.getorderList(sql);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
request.setAttribute("orderlist", list);
request.getRequestDispatcher("OrderList.jsp").forward(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException{
}
}
function:
public List getorderList(String sql) throws Exception{
List<Order> list = new ArrayList<Order>();
// sql = "select * from order";
//String sql2 = "select * from productinfo";
PreparedStatement pstmt = null ;
DBConnect dbc = null;
java.sql.ResultSet rs=null;
try{
dbc = new DBConnect() ;
pstmt = dbc.getConnection().prepareStatement(sql) ;
rs = pstmt.executeQuery(sql);
while(rs.next()){
String buyername = rs.getString("buyername");
// String productname = rs.getString("productname");
// String productimage = rs.getString("productimage");
// String unitnum = rs.getString("unitnum");
// String unitvalue = rs.getString("unitvalue");
String id = rs.getString("id");
String sum = rs.getString("sum");
Order order = new Order();
order.setId(id);
order.setBuyername(buyername);
// order.setProductname(productname);
// order.setUnitvalue(unitvalue);
// order.setUnitnum(unitnum);
order.setSum(sum);
list.add(order);
}
rs.close();
pstmt.close();
}catch (SQLException e){
System.out.println(e.getMessage());
}finally{
dbc.close() ;
}
return list;
}
jsp:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<% String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %>
<%@ page import="jspservlet.servlet.*"%>
ID | buyer name | sum |
---|---|---|
${order.id } | ${order.buyername } | ${order.sum } |