JDBCÁ¬½ÓSQLServer³öÏÖµÄÒì³£
¿Î³ÌÉè¼ÆµÄµÚÒ»²½£º
Óû§µÇ½ģ¿é:¾ÍÕâ¸öСģ¿é°ÑÎÒÕûËÀÁË£¬³öÏÖµÄÎÊÌâÒ»¸ö½Ó×ÅÒ»¸ö£¬×îÖ÷ÒªµÄ¾ÍÊÇÊý¾Ý¿âÁ¬½Ó.
question1.
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
Òì³£ÔÒò£ºÃ»Óе¼Èëµ¼Çý¶¯°üsqljdbc.jar.
question2.
com.microsoft.sqlserver.jdbc.SQLServerException: ûÓÐΪ¼¯³ÉÉí·ÝÑéÖ¤ÅäÖÃÇý¶¯³ÌÐò
Òì³£ÔÒò£º´òsqlserver2005µÄsp3µÄ²¹¶¡£¬È»ºó½«Êý¾Ý¿âÉèÖÃΪÓÃwindows+sqlserverË«ÖØÑéÖ¤¡£
question3.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]¶ÔÏóÃû ‘xxx’ ÎÞЧ
Òì³£ÔÒò:·ÃÎÊÊý¾Ý¿âµÄÓû§ÓеǼȨÏÞ£¬µ«ÎÞ²Ù×÷±íµÄȨÏÞ
½â¾ö°ì·¨£º
1. ÔÚ[ÆóÒµ¿ØÖÆÌ¨]´°¿Ú–[Ê÷]×Ó´°¿Ú–[°²È«ÐÔ]×ÓÊ÷–[µÇ¼]ÏîÀォÄãʹÓõĵǽÓû§µÄĬÈÏÊý¾Ý¿âÉèΪÄãËùʹÓõÄÊý
¾Ý¿â¡£
2. ÔÚ[ÆóÒµ¿ØÖÆÌ¨]´°¿Ú–[Ê÷]×Ó´°¿Ú–[°²È«ÐÔ]×ÓÊ÷–[µÇ¼]ÏîÀïÐÂÔöÒ»¸öµÇ¼Óû§£¨ÔÚÆäÖÐÑ¡ÔñSQL Server Éí·ÝÑéÖ¤
¡¢·þÎñÆ÷½ÇÉ«ºÍÒª·ÃÎʵÄÊý¾Ý¿â£©£¬ÒÔºó±ã¿ÉÓÃЩÐÂÔöÓû§·ÃÎÊÄã¹´Ñ¡µÄÊý¾Ý¿âÁË¡£
question4.
java.sMS-sql 2005 ''xxx'' (Êý¾Ý¿â ''xxx''£¬¼Ü¹¹ ''dbo'')µÄ SELECT ȨÏÞ
Òì³£ÔÒò:Sql server 2005 ĬÈÏÉèÖÃϲ»ÔÊÐíÔ¶³ÌµÇ½
1 ÍâΧÉèÖà tcp/ip ºÍ named pipe ͬʱÆôÓÃ
2 ·þÎñÆ÷ --¡µÊôÐÔ --¡µ°²È«ÐÔ --¡µsql server ºÍwindows ÈÏ֤ģʽ ,Êý¾Ý¿â(xxx) --->°²È«ÐÔ---->¼Ü¹¹---->dbo(Êô
ÐÔ)--->ȨÏÞ--->Ìí¼Ó--->ä¯ÀÀ-->
[public]---->¾ßÓÐÊÚÓèȨÏÞ(select)
question5.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor
position.
Òì³£ÔÒò:ResultSetʵÀýresûÓÐÒÆ¶¯Ö¸ÕëλÖá£Ò»¸öResultSetÖ¸Õë×î³õµÄλÖÃÔÚµÚÒ»Ìõ¼Ç¼֮ǰ£¬µÚÒ»´Îµ÷ÓÃnext·½·¨
ʹµÚÒ»Ìõ¼Ç¼´¦ÓÚµ±Ç°Î»Ö㬵ڶþ´Îµ÷ÓÃnext·½·¨£¬Ê¹µÚ¶þÌõ¼Ç¼´¦ÓÚµ±Ç°Î»Öá£
Ïà¹ØÎĵµ£º
´æ´¢¹ý³ÌµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
´´½¨´æ´¢¹ý³Ì¡£´æ´¢¹ý³ÌÊÇÒѱ£´æµÄ Transact-SQL Óï¾ä¼¯ºÏ£¬»ò¶Ô Microsoft .NET Framework ¹«¹²ÓïÑÔÔËÐÐʱ (CLR) ·½·¨µÄÒýÓ㬿ɽÓÊÕ²¢·µ»ØÓû§ÌṩµÄ²ÎÊý¡£¿ÉÒÔ´´½¨¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°£¨¾Ö²¿ÁÙʱ¹ý³Ì£©ÖÐÁÙʱʹÓ㬻òÔÚËùÓлỰ£¨È«¾ÖÁÙʱ¹ý³Ì£©ÖÐÁÙʱʹÓá£
Æô¶¯ SQL ......
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚÆäËü±à³ÌÓïÑÔÖеÄʼþº¯Êý£¬SQL Server? ÔÊÐíΪ INSERT¡¢UPDATE¡¢DELETE ´´½¨´¥·¢Æ÷£¬µ±ÔÚ±í£¨ÊÓͼ£©ÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQL Óï¾ä¡£
±¾×¨ÌâµÄÄ¿µÄ²¢·ÇÊÇÏòÄúÏ꾡µØ½éÉÜ´¥·¢Æ÷£¬¶øÊÇϵͳµØÏòÄú½éÉÜ´¥·¢Æ÷µÄ³£ÓÃ֪ʶÓëÏà¹ØÓ¦Ó㬲¢ÓëÄúÒ ......
¡¾ÎÊÌâÃèÊö£º¡¿
Ò»¸öÓû§±íÖеÄ×¢²áÈÕÆÚÏÔʾ¸ñʽÊÇ£ºyyyy-mm-dd Thh:mm:ss.mmm ¡£¶øÎÒÏëͳ¼Æ³öÿÌìµÄÓû§×¢²áÊý£¬Ö±½Ógroup×¢²áÈÕÆÚ×Ö¶ÎÏÔÈ»ÊDz»Ðеġ£
¡¾ÎÊÌâ´¦Àí£º¡¿
ÀûÓÃSQLserverÖеÄconvertº¯Êý¶ÔÈÕÆÚ½øÐÐת»»×ª»»¡£groupת»»ºóµÄÈÕÆÚ¡£
¡¾½Å  ......
SQL Server 2000
Installing SQL Server 2000 (EÎÄ)
http://msdn.microsoft.com/en-us/library/aa299042(SQL.80).aspx
SQL Server 2000²¹¶¡
Microsoft SQL Server 2000 Service Pack 3a
http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=90DCD52C-0488-4E46-AFBF-ACACE536 ......
ÓÃwindowsÕ˺ݹÊÇ¿ÉÒԵǼµÄ¡£
²éÕÒÎÊÌâµÄ¹ý³Ì£º
µÚÒ»²½£º Æô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º ²é¿´windows·À»ðǽ£¬±»Ä¬ÈÏÆô¶¯ÁË£¬²»Æô¶¯Ñ¡ÔñÏî±»Disabled¡£Á½¸öÌáʾ“ÓÉÓÚ°²È«¿¼ÂÇ,ijЩÉèÖÃÓÉ×é²ßÂÔ¿ØÖÆ”“Windows·À»ðǽÕýÔÚʹÓÃÄúµÄÓòÉèÖÔ£¬ÏÈÓÃgpedit.msc´ò×é²ßÂÔ±à¼Æ÷£¬»úËã»úÅ ......