?? money_deal.jsp
字號:
<%@ 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>
<%
}
}
%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -