Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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)

´æ´¢¹ý³ÌµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
´´½¨´æ´¢¹ý³Ì¡£´æ´¢¹ý³ÌÊÇÒѱ£´æµÄ Transact-SQL Óï¾ä¼¯ºÏ£¬»ò¶Ô Microsoft .NET Framework ¹«¹²ÓïÑÔÔËÐÐʱ (CLR) ·½·¨µÄÒýÓ㬿ɽÓÊÕ²¢·µ»ØÓû§ÌṩµÄ²ÎÊý¡£¿ÉÒÔ´´½¨¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°£¨¾Ö²¿ÁÙʱ¹ý³Ì£©ÖÐÁÙʱʹÓ㬻òÔÚËùÓлỰ£¨È«¾ÖÁÙʱ¹ý³Ì£©ÖÐÁÙʱʹÓá£
Æô¶¯ SQL ......

³õʶSQLSERVER´¥·¢Æ÷(Ò»)


´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚÆäËü±à³ÌÓïÑÔÖеÄʼþº¯Êý£¬SQL Server? ÔÊÐíΪ INSERT¡¢UPDATE¡¢DELETE ´´½¨´¥·¢Æ÷£¬µ±ÔÚ±í£¨ÊÓͼ£©ÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQL Óï¾ä¡£
    ±¾×¨ÌâµÄÄ¿µÄ²¢·ÇÊÇÏòÄúÏ꾡µØ½éÉÜ´¥·¢Æ÷£¬¶øÊÇϵͳµØÏòÄú½éÉÜ´¥·¢Æ÷µÄ³£ÓÃ֪ʶÓëÏà¹ØÓ¦Ó㬲¢ÓëÄúÒ ......

SQLserverÖÐÓÃconvertº¯Êýת»»ÈÕÆÚ¸ñʽ

¡¾ÎÊÌâÃèÊö£º¡¿
      Ò»¸öÓû§±íÖеÄ×¢²áÈÕÆÚÏÔʾ¸ñʽÊÇ£ºyyyy-mm-dd Thh:mm:ss.mmm ¡£¶øÎÒÏëͳ¼Æ³öÿÌìµÄÓû§×¢²áÊý£¬Ö±½Ógroup×¢²áÈÕÆÚ×Ö¶ÎÏÔÈ»ÊDz»Ðеġ£
¡¾ÎÊÌâ´¦Àí£º¡¿
      ÀûÓÃSQLserverÖеÄconvertº¯Êý¶ÔÈÕÆÚ½øÐÐת»»×ª»»¡£groupת»»ºóµÄÈÕÆÚ¡£
¡¾½Å  ......

sqlserver°²×°ÎÊÌâ×ܽᣨSqlServer2000/2005)

 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 ......

Óû§"sa "µÇ½ʧ°Ü SQLServer ´íÎó18456

ÓÃwindowsÕ˺ݹÊÇ¿ÉÒԵǼµÄ¡£
²éÕÒÎÊÌâµÄ¹ý³Ì£º
µÚÒ»²½£º Æô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º ²é¿´windows·À»ðǽ£¬±»Ä¬ÈÏÆô¶¯ÁË£¬²»Æô¶¯Ñ¡ÔñÏî±»Disabled¡£Á½¸öÌáʾ“ÓÉÓÚ°²È«¿¼ÂÇ,ijЩÉèÖÃÓÉ×é²ßÂÔ¿ØÖÆ”“Windows·À»ðǽÕýÔÚʹÓÃÄúµÄÓòÉèÖÔ£¬ÏÈÓÃgpedit.msc´ò×é²ßÂԱ༭Æ÷£¬»úËã»úÅ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ