ÅäÖÃSQL Server2005 expressÓëjdbcÁ¬½Ó
ÉÏ΢ÈíÍøÕ¾ÏÂÔØsqlserver2005 jdbc driver °ü
1¡¢½«microsoft sql server 2005 jdbc driver\sqljdbc_1.2\chs\sqljdbc.jar°ü copyµ½·¢²¼ÏµÍ³ µÄ web-inf\libĿ¼ÖÐ
2¡¢½«microsoft sql server 2005 jdbc driver\sqljdbc_1.2\chs\auth\x86\sqljdbc_auth.dll Îļþcopyµ½ windows\system32Ŀ¼
web-inf\fcconfig.xml ÎļþÖеÄÁ¬½Ó×Ö·û´®ÈçÏÂÉèÖÃ
<ds name="fhjtest" dbtype="sqlserver"
type="jdbc" jdbcdriver="com.microsoft.sqlserver.jdbc.sqlserverdriver" jdbcurl="jdbc:sqlserver://localhost:1433;databasename=wy;integratedsecurity=true;" user="sa" password="small" />
×¢ÖØ£º
jdbcdriver="com.microsoft.sqlserver.jdbc.sqlserverdriver"
jdbcurl="jdbc:sqlserver://localhost:1433;databasename=wy;integratedsecurity=true;"
ÅäÖÃSQL Server2005 expressÓëjdbcÁ¬½Ó
±¾ÎÄÖ÷Òª½éÉÜÁËÅäÖÃSQL Server2005 expressÓëjdbcÁ¬½ÓµÄÈ«¹ý³Ì¡£
SQL Server2000ϵÄJavaÓ¦ÓÃÄÜ·ñÔÚSQL Server 2005 expressÉÏÔËÐУ¬¾¹ý²»¶Ï²âÊÔÓëÅäÖã¬×ܽáÒÔϾÑ飺
1£ºÊ×ÏÈÈ·ÈÏSQL Server2005 expressÒѾ°²×°ºÃÁË¡£
2£ºÆôÓÃTCP/IPÐÒé¡£
ÔÚ“³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”Öдò¿ªTCP/IPÐÒé¡£ÈçÏ£º
ͼ1-1 SQL Server ÍâΧӦÓÃÅäÖÃÆ÷´°¿Ú
Ñ¡Ôñ“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”£¬ÈçÏ£º
ÔÚ“Ô¶³ÌÁ¬½Ó”ÖÐÑ¡Ôñ“ͬʱʹÓÃTCP/IPºÍnamed pipes£¨B£©”,È»ºóµã“Ó¦ÓÔ¡£
3£ºÅäÖÃSQL Server 2005ÖеÄTCP/IPÐÒé
ÔÚ“³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß”ÏÂÔËÐГSQL Server Configuration Manager”£¬ÈçÏ£º
ĬÈÏTCP/IPÊôÐÔ,È«²¿ÕìÌýµÄֵΪ“ÊÇ”£¬ÈçÏ£º
ÐÞ¸ÄTCP/IPÊôÐÔ,½«È«²¿ÕìÌý¸ÄΪ“·ñ”
½«TCP¶¯Ì¬¶Ë¿Ú¸ÄΪ¿Õ£¨È÷þÎñÆ÷×Ô¼ºÑ¡Ôñ¶Ë¿Ú£©, TCP¶Ë¿Ú¸ÄΪ1433
ÍƼö£ºÈ»ºóÖØÆô»úÆ÷£¬ÈÃÖØÆô»úÆ÷µÄ¹ý³ÌÖаÑSQL Server 2005 expressÆô¶¯¡£Ò²¿ÉÒÔÖØÐÂÆô¶¯SQL Server2005 express·þÎñ¡£
4£ºÔÚtomcatÖÐÅäÖÃSQL ServerÊý¾Ý¿â³É¹¦¡£
SQL Server 2005 expressÖÐurlºÍdriverClassName¸úSQL Server 2000Óв
Ïà¹ØÎĵµ£º
/*
SQL SERVER 2008 ±íÖµ²ÎÊý
SQL SERVER ÒýÈëÁË¿¹ÒéÓÃÀ´½«Ðм¯´«Èëµ½´æ´¢¹ý³ÌºÍÓû§¶¨Ò庯ÊýµÄ±íÖµ²ÎÊý.
Õâ¸ö¹¦ÄÜ¿ÉÒÔʹ´æ´¢¹ý³ÌºÍº¯Êý¾ßÓзâ×°¶à¸öÐм¯µÄ¹¦ÄÜ,¶ø²»ÊDZØÐëÒ»ÐÐÒ»Ðеص÷
Êý¾ÝÐ޸Ĺý³ÌºÍ´©¼þ¶à¸öÊäÈë²ÎÊýÀ´ÉúÓ²µÄת»¯Îª¶àÐÐ.
ÎÒÃÇÔÚÓ¦ÓÃÖо³£Óà ......
1. ʲôÊÇÃüÃû¹ÜµÀ£¿
ÓëTCP/IP£¨´«Êä¿ØÖÆÐÒé»òinternetÐÒ飩һÑù£¬ÃüÃû¹ÜµÀÊÇÒ»ÖÖͨѶÐÒé¡£ËüÒ»°ãÓÃÓÚ¾ÖÓòÍøÖУ¬ÒòΪËüÒªÇó¿Í»§¶Ë±ØÐë¾ßÓзÃÎÊ·þÎñÆ÷×ÊÔ´µÄȨÏÞ¡£
Òª½âÊÍÕâ¸öÎÊÌ⣬ÎÒ»¹ÊÇժ¼΢Èí¹Ù·½µÄ×ÊÁϱȽϺÃ
http://msdn.microsoft.com/zh-cn/library/ms187892.aspx
ÈôÒªÁ¬½Óµ½ SQL Server Êý¾Ý¿âÒýÇ棬±ØÐëÆô ......
SQLÓï¾äµ¼Èëµ¼³ö´óÈ«[ÊÕ¼¯]
ÕýÇÉÕâÁ½ÌìÒªÓõ½Õâ¸ö£¬ÉÏÍøÕÒµ½Ò»¸ö£¬»ØÀ´×Ô¼º¼ì²âһϣº
/******* µ¼³öµ½excel
EXEC master..xp_cmdshell 'bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -
S"GNETDATA/GNETDATA" -U"sa" -P""'
/*********** µ¼ÈëExcel
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
......
µÚÒ»²¿·Ö£ºoracle pl/sqlʵÀýÁ·Ï°(1)
Ò»¡¢Ê¹ÓÃscott/tigerÓû§ÏµÄemp±íºÍdept±íÍê³ÉÏÂÁÐÁ·Ï°£¬±íµÄ½á¹¹ËµÃ÷ÈçÏÂ
empÔ±¹¤±í(empnoÔ±¹¤ºÅ/enameÔ±¹¤ÐÕÃû/job¹¤×÷/mgrÉϼ¶±àºÅ/hiredateÊܹÍÈÕÆÚ/salн½ð/commÓ¶½ð/deptno²¿ÃűàºÅ)
dept²¿Ãűí(deptno²¿ÃűàºÅ/dname²¿ÃÅÃû³Æ/locµØµã)
¹¤×Ê £½ н½ð £« Ó¶½ð
Ò²¿ÉÒÔͨ¹ý ......
select top Ò³´óС *
from table1
where id>
(select max (id) from
(select top ((Ò³Âë-1)*Ò³´óС) id from table1 order by id) as T) order by id ......