schema.sql

有关JDBC的使用一些编程实例,有关与数据库连接的代码

#
# create a simple cardfile file

# just in case it already exists, drop the table. If it doesn't
# exist, this will produce an error...
#
drop table cardfile
\g

create table cardfile
   (name    char(20),
    address char(35),
    city    char(20),
    state   char(2),
    zip     char(11),
    country char(25),
    phone   char(20),
    id      int) 
\g
   
CREATE UNIQUE INDEX ix_id ON cardfile (id)
\g