JSP_042网上书店售书系统

/* */ package servlet; /* */ /* */ import bean.SelectBean; /* */ import java.io.IOException; /* */ import java.util.ArrayList; /* */ import javax.servlet.ServletException; /* */ import javax.servlet.http.HttpServlet; /* */ import javax.servlet.http.HttpServletRequest; /* */ import javax.servlet.http.HttpServletResponse; /* */ /* */ public class ListServlet extends HttpServlet /* */ { /* */ public void destroy() /* */ { /* 27 */ super.destroy(); /* */ } /* */ /* */ public void doGet(HttpServletRequest request, HttpServletResponse response) /* */ throws ServletException, IOException /* */ { /* 34 */ SelectBean ib = new SelectBean(); /* */ /* 36 */ String sql1 = "select * from types"; /* 37 */ String[] args1 = { "id", "name" }; /* 38 */ ArrayList al1 = ib.select(sql1, args1); /* 39 */ request.setAttribute("type", al1); /* */ /* 41 */ String sql2 = "select * from books"; /* 42 */ String[] args2 = { "id", "name", "author", "publishing", "number", "price", "storage", "brief", "type", "tate", "sums", "imgpath" }; /* 43 */ ArrayList al2 = ib.select(sql2, args2); /* 44 */ request.setAttribute("books", al2); /* */ /* 46 */ String sql3 = "select * from paihang order by times desc"; /* 47 */ String[] args3 = { "bookid", "name" }; /* 48 */ ArrayList al3 = ib.select(sql3, args3); /* 49 */ request.setAttribute("xiaosou", al3); /* */ /* 51 */ String sql4 = "select * from tates"; /* 52 */ String[] args4 = { "id", "name" }; /* 53 */ ArrayList al4 = ib.select(sql4, args4); /* 54 */ request.setAttribute("tate", al4); /* */ /* 56 */ String sql5 = "select * from books where tate=1"; /* 57 */ String[] args5 = { "id", "name", "author", "publishing", "number", "price", "storage", "brief", "type", "tate", "sums", "imgpath" }; /* 58 */ ArrayList al5 = ib.select(sql5, args5); /* 59 */ request.setAttribute("tuibook", al5); /* */ /* 61 */ String sql6 = "select * from books where tate=2"; /* 62 */ String[] args6 = { "id", "name", "author", "publishing", "number", "price", "storage", "brief", "type", "tate", "sums", "imgpath" }; /* 63 */ ArrayList al6 = ib.select(sql6, args6); /* 64 */ request.setAttribute("newbook", al6); /* */ /* 66 */ String sql7 = "select * from users"; /* 67 */ String[] args7 = { "id", "name", "pwd", "realname", "sex", "age", "card", "address", "phone", "email", "code" }; /* 68 */ ArrayList al7 = ib.select(sql7, args7); /* 69 */ request.setAttribute("users", al7); /* */ } /* */ /* */ public void doPost(HttpServletRequest request, HttpServletResponse response) /* */ throws ServletException, IOException /* */ { /* 75 */ doGet(request, response); /* */ } /* */ /* */ public void init() /* */ throws ServletException /* */ { /* */ } /* */ }