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

　　

【正文】 字段的最左邊，在鼠標變?yōu)榧犹枙r，單擊該字段，鍵入要插入的文本。 注意：如果鍵入有錯，可按 BACKSPACE 鍵；如果要取消對當前字段的更改，按 ESC 鍵；如果要取消對整個記錄的更改，在移出該字段之前再次按 ESC 鍵，當從一個記錄移動到其它記錄時， Access 將保存對該記錄的修改。 復(fù)制或移動數(shù)據(jù)：在其它應(yīng)用程序，如 Excel、 Word 中，選擇要復(fù)制或移動的一至多行。如果是從 Word 中復(fù)制數(shù)據(jù)，應(yīng)確保記錄在選擇之前已經(jīng)在表中排列好或已經(jīng)使用制表符分隔開，如果粘貼數(shù)據(jù)到數(shù)據(jù)表中，應(yīng)確保數(shù)據(jù)表中的列與要復(fù)制或移動的數(shù)據(jù)的順序一致，如果粘貼數(shù)據(jù)到窗體上，而窗體上相應(yīng)的控件名稱與復(fù)制數(shù)據(jù)的列名相同， Access 將粘貼數(shù)據(jù)到名稱相同的控件上。 在Access 中，打開要向其中粘貼記錄的數(shù)據(jù)表或窗體，如果要替換現(xiàn)有記錄，選擇要替換的記錄，然后單擊工具欄上的“粘貼追加”或“粘貼”按鈕 ；如果窗體中的記錄選定器不可用，要選擇當前記錄，可單擊“編輯”菜單中的“選擇記錄”命令。 刪除記錄：單擊要刪除的記錄，單擊工具欄上的“刪除記錄”按鈕 。 4 使用 ADO 數(shù)據(jù)控件訪問數(shù)據(jù)庫 ADO(Active Data Objects)是一種新的數(shù)據(jù)訪問方式，具有以下特征： 38 ? 有一個簡化的對象模型 ? 與其他 Microsoft 和非 Microsoft 技術(shù)更加緊密的集成。 ? 是 一個本地和遠程數(shù)據(jù)訪問、遠程和斷開連接的記錄集、用戶可以訪問的數(shù)據(jù)綁定接口以及層次化的記錄集的通用接口。 XX 人事勞資管理信息系統(tǒng)通過 ADO 這個數(shù)據(jù)控件來訪問數(shù)據(jù)庫，首先，安裝 ADO 控件要在 簡體中文 VISUAL 企業(yè)版中注冊后才能使用。ADO(ActiveX Data Object)是微軟提出的數(shù)據(jù)訪問接口，它實現(xiàn)了 RDO 的絕大多數(shù)功能，另外還增加了一些用戶以前沒有接觸到的特征。 Visual Basic 可以很好地支持 ADO 和 OLE DB 數(shù)據(jù)訪問模式。 在 中包含了數(shù)據(jù)綁定 、可視化設(shè)計工具以及 OLE DB 數(shù)據(jù)源書寫模板等新的內(nèi)容。在 Visual 中， ADO 的數(shù)據(jù)環(huán)境設(shè)計器 (Data Environment Designer)取代了 Visual Basic 中的 RDO 的用戶連接設(shè)計器 (User Connection Designer)。 User Connection 對象只支持 ODBC 數(shù)據(jù)源，而 Data Environment 對象可以連接所有的 OLE DB 數(shù)據(jù)源 o ADO 對象模型定義了一個可編程的分層的對象集合，它支持部件對象模型(COM)和 OLE DB 數(shù)據(jù)源。與其他的數(shù)據(jù)訪問對象相比，包含在 ADO 的對象少得多，也更加容易使用。 ADO 對象模型中包含了 3 個一般用途的對象： Connection、 Command 和Recordset。程序開發(fā)人員可以創(chuàng)建這些對象并且使用這些對象訪問數(shù)據(jù)庫。在ADO 對象模型中還有其他幾個對象，例如 Field、 Property、 Error 和 Parameter，它們是作為前面 3 個對象的子對象進行訪問的。 （ 1）、 ADO 數(shù)據(jù)控件的功能 ADO data 控件使用 ActiveX 數(shù)據(jù)對象（ 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ù)控件實現(xiàn)下面一些功能： ? 連接一個本地數(shù)據(jù)庫或遠程數(shù)據(jù)庫。 39 ? 打開一個指定的數(shù)據(jù)庫表，或定義一個基于結(jié)構(gòu)化查詢語言 (SQL)的查詢、存儲過程或者是該數(shù)據(jù)庫中表的視圖的記錄集合。 ? 將數(shù)據(jù)字段的數(shù)值傳遞給數(shù)據(jù)綁定的控件，可以在這些控件 中顯示或更改這些數(shù)值。 ? 添加新的記錄，或者根據(jù)對顯示在綁定的控件中的數(shù)據(jù)的任何更改來更新一個數(shù)據(jù)庫。 （ 2）、 ADO 數(shù)據(jù)控件的屬性 ADO 數(shù)據(jù)控件與 Visual Basic 的內(nèi)部數(shù)據(jù)控件 (Data)和遠程數(shù)據(jù)控件 (RDC)很相似，它允許使用 ADO 快速地創(chuàng)建與數(shù)據(jù)庫的連接。 與 Data 控件類似，為了實現(xiàn)對數(shù)據(jù)庫的訪問， ADO 數(shù)據(jù)控件提供了幾個屬性，這些屬性定義了怎樣連接數(shù)據(jù)庫以及同什么樣的數(shù)據(jù)庫相連接。 Connection String 屬性：是一個字符串，可以包含進行一個連接所需的所 有設(shè)置值，在該字符串中所傳遞的參數(shù)是與驅(qū)動程序相關(guān)的。例如， ODBC 驅(qū)動程序允許該字符串包含驅(qū)動程序、提供者、默認的數(shù)據(jù)庫、服務(wù)器、用戶名稱以及密碼等。 ADO 支持 Connection String屬性的 4 個參數(shù)，而且這 4 個參數(shù)將不經(jīng)過 ADO的處理直接送到數(shù)據(jù)源。這四個參數(shù)的屬性如表 所示： 表 Connection String 屬性的 4 個參數(shù)表 參數(shù) 描述 Provider 指定數(shù)據(jù)源的名稱 File Name 指定基于數(shù)據(jù)源的文件名稱 Remote Server 指定在打開一個客戶端連 接時使用的數(shù)據(jù)源名稱 Remote Server 指定打開客戶端連接時使用的服務(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