initialise_qt.jsp

来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 63 行

JSP

63 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>初始化</title>
<style>
<!--
a {text-decoration: none}
.f1          { font-size: 9pt; font-family: Verdana; line-height: 15pt }
.f2          { font-size: 8pt; font-family: Verdana; line-height: 12pt }
body {
	background-image: url(../img/mainbg.gif);
}
input.noborInput{background:#ffffff; border-bottom-width:0px;border-top-width:0px;border-left-width:0px;border-right-width:0px; solid #ff6633; COLOR: #3300FF; FONT-SIZE: 10pt}
input.smallInput{BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid}
input.buttonface{BACKGROUND: #CCCCFF; border:1 solid #CC33FF; COLOR: #CC00FF; FONT-SIZE: 9pt; FONT-STYLE: normal; FONT-VARIANT: normal; FONT-WEIGHT: normal; HEIGHT: 18px; LINE-HEIGHT: normal}
-->
</style>
</head>
<body>
<p>
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<% 
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
if(page_type==null){page_type="";}
if(session.isNew()){response.sendRedirect("../index.jsp");}
else
{	if(!(page_type.equals("super")) && !page_type.equals("sgz"))
	{response.sendRedirect("../index.jsp");}	
} 
%>
<% /*Calendar calendar=Calendar.getInstance();
  int year=calendar.get(Calendar.YEAR);
  int month=calendar.get(Calendar.MONTH)+1;
  String y=String.valueOf(year);
  String m=String.valueOf(month);
  String name="B"+y.concat(m);
  String condition="create table "+name+" as select * from BGZDH.BZGZ";*/
ResultSet rs=null;
String dayy=null;
String condition="select to_char(sysdate,'yyyymm') nyr from dual";
rs=conn.executeQuery(condition);
while(rs.next())
{dayy=rs.getString("nyr");}
String name="B"+dayy;
condition="create table "+name+" as select * from BGZDH.BZGZ";
out.print(condition);
 conn.executeQuery(condition);
  out.print("当月表备份中...<br>");
 conn.executeQuery("DELETE FROM BGZDH.BZGZ");
 out.print("当月表初始化中...");
 conn.executeQuery("Insert into BGZDH.BZGZ select * from BGZDH.BZK");
  
  //out.print("<SCRIPT language=JavaScript>alert('初始化成功！');");
  //out.print("javascript:history.go(-1)</SCRIPT>");
 %>
</p>
<p><a href="initialise_gt.jsp">设置工天</a></p>
</body>
</html>

initialise_qt.jsp - 源码说明

本页面展示了「JSP页面和oracle9i数据库的源代码」中的 initialise_qt.jsp 源码文件，采用 JSP 编程语言编写，共 63 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与oracle9i相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?