src/servlet/ListServlet.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package servlet;

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;

import bean.SelectBean;

public class ListServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public ListServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		SelectBean sb = new SelectBean();
		
		String sql1 = "select * from types";
		String[] args1 = {"id","name"};
		ArrayList al1 = sb.select(sql1, args1);
		request.setAttribute("type", al1);
		
		String sql2 = "select * from supplier";
		String[] args2 = {"id","name","phone","addr","contact"};
		ArrayList al2 = sb.select(sql2, args2);
		request.setAttribute("supplier", al2);
		
		String sql3 = "select * from books";
		String[] args3 = {"id","name","author","publishing","price","storage","brief","types","sums","supplier","imgpath"};
		ArrayList al3 = sb.select(sql3, args3);
		request.setAttribute("book", al3);
		
		String sql4 = "select * from users";
		String[] args4 = {"id","name","sex","age","phone","addr","imgpath"};
		ArrayList al4 = sb.select(sql4, args4);
		request.setAttribute("user", al4);
		
		String sql5 = "select * from sale";
		String[] args5 = {"id","bookid","bookname","price","sums","userid","username"};
		ArrayList al5 = sb.select(sql5, args5);
		request.setAttribute("sale", al5);
		
		String sql6 = "select * from orders";
		String[] args6 = {"id","aggregate","supplierid","suppliername","times","state"};