money_deal.jsp

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

<%@ page contentType="text/html; charset=gb2312" import="java.sql.*,qyxx.*"%>
<jsp:useBean id="db" class="qyxx.moneyDB" />
<%
	String action = request.getParameter("action");
	if("add".equals(action))
	{
		String mount = request.getParameter("mount");
		String departid = request.getParameter("departid");
		String jiedai = request.getParameter("jiedai");
		String user = (String)session.getAttribute("username");
		String pr = (String)session.getAttribute("priority");
		try
		{
			moneyTable mt = new moneyTable();
			mt.setMount(mount);
			mt.setDepartid(departid);
			mt.setJiedai(jiedai);
			mt.setMoneyman(user);
			mt.setMoneypriority(pr);
			mt.setMoneytime((new java.util.Date()).toLocaleString());
			if(db.addMoney(mt) == 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 mount = request.getParameter("mount");
		String departid = request.getParameter("departid");
		String jiedai = request.getParameter("jiedai");
		String id = request.getParameter("id");
		String pr = (String)session.getAttribute("priority");
		try
		{
			moneyTable mt = new moneyTable();
			mt.setId(id);
			mt.setMount(mount);
			mt.setDepartid(departid);
			mt.setJiedai(jiedai);
			if(db.editMoney(mt) == 1)
			{
			%>
			<script language="javascript">
				alert("操作成功");
				window.close();
				opener.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.deleteMoney(id)  == 1)
			{
			%>
			<script language="javascript">
				alert("操作成功");
				self.location.href="money_delete_"+"<%=("1".equals(pr) ? "p" : ("2".equals(pr) ? "z" : "j"))%>"+".jsp";
			</script>
			<%
			}
		}
		catch(Exception e)
		{
			%>
			<script language="javascript">
				alert("异常");
					window.close();
			</script>
			<%
		}
	}
%>