tables.isql.def.unix

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

/* table definitions for the stain schema... */

/* make sure you have a database called javadb */

use javadb
GO

DROP TABLE item
DROP TABLE stain
DROP TABLE stainxrf
DROP TABLE type
GO

CREATE TABLE item
	(it_id int, it_name char(40), it_ty_id_ int)
CREATE TABLE stain
	(st_id int, 
	 st_name char(20))
CREATE TABLE stainxrf
 	(sx_st_id_ int, 
	 sx_it_id_ int)
CREATE TABLE type
 	(ty_id int, 
	 ty_name char(20))
GO

INSERT INTO item (it_id, it_name, it_ty_id_)
   VALUES (1, 'Handknit Sweater', 1)
INSERT INTO item (it_id, it_name, it_ty_id_)
   VALUES (2, 'Couch', 2)
INSERT INTO item (it_id, it_name, it_ty_id_)
   VALUES (3, 'Teddy Bear', 3)
INSERT INTO item (it_id, it_name, it_ty_id_)
   VALUES (4, 'Silk Tie', 1)
GO

INSERT INTO type
   (ty_name, ty_id)
   VALUES ('Clothing', 1)
INSERT INTO type
   (ty_name, ty_id)
   VALUES ('Furniture', 2)
INSERT INTO type
   (ty_name, ty_id)
   VALUES ('Faithful Companion', 3)
GO

INSERT INTO stain
   (st_name, st_id)
   VALUES ('Merlot', 1)
INSERT INTO stain
   (st_name, st_id)
   VALUES ('Jelly', 2)
INSERT INTO stain
   (st_name, st_id)
   VALUES ('Coffee', 3)
INSERT INTO stain
   (st_name, st_id)
   VALUES ('Ketchup', 4)
INSERT INTO stain
   (st_name, st_id)
   VALUES ('Unknown', 5)
GO

INSERT INTO stainxrf
   (sx_st_id_, sx_it_id_)
   VALUES (1, 1)
INSERT INTO stainxrf
    (sx_st_id_, sx_it_id_)
    VALUES (2, 1)
INSERT INTO stainxrf
    (sx_st_id_, sx_it_id_)
    VALUES (3, 1)
INSERT INTO stainxrf
    (sx_st_id_, sx_it_id_)
    VALUES (4, 2)
INSERT INTO stainxrf
   (sx_st_id_, sx_it_id_)
   VALUES (3, 2)
INSERT INTO stainxrf
   (sx_st_id_, sx_it_id_)
   VALUES (5, 2)
INSERT INTO stainxrf
   (sx_st_id_, sx_it_id_)
   VALUES (2, 3)
INSERT INTO stainxrf
   (sx_st_id_, sx_it_id_)
   VALUES (3, 3)
INSERT INTO stainxrf
   (sx_st_id_, sx_it_id_)
   VALUES (2, 4)
INSERT INTO stainxrf
   (sx_st_id_, sx_it_id_)
   VALUES (4, 4)
GO