20-CS-694 Advanced Programming Techniques Spring 2012
JDBC

Interfaces, Exceptions, Graphics, Animation, Threads, Reflection, Networking, RMI, JDBC, JNI

     Previous      Next      PostgreSQL Docs      MySQL Docs      All lectures

Set Up a Table

The table COFFEES

Includes coffee names, their prices, the number of pounds sold the current week, and the number of pounds sold to date.

COF_NAME

SUP_ID

PRICE

SALES

TOTAL

Colombian

101

7.99

0

0

French_Roast

49

8.99

0

0

Espresso

150

9.99

0

0

Colombian_Decaf

101

8.99

0

0

French_Roast_Decaf 

49

9.99

0

0

COF_NAME:  SQL type: VARCHAR, maximum length: 32 characters, Primary Key.

SUP_ID:  SQL type: INTEGER.

PRICE:  SQL type: FLOAT (for compatibility over many DBMSs and JDBC - normally in SQL type DECIMAL or NUMERIC)

SALES:  SQL type: INTEGER

TOTAL:  SQL type: INTEGER

The table SUPPLIERS

SUP_ID

SUP_NAME

STREET

CITY

STATE

ZIP

101

Acme, Inc.

99 Market Street 

Groundsville 

CA

95199

49

Superior Coffee

1 Party Place

Mendocino

CA

95460

150

The High Ground 

100 Coffee Lane

Meadows

CA

93966