tomcat+mysqlÁ¬½Ó³ØµÄÅäÖÃ
ÔÚTOMCAϵÄCatalina\localhostĿ¼µÄ¹¤³Ìxml£¬±àдÈçÏ´úÂ룺
<Context path="/testProject" docBase="E:\project\TestProject\WebContent" reloadable="true" debug="0" privileged="true">
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mysql">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/mysql</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
</ResourceParams>
</Context>
ÔÚ¹¤³ÌĿ¼WebContent\WEB-INFϵÄweb.xmlÖÐÌí¼Ó£º
<resource-ref>
<description>DB Connection</description>
¡¡¡¡<res-ref-name>jdbc/mysql</res-ref-name>
¡¡¡¡<res-type>javax.sql.DataSource</res-type>
¡¡¡¡<res-auth>Container</res-auth>
Ïà¹ØÎĵµ£º
±íÃûΪtableµÄ±íÄÚÈÝÈçÏÂ
Year month value
2009 1 1.1
2009 2 1.2
2009 3 1.3
2009 4 1.4
2010 1 2.1
2010 2 2.2
2010 3 &nb ......
RedHat Linux (Fedora Core/Cent OS)
1.Æô¶¯£º/etc/init.d/mysqld start
2.Í£Ö¹£º/etc/init.d/mysqld stop
3.ÖØÆô£º/etc/init.d/mysqld restart
Debian / Ubuntu Linux
1.Æô¶¯£º/etc/init.d/mysql start
2.Í£Ö¹£º/etc/init.d/mysql stop
3.ÖØÆô£º/etc/init.d/mysql restart
Windows
1.µã»÷“¿ªÊ¼&rdq ......
×î½üÓиöÏîÄ¿Òª²¿Êðµ½linuxÉÏ£¬ÔÚÍøÉϲéÁËЩ×ÊÁÏ£¬¼ÇϵãÓöµ½µÄÎÊÌ⣬ÒԱ㽫À´ÔÙÓá£
Ò»£ºjdk°²×°
1.ͨ¹ýchmod a+x jdk-1_5_x-rc-linux-i586-rpm.binÃüÁîʹÆä»ñµÃ¿ÉÖ´ÐÐȨÏÞ
2.ͨ¹ý rpm –ivh jdk-1_5_x-rc-linux-i586-rpm.binÀ´½øÐа²×°
3.°²×°Íê±Ï,JDK°²×°ÔÚ/usr/java/Ŀ¼ÏÂ
4.ÉèÖû·¾³±äÁ¿(дÈëvi/etc/ ......
Ò»¡¢Á¬½ÓMYSQL
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂ룬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³µ¼´¿É½øÈëµ½MYSQLÖÐÁË£¬MYSQLµÄÌáʾ·ûÊÇ£ºmysql>
2¡¢Àý2£ºÁ¬½Óµ½Ô ......
»ù±¾²éѯ
SELECTÓï¾äÓÃÓÚ²éѯÊý¾Ý¿âºÍSQLÖеÄËùÓÐÊä³ö²Ù×÷¡£
SELECTc_u_name, emailfromcooya_users;
Êä³öcooya_users±íÖÐËùÓÐÐУ¨»ò¼Ç¼£©µÄÊôÐÔc_u_nameºÍemailµÄÖµ¡£
Èç¹ûÐèÒªËùÓÐÊôÐÔ£¬¿ÉÒÔʹÓÃÐǺţ¨*£©µÄ¿ì½Ý·½Ê½¡£
SELECT* from cooya_users;
SELECTÓï¾ä»¹¿ÉÒÔÊä³ö²»ÊÇÊý¾Ý¿âÖеÄÊý¾Ý¼°¿ÉÒÔÓÃ×÷¼òµ¥µÄ¼ÆËã·û ......