src/servlet/AddDingdanServlet.java

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

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

package servlet;

import java.io.IOException;
import java.util.ArrayList;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import util.Validate;
import bean.InsertUpdateDelBean;
import bean.SelectBean;

public class AddDingdanServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public AddDingdanServlet() {
		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 {
		Validate vd = new Validate();
		String supplier = vd.getUnicode(request.getParameter("supplier"));
		int i = Integer.parseInt(vd.getUnicode(request.getParameter("i")));
		int n = 0;
		for(int j = 0;j < i;j++){
			String sums = vd.getUnicode(request.getParameter("sums"+j));
			if(sums == null || sums.equals("")){
				n++;
				continue;
			}
		}
		if(n == i){
			request.setAttribute("error", "1");
		}else{
			InsertUpdateDelBean ib = new InsertUpdateDelBean();
			SelectBean sb = new SelectBean();
			String sql1 = "insert into dingdan(supplierid) values('"+supplier+"')";
			String sql2 = "select max(id) as dingdanid from dingdan";
			String args[] = {"dingdanid"};
			ib.insertANDupdateANDdel(sql1);
			ArrayList al = sb.select(sql2, args);
			ArrayList alRow = (ArrayList)al.get(0);
			for(int j = 0;j < i;j++){
				String name = vd.getUnicode(request.getParameter("name"+j));
				String sums = vd.getUnicode(request.getParameter("sums"+j));
				String sql3 = "insert into sandd(dingdanid,shangpinid,sums) values('"+alRow.get(0)+"','"+name+"','"+sums+"')";