JDBCÁ¬½ÓSQLserverÎÊÌâ ÓôÃÆ~
ÓÖ³öÏÖ£ºcom.microsoft.sqlserver.jdbc.SQLServerException: ûÓÐΪ¼¯³ÉÉí·ÝÑéÖ¤ÅäÖÃÇý¶¯³ÌÐò¡£Õâ¸ö´íÁË ÉÏ´ÎÏ¡ÀïºýÍ¿µÄ¸øŪ³öÀ´ÁË £¬Õâ´ÎŪÁË°ëÌ춼ûÆ×£¬Õâµ½µ×ÊÇɶÔÒò£¡
×Ô¼ºÏȶ¥Ò»¸ö
ÊDz»ÊÇû´òsp3 ²¹¶¡°¡
.
ÊÇûÓÐSQLserverÇý¶¯³ÌÐòÂð
ÏÂÔØ£ºSQL Server 2000 SP3£¬Í¬Ñùµ½MicrosoftµÄÍøվȥÏÂÔØÉý¼¶°ühttp://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=zh-cn£¬ÏÂÔØÆäÖеÄchs_sql2ksp3.exe£¬×¢ÒâÏÂÔØÏÂÀ´µÄÊÇchs_sql2ksp3.exeÎļþ,Ë«»÷ËüÑ¡Ôñ°²×°µ½Ò»¸öĿ¼ʱÊÇÔÚ½âѹ,È»ºóÄ㻹Ҫµ½ÄǸöĿ¼ÏÂË«»÷setup.batÅú´¦ÀíÎļþ²ÅÊÇ¿ªÊ¼°²×°(Ó¦¸Ã˵ÊÇÉý¼¶)!!!¾ßÌåÏÂÔصØÖ·ÊÇ£ºhttp://download.microsoft.com/download/d/d/e/dde427eb-0296-4eac-a47c-d11a66b03816/chs_sql2kasp3.exe
~~~~~~~~~~~~~~~~~~~~¹Ø¼ü½áÊø~~~~~~~~~~~~~~~~~~~~~~~~~×¢£ºÎÒÒ»Ö±ÊÇÕâ¸öÔÒò£¬×°´í²¹¶©ÁË£¬ÎÒÔø¾×°¹ýSP3a£¬SP4£¬½á¹û¶¼²»ÐУ¡2£¬°²×°JDBC£¬°ÑÆ䰲װĿ¼ÏµÄlibϵÄÈý¸öÎļþÌí¼Óµ½classpathÖУ¬Õâ¸öÍøÉ϶¼ÓкܶࡣÎÒµÄÊÇ£ºC:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;Ìí¼ÓÍê³Éºó£¬°²×°SP3²¹¶©£¬Ò²¾ÍÊǸղÅϵÄÄǸöÎļþ£¬
ûµ¼Çý¶¯°ü°É£¿ÔÚWEB-INFµÄlibÅäÖù¹½¨Â·¾¶µ¼Èësqljdbc.jar°üÊÔÊÔ
ûÓÐsqlserverµÄjdbcÇý¶¯°ü
1,Êý¾Ý¿âÇý¶¯Ã»µ¼Èë
2,²¹¶¡Ã»´ò
Òª²»¾ÍÊÇȱÉÙ°ü£¬Òª
Ïà¹ØÎÊ´ð£º
ÈçÌâ
Ö»ÓÐ100·Ö¸øÁË¡£¡£¡£
ÄĸöÐÐÒµ£¿
ÎÒÏëÍøÉϵÄÔ´Âë¿Ï¶¨²»ÄÜÍêÈ«Âú×ã¸öÈËÏë·¨
×îºó»¹µÃ×Ô¼ºÕû
ÍƼöÒ»¿î×ÔÖú½¨Õ¾Èí¼þ£º·çѶ
C#+SQL
¿ÉÒÔÉè¼Æ³ö±È½ÏÁé»îµÄÍøÕ¾
ʲôÐÐÒµ°¡....
µ½51aspx.co ......
ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæʱ²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......
Ö÷¼üÊÇuniqueidentifierÀàÐÍ£¬Ã»ÓÐ×ÔÔö×ֶΡ£¡£
ÕâÑùÓ¦¸ÃÔõô»ñÈ¡£¿
L@_@K
SQL code:
SELECT ISNULL(SCOPE_IDENTITY(), -1) AS [SCOPE_IDENTITY]
°´Ê±¼äÅÅÐò
»ò
guid²»Òª×Ô¶¯Éú³É
......
ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾдÁ˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË
Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË
»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......