JTDSÁ¬½ÓSQL Server Óöµ½µÄÎÊÌâ
½ñÌìÔÚÓÃJTDSÁ¬½ÓSQL Server ʱºò£¬Óöµ½¼¸¸öÎÊÌ⣬¼Ç¼ÈçÏ£º
error while performing database login with the jtds driver:
network error ioexception:connection refused: connect
È»ºó²é¿´¶Ë¿Ú£¬ÔÀ´ÊÇ1433¶Ë¿Úδ´ò¿ª£¬È»ºóÔÚSQL Server configuration ManagerϵÄTCP\IPÖÐÆôÓÃ1433¶Ë¿Ú£¬ÖØÆôSQL Server·þÎñ£¬netstat -a -n ²é¿´¶Ë¿Ú£¬1433´ËʱÒѾ´ò¿ª¡£
ÔٴΓtest driver”½á¹ûÓÖ³öÏÖÎÊÌ⣺
±¾ÈËÏë³¢ÊÔ¿ªÆôSQL Server µÄVIA£¬½á¹ûÖØÆôSQL Serverʱ£¬²»ÄÜÕý³£Æô¶¯~£¡
֮ǰͨ¹ýjdbcÁ¬½Ó³É¹¦¹ý£¬ÏÖÔÚÊÔһϣ¬½á¹û£º
½â¾ö°ì·¨£º
1. ÏȽ«VIA½ûÓã¬È»ºó´ò¿ªSQL Server Configuration Manager->MSSQL ServerµÄÐÒé
->TCP/IP->IPµØÖ·
2. ²é¿´Á¬¸öIPµØÖ·ºÍ¶Ë¿Ú£¬¾¹ýÉÏÊöµÄ´íÎó£¬Ó¦¸Ã¶Ë¿ÚÉèÖÃûÓÐÎÊÌâµÄ£¬Îª1433£¬µ«ÊÇÎÊ
Ìâ¾Í³öÔÚÁ½¸öIPµØÖ·ÉÏ£¬¼ì²éʱºòÆôÓÃÁËIPµØÖ·£¬²¢ÇÒÖ»¿ÉÒÔÆôÓÃÒ»¸öŶ£¬²»È»¾Í»á³öÏÖ
windows socket errorµÄ´íÎ󣬯ôÓÃÒ»¸öÖ®ºóÖØÆôÒ»ÏÂSQL Server·þÎñ£¬JTDSºÍJDBCÁ¬
½Ó¶¼Õý³£~£¡À§ÈÅÒ»ÍíµÄÎÊÌâ½â¾ö~£¡
Ïà¹ØÎĵµ£º
Ê×ÏÈдһ¸öSQL×¢Èë¹ýÂ˵ÄÀࣺ
public class SqlFilter
{
#region SQL×¢Èëʽ¹¥»÷´úÂë·ÖÎö
/// <summary>
/// ´¦ÀíÓû§Ìá½»µÄÇëÇó
/// </summary>
public void StartProcessRequest()
{
string getkeys = "";
s ......
ÎÒ¾õµÃÖ÷ÒªÓ¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æÐ¡ÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
ÏÖÔÚ¼òµ¥µÄ¾Ù¼¸¸öÀý×Ó
Where×Ó¾äÖÐÓГ!=”½«²»Ê¹ÓÃË÷Òý
select account_name from test where amount != 0 (²»Ê¹ÓÃ)
......
ÎÊÌâ:
Äú¹¤×÷µÄ±¾»ú×°ÓÐVisual Studio 2005£¬¾ÖÓòÍøÖÐÓÐһ̨SQL Server 2005Êý¾Ý¿â·þÎñÆ÷£¬ÄãÏëͨ¹ý±¾»úÔ¶³Ìµ÷ÊÔSQL Server 2005·þÎñÆ÷ÉϵĴ洢¹ý³Ì¡£µ«ÊDz»ÖªµÀÈçºÎÅäÖûòÆôÓÃÔ¶³Ìµ÷ÊÔ£¿Ï£ÍûÕâÆªÎÄÕ¶ÔÄúÓÐÓ᣶ÔÓÚÊý¾Ý¿âºÍVisual StudioÔÚͬһ»úÆ÷µÄ´æ´¢¹ý³Ìµ÷ÊÔ£¬Ô°×ÓÀïÒѾÓÐһƪÒë×÷˵µÄºÜºÃÁË£¬¿ ......
--SQL Server£º
Select TOP N * from TABLE Order By NewID()
--Access£º
Select TOP N * from TABLE Order By Rnd(ID)
Rnd(ID) ÆäÖеÄIDÊÇ×Ô¶¯±àºÅ×ֶΣ¬¿ÉÒÔÀûÓÃÆäËûÈκÎÊýÖµÀ´Íê³É£¬±ÈÈçÓÃÐÕÃû×Ö¶Î(U ......