Tomcat+MySQl JDBCÁ¬½Ó³ØµÄÅäÖÃ
1¡¢°²×°Tomcat
JDBCÁ¬½Ó³ØÅäÖõĵÚÒ»²½ÊÇÏÂÔغͰ²×°Tomcat¡£²Î¿¼Tomcat for window µÄ°²×°Ïòµ¼£¬»ù±¾Ö±½Ó°²×°¼´¿É£¬×¢Ò⣺°²×°Ê±»áÌáʾÊäÈë¹ÜÀíÓû§ÃûºÍÃÜÂ룬ÕâÊÇÒÔºó»áÓõ½µÄÓû§ÃûºÍÃÜÂ룬Çмǡ£
2¡¢°²×°MySql
ĬÈÏ°²×°¼´¿É¡£
3¡¢Ê¹ÓÃTomcatµÄWeb¹ÜÀíÓ¦ÓÃÅäÖÃÊý¾ÝÔ´
Æô¶¯Tomcat·þÎñÆ÷£¬´ò¿ªä¯ÀÀÆ÷£¬ÊäÈëhttp://localhost:8080/admin/£¨ÆäÖÐlocalhost¿ÉÄÜÊÇһ̨»úÆ÷µÄIP»òÊÇ·þÎñÆ÷Ãû³Æ£©£¬½øÈë¹ÜÀí½çÃæµÄµÇ½ҳÃ棬ÕâʱºòÇëÊäÈëÔÀ´°²×°Ê±ÒªÇóÊäÈëµÄÓû§ÃûºÍÃÜÂ룬µÇ½µ½¹ÜÀí½çÃ棬
Ñ¡ÔñResources£Data sources½øÈëJDBCÁ¬½Ó³ØÅäÖÃÊý¾ÝÔ´½çÃ棬ѡÔñData Source Actions £>Ñ¡ÔñCreate New Data Source,½øÈëÅäÖÃÏêϸÐÅÏ¢½çÃ棬ÄÚÈÝÈçÏ£º
JNDI Name: jdbc/mysql Data Source URL: jdbc:mysql://192.168.0.16/SUBRDB JDBC Driver Class: org.gjt.mm.mysql.Driver User Name: root Password: ******** Max. Active Connections: 4 Max. Idle Connections: 2 Max. Wait for Connection: 500 Validation Query:
ÒªÇóÊäÈëµÄJNDI NameµÈÐÅÏ¢£¬ÆäÖгýÁËJDBC DriverClassÖ®Í⣬ÆäËûµÄ¿ÉÒÔ¸ù¾ÝÄãµÄÐèÒªÌîд¡£±ÈÈçData Source URLµÄÄÚÈÝ¿ÉÄÜÊÇ£ºjdbc:mysql:// IP»òÊÇÃû³Æ/DataBaseName£¬ÆäÖÐDataBaseNameÊÇÄãµÄÊý¾Ý¿âÃû³Æ£¬IPÊÇÄãµÄÊý¾Ý¿âµÄËùÔڵķþÎñÆ÷µÄIP»òÊÇÃû³Æ¡£×îºóµã»÷Save£>Commit Change.ÕâÑùÄãµÄÊý¾ÝÔ´µÄ»ù±¾×ÊÁÏÅäÖÃÒ»°ëÁË¡£
4¡¢web.xmlºÍ%TOMCAT_HOME%\conf\Catalina\localhost϶ÔÓ¦ÄãµÄÒýÓõÄÅäÖÃÎļþÐÞ¸Ä
ͨ¹ýÎļþ¼Ðµ¼º½µ½%TOMCAT_HOME%\conf£¬´ò¿ªweb.xml,ÔÚ</web-app>µÄÇ°ÃæÌí¼ÓÒÔÏÂÄÚÈÝ£º
<resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/mysql</res-ref-name> <res-type>javax.sql.DataSource</res-type>
Ïà¹ØÎĵµ£º
MysqlÊý¾Ý¿âÌṩÁ½ÖÖÀàÐ͵ÄË÷Òý£¬Èç¹ûûÕýÈ·ÉèÖã¬Ë÷ÒýµÄÀûÓÃЧÂÊ»á´ó´òÕÛ¿ÛÈ´ÍêÈ«²»ÖªÎÊÌâ³öÔÚÕâ¡£
CREATE TABLE test (
id INT NOT NULL,
last_name CHAR(30) NOT NULL,
first_name CHAR(30) NOT NULL,
PRIMARY KEY (id),
INDEX name (last_name,first_name)
);
ÒÔÉÏ´ ......
Êý¾Ý¿âĿ¼ÊÇMySQLÊý¾Ý¿â·þÎñÆ÷´æ·ÅÊý¾ÝÎļþµÄµØ·½£¬²»½ö°üÀ¨ÓйرíµÄÎļþ£¬»¹°üÀ¨Êý¾ÝÎļþºÍMySQLµÄ·þÎñÆ÷Ñ¡ÏîÎļþ¡£²»Í¬µÄ·Ö·¢£¬Êý¾Ý¿âĿ¼µÄȱʡλÖÃÊDz»Í¬µÄ¡£
Êý¾ÝĿ¼µÄλÖÃ
ȱʡµÄÊý¾Ý¿âλÖÃ
ȱʡÊý¾Ý¿âµÄλÖñàÒëÔÚ·þÎñÆ÷ÖС£
¡ôÈç¹ûÄúÊÇÔÚÒ»¸öÔ´³ÌÐò·Ö·¢°üÖа²×° MySQL£¬µäÐ͵ÄȱʡλÖÿÉÄÜÊÇ /usr/local/var ......
ÔÚÊý¾Ý¿â±íÖУ¬¶Ô×ֶν¨Á¢Ë÷Òý¿ÉÒÔ´ó´óÌá¸ß²éѯËٶȡ£¼ÙÈçÎÒÃÇ´´½¨ÁËÒ»¸ö
mytable
񡜧
CREATE TABLE mytable(
ID INT NOT NULL,
username VARCHAR(16) NOT NULL
);
ÎÒÃÇËæ»úÏòÀïÃæ²åÈëÁË
10000
Ìõ¼Ç¼£¬ÆäÖÐÓÐÒ»Ìõ£º
5555, admin
¡£
ÔÚ²éÕÒ
username="admin"
µÄ¼Ç¼
SELECT * from mytable WH ......
1¡¢ÏÂÔØMySQLµÄ°²×°Îļþ
°²×°MySQLÐèÒªÏÂÃæÁ½¸öÎļþ£º
MySQL-server-5.0.46.i386.rpm¡¡¡¡¡¡
MySQL-client-5.0.46.i386.rpm
2¡¢°²×°MySQL
rpmÎļþÊÇRed Hat¹«Ë¾¿ª·¢µÄÈí¼þ°²×°°ü£¬rpm¿ÉÈÃLinuxÔÚ°²×°Èí¼þ°üʱÃâ³ýÐí¶à¸´ÔÓµÄÊÖÐø¡£¸ÃÃüÁîÔÚ°²×°Ê±³£ÓõIJÎÊýÊÇ
ivh
,ÆäÖÐi±íʾ½«°²×°Ö¸¶¨µÄrmpÈí¼þ°ü£¬V±í ......
×î½ü±ðÈËÔÚ¸øÎÒ sql Îļþʱ¼òµ¥µÄÌáÁËÏ µ¼Èë/µ¼³ö ÃüÁÔÚ´Ë»ù´¡ÉÏѧϰÁËÏ£¬×ܽᵽ myhere¡£
¹æ¶¨£º
Óû§Ãû£ºdb_user
Õʺţº db_pass
Êý¾Ý¿â£º db_name
񡜧 table_name_1, table_name_2
˵Ã÷£º һЩ²Ù×÷ÐèÒªÓÐÊʵ±µÄȨÏÞ¡£
1. ......