📄 insert.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<%! String sql,err1,err2,Bbbm,JsGs,JsJb,JsBz,bbbz; %>
<%! int i,j,MaxHc,MaxLc; %>
<%
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<%
Bbbm = request.getParameter("T_bbbm");
bbbz = request.getParameter("T_bbbz");
MaxHc = Integer.parseInt(request.getParameter("MaxHc"));
MaxLc = Integer.parseInt(request.getParameter("MaxLc"));
err1 = "";
try
{
DbBean.prepare();
sql = "DELETE FROM DBO.BBGSDY WHERE BBBM='" + Bbbm + "'";
DbBean.insertUpdate(sql);
DbBean.exeInsert();
}
catch( Throwable e)
{
err1 = e.getMessage();
return;
}
err2 = "";
try
{
DbBean.prepare();
JsBz = "0";
if ( bbbz.equals("0") )
{
for (j=1;j<=MaxLc;j++)
{
JsGs = request.getParameter("H0L"+j);
JsJb = request.getParameter("J0B"+j);
JsBz = request.getParameter("B0Z"+j);
if ( !JsGs.equals("") )
{
sql = "INSERT INTO DBO.BBGSDY VALUES('" + Bbbm + "'," + i + "," + j + ",'" + JsGs + "','" + JsJb + "','" + JsBz + "')";
DbBean.insertUpdate(sql);
}
}
}
if ( bbbz.equals("1") )
{
for (i=1;i<=MaxHc;i++)
{
for (j=1;j<=MaxLc;j++)
{
JsGs = request.getParameter("H"+i+"L"+j);
JsJb = request.getParameter("J"+i+"B"+j);
JsBz = request.getParameter("B"+i+"Z"+j);
if ( !JsGs.equals("") )
{
sql = "INSERT INTO DBO.BBGSDY VALUES('" + Bbbm + "'," + i + "," + j + ",'" + JsGs + "','" + JsJb + "','" + JsBz + "')";
DbBean.insertUpdate(sql);
}
}
}
}
if ( bbbz.equals("2") )
{
for (i=0;i<=MaxHc;i++)
{
for (j=1;j<=MaxLc;j++)
{
JsGs = request.getParameter("H"+i+"L"+j);
JsJb = request.getParameter("J"+i+"B"+j);
JsBz = request.getParameter("B"+i+"Z"+j);
if ( !JsGs.equals("") )
{
sql = "INSERT INTO DBO.BBGSDY VALUES('" + Bbbm + "'," + i + "," + j + ",'" + JsGs + "','" + JsJb + "','" + JsBz + "')";
DbBean.insertUpdate(sql);
}
}
}
}
DbBean.exeInsert();
System.gc();
}
catch( Throwable e)
{
DbBean.clear();
err2 = err2 + e.getMessage();
System.gc();
return;
}
%>
<META http-equiv="Content-Language" content="zh-cn">
<META http-equiv="Content-Type" content="text/html; charset=gb2312">
<META http-equiv="Content-Style-Type" content="text/css">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<title>1</title>
</HEAD>
<BODY onload="ShowData()">
<form name="form1">
<script language=JavaScript>
function ShowData()
{
<%
if ( !err2.equals("") )
{
out.println(" alert('操作失败！系统错误信息：" + err2 + "');");
}
else
{
out.println(" alert('操作成功！');");
}
%>
}
</script>
</form>
</body>
</html>
<%
System.gc();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -