📄 kmjc_tj.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 language = "java"%>
<%@page import = "java.lang.*"%>
<%@page import = "java.io.*"%>
<%@page import = "java.sql.*"%>
<%@page import = "publib.*"%>
<%@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;
	}

	String flag = "";
	String jgbm = "";
	String km1bm = "";
	String km1ye = "";
	String [] km2bm = null;
	String [] km2ye = null;
	String sqlstr = "";
	String dqgzr = "";
	try
	{
		out.println("<HTML><HEAD><META http-equiv='Content-Style-Type' content='text/css'><TITLE>科目检查</TITLE><LINK rel='stylesheet' href='/resources/Master.css' type='text/css'></HEAD><BODY>");

		dqgzr = (String)request.getParameter("dqgzr");		
		jgbm = (String)request.getParameter("jgbm");
		km1bm = (String)request.getParameter("km1bm");
		km1ye = (String)request.getParameter("km1ye");
		km2bm = (String [])request.getParameterValues("km2bm");
		km2ye = (String [])request.getParameterValues("km2ye");
		DbBean.prepare();
		//根据flag，选择所需修改的数据库表
		sqlstr = "update ZZXXJK set YE = "+km1ye+"  where RQ = '"+dqgzr+"' and JGBM = '"+jgbm+"' and KMBM = '"+km1bm+"'";
		DbBean.insertUpdate(sqlstr);
		for (int i = 0 ; i <= km2bm.length - 1; i++ )
		{
			sqlstr = "update ZZXXJK set YE = "+km2ye[i]+"  where RQ = '"+dqgzr+"' and JGBM = '"+jgbm+"' and KMBM = '"+km2bm[i]+"'";
			DbBean.insertUpdate(sqlstr);
		}
		//修改检查纪录
		sqlstr = "update ZFJCB set ZC = 0,YE = "+km1ye+"  where RQ = '"+dqgzr+"' and JGBM = '"+jgbm+"' and KMBM = '"+km1bm+"'";
		DbBean.insertUpdate(sqlstr);
		DbBean.exeInsert();
		DbBean.clear();
		out.println("<script language= 'javascript'>");
		out.println("window.alert('修改成功');");
		out.println("self.location = 'kmjc_xs.jsp';");
		out.println("</script></BODY></HTML>");

	}
	catch ( Throwable e )
	{
		System.out.println(""+e.getMessage());
		out.println("<script language= 'javascript'>");
		out.println("window.alert('修改失败');");
		out.println("history.back();");
		out.println("</script></BODY></HTML>");

		return;
	}
%>
⌨️ 快捷键说明

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