TOMCAT/MySQL JNDIʹÓÃÅäÖÃ˵Ã÷

TomcatÅäÖÃ
Èç¹û³öÏÖ
Unable to find a javac compiler;
com.sun.tools.javac.Main is not on the classpath.
Perhaps JAVA_HOME does not point to the JDK
...
Tomcat ClassPathÅäÖÃÈçÏ£º
C:\Program Files\Apache Software Foundation\Tomcat 5.0\bin\bootstrap.jar;C:\Program Files\Java\jdk1.5.0\lib\tools.jar
MySQLÄ¿Ç°°æ±¾Îª 4.0.21
ÏÂÔصØÖ·: http://dev.mysql.com/downloads/mysql/4.0.html
MySQLÅäÖÃ
c:\mysql\bin>mysqld¡¡¡¡¡¡¡¡ //Æô¶¯mysqlµÄ·þÎñ½ø³Ì
c:\mysql\bin\mysql -uroot //Á¬½Óµ½mysqlÊý¾Ý¿â
¡¡¡¡mysql>update user set password=PASSWORD('<new_root_password>') where user='root';
¡¡¡¡mysql>flush privileges;
¡¡¡¡ÉÏÃæµÄ²Ù×÷ÊÇÐÞ¸ÄrootÓû§µÄÃÜÂ룬'<new_root_password>'ÊÇÄãÉèÖõÄÃÜÂë¡£
¡¡¡¡mysql>create database gamedb;¡¡ ¡¡¡¡¡¡//´´½¨gamedb¿â
¡¡¡¡mysql>connect gamedb;¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ //Á¬½Óµ½gamedb¿â
¡¡¡¡mysql>source gamedb.sql;¡¡ //gamedb³õʼ»¯½¨±í
mysql>GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER,
CREATE, DROP, REFERENCES, LOCK TABLES,
CREATE TEMPORARY TABLES
ON gamedb.* TO gamedb@localhost IDENTIFIED BY '<gamedb_password>';
¡¡¡¡mysql>flush privileges;
¡¡¡¡ÉÏÃæÊǽ¨Á¢gamedbÓû§£¬<gamedb_password>ΪgamedbÓû§µÄÃÜÂë¡£
¡¡¡¡mysql>exit;¡¡¡¡¡¡//Í˳ö
ÏÂÔØMySQL JDBC
Connector/J 3.0.15-ga (MySQL.comÌṩµÄJDBC Driver)
ÏÂÔصØÖ·:http://dev.mysql.com/downloads/connector/j/3.0.html
°²×°JDBC
mysql-connector-java-3.0.15-ga.zip½âѹºó½«mysql-connector-java-3.0.15-ga-bin.jar ¸´ÖƵ½%TOMCAT_HOME%\common\libÏÂ
ÅäÖÃTomcat
¼ÙÉ裺Êý¾Ý¿â£ºgamedb Óû§Ãû£ºgamedb ÃÜÂ룺gamedb
µÚÒ»²½: http://127.0.0.1:8080£¬½øÈëtomcatÒ³£¬ÓÃtomcatµÄ Tomcat Administration--->Resources--->Data SourcesÒ³ÃæÌí¼Ó£¬²ÎÊýÈçÏ£º
JNDI Name: jdbc/mysql
Data Source URL: jdbc:mysql://localhost:3306/gamedb?autoReconnect=true&useUnicode=true&characterEncoding=GB2312
JDBC Driver Class: com.mysql.jdbc.Driver
User Name: gamedb
Password: g