½ñÌìÎÒÓÃpl/sqlÍùoracleÖвåÈëÊý¾ÝµÄÊÇʱºò£¬²»ÖªµÀΪʲôÊý¾Ý×ÜÊÇĪÃûµÄ»áÔÚij¸öµØ·½Í£Ö¹¡£
ÎÒµ¼ÈëµÄÊDZðÈ˵¼³öµÄsqlÓï¾ä¡£
Ëûµ¼³öµÄ¶¼ÊÇsql£¬ËùÒÔÎÒÖ±½Ó´ò¿ªµÄpl/sql£¬ÃüÁî´°¿Ú£¬Ö±½Ó°ÑËûµ¼³öµÄsqlÓï¾äÖ±½Ó¸´ÖÆÕ³Ìù¡£
ÎÒ¾õµÄÕâÖÖ·½·¨Ã»ÓÐ´í°¡£¬ÎªÊ²Ã´ÕâÑù˵ÄÇ£¬Ö÷ÒªÊÇ£¬ÉÏÖܵÄʱºòÒ²ÊÇÕâôµ¼ÈëµÄ¾ÍûÓÐÊÂÇé¡£
......
ORACLE´æ´¢¹ý³ÌÖдò¿ªÁËÊý¾Ý¿âÓα꣬ADOµÄRECORDSET¶ÔÏ󹨱ÕÈ´²»ÄܹرÕÊý¾Ý¿âÓα꣬Õâµ¼ÖÂÔÚÊý¾Ý¿âµÄÒ»¸öSESSIONÖÐÓαê´ò¿ªÊýÒ»Ö±ÉÏÕÇ×îÖÕ³¬¹ýÉ趨ÉÏÏÞ¡£
ÓÐÁ½¸öÎÊÌ⣺
1. ÔÚÓÎÏ··þÎñÆ÷Öб£³ÖÒ»¸öÊý¾Ý¿âÁ¬½ÓÊÇ·ñºÏÊÊ£¿
2. Èç¹û1´ð°¸Îª¿Ï¶¨£¬ADOÈç¹ûÀ´¹Ø±ÕÊý¾Ý¿âÓαꣿ
1.¿ÉÒÔÁ¬½ÓÒ»¸ö·þÎñÆ÷
2.ÔÚ¹ý³ÌÀï¹Ø± ......
Java code:
hql = "from Position p where p.tpId= '"+postId+"'";
ºÜ¼òµ¥µÄÒ»¸öhqlÓï¾ä¶¼»á±¨´í£¬Ö»ÊÇ»»ÁËÒ»ÏÂÊý¾Ý¿â£¬±¨ÈçÏ´íÎó£º
Java code:
18:46:32,562 ERROR JDBCExceptionReporter:72 - ¹Ø¼ü×Ö 'where' ¸½½üÓÐÓï·¨´íÎó¡£
org.springframework.orm.hibernate3.HibernateJdbc ......
550016~"34jh4"~"0324100123000276"~"01"~"123456ÍÅ
ÒÔÉÏÊÇÎı¾µ¼ÈëÊý¾Ý ²»Òª·ûºÅ
¿ØÖÆÎļþ
load data¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
infile 'ddd.txt'¡¡¡¡¡¡¡¡¡¡¡¡
append into ......
550016~"34jh4"~"0324100123000276"~"01"~"123456ÍÅ
ÒÔÉÏÊÇÎı¾µ¼ÈëÊý¾Ý ²»Òª·ûºÅ
¿ØÖÆÎļþ
load data¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
infile 'ddd.txt'¡¡¡¡¡¡¡¡¡¡¡¡
append into t ......
VC¿ª·¢SQL SERVERµÄÓ¦ÓóÌÐòÎÒÓÃADO
VC¿ª·¢MySQLµÄÓ¦ÓóÌÐòÎÒÓà MySQLµÄ¿ª·¢°ü£¬×°ÉÏÖ®ºó£¬ÔÚVCÀïÉèÖÃһϷ¾¶¾ÍÄÜ¿ª·¢ÁË
¾Í¸úVCÀïÉèÖÃSDK·¾¶Ò»Ñù
µ«ÊÇÎÒÏÖÔÚÒªÓÃVC¿ª·¢OracleµÄÓ¦ÓóÌÐò£¬ÔÚÍøÉÏËÑÁËËÑ£¬´ó²¿·Ö¶¼ËµÊÇÓÃODBC£¬
ÎÒʵÔÚ²»ÏëÓÃODBC£¬Îҷdz£ÏëÓÃÏñMySQL ÄÇÑùµÄ¿ª·¢°ü¡£
ËùÒÔÎÒµÄÎÊÌâ¾ÍÊÇOracleÓÐûÓÐÕâÑùµ ......