📄 czysz_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>
<%
 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 strCzybm="";
	java.lang.String strJgbm ="";
	java.lang.String strCzyxm="";
	java.lang.String strYhzbm="";
	java.lang.String strCzymm="";
	java.lang.String strRybm ="";
	java.lang.String strCzyzt="";
	
        java.lang.String strCzybmList[];
	java.lang.String strJgbmList[];
	java.lang.String strCzyxmList[];
	java.lang.String strYhzbmList[];
	java.lang.String strCzymmList[];
	java.lang.String strIsChaList[];
	java.lang.String strRybmList[];
	
        java.lang.String backParameter =((java.lang.String)(request.getParameter("jgbmlist"))).trim();	
	java.lang.String backUrl="";
	switch(iAct)
	{
		case 2:
			//修改
			strCzybmList=request.getParameterValues("OCZYBM");  
			strJgbmList= request.getParameterValues("OJGBM");
			strCzyxmList=request.getParameterValues("OCZYXM");  
			strYhzbmList=request.getParameterValues("OYHZBM");  
			strCzymmList=request.getParameterValues("OCZYMM");
			strIsChaList=request.getParameterValues("ISOCZYMM");			  
			strRybmList= request.getParameterValues("ORYBM");  

			DbBean.prepare();
			for(i=0;i<strCzybmList.length;i++)
			{ 
			        if(strIsChaList[i].equals("1"))
			        {                     
					strCzymmList[i]=DbBean.convertString(strCzymmList[i]);                                	
					sql="UPDATE CZYZD SET JGBM ='" + strJgbmList[i]+"', CZYXM = '" + strCzyxmList[i] + "', YHZBM= '" + strYhzbmList[i] + "', CZYMM = '" + strCzymmList[i] + "', RYBM ='" + strRybmList[i] + "', CZYZT = '' WHERE JGBM = '" + backParameter + "' AND CZYBM = '" + strCzybmList[i] + "'";
				}
				else
			        {
				sql="UPDATE CZYZD SET JGBM ='" + strJgbmList[i]+"', CZYXM = '" + strCzyxmList[i] + "', YHZBM= '" + strYhzbmList[i] + "', RYBM ='" + strRybmList[i] + "', CZYZT = '' WHERE JGBM = '" + backParameter + "' AND CZYBM = '" + strCzybmList[i] + "'";
				}
				DbBean.insertUpdate(sql);
			 }
			 			 
			DbBean.exeInsert();                       
			out.println("<br>修改成功！");
			break;

		case 3:
			//增加
			strCzybm=((java.lang.String)(request.getParameter("NCZYBM"))).trim();
			strJgbm =((java.lang.String)(request.getParameter("jgbmlist"))).trim();
			strCzyxm=((java.lang.String)(request.getParameter("NCZYXM"))).trim();
			strYhzbm=((java.lang.String)(request.getParameter("NYHZBM"))).trim();
			strCzymm=((java.lang.String)(request.getParameter("NCZYMM"))).trim();
			
			strRybm =((java.lang.String)(request.getParameter("NRYBM"))).trim();
                        if(!strCzybm.equals(""))
                        {
				strCzymm=DbBean.convertString(strCzymm);
                        	sql="INSERT INTO DBO.CZYZD (CZYBM,JGBM,CZYXM,YHZBM,CZYMM,RYBM,CZYZT) VALUES ('"+strCzybm+"','"+strJgbm+"','"+strCzyxm+"','"+strYhzbm+"','"+strCzymm+"','"+strRybm+"','"+strCzyzt+"')";
                        	DbBean.prepare();
                        	DbBean.insertUpdate(sql);
                        	DbBean.exeInsert();
                        }
                        
			out.println("<br>增加成功！");
			break;
		case 4:
			//删除
			chaList=request.getParameterValues("DCZYBMCHECK");
			
                        DbBean.prepare();
                        if(chaList==null) { ;}
                        else
                        {
                        	for(i=0;i<chaList.length;i++)
                        	{                       
                        		sql="DELETE FROM DBO.CZYZD  WHERE CZYBM='"+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='czysz.jsp?isFirst=0&jgbmlist=<%=backParameter%>'">
<!--BODY-->
<br><br>
<CENTER>
<INPUT TYPE="button" name="test" value="返回" onclick="history.back()">
</CENTER>
</BODY>
</HTML>
<%
}
 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());
       		 return;
 }
     finally
     {
     	System.gc();
     }
%>
⌨️ 快捷键说明

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