ÔõÑù²ÅÄÜʵÏÖÅÅÐòÓÅ»¯µÄ²ã´Î¹Øϵ±íÉè¼Æ_SQL¼¼ÇÉ
Êý¾Ý²ã´ÎµÄ¸ÅÄî:
Êý¾Ý²ã´ÎÊDZí´ïÊý¾ÝµÄÒ»ÖÖÖØÒª¹Øϵ£¬ÔÚÊý¾Ý¿âµÄÉè¼ÆÖУ¬È磺×éÖ¯½á¹¹·Ö½â¡¢¹¤×÷ÈÎÎñ·Ö½â¡¢ÐÐÕþÇø»®µÄ·Ö½âµÈ¶¼ÊDzã´Î¹ØϵÊý¾ÝµÄµäÐÍʵÀý¡£
±í´ï²ã´Î¹ØϵµÄÊý¾ÝÒ»°ãÐèҪʵÏÖÈçÏÂÊôÐÔ£º
1.²ã´ÎµÄ×î´ó¼¶Áª²ã´ÎÊý¡£È磺Öйú£>ºþÄÏÊ¡->³¤É³ÊÐ->Ó껨Çø£¬¾ÍÊÇ4²ã¡£
2.ÄÜ·´Ó³Í¬Ò»²ã´ÎÖ®¼äµÄ˳Ðò¹Øϵ¡£È磺³¤É³ÊÐ ±ØÐëÔÚ ºâÑôÊеÄÇ°Ã棬£¨ÒòΪÆäÊÇÊ¡»á£©¡£
3.ÄÜ»ñÈ¡ÈÎÒâ²ã´ÎµÄ¸¸½Úµã¼¶×ӽڵ㣨×ӽڵ㼯£©¡£
4.Ö±½Ó»ñÈ¡ÈÎÒâ²ã´ÎµÄÊý¾Ý¡£±ÈÈ磺µÚÈý²ã Ê춱ðµÄÊý¾Ý¡£
5.ÄÜ·½±ã¹¹Ôì²ã´Î¹Øϵ±í´ïÊ÷¡£
6.²ã´Î½á¹¹¼°ÅÅÐò·½Ê½µÄ¸Ä±ä²»Ó°ÏìÆäÆäËûÊý¾ÝµÄÄÚ²¿Âß¼¹Øϵ¡£
Ò»°ãÓÐÈýÖÖ·½Ê½À´±íÏÖ²ã´Î¹ØϵµÄÊý¾Ý£º
1.½¨Á¢¶à¸öÊý¾Ý¿â±í£º
È磺 COUNTRY: ID(Ö÷¼ü) COUNTRY_NAME
PROVINCE: ID(Ö÷¼ü) COUNTRY_ID£¨Íâ¼ü£©,PROVINCE_NAME
CITY: ID(Ö÷¼ü), PROVINCE_ID£¨Íâ¼ü£©,CITY_NAME
´ËÖÖ·½Ê½±È½Ï¼òµ¥£¬µ«Éè¼ÆµÄÁé»îÐÔ²»¹»£¬Êý¾Ý´¦ÀíÆðÀ´±È½ÏÂé·³¡£
2.²ÉÓñíµÄ×Ô¹ØÁªÍâ¼üÒýÓÃ
È磺 DISTRICT_INFO: ID£¨Ö÷¼ü£©,PARENT_ID,£¨Íâ¼ü£©DISTRICT_INFO
ͨ¹ýÍâ¼ü(PARENT_ID)µÄ×ÔÉíÒýÓÃÖ÷¼ü(ID)À´È·Á¢²ã´Î¹Øϵ¡£
Óŵ㣺ÎÞÏÞ¼¶±ðµÄ²ã´Î¹Øϵ£¬À©³äÐÔÇ¿¡£¶ÔÓÚOracleÊý¾Ý¿âÀ´Ëµ£¬Äܼòµ¥Í¨¹ý Start With,,,Connect By--Óï¾äÀ´ÊµÏÖÊý¾ÝµÄ²éѯ¡£
ȱµã£º²»ÄÜÃ÷È·¿´³ö²ã´Î¹Øϵ£¬ÎÞ·¨ÊµÏÖÅÅÐò¡£
3.²ÉÓñàÂ뷽ʽÀ´ÊµÏÖ²ã´Î
DISTRICT: ID,CODE,NAME ÆäÖÐCODEµÄÌصãÊÇÉϼ¶±àÂëÊÇϼ¶±àÂëµÄǰ׺
Óŵ㣺ͨ¹ý±àÂëµÄÄÚÈÝÄܹ»ºÜÈÝÒ×»ØÈ¥Êý¾ÝµÄ²ã´Î¹Øϵ¡£
ȱµã£ºÊ¹ÓÃLike·½·¨»òº¯Êý²éѯÀ´ÊµÏÖ×Ó¼¯µÄ²éÕÒ£¬Ð§Âʽϵͣ¬ÄÜʵÏÖ²ã´Î¹ØϵµÄ¼¶ÊýÓÐÏÞ£¨ÊÜCODEµÄ×ֶ㤶ÈÓ°Ï죩¡£
ÓÅ»¯·½°¸£º
¼¯ºÏ2£¬3µÄÓŵ㣬²ÉÓù̶¨±àÂ뼶´ÎµÄ³¤¶ÈµÄ·½·¨À´Éè¼Æ±í¡£
DISTRICT:ID,CODE,PARENT_ID,NAME
ÆäÖÐIDΪÖ÷¼ü£¬CODE:¹æ¶¨Îª4λһ¼¶¡£±íÏÖµÄÊý¾ÝÈçÏ£º
ID,CODE PARENT_ID, NAME
1 0001 Öйú
2 00010001 1 ºþÄÏ
3 000100010001 2 ºâÑô
4 000100010002 2 ³¤É³
5 0001000100020001 4 Ó껨
´ÓÊý¾ÝÖпÉÒÔ¿´³ö£¬PARENT_ID¿ÉÒÔÖ±¹Û±í´ï²ã´ÎµÄÉÏϼ¶¹Øϵ
¶ø±àÂëCODE¿ÉÒÔÖ±¹Û±í´ï²ã´Î¹ØϵÓëͬһ²ã´ÎµÄ˳Ðò¹Øϵ¡£
Ïà¹ØÎĵµ£º
/*Á½ÖÖ·½·¨µÄÇ°Ì᣺1.±¾µØ·þÎñÆ÷µÄsqlserver agent·þÎñ±£Ö¤´¦ÓÚÆô¶¯×´Ì¬
2.Ô¶³Ì¼ÆËã»ú£¨¼ÆËã»ú¹ÜÀíÀ½¨Á¢Ò»¸öÆÕͨȨÏÞÓû§£¬²¢ÎªÆä¼ÓÉÏÃÜÂ루ÀýÈçÓû§ÃûΪkyle£¬ÃÜÂëΪ1234£©£¬Í¬Ê±ÔÚÄÇ̨»úÆ÷µÄ·ÇϵͳÅÌÀィһ¸öÃûΪbackupµÄ¹²ÏíÎļþ¼Ð£¬ÎªÁË°²È«ÁíÍâÉèÖÃÕ ......
//±¾³ÌÐòÁ¬½ÓµÄÊÇsql server 2005£¬ÓëÁ¬½Ósql server 2000Óе㲻ͬ£ºdriverNameºÍURL¶¼²»Í¬
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class create{
public void getConnection() th ......
±êÇ©£ºÊý¾Ý·ÃÎÊ ADO.NET
µ÷ÓÃSQL´æ´¢¹ý³Ì ´æ´¢¹ý³ÌÔÚÒ»¸öµ¥ÔªÖзâ×°Á˸´ÔÓµÄSQL²éѯºÍÊý¾Ý¹ý³Ì£¬¿ÉÒÔÓɶà¸ö³ÌÐò»òÓû§Ö®¼äµ÷Óá£
Àý£º
......
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄǾÍÐèҪѡÔñ½»²æ±í(intersectio ......