½â¾öaccess¼¶Áª¸üÐÂÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ON UPDATE CASCADE)
·¢ÉúÔ¼Êø´íÎó

µ«ÊÇ
CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)£©¿ÉÒÔÔËÐÐ

ÔËÐл·¾³£ºsun.jdbc.odbc.JdbcOdbcDriver"

Çë¸ßÈËÖ¸½Ì~½â¾öaccess¼¶Áª¸üÐÂÎÊÌâ

---

ÄãµÄPC±íÖÐ model ÊDz»ÊÇÖ÷¼ü»òË÷Òý£¿

---

String queryx="create table PC(model integer, speed integer, ram integer, hd integer, price integer,CONSTRAINT CHINA PRIMARY KEY (model))";
   
String query="CREATE TABLE Product(model integer, maker varchar(20), CONSTRAINT SAND PRIMARY KEY (model), CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) ON DELETE CASCADE ON UPDATE CASCADE)";
   
  s.executeUpdate(queryx);
  s.executeUpdate(query);


ÎÊÌâÔÚÓÚON DELETE CASCADE ON UPDATE CASCADE¡£ºÃÏñ²»ÄÜÕâÑùд~Ë­Óо­Ñé½â¾öÒ»ÏÂ~

s¾ßÌåÄÚÈÝÊ¡ÂÔ..

---

ÄãÊÇͨ¹ýODBCÁ¬½ÓMDBµÄ£¿