📄 dbgw.jsp

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。注意： 1. 本书中的案例提供的数据库环境不同

💻 JSP

字号:

<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*" %>
<%@ page import="oa.main.*" %>
<%@ page import="oa.bean.*" %>
<%@ include file="inc.jsp"%>

<%
DocBean docb=null;
ResultSet rs=null;
Statement stm = null;
try{
%>
<html>
<head>
<title>公文状态查看</title>
<link rel="stylesheet" type="text/css" href="../css/css_new.css">
</head>
<body class=bgl>
<form action="../office/gwswhcl.jsp" method=post name="form1">
  <table border="0" width="100%" cellspacing="0" cellpadding="0">
    <tr>
      <td width="29"><font color="#FFFFFF"><img border="0" src="../image/index/connerx1.gif"><img border="0" src="../image/index/alert_2.gif"></font></td>
      <td bgcolor="#2969B5"><font color="#FFFFFF">上文号</font></td>
      <td width="12"><font color="#FFFFFF"><img border="0" src="../image/index/connerx2.gif"></font></td>
    </tr>
  </table>
<table border="1" width="100%" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#A5BEE0" >
    <!--<tr bgcolor="#ffffff" height=25>
      <td width="15%">公文类别:</td>
      <td width="85%" colspan="5"><%if(GWLB.equals("1"))out.print("公司发文");else if(GWLB.equals("0"))out.print("部门发文");%>-->
    <tr bgcolor="#d0e7ff" height=25>
      <td width="15%" align="center">标&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;题:</td>
      <td width="85%" colspan="5" bgcolor="#d0e7ff"><%=GWBT%></td>
    </tr>
    <tr bgcolor="#ffffff" height=25>
      <td width="15%" align="center">&nbsp;</td>
      <td width="85%" colspan="5" bgcolor="#ffffff">&nbsp;</td>
    </tr>
     <tr bgcolor="#d0e7ff" height=25>
      <td width="15%" align="center">&nbsp;</td>
      <td width="85%" colspan="5" bgcolor="#d0e7ff">&nbsp;</td>
    </tr>
     <tr bgcolor="#ffffff" height=25>
      <td width="15%" align="center">&nbsp;</td>
      <td width="85%" colspan="5" bgcolor="#ffffff">&nbsp;</td>
    </tr>
     <tr bgcolor="#d0e7ff" height=25>
      <td width="15%" align="center">&nbsp;</td>
      <td width="85%" colspan="5" bgcolor="#d0e7ff">&nbsp;</td>
    </tr>
     <tr bgcolor="#ffffff" height=25>
      <td width="15%" align="center">&nbsp;</td>
      <td width="85%" colspan="5" bgcolor="#ffffff">&nbsp;</td>
    </tr>
     <tr bgcolor="#d0e7ff" height=25>
      <td width="15%" align="center">&nbsp;</td>
      <td width="85%" colspan="5" bgcolor="#d0e7ff">&nbsp;</td>
    </tr>
     <tr bgcolor="#ffffff" height=25>
      <td width="15%" align="center">&nbsp;</td>
      <td width="85%" colspan="5" bgcolor="#ffffff">&nbsp;</td>
    </tr>
     <tr bgcolor="#d0e7ff" height=25>
      <td width="15%" align="center">&nbsp;</td>
      <td width="85%" colspan="5" bgcolor="#d0e7ff">&nbsp;</td>
    </tr>
    <tr bgcolor="#ffffff" height=25>
      <td width="15%" align="center">&nbsp;</td>
      <td width="85%" colspan="5" bgcolor="#ffffff">&nbsp;</td>
    </tr>
    <tr bgcolor="#d0e7ff" height=25>
      <td width="15%" align="center">&nbsp;</td>
      <td width="85%" colspan="5" bgcolor="#d0e7ff">&nbsp;</td>
    </tr>
  </table>
	<jsp:include page="gdmember.jsp" />
<p  align=center >&nbsp;</p>
</form>
</body>

</html>
<%}finally{
if(rs!=null){stm=rs.getStatement();rs.close() ;}
if(stm!=null)stm.close();
	if(docb!=null)docb.closeConn();
}%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -