📄 kmjc_tjbj.jsp
字号:
<!--科目检查：提交用户修改，修改BJZZXXJK-->
<!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 jgbm = "";
String km1bm = "";
String km1jye = "";
String km1dye = "";
String [] km2bm = null;
String [] km2jye = null;
String [] km2dye = 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");
km1jye = (String)request.getParameter("km1jye");
km1dye = (String)request.getParameter("km1dye");
km2bm = (String [])request.getParameterValues("km2bm");
km2jye = (String [])request.getParameterValues("km2jye");
km2dye = (String [])request.getParameterValues("km2dye");
DbBean.prepare();
//根据flag，选择所需修改的数据库表
sqlstr = "update BJZZXXJK set QMJ = "+km1jye+" ,QMD = "+km1dye+" where RQ = '"+dqgzr+"' and JGBM = '"+jgbm+"' and KMBM = '"+km1bm+"'";
DbBean.insertUpdate(sqlstr);
for (int i = 0 ; i <= km2bm.length - 1; i++ )
{
sqlstr = "update BJZZXXJK set QMJ = "+km2jye[i]+" ,QMD ="+km2dye[i]+" where RQ = '"+dqgzr+"' and JGBM = '"+jgbm+"' and KMBM = '"+km2bm[i]+"'";
DbBean.insertUpdate(sqlstr);
}
//修改检查纪录
sqlstr = "update ZFJCB set ZC = 0 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 + -