sql serverÓëoracleÊý¾Ý¿âÁ¬½á³ö´íÎÊÌâ
´íÎó:
Á´½Ó·þÎñÆ÷"YBERP1"µÄ OLE DB ·ÃÎÊ½Ó¿Ú "MSDAORA" ·µ»ØÁËÏûÏ¢ "δÕÒµ½ Oracle ¿Í»§¶ËºÍÍøÂç×é¼þ¡£ÕâЩ×é¼þÊÇÓÉ Oracle ¹«Ë¾ÌṩµÄ£¬ÊÇ Oracle 8i °æ (»ò¸ü¸ß) ¿Í»§Èí¼þ°²×°µÄÒ»²¿·Ö¡£
ÔÚ°²×°ÕâЩ×é¼þ֮ǰ£¬½«ÎÞ·¨Ê¹ÓôËÌṩ³ÌÐò¡£"¡£
ÏûÏ¢ 7303£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
ÎÞ·¨³õʼ»¯Á´½Ó·þÎñÆ÷ "YBERP1" µÄ OLE DB ·ÃÎÊ½Ó¿Ú "MSDAORA" µÄÊý¾ÝÔ´¶ÔÏó¡£
˵Ã÷:ÎÒÒѰ²×°ÁËoracle¿Í»§¶Ë,ÇÒ¿Í»§¶Ë²âÊÔÊdzɹ¦µÄ.
ÊǵÄ
²¹³ä˵Ã÷ÏÂ,ϵͳΪwindows server2003°æ,oracle¿Í»§¶Ë¿ÉÒÔÕý³£Ê¹ÓÃ.
Ôõô²âÊÔ°¡?
Èç¹û˵ÄãÔ¶³ÌÁ¬½Óoracleʧ°ÜµÄ»°
ÓÃsqlÁ¬½ÓoracleÄÇô¿Ï¶¨»áʧ°ÜµÄ
<
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......