insertinshopping.java

是一个企业的进销存系统。账号问1001密码为123456

package com.jxc.servlet.inshopping;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

import com.jxc.dao.Conn;
import com.jxc.dao.InShoppingTreat;
import com.jxc.dao.StockShoppingTreat;
import com.jxc.vo.InShopping;
import com.jxc.vo.StockShopping;

import java.sql.*;

public class InsertInShopping extends HttpServlet
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws IOException, ServletException
	{
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		response.setContentType("text/html");
		Connection cnn1 = Conn.getConnection();
		Connection cnn2 = Conn.getConnection();
		Connection cnn3 = Conn.getConnection();
		Connection cnn4 = Conn.getConnection();
		Connection cnn5 = Conn.getConnection();
		String sid = request.getParameter("sid");
		java.util.Date d=new java.util.Date();
		HttpSession session=request.getSession();
		int intprince=0;
		int innum=0;
		java.sql.Date intime=null;
		if("".equals(request.getParameter("intprince"))||"".equals(request.getParameter("intprince"))||"".equals(sid)){
			session.setAttribute("erro", "null");
			response.sendRedirect("inshopping_add.jsp");
		}else{
		
		try {
			try {
				intprince = Integer.parseInt(request.getParameter("intprince"));
				innum = Integer.parseInt(request.getParameter("innum"));
			} catch (RuntimeException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			intime = new java.sql.Date(d.getYear(),d.getMonth(),d.getDate());
		} catch (NumberFormatException e) {
			
			e.printStackTrace();
		}
		String yid = (String) session.getAttribute("yid");
		InShopping ins = new InShopping();
		ins.setSid(sid);
		ins.setIntprince(intprince);
		ins.setInnum(innum);
		ins.setIntime(intime);
		ins.setYid(yid);
		if(new StockShoppingTreat().selectId(cnn1, sid)){
			if(new StockShoppingTreat().updateById(cnn2, sid, innum)&&new InShoppingTreat().insert(cnn3, ins)){
				session.setAttribute("erro", "succ");
				response.sendRedirect("inshopping_add.jsp");
			}else{
				session.setAttribute("erro", "false");
				response.sendRedirect("inshopping_add.jsp");
			}
		}else{
			StockShopping st=new StockShopping();
			st.setSid(sid);
			st.setSnum(innum);
			if(new StockShoppingTreat().insert(cnn4, st)&&new InShoppingTreat().insert(cnn5, ins)){
				session.setAttribute("erro", "succ");
				response.sendRedirect("inshopping_add.jsp");
			}else{
				session.setAttribute("erro", "false");
				response.sendRedirect("inshopping_add.jsp");
			}
			
		}
		}
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws IOException, ServletException
	{
		doPost(request, response);
	}
}