produce_deal.jsp

来自「JSP+oracle开发实例精粹》随书光盘」· JSP 代码 · 共 106 行

<%@ page contentType="text/html; charset=gb2312" import="java.sql.*,qyxx.*"%>
<jsp:useBean id="db" class="qyxx.produceDB" />
<%
	String action = request.getParameter("action");
	if("add".equals(action))
	{
		String mount = request.getParameter("produce_mount");
		String good_id = request.getParameter("good_id");
		String user = (String)session.getAttribute("username");
		String pr = (String)session.getAttribute("priority");
		try
		{
			produceTable pt = new produceTable();

			pt.setGoodid(good_id);
			pt.setProducemount(mount);
			pt.setProduceman(user);
			pt.setPriority(pr);
			pt.setProducetime((new java.util.Date()).toLocaleString());
			
			if(db.addProduce(pt) == 1)
			{
			%>
			<script language="javascript">
				alert("操作成功");
				window.close();
				opener.top.location.reload();
			</script>
			<%
			}
		}
		catch(Exception e)
		{
			%>
			<script language="javascript">
				alert("异常");
				window.close();
			</script>
			<%
		}
	}

	if("update".equals(action))
	{
		String id = request.getParameter("id");
		String mount = request.getParameter("mount");
		String produce_mount = request.getParameter("produce_mount");
		String good_id = request.getParameter("good_id");
		try
		{
			produceTable pt = new produceTable();

			pt.setGoodid(good_id);
			pt.setProducemount(produce_mount);
			pt.setId(id);
			
			if(db.editProduce(pt) == 1)
			{
			%>
			<script language="javascript">
				alert("操作成功");
				window.close();
				opener.top.mainFrame.location.reload();
			</script>
			<%
			}
		}
		catch(Exception e)
		{
			%>
			<script language="javascript">
				alert("异常");
				window.close();
			</script>
			<%
		}
	}


	if("delete".equals(action))
	{
		String [] id = request.getParameterValues("id");	
		String pr = (String)session.getAttribute("priority");
		try
		{
			if(db.deleteProduce(id) == 1)
			{
			%>
			<script language="javascript">
				alert("操作成功");
				self.location.href="produce_delete_"+"<%=("1".equals(pr) ? "p" : ("2".equals(pr) ? "z" : "j"))%>"+".jsp";
			</script>
			<%
			}
		}
		catch(Exception e)
		{
			%>
			<script language="javascript">
				alert("异常");
					window.close();
			</script>
			<%
		}
	}
%>