How to execute an instance program

Source: Internet
Author: User
Tags exit

Actions on the server

(1) Login "Sqlplus Worksheet" as System user and SYSDBA, execute creategraduateuser.sql file creation user Graduateuser.

(2) Execute Createtablegraduateinfo.sql file creation data table Graduateuser.graduate_info.

(3) Execute Createtabledirectorinfo.sql file creation data table Graduateuser.director_info.

(4) Execute Createtablemajorinfo.sql file creation data table Graduateuser.major_info.

(5) Execute Createindexgraduate.sql file creation data table Graduateuser. The index of the name field of the Graduate_info.

(6) Execute Createindexdirector.sql file creation data table Graduateuser. The index of the name field of the Director_info.

(7) Execute Createviewgraduate.sql file creation data table Graduateuser. The Graduate_info view.

(8) Execute Createviewdirector.sql file creation data table Graduateuser. The Director_info view.

(9) Execute Createviewmajor.sql file creation data table Graduateuser. The Major_info view.

Actions on the client

(1) The Network Configuration assistant (NET Configuration Assistant) that invokes the Oracle 9i client on the client computer configures a "local network service name" that can connect to the database server, and the author is configured with the name Myoraclelink. This name can be arbitrarily taken.

(2) Create a system data source name in the client's control Panel/32-bit ODBC name, which must be graduatedb. Of course, if the reader to use their own name, can be in the VB Program module MODULE1 to make appropriate changes. The modified code is as follows.

―――――――――――――――――――――――――――――――――――――

' defines a parameterless function named ConnectString, which connects the database

Public Function connectstring () as String

ConnectString = "DSN=GRADUATEDB; Uid=graduateuser; pwd=12345678 "

End Function

―――――――――――――――――――――――――――――――――――――

Running programs on the client

(1) Copy the Graduate.exe file on the supporting CD to the client, and execute the file as shown in Figure 10.55.

(2) The "Add Professional Information" interface appears as shown in Figure 10.56.

(3) The prompt interface shown in Figure 10.57 appears after the successful addition of professional information.

(4) According to the same steps to add professional information data, so that the added professional data will be used for postgraduate information entry and tutorial information entry form use.

(5) The "Add Mentor Information" interface appears as shown in Figure 10.58.

(6) After the successful addition of mentor information, the interface shown in Figure 10.59 appears.

(7) Follow the same steps to add the tutor information data sequentially.

(8) The interface appears as shown in Figure 10.60.

(9) After the successful addition of postgraduate information appears as shown in Figure 10.61 interface, click the "OK" button.

(10) The "Revise Postgraduate Information" interface, as shown in Figure 10.62, appears.

(11) The "Inquiry Postgraduate Information" interface appears as shown in Figure 10.63.

(12) in Figure 10.55, the system main interface of the "menu bar" option "Exit system" options will exit the system.

(13) Other operating readers can learn by themselves, no longer repeat here.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.