資源簡介
第16章 網上辦公系統
_________________________________________________________________________
文件介紹
文件夾名 說明
=================================================================
Code 網上辦公系統源代碼
DataBases\Office 網上辦公系統系統示例的數據庫文件
=================================================================
_________________________________________________________________________
數據庫配置
本示例程序使用的SQL Server 2000數據庫，在配置數據庫時，比前面
節稍復雜，步驟如下：
1.將數據庫復制硬盤上
確保您的機器上安裝了SQL Server2000或以上的版本，將本示例的數據
庫文件連同文件夾“college”一起拷貝到硬盤上（例如拷貝到C:\），并去
掉文件的只讀屬性。
2.在SQL Server中添加本案例數據庫
依次選擇“開始”→“程序”→“SQL Server”→“Microsoft SQL
Server”→“查詢分析器”，啟動SQL Server查詢分析器，在查詢命令窗口
中輸入數據庫附加代碼，例如：
====================================================
sp_Attach_db @dbName = N'Office',
@FileName1 = N'C:\Office\myoffice.mdf',
@FileName2 = N'C:\Office\myoffice.ldf'
====================================================
注意：@FileName1 = N'myoffice.mdf'用于指定數據庫文件夾路徑，當
路徑發生變化時，也要相應調整上述代碼。
_____________________________________________________________________________
用戶說明
帳號 密碼 權限
=====================================================================
admin admin 管理員
用戶名、密碼和權限存放在本案例數據庫中的userinf表，讀者可以在這個
表中添加新的用戶。
=====================================================================
_____________________________________________________________________________
代碼片段和文件信息
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1794??2004-04-22?12:25??ch16\使用說明.txt
?????文件????2097152??2004-03-29?17:21??ch16\Databases\Office\myoffice.ldf
?????文件???10485760??2004-03-29?17:21??ch16\Databases\Office\myoffice.mdf
?????文件???????4732??2004-08-31?15:40??ch16\Code\index.asp
?????文件???????3378??2004-03-20?10:35??ch16\Code\office\addaddress.asp
?????文件???????6227??2004-03-29?16:57??ch16\Code\office\address.asp
?????文件???????5120??2004-03-22?15:36??ch16\Code\office\adduser.asp
?????文件???????2890??2004-03-19?14:20??ch16\Code\office\addworkrep.asp
?????文件??????23316??2004-03-13?12:46??ch16\Code\office\cal.asp
?????文件???????6035??2004-03-19?11:09??ch16\Code\office\dayrep.asp
?????文件????????665??2004-03-12?22:56??ch16\Code\office\default.asp
?????文件???????3553??2004-03-22?15:36??ch16\Code\office\deptcontrol.asp
?????文件???????4813??2004-03-19?13:32??ch16\Code\office\displayworkrec.asp
?????文件???????1471??2004-03-20?21:38??ch16\Code\office\downgong.asp
?????文件???????3699??2004-03-29?16:38??ch16\Code\office\editaddress.asp
?????文件???????3016??2004-03-19?14:41??ch16\Code\office\editworkrep.asp
?????文件???????6008??2004-03-20?22:42??ch16\Code\office\havercidate.asp
?????文件???????6197??2004-03-20?21:32??ch16\Code\office\havesenddate.asp
?????文件???????3680??2004-03-21?13:25??ch16\Code\office\hsmessage.asp
?????文件????????662??2004-03-18?14:33??ch16\Code\office\index.asp
?????文件???????7274??2004-03-18?20:24??ch16\Code\office\left.asp
?????文件????????676??2004-03-18?19:36??ch16\Code\office\logout.asp
?????文件???????4241??2004-03-21?14:52??ch16\Code\office\lookmessage.asp
?????文件???????3282??2004-03-29?16:40??ch16\Code\office\lookshare.asp
?????文件???????3092??2004-03-19?19:57??ch16\Code\office\newnotice.asp
?????文件???????6680??2004-03-19?21:14??ch16\Code\office\noticecontrol.asp
?????文件???????6153??2004-03-19?20:54??ch16\Code\office\noticelook.asp
?????文件???????3248??2004-03-29?17:19??ch16\Code\office\seemessage.asp
?????文件???????5275??2004-03-20?19:42??ch16\Code\office\senddate.asp
?????文件???????8463??2004-03-20?23:01??ch16\Code\office\senddatecontrol.asp
............此處省略84個文件信息
-----------?---------??----------?-----??----
?????文件???????1794??2004-04-22?12:25??ch16\使用說明.txt
?????文件????2097152??2004-03-29?17:21??ch16\Databa
?????文件???10485760??2004-03-29?17:21??ch16\Databa
?????文件???????4732??2004-08-31?15:40??ch16\Code\index.asp
?????文件???????3378??2004-03-20?10:35??ch16\Code\office\addaddress.asp
?????文件???????6227??2004-03-29?16:57??ch16\Code\office\address.asp
?????文件???????5120??2004-03-22?15:36??ch16\Code\office\adduser.asp
?????文件???????2890??2004-03-19?14:20??ch16\Code\office\addworkrep.asp
?????文件??????23316??2004-03-13?12:46??ch16\Code\office\cal.asp
?????文件???????6035??2004-03-19?11:09??ch16\Code\office\dayrep.asp
?????文件????????665??2004-03-12?22:56??ch16\Code\office\default.asp
?????文件???????3553??2004-03-22?15:36??ch16\Code\office\deptcontrol.asp
?????文件???????4813??2004-03-19?13:32??ch16\Code\office\displayworkrec.asp
?????文件???????1471??2004-03-20?21:38??ch16\Code\office\downgong.asp
?????文件???????3699??2004-03-29?16:38??ch16\Code\office\editaddress.asp
?????文件???????3016??2004-03-19?14:41??ch16\Code\office\editworkrep.asp
?????文件???????6008??2004-03-20?22:42??ch16\Code\office\havercidate.asp
?????文件???????6197??2004-03-20?21:32??ch16\Code\office\havesenddate.asp
?????文件???????3680??2004-03-21?13:25??ch16\Code\office\hsmessage.asp
?????文件????????662??2004-03-18?14:33??ch16\Code\office\index.asp
?????文件???????7274??2004-03-18?20:24??ch16\Code\office\left.asp
?????文件????????676??2004-03-18?19:36??ch16\Code\office\logout.asp
?????文件???????4241??2004-03-21?14:52??ch16\Code\office\lookmessage.asp
?????文件???????3282??2004-03-29?16:40??ch16\Code\office\lookshare.asp
?????文件???????3092??2004-03-19?19:57??ch16\Code\office\newnotice.asp
?????文件???????6680??2004-03-19?21:14??ch16\Code\office\noticecontrol.asp
?????文件???????6153??2004-03-19?20:54??ch16\Code\office\noticelook.asp
?????文件???????3248??2004-03-29?17:19??ch16\Code\office\seemessage.asp
?????文件???????5275??2004-03-20?19:42??ch16\Code\office\senddate.asp
?????文件???????8463??2004-03-20?23:01??ch16\Code\office\senddatecontrol.asp
............此處省略84個文件信息
- 上一篇：C# 超市管理系統（asp.net）
- 下一篇：asp 校園WEBGIS系統源代碼
評論
共有 條評論
川公網安備 51152502000135號