?? bbfbdz_save.jsp
字號:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<%@page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<%
if((session.getValueNames()).length==0)
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/sysmang/loginagain.html';");
out.println("</SCRIPT>");
return;
}
java.lang.String act=((java.lang.String)request.getParameter("ACT")).trim();
int iAct=Integer.parseInt(act);
/******************************************************
*操作參數(ACT)說明：
* 2:修改
* 3:增加
* 4:刪除
******************************************************/
try
{
int i=0;
java.lang.String sql="";
java.lang.String chaList[];
java.lang.String strBbbm=""; //報表編碼
java.lang.String strBz=""; //報表備注
java.lang.String strWldz=""; //網絡發布地址
java.lang.String strBbbmList[];
java.lang.String strWldzList[];
java.lang.String strBzList[];
switch(iAct)
{
case 2:
//修改
strBbbmList=request.getParameterValues("OBBBM");
strBzList=request.getParameterValues("OBZ"); //報表名稱說明
strWldzList=request.getParameterValues("OWLDZ");
DbBean.prepare();
for(i=0;i<strBbbmList.length;i++)
{
sql="UPDATE DBO.BBFBZD SET WLDZ='" + strWldzList[i] + "', BZ = '" + strBzList[i] + "' WHERE BBBM = '" + strBbbmList[i] + "'";
DbBean.insertUpdate(sql);
}
DbBean.exeInsert();
out.println("<br>修改成功！");
break;
case 3:
//增加
strBbbm=((java.lang.String)(request.getParameter("NBBBM"))).trim();
strWldz=((java.lang.String)(request.getParameter("NWLDZ"))).trim();
strBz=((java.lang.String)(request.getParameter("NBZ"))).trim();
if(!strBbbm.equals("") || !strWldz.equals(""))
{
sql="INSERT INTO DBO.BBFBZD (BBBM, WLDZ, BZ) VALUES ('"+strBbbm+"','"+strWldz+"','"+strBz+"')";
DbBean.prepare();
DbBean.insertUpdate(sql);
DbBean.exeInsert();
}
else
{
out.println("新增報表發布地址的數據不完整!");
return;
}
out.println("<br>增加成功！");
break;
case 4:
//刪除
chaList=request.getParameterValues("DBBBMCHECK");
DbBean.prepare();
if(chaList==null)
{
out.println("沒有選中要刪除的報表地址!");
return;
}
else
{
for(i=0;i<chaList.length;i++)
{
sql="DELETE FROM DBO.BBFBZD WHERE BBBM='"+chaList[i]+"'";
DbBean.insertUpdate(sql);
}
}
DbBean.exeInsert();
out.println("<br>刪除成功！");
break;
default:
java.sql.SQLException exception = new java.sql.SQLException("參數傳遞錯誤！");
throw exception;
}
%>
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<TITLE>
用戶組權限維護保存
</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
</HEAD>
<BODY onLoad="self.location='bbfbdz.jsp?isFirst=0'">
<!--BODY-->
<br><br>
<CENTER>
<INPUT TYPE="button" name="test" value="返回" onclick="history.back()">
</CENTER>
</BODY>
</HTML>
<%
System.gc();
} catch( Throwable e)
{
DbBean.clear();
if(((e.getMessage())).equals("ResultSet is closed"))
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/blank.html';");
out.println("</SCRIPT>");
}
else if(e.getMessage()==null)
{
out.println("服務已經重啟，您閑置的時間太長或系統調用錯誤，請重新登入試一下！<br>如果再出現這種情況請與系統維護員聯系！");
}
else out.println(e.getMessage());
System.gc();
return;
}
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -