📄 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"%>
<%! ResultSet RS; %>
<%! String sql,Bbbm,Bbmc,Ccbm,Bbls,Czls,Gdls,Bbhs,Scsx,Bbbz,Bbbz1,Bbbz2,err1,err2; %>
<%! int i,j,num,num1,num2; %>
<%
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("bbbm");
Bbmc = request.getParameter("bbmc").trim();
Ccbm = request.getParameter("ccbm");
Bbls = request.getParameter("bbls");
Czls = request.getParameter("czls");
Gdls = request.getParameter("gdls");
Bbhs = request.getParameter("bbhs");
Scsx = request.getParameter("scsx");
Bbbz1 = request.getParameter("bbbz1");
Bbbz2 = request.getParameter("bbbz2");
Bbbz = Bbbz1 + "" + Bbbz2;
out.println("bbbz: " + Bbbz);
try
{
err1 = "";
DbBean.prepare();
sql = "DELETE FROM DBO.BBZD WHERE BBBM='" + Bbbm + "'";
DbBean.insertUpdate(sql);
DbBean.exeInsert();
}
catch( Throwable e)
{
err1 = e.getMessage();
System.gc();
return;
}
try
{
err2 = "";
DbBean.prepare();
sql = "INSERT INTO DBO.BBZD VALUES('" + Bbbm + "','" + Bbmc + "','" + Ccbm + "'," + Bbls + "," + Czls + "," + Gdls + "," + Bbhs + "," + Scsx + ",'" + Bbbz + "')";
DbBean.insertUpdate(sql);
DbBean.exeInsert();
}
catch( Throwable e)
{
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">
<title>1</title>
</HEAD>
<BODY onload="WriteIn()">
<form name="form1">
<script language=JavaScript>
function WriteIn()
{
<%
if ( !err1.equals("") )
{
out.println(" opener.ShowResult('error','" + err1 + "');");
}
else
{
if ( !err2.equals("") )
{
out.println(" opener.ShowResult('error','" + err2 + "');");
}
else
{
out.println(" opener.ShowResult('ok','ok');");
}
}
%>
window.close();
}
</script>
</form>
</body>
</html>
<%
System.gc();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -