Getting started with database series-tips 3_MySQL-mysql tutorial

Author: think about it: below the South China Sea, I also prepared a database dinner for all netizens. this is the ClientServer structure programming example under MS-SQLServer: MS-SQLSERVER is a medium-sized relational database management system produced by Microsoft, it has the following characteristics: the customer server system structure graphical user interface, make the system management more author: Thinking: Nanhai

Next, I have prepared a database dinner for all netizens.

Client/Server schema programming example under MS-SQL Server:

MS-SQL SERVER is a medium-sized relational database management system produced by Microsoft. it has the following features:

Customer/server architecture
The graphical user interface makes the system management more intuitive and simple.
A wide range of programming interfaces provide users with more options for application design.
Integrated with the Windows NT operating system and multi-threaded architecture design improve the system's concurrent access speed to users.
The support for Web technology enables users to easily publish data in databases to the Internet.
Price advantages. Compared with other large database systems such as Oracle and Sybase, SQL Server is very inexpensive.
Because the SQL Server database management system is a little prominent, more and more users are there. This article describes some methods and experiences of using SQL Server (taking SQL Server6.5 as an example ).

1. system installation

SQL Server is required to be installed on the Windows NT operating system platform. it can run with NT in a microprocessor environment with different architecture such as Intel x86, Alpha AXP or MIPS. The minimum requirements for the system memory and hard disk space are 16 MB and 96 MB. During the installation, start the setup.exe program under the i386directory on the optical disk, and install the system easily according to the prompts of the installation program.

During the installation process, the system mainly generates system tools such as SQL Enterprise Manager, SQL Web Assistant, ISQL_W, and SQL Books Online. SQL Enterprise Manager is the most important tool, it provides comprehensive operations and maintenance for the SQL Server database system.

After the system is installed, you can start the SQL Server service in the following ways:

Use the net start mssqlserver command to start the SQL Server service.
The system starts automatically.
Use the system management tool SQL Enterprise Manager or SQL Service Manager to start the Service.
Use the service options in the Windows NT control panel to start the SQL Server service.


II. database establishment

Select "new" from the database management window of SQL Enterprise Manager to bring up the "new database" dialog box (as shown in the following figure ). In this dialog box, enter the name of the new database, select the device used to store the database and its logs, and enter the space (in MB ), select the Create for Load check box as needed (this check box shows whether to Load data from a backup database to the new database), and then select the "OK" button to Create a new database.

In addition, you can use SQL statements to create databases:

Create database MyDataBase

[ON {DEFAULT | database_device} [= size]

[, Database_device [= size]…]

[Log on database_device [= size]

[, Database_device [= size]… ]

[For load]

The size is measured in MB.



3. create a table

Select DataBases> DataBaseName> Objects> Tables from the database management window of SQL Enterprise Manager. the create data table dialog box () is displayed ().

　　

In this dialog box, set the attribute name, data type, field length, whether it can be blank, and default value.

After setting, click the "storage" icon to complete Form storage.

4. use front-end development tools to program and manipulate databases

In this example, the front-end development tool uses Inprise Delphi4.0 to perform operations on the background database through the front-end program, which is also the standard structure of the Client/Server.

First, place some necessary controls on the Form of Delphi: DataBase, Table, DataSource, DBGrid, and DBNavigator. Here, the DataBase attribute is set to (the address of the DataBase server) (the DataBase username) (assume that the password is 123456)

Set the DataBaseName attribute of the Table to be the same as the DataBaseName attribute of the DataBase control. The TableName attribute is the database to be manipulated.

Set DataSet of the DataSource control to Table1 (Name of the Table control ). The DataSource attributes of DBGrid and DBNavigator are Performance1 (Name of the DataSource control ).

After the preceding settings, a simple program that can manipulate database forms is completed. the running interface of the program is as follows:

　　

The above implementation is based on the Client/Server structure of the database programming, in Windows NT 4.0 + ms SQL Server6.5 debugging through (PIII550, 256 M RAM ).

In addition, we also have a Browser/Server structure program design example based on MS-SQL Server, will be implemented in the future JSP/ASP lecture.

This is the end of this article. I wish you a pleasant stay!