📄 o_khzhdy_save.jsp

📁 管理会计系统主要功能在主页面左侧的菜单面中
💻 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>

<%
java.lang.String act=((java.lang.String)request.getParameter("ACT")).trim();
int iAct=Integer.parseInt(act);
/******************************************************
*操作参数(ACT)说明：
* 2:修改
* 3:增加
* 4:删除
******************************************************/
try
{
    int i=0;
	int iorder=0;
	boolean bret;
    java.lang.String sql="";
	java.sql.ResultSet rs=null;						//查询结果集;	

    java.lang.String chaList[];   
    java.lang.String strKhbm="";
    java.lang.String strJgbm="";
	java.lang.String strZh="";
	java.lang.String strZhbzFirst="";
	java.lang.String strZhbz="";
	java.lang.String strZhsm="";
	
	java.lang.String strKhbmList[];
	java.lang.String strJgbmList[];
	java.lang.String strHiddenJgbmList[];
	java.lang.String strZhList[];
	java.lang.String strHiddenZhList[];
	java.lang.String strZhbzFirstList[];
	java.lang.String strZhsmList[];
	
    java.lang.String selectedJgbm =((java.lang.String)(request.getParameter("jgbmlist"))).trim();	
    java.lang.String selectedRybm =((java.lang.String)(request.getParameter("rybmlist"))).trim();	
	//java.lang.String backUrl="";
	switch(iAct)
	{
		case 2:
			//修改
			chaList=request.getParameterValues("UKHBMCHECK");  
			strKhbmList=request.getParameterValues("UKHBM");  
			strJgbmList=request.getParameterValues("UJGBM");  
			strHiddenJgbmList=request.getParameterValues("UHIDDENJGBM");  
			strZhList=request.getParameterValues("UZH");  
			strHiddenZhList=request.getParameterValues("UHIDDENZH");  
			strZhbzFirstList=request.getParameterValues("UZHLB");  
			strZhsmList=request.getParameterValues("UZHSM");  

			if(chaList == null)
			{
				out.println(DbBean.AlertMsg("没有选中修改的记录!"));
				break;
			}
			else
			{
				DbBean.prepare();
				for(i=0;i<chaList.length;i++)
				{                
					iorder = Integer.parseInt(chaList[i]);
					strZhbz = strZhbzFirstList[iorder];

					sql="UPDATE KHZHDZB SET JGBM = '" + strJgbmList[iorder] + "', ZH = '" + strZhList[iorder] + "', ZHBZ = '" + strZhbz + "', ZHSM = '" + strZhsmList[iorder] + "' WHERE JGBM = '" + strHiddenJgbmList[iorder] + "' AND KHBM = '" + strKhbmList[iorder] + "' AND ZH = '" + strHiddenZhList[iorder] + "'";
					DbBean.insertUpdate(sql);
				}
				DbBean.exeInsert();
			}
			out.println("<br>修改成功！");
			break;
		case 3:
			//增加
			strKhbm =((java.lang.String)(request.getParameter("NKHBM"))).trim();
			strJgbm =((java.lang.String)(request.getParameter("NJGBM"))).trim();
			strZh=((java.lang.String)(request.getParameter("NZH"))).trim();
			strZhbz=((java.lang.String)(request.getParameter("NZHLB"))).trim();
			strZhsm=((java.lang.String)(request.getParameter("NZHSM"))).trim();

			if(strZh.equals(""))
			{
				out.println(DbBean.AlertMsg("新增客户帐号的信息数据不完整!"));
				break;
			}
			else if(strKhbm.equals("请选择"))
			{
				out.println(DbBean.AlertMsg("没有选择该客户经理的管辖客户!"));
				break;
			}
			else if(strJgbm.length() < 9)
			{
				out.println(DbBean.AlertMsg("客户帐号的机构输入不正确!"));
				break;
			}
			else
			{
				//增加客户帐号信息记录
				DbBean.prepare();
				sql="INSERT INTO DBO.KHZHDZB (JGBM, KHBM, ZH, ZHBZ, ZHSM) VALUES ('" + strJgbm  + "', '" + strKhbm + "', '" + strZh + "', '" + strZhbz + "', '" + strZhsm + "')";
				DbBean.insertUpdate(sql);
				DbBean.exeInsert();
			}
			out.println("<br>增加成功！");
			break;
		case 4:
			//删除
			chaList=request.getParameterValues("DKHBMCHECK");
			strKhbmList=request.getParameterValues("DKHBM");
			strJgbmList=request.getParameterValues("DJGBM");
			strZhList=request.getParameterValues("DZH");
			DbBean.prepare();
			if(chaList==null)
			{
				out.println(DbBean.AlertMsg("没有选中要删除的客户帐号!"));
		        break;				
			}
			else
			{
				for(i=0;i<chaList.length;i++)
				{          
					iorder = Integer.parseInt(chaList[i]);
					sql="DELETE FROM DBO.KHZHDZB WHERE JGBM = '" + strJgbmList[iorder] + "' AND KHBM ='" + strKhbmList[iorder] + "' AND ZH = '" + strZhList[iorder] + "'";
					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='khzhdy.jsp?isFirst=2&jgbmlist=<%=selectedJgbm%>&rybmlist=<%=selectedRybm%>'">
<!--BODY onLoad="self.location='khxxzd.jsp?isFirst=0&jgbmlist=<%=selectedJgbm%>&rybmlist=<%=selectedRybm%>'"-->
<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("window.alert('"+e.getMessage()+(request.getHeader("referer")).trim()+"');"); 
	 		//out.println("self.location='/refresh.jsp'"); 
	 		out.println("self.location='/blank.html';");
	 		out.println("</SCRIPT>");
      		 }
      		 else if(e.getMessage()==null)
      		 {
	                //out.println("<SCRIPT language='JavaScript'>");
	 		//out.println("window.alert('服务已经重启，您闲置的时间太长或系统调用错误，请重新登入试一下！如果再出现请与系统维护员联系！');"); 
	 		//out.println("</SCRIPT>");
	 		out.println("服务已经重启，您闲置的时间太长或系统调用错误，请重新登入试一下！<br>如果再出现这种情况请与系统维护员联系！"); 
      		 }
      		 else out.println(e.getMessage());
      		 System.gc();
       		 return;
          }

%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -