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ÔÚmsdbÊý¾ÝÖÐά»¤ÁËһϵÁÐ±í£¬ÓÃÀ´´æ´¢Ö´ÐÐËùÓб¸·ÝºÍ»¹ÔµÄϸ½ÚÐÅÏ¢¡£¼´Ê¹ÄãÕýÔÚʹÓõÚÈý·½µÄ±¸·ÝÓ¦ÓóÌÐò£¬Ö»ÒªÕâ¸öÓ¦ÓóÌÐòʹÓÃSQL ServerµÄÐéÄâÉ豸½Ó¿Ú(Virtual Device Interface---VDI)À´Ö´Ðб¸·ÝºÍ»¹ÔÖ´ÐУ¬ÄÇôִÐÐϸ½ÚÒÀÈ»±»´æ´¢ÔÚÕâһϵÁбíÖС£
´æ´¢Ï¸½ÚµÄ±í°üÀ¨£º
backupset
backupfile&n ......
ÏëʹÓÃPL/SQL¿ª·¢¹¤¾ß£¬µ«²»Ïë°²×°ÄǸö¼¸°ÙÕ×µÄoracle¿Í»§¶Ë£¬ÓÚÊǰ²×°ÁËoracle 10g inistant client£¬40¶àM°É¡£
°²×°ºóPL/SQL¿ÉÒÔÓÃÁË£¬µ«ÊDzéѯ³ö¼Ç¼ÀïÃæµÄÖÐÎÄÈ´ÊÇÂÒÂë¡£ÕÛÌÚÁ˺þòÅÕÒ³ö½â¾ö·½·¨£º
ÉèÖû·¾³±äÁ¿£ºNLS_LANG£¬ÖµÎªOracleÊý¾Ý¿âÉèÖõÄ×Ö·û¼¯£¬ÔÚÎÒµÄϵͳÀïÃæÉèÖÃÊÇ£ºSIMPLIFIED CHINESE_CHINA.ZHS16GBK ......
Transact SQL Óï ¾ä ¹¦ ÄÜ
========================================================================
¡¡¡¡--Êý¾Ý²Ù×÷
¡¡¡¡ SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
¡¡¡¡¡¡¡¡¡¡¡¡INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
¡¡¡¡¡¡¡¡¡¡¡¡DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
¡¡¡¡¡¡¡¡¡¡¡¡UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý ......
1ÏÞÖÆ SQL Server·þÎñµÄȨÏÞ
¡¡¡¡
¡¡¡¡SQL Server 2000 ºÍ SQL Server Agent ÊÇ×÷Ϊ Windows ·þÎñÔËÐеġ£Ã¿¸ö·þÎñ±ØÐëÓëÒ»¸ö Windows ÕÊ»§Ïà¹ØÁª£¬²¢´ÓÕâ¸öÕÊ»§ÖÐÑÜÉú³ö°²È«ÐÔÉÏÏÂÎÄ¡£SQL ServerÔÊÐísa µÇ¼µÄÓû§£¨ÓÐʱҲ°üÀ¨ÆäËûÓû§£©À´·ÃÎʲÙ×÷ÏµÍ³ÌØÐÔ¡£ÕâЩ²Ù×÷ϵͳµ÷ÓÃÊÇÓÉÓµÓзþÎñÆ÷½ø³ÌµÄÕÊ»§µÄ°²È«ÐÔÉÏÏÂÎÄÀ´´ ......
SQL SERVER 2005 ͬ²½¸´ÖƼ¼Êõ
ÒÔÏÂʵÏÖ¸´ÖƲ½Ö裨ÒÔ¿ìÕÕ¸´ÖÆÎªÀý£©
ÔËÐÐÆ½Ì¨SQL SERVER 2005
Ò»¡¢×¼±¸¹¤×÷£º
1£®½¨Á¢Ò»¸ö WINDOWS Óû§£¬ÉèÖÃΪ¹ÜÀíԱȨÏÞ£¬²¢ÉèÖÃÃÜÂ룬×÷Ϊ·¢²¼¿ìÕÕÎļþµÄÓÐЧ·ÃÎÊÓû§¡£
2£®ÔÚSQL SERVERÏÂʵÏÖ·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷µÄͨÐÅÕý³££¨¼´¿ÉÒÔ»¥·Ã£©¡£´ò¿ª1433¶Ë¿Ú£¬ÔÚ·À»ðǽÖÐÉèÌØÀ ......