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

tomcat sql Á¬½Ó³ØÅäÖà Rubicon

tomcatµÄÅäÖÃ:
1.ÈçºÎÐÞ¸ÄtomcatµÄ¶Ë¿Ú
2.ÈçºÎÉèÖÃÐéÄâĿ¼
3.ÈçºÎ¸øtomcatµÄ¹ÜÀíÔ±ÉèÖÃÃÜÂë
4.ÈçºÎÉèÖÃÊý¾ÝÔ´ºÍÁ¬½Ó³Ø(¹«Ë¾³£ÓÃ!)
(¶þ)ÈçºÎÐÞ¸ÄtomcatµÄ¶Ë¿Ú
ÔÚijЩÇé¿öÏ£¬¿ÉÄÜÐèÒªÐÞ¸Ätomcat¼àÌýµÄ¶Ë¿Ú8080 £¬±ÈÈ磺
¡ôÐèÒªÆô¶¯Á½·Ýtomcat·þÎñÆ÷
¡ôij¸ö·þÎñÕ¼ÓÃÁË8080¶Ë¿Ú
(Èý)ÈçºÎÐÞ¸ÄtomcatµÄ¶Ë¿Ú
ÐÞ¸Ätomcat¶Ë¿ÚµÄ·½·¨:
ÐÞ¸Ä~tomcat~/conf/server.xml ÎļþÖÐµÄ port=“8080” Êý¾Ý½«8080Ð޸ijÉÄãÐèÒªµÄ¶Ë¿ÚºÅ¼´¿É.
(ËÄ)ÈçºÎÉèÖÃÐéÄâĿ¼
(Îå)ÈçºÎÉèÖÃÐéÄâĿ¼
(Áù) ¸øtomcatµÄ¹ÜÀíÔ±ÉèÃÜÂë
(Æß)¸øtomcatµÄ¹ÜÀíÔ±ÉèÃÜÂë
(°Ë)¸øtomcatµÄ¹ÜÀíÔ±ÉèÃÜÂë
(¾Å)ÅäÖÃÊý¾ÝÔ´ºÍÁ¬½Ó³Ø
(Ê®)ÅäÖÃÊý¾ÝÔ´ºÍÁ¬½Ó³Ø
(ʮһ)ÅäÖÃÊý¾ÝÔ´ºÍÁ¬½Ó³Ø
(Ê®¶þ)´úÂë
<Context path="/MyWebSite" docBase="e:\MyWebSite" debug="0">
<!--name: ¸øÊý¾ÝÔ´ÉèÖÃÃû×Ö(jndi) auth: ±íʾ¸ÃÊý¾ÝÊÇÓÐË­¹ÜÀí type: ÀàÐÍ-->  
<Resource name="shunping" auth="Container" type="javax.sql.DataSource"/>   
<ResourceParams name="shunping">
<!--¹¤³§ÉèÖÃ-->
<parameter>  
<name>factory</name>  
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>  
</parameter>     
<parameter>
<!--Çý¶¯ÉèÖÃ,¸ÃÇý¶¯·ÅÔÚtomcatµÄcommon/libÏ£¬»òÕß·ÅÔÚ¸ÃÕ¾µã×Ô¼ºµÄlibĿ¼ÏÂ-->
<name>driverClassName</name>  
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>  
</parameter>     
<parameter>
<!--ÉèÖÃurl-->
<name>url</name>  
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=spdb1</value>    
</parameter>
<parameter>
<!--ÉèÖÃÁ¬½ÓÊý¾Ý¿âµÄÓû§Ãû-->      
<name>username</name>  
<value>sa</value>     
</parameter>     
<parameter>
<!--ÉèÖÃÁ¬½ÓÊý¾Ý¿âµÄÃÜÂë-->   &nb


Ïà¹ØÎĵµ£º

ÈçºÎ²éѯSQL Server±¸·Ý»¹Ô­ÀúÊ·¼Ç¼

SQL ServerÔÚmsdbÊý¾ÝÖÐά»¤ÁËһϵÁÐ±í£¬ÓÃÀ´´æ´¢Ö´ÐÐËùÓб¸·ÝºÍ»¹Ô­µÄϸ½ÚÐÅÏ¢¡£¼´Ê¹ÄãÕýÔÚʹÓõÚÈý·½µÄ±¸·ÝÓ¦ÓóÌÐò£¬Ö»ÒªÕâ¸öÓ¦ÓóÌÐòʹÓÃSQL ServerµÄÐéÄâÉ豸½Ó¿Ú(Virtual Device Interface---VDI)À´Ö´Ðб¸·ÝºÍ»¹Ô­Ö´ÐУ¬ÄÇôִÐÐϸ½ÚÒÀÈ»±»´æ´¢ÔÚÕâһϵÁбíÖС£
´æ´¢Ï¸½ÚµÄ±í°üÀ¨£º
backupset 
backupfile&n ......

SQL Server2005 ÖÐÓà Pivot Éú³É½»²æ±í

×î½üÔÚ×öÒ»¸öÊý¾Ýͳ¼Æ£¬ÒªÇó¶ÔÒ»¸ö±íÖеÄÊý¾Ý°´ÕÕÁ½¸öά¶È³ÊÏÖ£¬Ò²¾ÍÊÇ´«Í³µÄ½»²æ±í
±ÈÈ磬ÓÐÒ»¸öÎÊÌâ±í£¬ÓÐÈý¸ö×ֶΣ¬£¨±êÌâ¡¢ÎÊÌâÀà±ð¡¢ÎÊÌâ״̬£©
ÒªÇó°´ÕÕ²»Í¬µÄÀà±ð£¬·Ö±ðͳ¼Æ´¦¸÷¸ö״̬µÄÎÊÌâÊýÁ¿£¨È磺²úÆ·ÎÊÌâÖÐδ´¦ÀíµÄÊýÁ¿¡¢·þÎñÎÊÌâÖÐÒÅÁôÎÊÌâÊýÁ¿µÈµÈ£©¡£
¾­¹ý²éÕҺͳ¢ÊÔ£¬ÖÕÓÚÉú³ÉÁ˽á¹û£¬ÏÖÔÚ·ÖÏí¸ø´ó¼Ò¡£ ......

¾«ÃîsqlÓï¾äÊÕ²Ø

SQLÓï¾äÏÈǰдµÄʱºò£¬ºÜÈÝÒ×°ÑÒ»Ð©ÌØÊâµÄÓ÷¨Íü¼Ç£¬ÎÒÌØ´ËÕûÀíÁËÒ»ÏÂSQLÓï¾ä²Ù×÷¡£
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'd ......

SQL SERVER 2005 ͬ²½¸´ÖƼ¼Êõ

SQL SERVER 2005 ͬ²½¸´ÖƼ¼Êõ
ÒÔÏÂʵÏÖ¸´ÖƲ½Ö裨ÒÔ¿ìÕÕ¸´ÖÆÎªÀý£©
ÔËÐÐÆ½Ì¨SQL SERVER 2005
Ò»¡¢×¼±¸¹¤×÷£º
1£®½¨Á¢Ò»¸ö WINDOWS Óû§£¬ÉèÖÃΪ¹ÜÀíԱȨÏÞ£¬²¢ÉèÖÃÃÜÂ룬×÷Ϊ·¢²¼¿ìÕÕÎļþµÄÓÐЧ·ÃÎÊÓû§¡£
2£®ÔÚSQL SERVERÏÂʵÏÖ·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷µÄͨÐÅÕý³££¨¼´¿ÉÒÔ»¥·Ã£©¡£´ò¿ª1433¶Ë¿Ú£¬ÔÚ·À»ðǽÖÐÉèÌØÀ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ