【導(dǎo)讀】利用計(jì)算機(jī)管理可以最大限度的發(fā)揮準(zhǔn)確、快捷、高效等作用,在越來越激。烈的珠寶行業(yè)中，計(jì)算機(jī)管理技術(shù)對(duì)珠寶首飾公司的服務(wù)管理提供強(qiáng)有力的支持。服務(wù)水準(zhǔn)的重要手段之一。本系統(tǒng)應(yīng)用VisualBasic中文版開發(fā)前臺(tái)，用Microsoft. Access作后臺(tái)服務(wù)器，采用客戶機(jī)/服務(wù)器（C/S）管理思想來對(duì)珠寶首飾進(jìn)銷存管理。珠寶行業(yè)在我國是一個(gè)新興行業(yè)，目前尚處于初步階段。自動(dòng)賦予唯一編號(hào)，跟隨該珠寶做完出貨和銷售全過程。能，為經(jīng)營決策提供了切實(shí)可靠的依據(jù)。管理水平，已成為此行業(yè)發(fā)展的當(dāng)務(wù)之急?？萍际侄蝸硖岣咂髽I(yè)的管理水平無疑是一條行之有效的途徑。目前擁有十余名中、高級(jí)。品，它是以各種絢麗多彩的寶玉石為原料，由美工師根據(jù)寶玉石的形態(tài)和色澤，一九九九年澳門回歸之際，大型中國。別行政區(qū)政府，得到了自治區(qū)政府領(lǐng)導(dǎo)的高度評(píng)價(jià)。取得了豐碩成果，獲得了明顯的經(jīng)濟(jì)效益和社會(huì)效益。場的能力，使公司成為具有現(xiàn)代企業(yè)架構(gòu)和現(xiàn)代管理體系的高新技術(shù)企業(yè)。

　　

【正文】 字段的最左邊，在鼠標(biāo)變?yōu)榧犹?hào)時(shí)，單擊該字段，鍵入要插入的文本。 注意：如果鍵入有錯(cuò)，可按 BACKSPACE 鍵；如果要取消對(duì)當(dāng)前字段的更改，按 ESC 鍵；如果要取消對(duì)整個(gè)記錄的更改，在移出該字段之前再次按 ESC 鍵，當(dāng)從一個(gè)記錄移動(dòng)到其它記錄時(shí)， Access 將保存對(duì)該記錄的修改。 復(fù)制或移動(dòng)數(shù)據(jù)：在其它應(yīng)用程序，如 Excel、 Word 中，選擇要復(fù)制或移動(dòng)的一至多行。如果是從 Word 中復(fù)制數(shù)據(jù)，應(yīng)確保記錄在選擇之前已經(jīng)在表中排列好或已經(jīng)使用制表符分隔開，如果粘貼數(shù)據(jù)到數(shù)據(jù)表中，應(yīng)確保數(shù)據(jù)表中的列與要復(fù)制或移動(dòng)的數(shù)據(jù)的順序一致，如果粘貼數(shù)據(jù)到窗體上，而窗體上相應(yīng)的控件名稱與復(fù)制數(shù)據(jù)的列名相同， Access 將粘貼數(shù)據(jù)到名稱相同的控件上。 在Access 中，打開要向其中粘貼記錄的數(shù)據(jù)表或窗體，如果要替換現(xiàn)有記錄，選擇要替換的記錄，然后單擊工具欄上的“粘貼追加”或“粘貼”按鈕 ；如果窗體中的記錄選定器不可用，要選擇當(dāng)前記錄，可單擊“編輯”菜單中的“選擇記錄”命令。 刪除記錄：單擊要?jiǎng)h除的記錄，單擊工具欄上的“刪除記錄”按鈕 。 4 使用 ADO 數(shù)據(jù)控件訪問數(shù)據(jù)庫 ADO(Active Data Objects)是一種新的數(shù)據(jù)訪問方式，具有以下特征： 38 ? 有一個(gè)簡化的對(duì)象模型 ? 與其他 Microsoft 和非 Microsoft 技術(shù)更加緊密的集成。 ? 是 一個(gè)本地和遠(yuǎn)程數(shù)據(jù)訪問、遠(yuǎn)程和斷開連接的記錄集、用戶可以訪問的數(shù)據(jù)綁定接口以及層次化的記錄集的通用接口。 XX 人事勞資管理信息系統(tǒng)通過 ADO 這個(gè)數(shù)據(jù)控件來訪問數(shù)據(jù)庫，首先，安裝 ADO 控件要在 簡體中文 VISUAL 企業(yè)版中注冊(cè)后才能使用。ADO(ActiveX Data Object)是微軟提出的數(shù)據(jù)訪問接口，它實(shí)現(xiàn)了 RDO 的絕大多數(shù)功能，另外還增加了一些用戶以前沒有接觸到的特征。 Visual Basic 可以很好地支持 ADO 和 OLE DB 數(shù)據(jù)訪問模式。 在 中包含了數(shù)據(jù)綁定 、可視化設(shè)計(jì)工具以及 OLE DB 數(shù)據(jù)源書寫模板等新的內(nèi)容。在 Visual 中， ADO 的數(shù)據(jù)環(huán)境設(shè)計(jì)器 (Data Environment Designer)取代了 Visual Basic 中的 RDO 的用戶連接設(shè)計(jì)器 (User Connection Designer)。 User Connection 對(duì)象只支持 ODBC 數(shù)據(jù)源，而 Data Environment 對(duì)象可以連接所有的 OLE DB 數(shù)據(jù)源 o ADO 對(duì)象模型定義了一個(gè)可編程的分層的對(duì)象集合，它支持部件對(duì)象模型(COM)和 OLE DB 數(shù)據(jù)源。與其他的數(shù)據(jù)訪問對(duì)象相比，包含在 ADO 的對(duì)象少得多，也更加容易使用。 ADO 對(duì)象模型中包含了 3 個(gè)一般用途的對(duì)象： Connection、 Command 和Recordset。程序開發(fā)人員可以創(chuàng)建這些對(duì)象并且使用這些對(duì)象訪問數(shù)據(jù)庫。在ADO 對(duì)象模型中還有其他幾個(gè)對(duì)象，例如 Field、 Property、 Error 和 Parameter，它們是作為前面 3 個(gè)對(duì)象的子對(duì)象進(jìn)行訪問的。 （ 1）、 ADO 數(shù)據(jù)控件的功能 ADO data 控件使用 ActiveX 數(shù)據(jù)對(duì)象（ ADO）來快速建立數(shù)據(jù)約束控件和數(shù)據(jù)提供者之間的連 接，并快速創(chuàng)建記錄集，然后將數(shù)據(jù)通過數(shù)據(jù)約束控件提供給用戶，其中數(shù)據(jù)約束控件可以是任何具有“數(shù)據(jù)源”屬性的控件，而數(shù)據(jù)提供者可以是符合 OLE DB 規(guī)范的數(shù)據(jù)源。使用 Visual Basic 的類模塊也可以很方便的創(chuàng)建子集的數(shù)據(jù)提供者。在 Visual 中，可以使用 ADO 數(shù)據(jù)控件實(shí)現(xiàn)下面一些功能： ? 連接一個(gè)本地?cái)?shù)據(jù)庫或遠(yuǎn)程數(shù)據(jù)庫。 39 ? 打開一個(gè)指定的數(shù)據(jù)庫表，或定義一個(gè)基于結(jié)構(gòu)化查詢語言 (SQL)的查詢、存儲(chǔ)過程或者是該數(shù)據(jù)庫中表的視圖的記錄集合。 ? 將數(shù)據(jù)字段的數(shù)值傳遞給數(shù)據(jù)綁定的控件，可以在這些控件 中顯示或更改這些數(shù)值。 ? 添加新的記錄，或者根據(jù)對(duì)顯示在綁定的控件中的數(shù)據(jù)的任何更改來更新一個(gè)數(shù)據(jù)庫。 （ 2）、 ADO 數(shù)據(jù)控件的屬性 ADO 數(shù)據(jù)控件與 Visual Basic 的內(nèi)部數(shù)據(jù)控件 (Data)和遠(yuǎn)程數(shù)據(jù)控件 (RDC)很相似，它允許使用 ADO 快速地創(chuàng)建與數(shù)據(jù)庫的連接。 與 Data 控件類似，為了實(shí)現(xiàn)對(duì)數(shù)據(jù)庫的訪問， ADO 數(shù)據(jù)控件提供了幾個(gè)屬性，這些屬性定義了怎樣連接數(shù)據(jù)庫以及同什么樣的數(shù)據(jù)庫相連接。 Connection String 屬性：是一個(gè)字符串，可以包含進(jìn)行一個(gè)連接所需的所 有設(shè)置值，在該字符串中所傳遞的參數(shù)是與驅(qū)動(dòng)程序相關(guān)的。例如， ODBC 驅(qū)動(dòng)程序允許該字符串包含驅(qū)動(dòng)程序、提供者、默認(rèn)的數(shù)據(jù)庫、服務(wù)器、用戶名稱以及密碼等。 ADO 支持 Connection String屬性的 4 個(gè)參數(shù)，而且這 4 個(gè)參數(shù)將不經(jīng)過 ADO的處理直接送到數(shù)據(jù)源。這四個(gè)參數(shù)的屬性如表 所示： 表 Connection String 屬性的 4 個(gè)參數(shù)表 參數(shù) 描述 Provider 指定數(shù)據(jù)源的名稱 File Name 指定基于數(shù)據(jù)源的文件名稱 Remote Server 指定在打開一個(gè)客戶端連 接時(shí)使用的數(shù)據(jù)源名稱 Remote Server 指定打開客戶端連接時(shí)使用的服務(wù)器的路徑與名稱 40 And what numberless and powerful causes tend to destroy these rare natures! What causes? In the first place there are their own virtues, their courage, temperance, and the rest of them, every one of which praise w orthy qualities (and this is a most singular circumstance) destroys and distracts from philosophy the soul which is the possessor of them. That is very singular, he replied. Then there are all the ordinary goods of life beauty, wealth, strength, rank, and great connections in the State you understand the sort of things these also have a corrupting and distracting effect. I understand。 but I should like to know more precisely what you mean about them. Grasp the truth as a whole, I said, and in the right way。 you will then have no difficulty in apprehending the preceding remarks, and they will no longer appear strange to you. And how am I to do so? he asked. Why, I said, we know that all germs or seeds, whether vegetable or animal, when they fail to meet with proper nutriment or climate or soil, in proportion to their vigour, are all the more sensitive to the want of a suitable environment, for evil is a greater enemy to what is good than what is not. Very true. There is reason in supposing that the finest natures, when under alien conditions, receive more injury than the inferior, because the contrast is greater. Certainly. And may we not say, Adeimantus, that the most gifted minds, when they are illeducated, bee preeminently bad? Do not great crimes and the spirit of pure evil spring out of a fulness of nature ruined by education rather than from any inferiority, whereas weak natures are scarcely capable of any very great good or very great evil? There I think that you are right. And our philosopher follows the same analogy he is like a plant which, having proper nurture, must necessarily grow and mature into all virtue, but, if sown and planted in an alien soil, bees the most noxious of all weeds, unless he be preserved by some divine power. Do you really think, as people so often say, that our youth are corrupted by Sophists, or tha t private teachers of the ar t corrupt them in any degree worth speaking of ? Are not the public who say these things the greatest of all Sophists? And do they not educate to perfection young and old, men and women alike, and fashion them after their own hearts? When is this acplished? he said. When they meet together, and the world sits down at an assembly, or in a court of law, or a theatre, or a camp, or in any other popular resort, and there is a great uproar, and they praise some things which are being said or done, and blame other things, equally exaggerating both, shouting and clapping their hands, and the echo of the roc ks and the place in which they are assembled redoubles the sound of the praise or blame at such a time will not a young man39。s heart, as they say, leap within him? Will any private training enable him to stand firm against the overwhelming flood of popular opinion? or will he be carried away by the stream? Will he not have the notions of good and evil which the public in general have he will do as they do, and as they are, such will he be? Yes, Socrates。 necessity will pel him. And yet, I said, there is a still greater necessity, which has not been mentioned. What is that? The gentle force of attainder or confiscation or death which, as you are aware, these new Sophists and educators who are the public, apply when their wor