ÔÚдһ¸öÄ£¿éµÄʱºò£¬²åÈëÊý¾ÝʱÐèÒªÁ¢¼´·µ»ØËù²åÈëµÄ£É£Ä£¬×Ô¶¯ÔöÁ¿ÐòÁм°´¥·¢Æ÷ÒѾȫ²¿Ð´ºÃ£¬ÔÚÍøÉϲéÁ˸ö·½·¨£º
ÔÚ²åÈëÒ»Ìõ¼Ç¼ºóÂíÉÏÖ´ÐÐÒ»ÏÂÏÂÃæµÄÓï¾ä¼´·µ»Øµ±Ç°²åÈëÊý¾ÝµÄID¡£
$query="select seq_atable.currval from dual";
££££££££££££££££££££££ÎÊÌâÊÇÕâ¾ä»°ÏêϸҪдÔڣã£ÄÇÀïµÄ£¿£¿$query²»ÊǣʣѣգţңÙÓï·¨Âð£¿
sf .......
CSDNÓиöºÃ´¦,¾ÍÊÇÈËÆøÍú,Óйý²»ºÃµÄµØ·½,¾ÍÊÇÈËÆø¹ýÍú,³ÁµÃ¿ì...ÎÊÌ⻹û½â¾ö,²»ÄܳÁ°¡,ÄÇλ´ó¸ç°ï°ïæÁË...
»¹ÓÐ ³ÁµÃ¿ì¸ú½áÌùÂÊÓйØ...
oracle ÀïµÄ insert Óï¾äÖ±½Ó¿ÉÒÔ returning ¸Õ²Å²åÈëµÄ×Ö¶Î
Èç¹ûÄãÖ»µ÷ÓõĴ洢¹ý³Ì¾Í¿ÉÒÔ°ÑÕâ¸öÖµ ÉèÖÃΪout
Ö±½Ó²éѯÐòÁв»¾Í¿ÉÒÔÁËô
ÒýÓà ֱ½Ó²éѯÐòÁв»¾Í¿ÉÒÔÁËôҪÊÇÓû§a¸Õ²åÈëÒ»Ìõ, ÔÚ²éѯÐòÁÐ֮ǰ, Óû§bÓÖ²åÁËÒ»Ìõ
ÇëÎÊ a ²éµ½µÄÐòÁÐÊÇ˵Ä?
ÒýÓà ÒýÓà 6 Â¥ strwangfan µÄ»Ø¸´: Ö±½Ó²éѯÐòÁв»¾Í¿ÉÒÔÁËô ÒªÊÇÓû§a¸Õ²åÈëÒ»Ìõ, ÔÚ²éѯÐòÁÐ֮ǰ, Óû§bÓÖ²åÁËÒ»Ìõ ÇëÎÊ a ²éµ½µÄÐòÁÐÊÇ˵Ä?number = ÐòÁÐ.nextval
INSERTINTO±íVALUES
(number, ×Ö¶ÎÖµ1,×Ö¶ÎÖµ2 ...);
number ¾ÍÊÇÓû§a²åÈëʱµÄÐòÁÐ
number = ÐòÁÐ.nextval
INSERTINTO±íVALUES
(number, ×Ö¶ÎÖµ1,×Ö¶ÎÖµ2 ...);
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»Öª ......