src/com/action/ruku_servlet.java

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

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

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

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

import com.dao.DB;
import com.orm.Tleixing;
import com.orm.Tshangpin;
import com.service.liuService;

public class ruku_servlet extends HttpServlet
{ 
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
		String type=req.getParameter("type");

		if(type.endsWith("rukuAdd"))
		{
			rukuAdd(req, res);
		}
		if(type.endsWith("shangpinMana"))
		{
			shangpinMana(req, res);
		}
		if(type.endsWith("shangpinList"))
		{
			shangpinList(req, res);
		}
	}
	public void rukuAdd(HttpServletRequest req,HttpServletResponse res)
	{
		int id=Integer.parseInt(req.getParameter("id"));
		int rukushuliang=Integer.parseInt(req.getParameter("rukushuliang"));
		String sql="Update shangpin set spkucun=spkucun+? where spID=?";
		Object[] params={rukushuliang,id};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		req.setAttribute("message", "入库成功");
		req.setAttribute("path", "ruku?type=shangpinMana");
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	public void shangpinMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		List shangpinList=new ArrayList();
		String sql="select a.*,b.leixingming from shangpin a left join leixing b on a.leixingID=b.leixingID order by a.spID";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);