javaÖÐʹÓÃjdbcÁ¬½Ósql server 2005
×¼±¸¹¤×÷
Ê×ÏÈ£¬²Ù×÷ϵͳÖа²×°ºÃSQL Server 2000/2005£¬Èç¹ûϵͳÖж¼×°ÓÐ2000ºÍ2005°æ£¬¼ÇµÃÍ£ÓÃÒ»¸ö£¬Ö»¿ªÒ»¸öÐÐÁË¡£
È»ºó£¬µ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.1
£¬Ò²¿ÉÒÔʹÓÃÕâ¸öµØÖ·Ö±½ÓÏÂÔØ
¡£
½âѹsqljdbc_1.1.1501.101_chs.exe£¬°Ñsqljdbc_1.1¸´ÖƵ½%ProgramFiles%£¨Èç¹ûϵͳÔÚCÅÌÔòΪC:\Program Files£©¡£
½«C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\auth\x64
sqljdbc_auth.dll
¸´ÖƵ½D:\program files\Microsoft SQL Server\MSSQL\Binn
ÏÂÃæ¡£·ñÔò»á±§com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
¾¯¸æ: Failed to load the sqljdbc_auth.dll
ÉèÖÃ Classpath
JDBC Çý¶¯³ÌÐò²¢Î´°üº¬ÔÚ Java SDK ÖС£Òò´Ë£¬Èç¹ûҪʹÓøÃÇý¶¯³ÌÐò£¬±ØÐ뽫 classpath ÉèÖÃΪ°üº¬ sqljdbc.jar Îļþ¡£Èç¹û classpath ȱÉÙ sqljdbc.jar ÏӦÓóÌÐò½«Òý·¢“ÕÒ²»µ½Àà”µÄ³£¼ûÒì³£¡£
sqljdbc.jar ÎļþµÄ°²×°Î»ÖÃÈçÏ£º
<°²×°Ä¿Â¼
>\sqljdbc_<°æ±¾
>\<ÓïÑÔ
>\sqljdbc.jar
ÏÂÃæÊÇÓÃÓÚ Windows Ó¦ÓóÌÐòµÄ CLASSPATH Óï¾äʵÀý£º
CLASSPATH =.;
%ProgramFiles%\sqljdbc_1.1\chs\sqljdbc.jar
ÏÂÃæÊÇÓÃÓÚ Unix/Linux Ó¦ÓóÌÐòµÄ CLASSPATH Óï¾äʵÀý£º
CLASSPATH =.:/home/usr1/mssqlserver2005jdbc/Driver/sqljdbc_1.1/chs/sqljdbc.jar
×¢Ò⣺
ÔÚ Window ϵͳÖУ¬Èç¹ûĿ¼Ãû³¤ÓÚ 8.3 »òÎļþ¼ÐÃûÖаüº¬¿Õ¸ñ£¬½«µ¼Ö classpath ³öÏÖÎÊÌâ¡£Èç¹û»³ÒÉ´æÔÚÕâÀàÎÊÌ⣬ӦÔÝʱ½« sqljdbc.jar ÎļþÒÆ¶¯µ½Ãû³Æ¼òµ¥µÄĿ¼ÖУ¬ÀýÈç C:\Temp
£¬¸ü¸Ä classpath£¬È»ºó²âÊÔÕâÑùÊÇ·ñ½â¾öÁËÎÊÌâ¡£
Ö±½ÓÔÚÃüÁîÌáʾ·ûÔËÐеÄÓ¦ÓóÌÐò
ÔÚ²Ù×÷ϵͳÖÐÅäÖà classpath¡£½« sqljdbc.jar ×·¼Óµ½ÏµÍ³µÄ classpath ÖС£»òÕߣ¬Ê¹Óà java -classpath
Ñ¡Ï¿ÉÒÔÔÚÔËÐдËÓ¦ÓóÌÐòµÄ Java ÃüÁîÐÐÉÏÖ¸¶¨ classpath¡£
ÉèÖÃSQL Server·þÎñÆ÷
ÎÒʹÓõÄÊÇSQL Server 2005±ê×¼°æSP2£¬ÕâЩ¶¼Ä¬Èϼ´¿É£¬Ò»°ã²»ÓÃÅäÖá£Èç¹ûÐèÒªÅäÖö˿ÚÇë¿´ÏÂÃæ¡£
1¡¢“¿ªÊ¼”→“³ÌÐò”→“Microsoft SQL Server 2005”→“ÅäÖù¤¾ß”→“SQL Server ÅäÖùÜÀíÆ÷”→“SQL Server 2005 ÍøÂçÅäÖÔ→“MSSQLSERVER µÄÐÒé”
2¡¢Èç¹û“TCP/IP”ûÓÐÆôÓã¬ÓÒ¼üµ¥»÷Ñ¡Ôñ“Æô¶¯&r
Ïà¹ØÎĵµ£º
ÈκÎÊÂÎñÎÞÂÛÆä¸ôÀë¼¶±ðÈçºÎ£¬¶¼¾ßÓÐÔ×ÓÐÔ¡£Ô×ÓÐԺ͸ôÀë¼¶±ðÊÇÁ½ÂëÊ¡£
¼Ù¶¨Ö»ÓÐÒ»ÖÖ×ÊÔ´Êý¾Ý±íÉϵēÐГ¿ÉÒÔ±»Ëø¶¨¡£ËøÖ»Óй²ÏíËøºÍÅÅËûËøÁ½ÖÖ¡£
ËøµÄ¼æÈÝÐÔ£º
SX
S 10
X 00
ÊÂÎñµÄ¸ôÀë¼¶±ð£º
Read Uncommitted
Êý¾Ý¶Áȡʱ²»ÐèÒªËø¶¨
Read Committed
Êý¾Ý¶ÁȡʱÐèÒª¹²ÏíËø¶¨
Repeatable Re ......
ÓÐÕâÑùÒ»¸öÊý¾Ý¿â±í
t1 t2 t3……n
--------------------------
aaa ......
SQL Server 2005 ¾µÏñ¹¹½¨ÊÖ²á
Ò»¡¢ ¾µÏñ¼ò½é
1¡¢ ¼ò½é
Êý¾Ý¿â¾µÏñÊǽ«Êý¾Ý¿âÊÂÎñ´¦Àí´ÓÒ»¸öSQL ServerÊý¾Ý¿âÒÆ¶¯µ½²»Í¬SQL Server»·¾³ÖеÄÁíÒ»¸öSQL ServerÊý¾Ý¿âÖС£¾µÏñ²»ÄÜÖ±½Ó·ÃÎÊ;ËüÖ»ÓÃÔÚ´íÎó»Ö¸´µÄÇé¿öϲſÉÒÔ±»·ÃÎÊ¡£
Òª½øÐÐÊý¾Ý¿â¾µÏñËùÐèµÄ×îСÐèÇó°üÀ¨ÁËÁ½¸ö²»Í¬µÄSQL ServerÔËÐл·¾³¡£Ö÷·þÎñÆ÷± ......
ÔÚSql Server Öе÷ÓÃJmail×é¼þ·¢ËÍÓʼþ
Ô¤±¸ÖªÊ¶
1£®OLE×Ô¶¯»¯º¯Êý
OLE×Ô¶¯»¯Ê¹Ó¦ÓóÌÐòÄܹ»¶ÔÁíÒ»¸öÓ¦ÓóÌÐòÖÐʵÏֵĶÔÏó½øÐвÙ×÷£¬»òÕß½«¶ÔÏ󹫿ªÒÔ±ã¿ÉÒÔ¶ÔÆä½øÐвÙ×÷¡£×Ô¶¯»¯¿Í»§¶ËÊǿɶÔÊôÓÚÁíÒ»¸öÓ¦ÓóÌÐòµÄ¹«¿ª¶ÔÏó½øÐвÙ×÷µÄÓ¦ÓóÌÐò£¬±¾ÎÄÖµµÃÊÇSql Server¡£¹«¿ ......
ÓÉÓÚ¹¤×÷ºÍѧϰµÄÐèÒª£¬ÒªÔÚ±¾±¾Éϰ²×°SQL SERVER 2005 ¿ª·¢°æ(±¾±¾µÄ²Ù×÷ϵͳÊÇXP£¬ËùÒÔ²»Äܰ²×°Enterprise°æ±¾£¬¶øExpress°æ±¾µÄ¹¦ÄÜÓÖÊ®·ÖÓÐÏÞ)£¬È¥Î¢ÈíµÄ¹Ù·½ÍøÕ¾ËÑË÷ÁËÒ»ÏÂsql server 2005 developer£¬ÕÒµ½ÁËһЩ¹ØÓÚSql server¸÷ÖÖ°æ±¾µÄ½éÉÜ£¬Ê×ÏÈsql server 2005ÓÐÒÔϼ¸ÖÖ°æ±¾£º EE = SQL Server 2005 Enterprise ......