📄 yhxx_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.sql.ResultSet rs=null;
java.lang.String sql="";

try
{
	java.lang.String czybm=(( java.lang.String)session.getValue("czydm")).trim();
	java.lang.String rybm=(( java.lang.String)request.getParameter("RYBM")).trim();
	java.lang.String czymm=(( java.lang.String)request.getParameter("CZYMM")).trim();
	java.lang.String strIsCha=(( java.lang.String)request.getParameter("ISOCZYMM")).trim();
	sql="SELECT  DBO.RYZD.RYBM AS RYBM FROM  DBO.RYZD WHERE DBO.RYZD.RYBM='"+rybm+"'";        
	rs=DbBean.sqlQuery(sql);
	out.println("<HTML><HEAD><META http-equiv='Content-Style-Type' content='text/css'>");
		out.println("<TITLE>用户个人信息维护</TITLE>");
		out.println("</HEAD>");
		out.println("<LINK rel='stylesheet' href='/resources/Master.css' type='text/css'>");
	if(true)
	{
	 	czymm=DbBean.convertString(czymm);
	        rs.close();//释放资源
	        rs=null;
	        if(strIsCha.equals("1"))  sql="UPDATE  DBO.CZYZD SET RYBM='"+rybm+"',CZYMM='"+czymm+"' WHERE CZYBM='"+czybm+"'"; 
	        else  sql="UPDATE  DBO.CZYZD SET RYBM='"+rybm+"' WHERE CZYBM='"+czybm+"'"; 
	        DbBean.prepare();
	        DbBean.insertUpdate(sql);                         
	        DbBean.exeInsert();
	        out.println("<BODY onload=\"self.location='yhxx.jsp'\"><br><br><CENTER>保存成功<br><br>");       
	} 
	else
	{
		rs.close();//释放资源
		rs=null;
               out.println("<BODY><br><br><CENTER>您输入的人员编码错误，请检查后再试！<br><br>");
	} 
        out.println("<INPUT TYPE='button' name='test' value='返回' onclick='history.back()'>");
        out.println("</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 + -