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Á¬
½Ó¶¼Õý³£~£¡À§ÈÅÒ»ÍíµÄÎÊÌâ½â¾ö~£¡
Ïà¹ØÎĵµ£º
º¯Êý¼ò½é:¡¡¡¡
·µ»Ø Variant (Long) µÄÖµ£¬±íʾÁ½¸öÖ¸¶¨ÈÕÆÚ¼äµÄʱ¼ä¼ä¸ôÊýÄ¿¡£
º¯ÊýÓï·¨:
¡¡¡¡DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
DateDiff º¯ÊýÓï·¨ÖÐÓÐÏÂÁÐÃüÃû²ÎÊý£º
¡¡¡¡interval ±ØÒª¡£×Ö·û´®±í´ïʽ£¬±íʾÓÃÀ´¼ÆËãdate1 ºÍ date2 µÄʱ¼ä²îµÄʱ¼ä¼ ......
·µ»Ø
¡¡¡¡·µ»Ø°üº¬Ò»¸öÈÕÆÚµÄ Variant (Date)£¬ÕâÒ»ÈÕÆÚ»¹¼ÓÉÏÁËÒ»¶Îʱ¼ä¼ä¸ô¡£
Óï·¨
¡¡¡¡DateAdd(interval, number, date)
¡¡¡¡DateAdd º¯ÊýÓï·¨ÖÐÓÐÏÂÁÐÃüÃû²ÎÊý£º
¡¡¡¡interval ±ØÒª¡£×Ö·û´®±í´ïʽ£¬ÊÇËùÒª¼ÓÉÏÈ¥µÄʱ¼ä¼ä¸ô¡£
¡¡¡¡number ±ØÒª¡£ÊýÖµ±í´ïʽ£¬ÊÇÒª¼ÓÉϵÄʱ¼ä¼ä¸ôµÄÊýÄ¿¡£ÆäÊýÖµ¿ÉÒÔΪÕýÊý£¨µÃ ......
SQLÓï¾ä¼¯½õ
--Óï ¾ä ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT& ......
ÐèÇó£ºÓÐexcelÎļþ£¬º¬¶à¸ösheet£¬Ã¿¸ösheetµÄÄÚÈݶÔÓ¦²åÈëµ½Ò»ÕÅ±í£¬sheetµÄÃû³Æ¾ÍÊǶÔÓ¦µÄ±íÃû³Æ¡£
ÿһÐÐΪÁÐÃû£¬ÀýÈ磺
´ï³É£º½«Ã¿¸ösheetÊä³ö³ÉÒ»¸öÒÔsheetÃû³ÆÃüÃûµÄsqlÎļþ£¬ÄÚÈÝΪÿÐÐÄÚÈݵÄinsertÓï¾ä¡£
ÒÔÉÏͼΪÀý»áÉú³ÉÈý¸ösqlÎļþ£¬·Ö±ðÊÇTF_R_TERMINAL_ARCH.sql£¬ TF_R_STOCK_TRADE.sql ºÍ TF_R_STOC ......
/*----------------------------------------------------------------
-- Author :feixianxxx(poofly)
-- Date :2010-05-12 19:43:03
-- Version:
-- Microsoft SQL Server 2008 (SP1) - 10 ......