JAVAͨ¹ýODBCÁ´½ÓSQL SERVER
/**
* @author ºýÍ¿¹í
* ÔÚ½¨Á¢Á¬½Ó֮ǰÐèҪһЩ׼±¸¹¤×÷£º
* ÔÚ¿ØÖÆÃæ°åÉÏͨ¹ý“¹ÜÀí¹¤¾ß”µÄ“Êý¾ÝÔ´(ODBC)”´ò¿ª“ODBCÊý¾ÝÔ´¹ÜÀíÆ÷”¶Ô»°¿ò£¬
* µ¥»÷“ϵͳDSN”Ñ¡Ï£¬È»ºóµ¥»÷“Ìí¼Ó”°´Å¥£¬µÃµ½“´´½¨Êý¾ÝÔ´”¶Ô»°¿ò£¬
* Ñ¡Ôñ“SQL Server”²¢µ¥»÷“Íê³É”°´Å¥£¬
* ÔÚ³öÏֵ罍Á¢ÐµÄÊý¾ÝÔ´µ½SQL Server”¶Ô»°¿òÖеēÊý¾ÝÔ´Ãû³Æ”ÏîÌîд“liltos”²¢Ñ¡È¡“·þÎñÆ÷Ãû”£¬
* È»ºóµ¥»÷“ÏÂÒ»²½”°´Å¥£¬Ñ¡Ôñ“ʹÓÃÍøÂçµÇ¼IDµÄWindows NTÑéÖ¤”ÏîÄ¿£¬
* µ¥»÷“ÏÂÒ»²½”°´Å¥£¬°ÑĬÈϵÄÊý¾Ý¿â¸ÄΪ“Northwind”£¬ÔÙµ¥»÷“ÏÂÒ»²½”£¬
* µ¥»÷“Íê³É”°´Å¥£¬È»ºó¿ÉÒÔµ¥»÷“²âÊÔÊý¾ÝÔ´”£¬³É¹¦ºó£¬µ¥»÷“È·¶¨”°´Å¥£¬
* Íê³ÉÁË(ODBC)Êý¾ÝÔ´ºÍÇý¶¯³ÌÐòµÄ½¨Á¢¡£
* °Ñµ¼ÈëµÄ°üÊ¡ÂÔÁË£¡
*/
public class First {
public static void main(String[] args) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager
.getConnection("jdbc:odbc:liltos_Region");
Statement sql = con.createStatement();
&nbs
Ïà¹ØÎĵµ£º
SQL UNION ²Ù×÷·û
UNION ²Ù×÷·ûÓÃÓںϲ¢Á½¸ö»ò¶à¸ö SELECT Óï¾äµÄ½á¹û¼¯¡£
Çë×¢Ò⣬UNION ÄÚ²¿µÄ SELECT Óï¾ä±ØÐëÓµÓÐÏàͬÊýÁ¿µÄÁС£ÁÐÒ²±ØÐëÓµÓÐÏàËÆµÄÊý¾ÝÀàÐÍ¡£Í¬Ê±£¬Ã¿Ìõ SELECT Óï¾äÖеÄÁеÄ˳Ðò±ØÐëÏàͬ¡£
SQL UNION Óï·¨
SELECT column_name(s) from table_name1
UNION
SELECT column_name(s) from table_na ......
Ó¦Óû·¾³¾ÍÊdzÌÐòÔÚÁ½¸öµØµãÔËÐеģ¬Á½±ß¶¼Òª²Ù×÷ÐÞ¸ÄÊý¾Ý£¬Á½µØÍ¨¹ý²¦ºÅÁ¬½Ó£¬ÊÇÓÃsql2000·½±ã£¬»¹ÊÇ2005·½±ã£¬ÓÃ2̨»úÆ÷¾Í¿ÉÒÔ»¹ÊÇ3̨»úÆ÷£¬Óô¥·¢Æ÷»¹ÊDZðµÄ·½·¨ÊµÏÖ£¿SQL codeÒÔÏÂʵÏÖ¸´ÖƲ½Ö裨ÒÔ¿ìÕÕ¸´ÖÆÎªÀý£©
ÔËÐÐÆ½Ì¨SQL SERVER 2005
Ò»¡¢×¼±¸¹¤×÷£º
1£®½¨Á¢Ò»¸ö WINDOWS Óû§£¬ÉèÖÃΪ¹ÜÀíԱȨÏÞ£¬²¢ÉèÖÃÃÜ ......
SQLÓï¾äÓÅ»¯¼¼Êõ·ÖÎö
·Ò룺Jerry [2005-11-11]
ÔÎijö´¦£ºhttp://www.51testing.com
ÔÎÄ×÷Õߣº²»Ïê
×ªÔØÇë×¢Ã÷£ºÀ´×ÔSawinϵͳ·ÖÎöÖ®´°
²Ù×÷·ûÓÅ»¯
IN ²Ù×÷·û
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ×¶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£
µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵쬴ÓORACLEÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃI ......
Ê×ÏÈÅäÖÃSQLSERVER2005£º
´ò¿ª”Microsoft SQL Server Management Studio“Ö±½ÓÓÃWindows Óû§Á¬½Ó½øÈ룬ÔÙÔÚ“°²È«ÐÔ”ÖеēµÇ¼Ãû”Äڵēн¨µÇ¼Ãû”£¬Äã¾Í¶ÔÓ¦µÄÌíºÃ“È·¶¨”¾Í¿ÉÒÔÁË¡£
ÔÙÔÚÄã¶ÔÓ¦µÄ“Êý¾Ý¿â”Àï“°²È«ÐÔ&r ......