📄 bblrlxdy_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 strLrsx="";
java.lang.String strXh="";
java.lang.String strLrbm="";
java.lang.String strLrmc="";
java.lang.String strCd="";
java.lang.String strLrbz="";
java.lang.String strLrsxList[];
java.lang.String strSLrsxList[];
java.lang.String strXhList[];
java.lang.String strLrbmList[];
java.lang.String strLrmcList[];
java.lang.String strCdList[];
java.lang.String strLrbzList[];
java.lang.String backParameter =((java.lang.String)(request.getParameter("bbbmlist"))).trim();
java.lang.String backUrl="";
switch(iAct)
{
case 2:
//修改
strLrsxList=request.getParameterValues("OLRSX");
strSLrsxList=request.getParameterValues("OSLRSX");
strXhList=request.getParameterValues("OXH");
strLrbmList=request.getParameterValues("OLRBM");
strLrmcList=request.getParameterValues("OLRMC");
strCdList=request.getParameterValues("OCD");
strLrbzList=request.getParameterValues("OLRBZ");;
DbBean.prepare();
for(i=0;i<strLrsxList.length;i++)
{
sql="UPDATE DBO.BBLRLXDY SET LRSX =" + strLrsxList[i]+", XH = " + strXhList[i] + ", LRBM= '" + strLrbmList[i] + "', LRMC ='" + strLrmcList[i] + "', CD=" + strCdList[i] + ", LRBZ ='" + strLrbzList[i] + "' WHERE BBBM = '" + backParameter + "' AND LRSX =" + strSLrsxList[i];
DbBean.insertUpdate(sql);
}
DbBean.exeInsert();
out.println("<br>修改成功！");
break;
case 3:
//增加
strLrsx=((java.lang.String)(request.getParameter("NLRSX"))).trim();
strXh=((java.lang.String)(request.getParameter("NXH"))).trim();
strLrbm=((java.lang.String)(request.getParameter("NLRBM"))).trim();
strLrmc=((java.lang.String)(request.getParameter("NLRMC"))).trim();
strCd=((java.lang.String)(request.getParameter("NCD"))).trim();
strLrbz=((java.lang.String)(request.getParameter("NLRBZ"))).trim();
if(!strLrsx.equals(""))
{
if(strXh.equals("")) strXh="0";
if(strCd.equals("")) strCd="0";
sql="INSERT INTO DBO.BBLRLXDY (BBBM, LRSX, XH, LRBM, LRMC, CD, LRBZ) VALUES ('"+backParameter+"',"+strLrsx+","+strXh+",'"+strLrbm+"','"+strLrmc+"',"+strCd+",'"+strLrbz+"')";
DbBean.prepare();
DbBean.insertUpdate(sql);
DbBean.exeInsert();
}
out.println("<br>增加成功！");
break;
case 4:
//删除
chaList=request.getParameterValues("DLRSXCHECK");
DbBean.prepare();
if(chaList==null) { ;}
else
{
for(i=0;i<chaList.length;i++)
{
sql="DELETE FROM DBO.BBLRLXDY WHERE BBBM='"+backParameter+"' AND LRSX="+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='bblrlxdy.jsp?isFirst=0&bbbmlist=<%=backParameter%>'">
<!--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 + -