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
Ïà¹ØÎĵµ£º
ÓÉÓÚµ±³õ±íÉè¼ÆµÄ²»ºÏÀí£¬ÂýÂýµÄ·¢ÏÖÀË·ÑÐí¶à¿Õ¼ä£¬ÇÒ¶ÔÀ©Õ¹²»Àû¡£¾ö¶¨²»°ÑͬÀàÐÍÄÚÈݲ¢ÅÅÁб£´æ£¬ËùÒÔ½ñÌì°Ñ¶àÓàµÄÁмôµô£¬²¹ÔÚ±£ÁôµÄÁÐÏÂÃæ¡£
ÔÚ±íÃûµãÓÒ¼ü£¬Êý¾Ý²Ù×÷£¬µ¼³öSQL½Å±¾Êý¾Ý¡£ÕÕÌáʾ²Ù×÷£¬ÕâÀïÎÒϲ»¶µÄÊÇ¿ÉÒÔÖ¸¶¨Áе¼³ö¡£
È»ºó°Ñ²»ÐèÒªµÄ¿ÕÁÐɾµô£¬¸ÄһϲåÈëµÄÁÐ ......
Ò»¡¢MySQL»ù±¾ÃüÁºÏ£º
1¡¢ create database mydata£»//´´½¨Êý¾Ý¿â
2¡¢ use mydata; //ÔÚmydataÕâ¸öÊý¾Ý¿âϹ¤×÷
3¡¢ create table dept //ÔÚmydataÊý¾Ý¿âÏ´´½¨±ídept
(
deptno int primary key,
dname varchar(14),
loc varchar(13)
);
create table emp / ......
MySQL½¨Á¢ÁÙʱ±íµÄÓï¾äÈçÏÂ:
CREATE TEMPORARY TABLE tmp (
article INT(4) UNSIGNED ZEROFILL DEFAULT '0000' NOT NULL,
price DOUBLE(16,2) DEFAULT '0.00' NOT NULL);
--LOCK TABLES article read;
--ÏȲåÈëÊý¾Ýµ½ÁÙʱ±í
INSERT INTO tmp SELECT article, MAX(price) from shop GRO ......
ÊýÖµÀàÐÍ
¡¡¡¡MySQL
µÄÊýÖµÊý¾ÝÀàÐÍ¿ÉÒÔ´óÖ»®·ÖΪÁ½¸öÀà±ð£¬Ò»¸öÊÇÕûÊý£¬ÁíÒ»¸öÊǸ¡µãÊý»òСÊý¡£Ðí¶à²»Í¬µÄ×ÓÀàÐͶÔÕâЩÀà±ðÖеÄÿһ¸ö¶¼ÊÇ¿ÉÓõģ¬Ã¿¸ö×ÓÀàÐÍÖ§³Ö²»Í¬´óСµÄÊý¾Ý£¬²¢ÇÒ
MySQL ÔÊÐíÎÒÃÇÖ¸¶¨ÊýÖµ×Ö¶ÎÖеÄÖµÊÇ·ñÓÐÕý¸ºÖ®·Ö»òÕßÓÃÁãÌî²¹¡£
¡¡¡¡±íÁгöÁ˸÷ÖÖÊýÖµÀàÐÍÒÔ¼°ËüÃǵÄÔÊÐí·¶Î§ºÍÕ¼ÓõÄÄÚ´æ¿Õ¼ä¡ ......
³õѧphp,ÐèÒª´î½¨Æ俪·¢»·¾³¡£ÓÉÓÚ°æ±¾¸üÌæµÈÔÒò£¬ÍøÉϵķ½·¨¼¸ºõÒ»ÈËÒ»¸öÑù£¬ÈÃÈËÎÞËùÊÊ´Ó¡£×òÌ컨ÁËÒ»ÍíÉÏʱ¼ä²ÅÔÚXPÏÂÅäÖúã¬ÏÖ½«ÆäÕûÀí³öÀ´£¬Ï£ÍûÄܶԱðÈËÓÐÓᣣ¨2007-11-21£©
Ò»¡¢ ÏÂÔØÈí¼þ¡£
1. ÏÂÔØapache_2.0.55-win32-x86-no_ssl.msi£¬ÓÒ¼üÓÃѸÀ×µã»÷´Ë´¦ÏÂÔØ£¨Ö±½Óµã»÷²»ÐУ©¡£
2. ÏÂÔØphp-5 ......