?? default.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="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?filename=新文檔.doc" 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="#edea10"><td width=50>id</td><td width=300>文件名</td><td width=200>大小</td><td width=150>操作</td></tr>
<!--讀取數據庫中的文件-->
<%
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:files";
Connection conn = 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);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery("select * from MyUploadTable");
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery: " + ex.getMessage());
}
while(rs.next())
{
long id = rs.getLong("id");
//String filename = new String( rs.getString("filename").getBytes("iso-8859-1"),"GB2312");
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=\"edit.jsp?docid=" + id + "&filename=" + filename + "\" target=_blank>編輯</a></td><tr>";
out.println(outStr);
}
rs.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 + -