A£¬ id, attributes
1£¬ 1001,12;1002,45
2, 1002,14;1003,54
B, id,name
1001,ÎÞµÐ
1002£¬Èõ
1003£¬Ç¿º·
AÖÐattributes×Ö¶ÎÊÇÓжà¸öBÊý¾Ý±íµÄidºÍÖµ×é³ÉµÄ£¬
ÏÖÔÚÎÒÏëÔÚselect,µÄʱºò°ÑËûµÄnameºÍÖµÒ»ÆðÏÔʾ£»
1£¬ÎÞµÐ,12;Èõ,45
2, Èõ,14;Ç¿º ......
ÎÒÓÐusers±í£¬ÀïÃæÓÐuserid,username£¬pwdµÈÁÐ,Õâ¸ö±íÀïÓкܶàÌõÊý¾ÝÁË
ÏÖÓÐtuijian±í£¬ÀïÃæÓÐtuijianid,zhuceid,zhucenameµÈÁУ¬Õâ¸ö±íÊÇÐÂ±í£¬ÎÞÊý¾Ý
ÏÖÔÚÎÒÏ뽫users±íÖеÄuserid,username(ÕâÁ½ÁеÄËùÓÐÖµ)ÕâÁ½¸öÁеÄÊý¾Ý¸´ÖƵ½tuijian±íÖеÄzhuceid,zhucename
ÇëÎʸÃSQLÓï¾äÔõôд°¡
SQL code:
insert tuijian(zh ......
ÎҵıíΪ£ºtesttable
×Ö¶ÎΪ£ºid int not,name decimal(10,2);
²åÈëµÄ²âÊÔÊý¾ÝΪ£º
1,10.2
SQLQuery query = con.createSQLQuery("select * from testtable");
List products = query.list();
±¨´íÈçÏ£º
2010-5-20 15:18:17 org.apache.catalina.core.StandardWrapperValve invoke
ÑÏÖØ: Servlet.servic ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
·½·¨2£º
ͨ¹ýÑ»·100´Î£¬Ã¿´ÎÖ´ÐÐÒ»¸öNameÌõ¼þ£¬Ö´ÐÐ100¸öSQLÓï¾ä
Select * from tmp_table where Name=' ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²×°¡£¡£¡£¡£
¸Õ°²×°ÁËMSsql2005°ÑÏÂÏÂÀ´µÄMDFµ¼ÈëÁË¡£¡£Ð»Ð»°¡
......
±àдPL/SQL³ÌÐò¿éShowInfo£¬¸ø¶¨Ò»¸öÔ±¹¤ºÅ¾Í¿ÉÒÔÏÔʾÆäÐÕÃû¡¢ÐÔ±ðµÈÐÅÏ¢,
Èç¹û¸ÃÔ±¹¤²»´æÔÚÔòÏÔʾ¡®¶Ô²»Æð£¬Ã»ÓдËÔ±¹¤£¡¡¯
ÇëÎÊÉÏÃæÕâµÀÌâÕâôд£¿£¿¸Õѧoracle¶ÔºÜ¶à¶¼²»ÊǺܶ®£¬Ï£ÍûÄܹ»Ïêϸ½âÊÍ£¡Ð»Ð»
if(v is not null)then
dbms_output.put_line('¸ÃÔ±¹¤²»´æÔÚ');
Õâ¸öÎÊÌâ¼ÇµÃǰ¼¸ÌìÓÐÈËÎʹý
×Ô¼ ......