Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

oracleÖÐsqlÓï¾äÖеÄinµÄÌõ¼þÊýÁ¿´óÓÚ1000ÓÐÎÊÌâ

oracleÖÐsqlÓï¾äÖÐselect * from t_Test t where  t.Id in(1,2,3......)/*ÊýÁ¿²»ÄÜ´óÓÚ1000¸ö*/
½â¾ö·½·¨ ·Ö¸î³É¶à´Îin È»ºóÔÙ»òÉÏ  Èç select * from t_Test t where  t.Id in(1,2,3......800) or  t.Id in(801,802,803......1300)
ÔÚʹÓÃÖÐ×îºÃÄܲ»Ê¹ÓÃÆäËûÌõ¼þÀ´´úÌæin
......

Íü¼ÇSQL ServerµÄSAÓû§ÃÜÂë½â¾ö·½·¨


×÷Õß:ÍøÂ·ÓÎÏÀ@youxia.org
·¢²¼Ê±¼ä:2005-9-25 11:48:18 ÎÄÕÂÀ´Ô´:youxia.org
̨ʽ»úºÍ±¾±¾·Ö±ð°²×°ÁËMS SQL Server£¬·½±ã×ö²âÊÔÓÃ
½á¹ûʱ¼ä³¤ÁË£¬
̨ʽ»úSQL ServerµÄÃÜÂëÍü¼ÇÁË……
ÄѵÀ……ûÓа취ÁËÂ𣿗—No£¡
¾­¹ýÒ»Õó×ÓÓôÃÆ£¬ÓÎÏÀÔÚ°Ù¶ÈËѵ½ÁË·½·¨£º
ÏÖÔÚÄãµÄ
ÆóÒ ......

SQLʱ¼ä¸ñʽת»»´óÈ«

                                                   ......

¾«Ãî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ºÅ