Tomcat+mysqlÁ¬½Ó³ØµÄÅäÖÃÓë²âÊÔ

»·¾³:
Tomcat6.0.18
Mysql: 5.1.36
Windwos XP sp2
×î½üÐèÒªÓõ½Tomcat+mysqlÁ¬½Ó³ØµÄÅäÖÃ,½ñÌìÔÚÍøÉϲéÁ˺öà×ÊÁÏ,ÀÏ×ÊÁÏÌ«¶à,¶ÔÓÚÒÔÉϵÄÀÏ°æ±¾tomcat¿ÉÄÜÓÐÓÃ,±¾ÈËûÓвâÊÔ¹ý,Õýȷд³ötomcat6.0ÅäÖõÄÎļäºÜÉÙ!ºÃ¶à×ÊÁÏÉÏÃæµÄÅäÖöÔÓÚÏÖÔÚаæµÄ¼¸ºõ¶¼ÊÇÓÐÎÊÌâµÄ,Ê®´íÆß°Ë!½ñÌì°ÑÎÒÅäÖõÄÕýÈ··½·¨Ð´ÏÂÀ´,¹©´ó¼Ò²Î¿¼!
1.°²×°tomcat,ÂÔ;
2.°²×°mysqlÂÔ,
½øÈëmysql,н¨Êý¾Ý¿âtest1;
test1 Êý¾Ý¿â Öн¨±ípet,±í½á¹¹ÈçÏÂ;
mysql> desc pet;
+---------+----------+------+-----+---------+-------+
| Field | Type     | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| name | char(20) | YES   |     | NULL |    |
| owner | char(20) | YES   |     | NULL |    |
| species | char(20) | YES   |     | NULL |    |
| sex     | char(1)   | YES   |     | NULL |    |
| birth | date     | YES   |     | NULL |    |
| death | date     | YES   |     | NULL |    |
+---------+----------+------+-----+---------+-------+
¼ÓÈëһЩÊý¾Ý;
INSERT INTO pet VALUES ('Öí°Ë½ä','ÌÆÉ®','ÉñÏÉ','f','2001-12-01',NULL);
ÕâÀï×¢Òâmysql±í×Ö·û¼¯ÉèÖÃ,ºÜÓпÉÄÜÔÚ¿Í»§¶ËºÍJSPÖÐÂÒÂë,¿É²Î¿¼ÎÒдµÄÎÄÕÂ:
eclipseÁ¬½ÓmysqlÂÒÂë¼°mysql[ERROR 1366 (HY000):´íÎó]
http://c02949.blog.163.com/blog/static/485037200962345218147/
ÍøÉÏËѵ½µÄºÃ¶à×ÊÁÏ˵:tomcatÅäÖÃmysqlÁ¬½Ó³ØÐèÒª¸Ä:
ÅäÖÃtomcatϵÄconfϵÄcontext.xml
ÅäÖÃtomcatϵÄconfϵÄwebt.xml
ÅäÖÃtomcatϵÄconfϵÄserver.xml ÂÒÆß°ËÔã,º¦ÎÒ°ÑTomcat6.0ÖØ×°Ò»´Î!ÀË·ÑÁ˺öàʱ¼ä.
ÕýÈ·µÄÅäÖ÷½·¨Ö»ÐèÒªÐÞ¸Äcontext.xmlºÍweb.xmlÁ½¸öÎļþ:
context.xmlÔÚ<context></context>Ö®¼äÌí¼ÓÁ¬½Ó³ØÈçÏÂ:
<Resource name="jdbc/mysql" auth="Container"
type="javax.sql.DataSource"
maxActive="50" maxIdle="10" maxWait="5000"
username="ÄãµÄmysqlÓû§" password="ÄãµÄmysqlÃÜÂë"
driverClass