📄 default.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.io.*,java.sql.*" %>
<HTML>
<HEAD>
<meta http-equiv="content-type" content="text/html;charset=gb2312">
<TITLE>NTKO Office文档控件JSP示例</TITLE>
</HEAD>
<BODY>
<Center>
<h1>NTKO Office文档控件JSP示例</h1>
<hr width=80%>
<h3><a href="edit.jsp" target="_blank">创建文档</A>
<button onclick="window.location.reload();">刷新</button></h3>
<hr width=80%><B>以下是数据库中保存的文档</B><hr width=80%>
<table width=700 border=1 cellpadding=0 cellspacing=0>
<tr bgcolor="#9cc3de"><td width=50>id</td><td width=150>文件名</td><td width=200>其他数据</td><td width=150>大小</td><td width=150>操作</td></tr>
<!--读取数据库中的文件-->
<%
//读取数据库中的文件列表
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:files23jsp";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try
{
//加载数据库驱动程序
Class.forName(DBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("DBconn (): " + e.getMessage());
}
//与DBMS建立连接
try
{
conn = DriverManager.getConnection(ConnStr);
stmt = conn.createStatement();
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery: " + ex.getMessage());
}
rs = stmt.executeQuery("select * from MyUploadTable");
while(rs.next())
{
long id = rs.getLong("id");
String filename = new String( rs.getBytes("filename"),"gb2312");
String data = new String( rs.getBytes("otherdata"),"gb2312");
long filesize = rs.getLong("filesize");
String outStr = "<tr><td>" + id + "</td><td>" + filename + "</td><td>" + data + "</td><td>" + filesize + "字节</td><td><a href=\"edit.jsp?docid=" + id + "\" target=_blank>编辑</a></td><tr>";
out.println(outStr);
}
rs.close();
%>
</table>
<hr width=80%><B>以下是html表中保存的文件</B><hr width=80%>
<table width=700 border=1 cellpadding=0 cellspacing=0>
<tr bgcolor="#9cc3de"><td width=50>id</td><td width=300>文件名</td><td width=250>大小</td><td width=150>操作</td></tr>
<%
//读取HTML文件列表
//与DBMS建立连接
rs = stmt.executeQuery("select * from htmlfiles");
while(rs.next())
{
long id = rs.getLong("id");
String filename = new String( rs.getBytes("filename"),"gb2312");
long filesize = rs.getLong("filesize");
String outStr = "<tr><td>" + id + "</td><td>" + filename + "</td><td>" + filesize + "字节</td><td><a href=\"readhtml.jsp?id=" + id + "\" target=_blank>打开</a></td><tr>";
out.println(outStr);
}
rs.close();
stmt.close();
conn.close();
%>
</table>
<BR><BR><BR>
<h3>@版权所有：刘伶训</h3>
<h3><a href="http://www.ntko.com" target="_blank">http://www.ntko.com</h3>
<h3><a href="mailto:tanger@ntko.com">tanger@ntko.com</a></h3>
</center>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -