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
Ïà¹ØÎĵµ£º
×î½üÔÚ×öÒ»¸öÊý¾Ýͳ¼Æ£¬ÒªÇó¶ÔÒ»¸ö±íÖеÄÊý¾Ý°´ÕÕÁ½¸öά¶È³ÊÏÖ£¬Ò²¾ÍÊÇ´«Í³µÄ½»²æ±í
±ÈÈ磬ÓÐÒ»¸öÎÊÌâ±í£¬ÓÐÈý¸ö×ֶΣ¬£¨±êÌâ¡¢ÎÊÌâÀà±ð¡¢ÎÊÌâ״̬£©
ÒªÇó°´ÕÕ²»Í¬µÄÀà±ð£¬·Ö±ðͳ¼Æ´¦¸÷¸ö״̬µÄÎÊÌâÊýÁ¿£¨È磺²úÆ·ÎÊÌâÖÐδ´¦ÀíµÄÊýÁ¿¡¢·þÎñÎÊÌâÖÐÒÅÁôÎÊÌâÊýÁ¿µÈµÈ£©¡£
¾¹ý²éÕҺͳ¢ÊÔ£¬ÖÕÓÚÉú³ÉÁ˽á¹û£¬ÏÖÔÚ·ÖÏí¸ø´ó¼Ò¡£ ......
DDL£ºÊý¾Ý¿â¶¨ÒåÓïÑÔ£¨create ,alter,modify£©¿É×Ô¶¯Ìá½»¡£
DML£ºÊý¾Ý¿â²Ù×÷ÓïÑÔ£¨insert, update,alter£©Ó¦ÉèSET AUTOCOMMIT ON
DCL£ºÊý¾Ý¿â¿ØÖÆÓïÑÔ£¨grant,deny,revoke£©
create table table_name (column_name type [not null] [constraint constraint_definition default XXXXXX] )
[primary key (column_name,col ......
SQL SERVER 2005 ͬ²½¸´ÖƼ¼Êõ
ÒÔÏÂʵÏÖ¸´ÖƲ½Ö裨ÒÔ¿ìÕÕ¸´ÖÆΪÀý£©
ÔËÐÐƽ̨SQL SERVER 2005
Ò»¡¢×¼±¸¹¤×÷£º
1£®½¨Á¢Ò»¸ö WINDOWS Óû§£¬ÉèÖÃΪ¹ÜÀíԱȨÏÞ£¬²¢ÉèÖÃÃÜÂ룬×÷Ϊ·¢²¼¿ìÕÕÎļþµÄÓÐЧ·ÃÎÊÓû§¡£
2£®ÔÚSQL SERVERÏÂʵÏÖ·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷µÄͨÐÅÕý³££¨¼´¿ÉÒÔ»¥·Ã£©¡£´ò¿ª1433¶Ë¿Ú£¬ÔÚ·À»ðǽÖÐÉèÌØÀ ......
×î½ü´¦ÀíexcelÊý¾Ýµ¼Èëµ½Sql ServerÖУ¬Ê§°Ü£¬±¨´íÈçÏÂ
£º
×÷
ΪԴÁÐ3£¨“²úƷ˵Ã÷”£©µÄÊý¾Ý¶ÔÓÚËùÖ¸¶¨µÄ»º³åÇøÀ´½²Ì«´ó
¡£
ÎÒµÄexcelÎļþÖÐÓÐÒ»ÁнГ²úƷ˵Ã÷”£¬¾ÍÊÇһЩ
ÎÄ×Ö¡£Sql
server´¦Àíµ¼excelÊý¾ÝÁ÷³ÌÊÇÕâÑùµÄ£¬Ëü»áÏÈ´´½¨Ä¿±ê±í£¬ÔÙ°ÑexcelÊý¾ÝдÈ뻺³åÇø£¬È»ºóÔÙ°Ñ»º³åÇøÊý ......