【正文】 f MDAC on the puter that is running the client application.Verify that the instance of SQL Server is listening correctlyTo verify that the instance of SQL Server is listening on named pipes, TCP/IP, or another protocol that you are using at the client application, open the current SQL Server error log file. The SQL Server error log file may contain entries that are similar to the following:20031106 09:49: server SQL server listening on TCP, Shared Memory, Named Pipes. 20031106 09:49: server SQL server listening on :1433, :1433.If you analyze the entries in the SQL Server error log file, you can verify that the instance of SQL Server is listening on the correct IP address and on the correct port. By default, a default instance of SQL Server listens on the port 1433. You can also use Server Network Utility to verify the protocol settings for SQL Server and to change the properties in SQL Server, including the protocols that can connect to SQL Server and the ports that can be used. For more information about using Server Network Utility, see the SQL Server Network Utility topic in SQL Server Books Online. Sometimes, SQL Server 2000 may not bind to port 1433 or any other specified port. This problem may occur if the port is being used by another application or if you are trying to connect by using an IP address that is not correct. Therefore, the TCP/IP connections to SQL Server may not be successful and you may receive the following error message in the SQL Server error log file: 20011114 15:49: server SuperSocket Info: Bind failed on TCP port 1433.If you cannot connect to the instance of SQL Server by using a TCP/IP connection, try to use the named pipes protocol or the Shared Memory protocol. Run the following mand at a mand prompt to obtain information about the ports that are in use:NETSTAT –anYou can also use the Portqry mandline utility to obtain more information about the ports that are in use.Note For named instances of SQL Server, SQL Server dynamically determines the port and listens on the determined port. Therefore, when you start the named instance of SQL Server, SQL Server tries to listen on the port that was previously being used. If SQL Server cannot bind to that port, the named instance may dynamically bind to a different port. In that situation, make sure that the client application is also set to determine the port dynamically. Alternatively, you can also specify a static port for the named instance to bind to and to listen on by using Client Network Utility.Troubleshoot MDAC IssuesConnectivity problems may also occur because of problems with MDAC. For example, a software installation may overwrite some of the MDAC files or change the permissions that you must have to access the MDAC files. You can run the MDAC Component Checker to verify the MDAC installation on your puter.Note If you are connecting to a named instance of SQL Server, make sure that you are running MDAC or later on your puter. Earlier versions of MDAC do not recognize named instances of SQL Server. Therefore, connections to named instances may not be successful.You can use the utility to verify connections through the SQL Server ODBC driver.You can also test connectivity to the instance of SQL Server by using a .udl file.Troubleshoot firewall issuesIf firewall exists between the client puter and the puter that is running SQL Server, make sure that the ports that are required to municate through the firewall are open.If you use the TCP/IP protocol to connect to the instance of SQL Server, make sure that you can use the Telnet program to connect to the port where SQL Server is listening. To use the Telnet program, run the following mand at a mand prompt: Telnet IP Address Port NumberIf the Telnet program is not successful and you receive an error message, resolve the error and then try to connect again.Note Because of issues that were caused by the Slam。通過對(duì)本系統(tǒng)的制作， b制作中的技術(shù)。在員工詳細(xì)信息頁面，修改員工的信息后點(diǎn)擊更新按鈕，則成功更新該員工的信息。 修改部門信息的測(cè)試：打開部門信息列表頁面，如下圖所示：點(diǎn)擊欲修改的部門名稱，鏈接到部門詳細(xì)信息頁面，如下圖所示：修改相應(yīng)的信息并點(diǎn)擊更新則成功修改了一條記錄。重要的是，還要從最終用戶的角度進(jìn)行安全性和可用性測(cè)試。如下圖所示 員工信息列表界面員工信息列表顯示已經(jīng)添加的員工信息，包括員工的編號(hào)、姓名、性別、聯(lián)系電話、聯(lián)系地址、出生年月、所屬部門。對(duì)于數(shù)據(jù)庫調(diào)用字符串，由于數(shù)據(jù)庫使用的是本地?cái)?shù)據(jù)庫，Data Source（數(shù)據(jù)源）設(shè)置為localhost；uid（用戶ID）賦予系統(tǒng)默認(rèn)的sa；pwd（連接密碼）賦值為sa；Database（數(shù)據(jù)名）設(shè)為前面所見的數(shù)據(jù)庫DBMispersonal。 用戶信息數(shù)據(jù)表用戶信息表用于存儲(chǔ)人事資源管理系統(tǒng)中所有登錄人員的信息，包括普通用戶登陸信息、管理員登陸信息，這樣可以方便系統(tǒng)判斷用戶登錄的類型，以及對(duì)用戶類型的統(tǒng)計(jì)管理。本人負(fù)責(zé)部門信息和員工信息的模塊，需創(chuàng)建兩張表即部門信息數(shù)據(jù)表（Tb_department）和員工信息數(shù)據(jù)表（Tb_User_Login）。 （3） 考勤管理 該模塊主要負(fù)責(zé)假別的管理和請(qǐng)假的記錄。主要功能包括添加部門信息、顯示部門信息、修改和刪除部門信息、查詢部門信息。第四章 系統(tǒng)總體設(shè)計(jì) 系統(tǒng)流程分析 系統(tǒng)用戶分兩大類：管理員和普通用戶。本系統(tǒng)性能力求易于使用，具體有較高的擴(kuò)展性和可維護(hù)性。了解這類要求的目的是在開發(fā)過程中，可對(duì)系統(tǒng)將來可能的擴(kuò)展與修改做準(zhǔn)備。確定新系統(tǒng)應(yīng)做什么，這是最主要的需求。隨著科學(xué)技術(shù)的不斷提高，這種傳統(tǒng)的手工管理方法必然被以計(jì)算機(jī)為基礎(chǔ)的信息管理方法所取代。它們只是根據(jù)自己業(yè)務(wù)工作的需要提出了要求，系統(tǒng)開發(fā)人員要對(duì)此進(jìn)行詳細(xì)的調(diào)查和分析，確認(rèn)用戶的要求可以通過現(xiàn)有的計(jì)算機(jī)技術(shù)實(shí)現(xiàn)，保證開發(fā)的管理信息系統(tǒng)的功能與用戶提出的要求相吻合。顯然B/S結(jié)構(gòu)應(yīng)用程序相對(duì)于傳統(tǒng)的C/S結(jié)構(gòu)應(yīng)用程序?qū)⑹蔷薮蟮倪M(jìn)步。在一段特別標(biāo)記的代碼中，開發(fā)者可以使用指針和傳統(tǒng)C/C++特性，如手工的內(nèi)存管理和指針運(yùn)算。即使他們本身寧愿使用更高效的開發(fā)環(huán)境。這些元數(shù)據(jù)可以應(yīng)用于任何對(duì)象。XML正逐漸成為在網(wǎng)絡(luò)上傳輸結(jié)構(gòu)化數(shù)據(jù)的標(biāo)準(zhǔn)。（3）變量是類型安全的。使用簡(jiǎn)單的C語言結(jié)構(gòu)，這些組件可以方便的轉(zhuǎn)化為XML(C也正由于C/C++語言的復(fù)雜性，C++也只有專業(yè)的程序員才能掌握，而對(duì)于一般用戶而言，C++確實(shí)有些沉重。1數(shù)據(jù)修改：update 表名 set列名=值表達(dá)式 [where 條件表達(dá)式]。1條件表達(dá)式的比較操作(1)、算術(shù)比較操作 ,=,=,=,=,!=,between…and。撤銷基本表： drop table基本表名[cascade | restrict]。primary key(t) 定義t 為主鍵。(b) 數(shù)據(jù)查詢語言，數(shù)據(jù)查詢語言是指Select命令，主要用來對(duì)數(shù)據(jù)庫中表進(jìn)行查詢并返回符合用戶查詢標(biāo)準(zhǔn)的結(jié)果數(shù)據(jù)，是SQL 語言中使用最頻繁的命令。開發(fā)者版（Developer Edition）用于程序員開發(fā)應(yīng)用程序，這些程序需要SQL Server 2000 作為數(shù)據(jù)存儲(chǔ)設(shè)備?？煽缭綇倪\(yùn)行Microsoft Windows 98 的膝上型電腦，到運(yùn)行Microsoft Windows 2000 的大型多處理器的服務(wù)器等多種平臺(tái)使用。（5）DataReader對(duì)象DataReader對(duì)象只是一次一筆向下循序的讀出數(shù)據(jù)源的數(shù)據(jù)。我們可以自己產(chǎn)生這個(gè)對(duì)象，或由其他對(duì)象自動(dòng)生成。一些老式的數(shù)據(jù)源使用ODBC協(xié)議，許多新的數(shù)據(jù)源使用OleDB協(xié)議，并且現(xiàn)在還不斷出現(xiàn)更多的數(shù)據(jù)源?！　∷峁┝似脚_(tái)互用性和可伸縮的數(shù)據(jù)訪問。編寫一個(gè)簡(jiǎn)單的定制控件，首先導(dǎo)入重要的命名空間，然后創(chuàng)建具有命名空間的類，該類繼承于System..，編程來指定其顯示方式，最后編譯該控件。比如，對(duì)于復(fù)雜的Web站點(diǎn)，通過后臺(tái)編碼，使設(shè)計(jì)人員專門負(fù)責(zé)維護(hù)外觀內(nèi)容，而開發(fā)人員注重編寫代碼，負(fù)責(zé)應(yīng)用程序的功能和邏輯，這樣不僅考慮了外觀效果，還保證長(zhǎng)期穩(wěn)定的可維護(hù)性?？蓮?fù)用代碼放到可從火SPX 頁面中引用的一個(gè)獨(dú)立組件上。提供基于組件、事件驅(qū)動(dòng)的可編程網(wǎng)絡(luò)表單，大大簡(jiǎn)化了編程。 　 目前主流的動(dòng)態(tài)網(wǎng)頁技術(shù)有JSP,ASP,PHP 、 。 客戶機(jī)平臺(tái)：Internet Explorer 。（1） 部門信息管理模塊的主要功能包括：部門信息的添加；