src/servlet/ReagentReworkServlet.java

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

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

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
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 ReagentReworkServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public ReagentReworkServlet() {
		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 id = vd.getUnicode(request.getParameter("id"));
		String name = vd.getUnicode(request.getParameter("name"));
		String property = vd.getUnicode(request.getParameter("property"));
		String spec = vd.getUnicode(request.getParameter("spec"));
		String yieldly = vd.getUnicode(request.getParameter("yieldly"));
		String storage = vd.getUnicode(request.getParameter("storage"));
		String price = vd.getUnicode(request.getParameter("price"));
		String validity = vd.getUnicode(request.getParameter("validity"));
		String smalltype = vd.getUnicode(request.getParameter("smalltype"));
		
		InsertUpdateDelBean ib = new InsertUpdateDelBean();
		String sql = "update reagent set name='"+name+"',property='"+property+"',spec='"+spec+"',yieldly='"+yieldly+"',storage="+storage+",price='"+price+"',validity='"+validity+"',smalltype='"+smalltype+"' where id="+id;
		int flag = ib.insertANDupdateANDdel(sql);
		if(flag == -1){
			request.setAttribute("error", "1");
		}else{
			request.setAttribute("ok", "1");
		}
		
		SelectBean sb = new SelectBean();
		String sql1 = "select * from reagent where id="+id;
		String[] args = {"id","name","property","spec","yieldly","storage","price","validity","smalltype"};
		ArrayList al = sb.select(args, sql1);
		request.setAttribute("reagents", al);