sales_deal.jsp

JSP+oracle开发实例精粹》随书光盘

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

			st.setSalesmount(mount);
			st.setSalesprice(price);
			st.setGoodid(good_id);
			st.setPriority(pr);
			st.setSalesmen(user);
			st.setSalestime((new java.util.Date()).toLocaleString());
			
			if(db.addSales(st) == 1)
			{
			%>
			<script language="javascript">
				alert("操作成功");
				window.close();
				opener.top.mainFrame.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("sales_mount");
		String price = request.getParameter("sales_price");
		String good_id = request.getParameter("good_id");
		
		try
		{
			salesTable st = new salesTable();
			st.setSalesmount(mount);
			st.setSalesprice(price);
			st.setGoodid(good_id);
			st.setId(id);
			if(db.editSales(st) == 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");
		ResultSet rs = null;
		try
		{
			if(db.deleteSales(id) == 1)
			{
			%>
			<script language="javascript">
				alert("操作成功");
				self.location.href="sales_delete_"+"<%=("1".equals(pr) ? "p" : ("2".equals(pr) ? "z" : "j"))%>"+".jsp";
			</script>
			<%
			}
		}
		catch(Exception e)
		{
			%>
			<script language="javascript">
				alert("异常");
					window.close();
			</script>
			<%
		}
	}
%>