ÉÏÖÜÒ»java µÄʧÀûÁË£¬ËäÈ»»¹Ã»Õýʽ¿ªÕâÃſΣ¬µ«ÎÒÒ²×ÔѧÁË°ëÄ꣬Õâ´ÎµÄʧÀûÈÃÎÒÉî¿ÌÈÏʶÁË×Ô¼ºËù´æÔڵIJ»×㡣ΪÒÔºóѧϰÁôÏÂÁ˱¦¹óµÄ¾Ñé¡£Ê컰˵£º¡°²»È뻢Ѩ£¬Ñɵû¢×Ó¡±¡£
ºóÌ죬ÎÒÒªÔÙÒ»´ÎÈ¥±±´ó¡£Õâ´Î¿¼SQL SERVER2000 £¬Í¬Ñù£¬ÕâÃÅ»¹Ã»Ñ§Í꣬Æäʵ£¬ÊǸտªÊ¼Ñ§¡£Ñ§µ½Á˵ÚÈýÕ¹ØϵģʽÉè¼ÆÔÀí £¬ ËäȻûÓбØʤµÄÐÅÐÄ¡£µ«ÎһᾡÎÒÈ«Á¦¡£³åÆÆ×îºóÒ»µÀ·À»ðÏß¡£¾¹ýÕâÁ½ÌìµÄ²ÙÁ·£¬ÎÒ×ܽ᣺¿¼Êý¾Ý¿âÆäʵÓо÷ÇÏ¡£¿´¿´ÀúÄ꿼Ìâ¾Í»á¾ªÆæµÄ·¢ÏÖÿÄêµÄÀàÐͺÜÏñ¡£ËäÈ»£¬Ã¿´Î¿¼ÊÔÄÚÈݶ¼²»Ò»Ñù£¬µ«ÎÞ·ÇÒ²¾ÍÊÇÏÂÃ漸ÖÖ¿¼ÊÔÌâÐÍ£º
1£¬½¨±í ÉèÖÃÖ÷¼ü Íâ¼ü ʵÌåÀàÐÍ ÓÐÎÞ·µ»ØÖµ
2£¬Íù±íÀïÌîÊý¾Ý £¨ÕâÀïÓкܶàСµÄϸ½Ú£©
3£¬SQL ²éѯ ÆäÖаüº¬ÈýСÌâ £¬Ã¿Ò»Ð¡ÌâÓв»Í¬µÄ·½Ê½¡£
4£¬Ð޸ļǼ
5£¬É¾³ý¼Ç¼
6£¬ÓÎ±ê ¿ÉÄÜÕâ¶ÔÎÒÀ´ËµÄã×îÓÐÌôÕ½Ð﵀ ÒòΪÎÒ¸ù±¾¾Í²»¶®Óαꡣ¶ÔÎÒÀ´ËµÊÇÄѵ㣬µ«¶Ô±ðÈË¿ÉÄܾͺÜÈÝÒס£ÎÒ¸ù±¾¾Íûѧ¹ý¡£²»¹ý»¹ÓÐÀ뿼ÊÔ»¹ÓÐ26Сʱ£¬ÎÒ»¹ÓÐʱ¼ä£¬ÕâÊÇÎÒ½ÓÏÂÀ´ÒªÑ§µÄÖص㡣Óαê×öµÄºÃ²»ºÃÊÇÅжÏÄãÄÜ·ñµÃÓŵĹؼü¡£½ñÍíÁ·Ï°ÁËÕâµÀÌ⣺
create table e191_sporter( sno char (5) primary key,
sname varchar (20) not null,
sex char (2) ,
dname varchar (20) not null)
go
create table e191_project( pno char(5) primary key ,
pname varchar(20) ,
address varchar (20) )
go
create table e191_grade ( sno char(5),
pno char(5),
credit tinyint null ,
check(credit in(6,4,2,0)),
primary key (sno,pno),
foreign key(sno) references e191_sporter(sno),
foreign key(pno) references e191_project(pno))
go
insert into e191_sporter values('1001','ÀîÃ÷','ÄÐ','¼ÆËã»úϵ') ;
insert into e191_sporter values('1002','ÕÅÈý','ÄÐ','Êýѧϵ') ;
insert into e191_sporter values('1003','ÀîËÄ','ÄÐ','ÎïÀíϵ') ;
insert into e191_sporter values('1004','Íõ¶þ','ÄÐ','ÎïÀíϵ') ;
insert into e191_sporter values('1005','ÀîÄÈ','Å®','Êýѧϵ') ;
insert into e191_sporter values('1006','ËïÙ³','Å®','Êýѧϵ') ;
insert into e191_project values('x001','ÄÐ×ÓÎåǧÃ×','Ò»²Ù³¡') ;
insert into e191_project values('x002','ÄÐ×Ó±êǹ','Ò»²Ù³¡') ;
insert into e191_project values('x003','ÄÐ×ÓÌøÔ¶','¶þ²Ù³¡') ;
insert into e191_project values('x004','Å®
UNION½«Á½¸ö»òÁ½¸öÒÔÉϵIJéѯ½á¹ûºÏ²¢ÎªÒ»¸ö½á¹û¼¯£¬ËüÓëʹÓÃÁ¬½Ó²éѯºÏ²¢Á½¸ö±íµÄÁÐÊDz»Í¬µÄ£¬Ê¹
ÓÃUNIONºÏ²¢²éѯ±ØÐë×ñÊØ£º1ÁеÄÊýÄ¿ºÍ˳Ðò±ØÐëÒ»Ö£»2Êý¾ÝµÄÀàÐͱØÐë¼æÈÝ¡£
select Óï¾ä
UNION [all]
select Óï¾ä
¿ÉÒÔ¿´µ½£¬Ö»Òª¶ÔÓ¦×ֶεÄÀàÐÍÏàͬ¾Í¿ÉÒÔÍê³ÉºÏ²¢²Ù×÷£¬µ«ÊÇΪÁËÓÐÒâÒ壬Á½¸ö²éѯµÄ½á¹ûÓ¦¸ÃΪÏàͬ
µ ......
Oracle SQL Developer ÊÇÒ»¸öÃâ·ÑµÄͼÐλ¯Êý¾Ý¿â¿ª·¢¹¤¾ß¡£Ê¹Óà SQL Developer£¬Äú¿ÉÒÔä¯ÀÀÊý¾Ý¿â¶ÔÏó¡¢ÔËÐÐ SQL Óï¾äºÍ SQL ½Å±¾£¬²¢ÇÒ»¹¿ÉÒԱ༺͵÷ÊÔ PL/SQL Óï¾ä¡£Äú»¹¿ÉÒÔÔËÐÐËùÌṩµÄÈκÎÊýÁ¿µÄ±¨±í£¬ÒÔ¼°´´½¨ºÍ±£´æÄú×Ô¼ºµÄ±¨±í¡£SQL Developer ¿ÉÒÔÌá¸ß¹¤×÷ЧÂʲ¢¼ò»¯Êý¾Ý¿â¿ª·¢ÈÎÎñ¡£
SQL Developer ¿ÉÒÔÁ¬½Óµ½È ......