ÔÚwinxp2ÏÂÔõôÁ¬½Ómssql 2000°¡?²»ÊÇÒªÎÊ´úÂë.ÊÇÇý¶¯Ôõô½â¾ö.×ÜÊÇÌáʾÇý¶¯²»Æ¥Åä.ËÄܰïÎÒ½â¾öÏÂ???
¼ÇµÃÉý¼¶µ½SP3ÒÔÉϵİ汾
¼ÇµÃ¹ÙÍøÓÐÏÂÔØ
sp3ÊÇÖ¸mssqlÒªÉý¼¶ÊÇÂð?¿ÉÎÒÒ²ÉýÁË.
Java code:
mssqlserver.jar,msbase.jar,msutil.jar
jar°üµ¼ÁËûÓÐ
ϵͳ´ò²¹¶¡
http://support.microsoft.com/kb/313100/zh-cn
¿´¹ÙÍø
xue xi
Driver for JDBC]Error establishing socket.
ÕâÊÇʲôÒì³£°¡
Á¬²»ÉÏ£¬ÊDz»ÊÇurl»òÕß¶Ë¿ÚɶµÄ´íÁË¡£
°²×°Ä¿Â¼ÏÂÓ¦¸ÃÓÐjdbc/libÀïÃæ°Ñjar¿½³öÀ´¡£
ÒýÓÃ:
³öÏÖÁËÕâ¸ö´íÎó£¬ÎÒÂíÉÏÏëµ½Á¬½Ó×Ö·û´®ÓÐÎÊÌâ¡£¿ÉÔÚÍøÉÏÕÒÁ˺ü¸¸ö°æ±¾¶¼ÊÇÕâÑù¡£
ºóÀ´ÓÉÓÚijÖÖżȻÔÒò£¬ÎÒÖªµÀÁË SQLServer ¿ÉÒÔÉèÖò鿴¶Ë¿ÚºÅ¡£²½ÖèÈçÏ£º
1£® ´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬ÒÀ´ÎÔÚ¿ØÖÆÌ¨¸ùĿ¼ ->Microsoft SQL Servers->SQL Server ×飬ÁгöÒ»²¿·ÖÊý¾Ý¿â·þÎñÆ÷¡£
2£® ÓÒ»÷ÎÒÃÇÒªÁ¬½ÓµÄÊý¾Ý¿â·þÎñÆ÷£¬Ñ¡ÔñÊôÐÔ£¬ÔÚ³£¹æÑ¡Ïµã»÷ÍøÂçÅäÖõ¯³öд°¿Ú¡£
3£® ÔÚÆôÓõÄÐÒéÇøÓòÎÒÃÇÑ¡Ôñ TCP/IP £¬µã»÷ÊôÐÔ°´Å¥£¬µ¯³öд°¿Ú¡£ÔÚÕâ¸ö´°¿ÚÓÐÍøÂçÐÒéĬÈÏÖµÉèÖã¬ÎÒÔÚÕâÀï¿´µ½ÎÒµÄĬÈ϶˿ÚÊÇ£º 4067 ¡£ÒòÃæÔÚʹÓà 1433 Á¬½ÓÊý¾Ý¿âʱ³ö´í¡£
....
ÀïÃæ»¹ÓкܶàÆÀÂÛ,ºÃºÃ¿´¿´,»áÓÐÄãµÄ½â¾ö·½°¸µÄ:
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
ÎÒÊǸöÐÂÊÖ£¬×öÒ»¸öJSPÍøÒ³£¬ÎÒÒª¶Á³öÊý¾Ý¿âÕý³££¬µ«ÊÇÎÒÒªÐ޸ĵÄʱºò£¬Ò²¾ÍÊǶÁÈëµÄʱºò³öÏÖÂÒÂ룬Çë¸ßÊÖ¸æËßÎÒÔõô½â¾ö£¬ÏÈллÁË¡£
request.setCharacterEncoding("UTF-8");
°Ñ±àÂëͳһ
/**
......