EVGA 123-LF-E653-KR - P55 LE Motherboard Manuel d'utilisateur télécharger pdf (Page 14)

Figure 4: The diagram above depicts the relationship between the three tables.

Database Queries

1) From customers.cs file, the following SQL insert statement is used to add members to

the members table:

"INSERT INTO Members " +

" (ID, FIRSTNAME, LASTNAME, ADDRESS, CITY, STATE, ZIPCODE,

PASSWORD, MEMBERTYPE) " +

" VALUES " +

" ('" + R(ID) +

"','" + R(firstName) +

"','" + R(lastName) +

"','" + R(address) +

"','" + R(city) +

"','" + R(state) +

"','" + zip +

"','" + R(password) +

"','" + R(memberType) + "')";

2) From orders.cs file, the following SQL insert statement is used to add orders in to the

orders table:

1 2 ... 9 10 11 12 13 14 15 16 17 18 19 20

Pas de commentaire

EVGA 123-LF-E653-KR - P55 LE Motherboard Manuel d'utilisateur Page 14