📄 ryzd_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.sql.ResultSet rs=null;						//查询结果集;	
    java.lang.String sql="";
    java.lang.String chaList[];
   
    java.lang.String strRybm="";
    int iRybm=0;
    java.lang.String strJgbm="";
    java.lang.String strRyxm="";
    java.lang.String strRyxb="";
    java.lang.String strNbbm="";				//柜员的内部编码；
    java.lang.String strRybzFirst="";
    java.lang.String strRybz ="";
    
    java.lang.String strRybmList[];
    java.lang.String strJgbmList[];
    java.lang.String strRyxmList[];
    java.lang.String strRyxbList[];
    java.lang.String strRybzFirstList[];
    java.lang.String strNbbmList[];				//柜员的内部编码；
	
    java.lang.String backParameter =((java.lang.String)(request.getParameter("jgbmlist"))).trim();	
    switch(iAct)
    {
		case 2:
			//修改
			strRybmList=request.getParameterValues("ORYBM");  
			strRyxmList=request.getParameterValues("ORYXM");  
			strRyxbList=request.getParameterValues("ORYXB");  
			strRybzFirstList=request.getParameterValues("ORYBZFIRST");  
			strNbbmList= request.getParameterValues("ONBBM");
			strJgbmList= request.getParameterValues("OJGBM");

			DbBean.prepare();
			for(i=0;i<strRybmList.length;i++)
			{
				strRybz = strRybzFirstList[i] + "";
				sql="UPDATE DBO.RYZD SET JGBM = '" + strJgbmList[i] + "', RYXM = '" + strRyxmList[i] + "', XB = '" + strRyxbList[i] + "', NBBM = '" + strNbbmList[i] + "', RYBZ = '" + strRybz + "' WHERE RYBM = '" + strRybmList[i] + "'";
				DbBean.insertUpdate(sql);                        	
			}
			DbBean.exeInsert();                        

			out.println("<br>修改成功！");
			break;
		case 3:
			//增加
			strRyxm =((java.lang.String)(request.getParameter("NRYXM"))).trim();
			strRyxb=((java.lang.String)(request.getParameter("NRYXB"))).trim();
			strRybzFirst=((java.lang.String)(request.getParameter("NRYBZFIRST"))).trim();
			strNbbm=((java.lang.String)(request.getParameter("NNBBM"))).trim();
			strJgbm=backParameter;

                        //启用事务
                        DbBean.prepare();
			//从参数字典中获取人员编码：取，增，存操作，但要注意锁表；
			//-----需要先锁表,最好是锁记录----			
			sql="SELECT CSZ FROM CSZD WITH (ROWLOCK) WHERE CSBM = 'RYBM'";
			rs = DbBean.sqlQuery2(sql);
			if(rs.next())
			{
				strRybm=(rs.getString("CSZ")).trim();
				rs.close();
				rs=null;
				iRybm = Integer.parseInt(strRybm);
				iRybm++;
                                
				//保存到CSZD表里；				
				sql="UPDATE CSZD SET CSZ='" + iRybm + "' WHERE CSBM = 'RYBM'";
				DbBean.insertUpdate(sql);
			}				
			DbBean.exeInsert();				//提交事物，对CSZD解锁;


			strRybz = strRybzFirst + "";
			if(!strRybm.equals("") || !strJgbm.equals(""))
			{
				sql="INSERT INTO DBO.RYZD (RYBM, JGBM, RYXM, XB, NBBM,RYBZ) VALUES ('"+strRybm+"','"+strJgbm+"','"+strRyxm+"','"+strRyxb+"','"+strNbbm+"','"+strRybz+"')";
				DbBean.prepare();
				DbBean.insertUpdate(sql);
				DbBean.exeInsert();
			}
			else
			{
				out.println(DbBean.AlertMsg("新增人员信息数据不完整!"));
		        break;
			}
			
			out.println("<br>增加成功！");
			break;
		case 4:
			//删除
			chaList=request.getParameterValues("DRYBMCHECK");
			DbBean.prepare();
			if(chaList==null)
			{
				out.println(DbBean.AlertMsg("没有选中要删除的人员!"));
		        break;				
			}
			else
			{
				for(i=0;i<chaList.length;i++)
				{                       
					sql="DELETE FROM DBO.RYZD  WHERE RYBM='"+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='ryzd.jsp?isFirst=0&jgbmlist=<%=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 + -