ÅäÖÃtomcat5.5 jndi ¸÷ÖÖÅäÖ÷½Ê½ ·ÖÎö×ܽᣨmysql£©
×¼±¸¹¤×÷£º
°²×°tomcat5.5£¨×¢ÒâÕâµã£©
°²×°mysql
¿½±´mysqlÇý¶¯µ½tomcat_home/common/libÏÂ
н¨Ò»¸öweb¹¤³Ì
ÔÚ¹¤³ÌÖмÓÈëindex.jsp
<%@page import="java.util.*,javax.naming.*,java.sql.*,javax.sql.*" %>
<%@page contentType="text/html;charset=BIG5"%>
<%
Context ctx = new InitialContext();
String strLookup = "java:comp/env/jdbc/test";
DataSource ds =(DataSource) ctx.lookup(strLookup);
Connection con = ds.getConnection();
if (con != null){
out.print("success");
}else{
out.print("failure");
}
%>
web.xmlÖмÓÈë
<resource-ref>
<res-ref-name>jdbc/test</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
ÅäÖÃtomcat
ÕâÒ»²½µÄÄ¿µÄ¾ÍÊǸæËßtomcatÈçºÎÁ¬½ÓÊý¾Ý¿â
¿ÉÒÔ·ÖΪÁ½ÖÖ´óµÄÀàÐÍ£¬Ã¿ÖÖÀàÐÍÓÖÓкܶàÖÖÅäÖ÷½Ê½
ÅäÖÃÀàÐÍÒ»£»
(Ö±½ÓÅäÖõÄÀàÐÍ£¬ÕâÖÖ·½Ê½×î¼òµ¥)
·½·¨Ò»£º
Ö±½ÓÔÚtomcat_home/conf/localhost/Ͻ¨Á¢Ò»¸öxmlÎļþ£¬ÎļþÃûÊÇ<yourAppName>.xml
ÀýÈçÎҵŤ³ÌÃû½Ðjndi£¬¶ÔÓ¦µÄÃû×Ö½Ðjdni.xml
ÄÚÈÝÈçÏÂ:
<Context>
<Resource
name="jdbc/test"
type="javax.sql.DataSource"
password="bb"
&nb
Ïà¹ØÎĵµ£º
¶ÔÓÚÖеȼ¶±ðÒµÎñÁ¿µÄϵͳÀ´Ëµ£¬±¸·Ý²ßÂÔ¿ÉÒÔÕâô¶¨£ºµÚÒ»´ÎÈ«Á¿±¸·Ý£¬Ã¿ÌìÒ»´ÎÔöÁ¿±¸·Ý£¬Ã¿ÖÜÔÙ×öÒ»´ÎÈ«Á¿±¸·Ý£¬Èç´ËÒ»Ö±ÖØ¸´¡£¶ø¶ÔÓÚÖØÒªµÄÇÒ·±Ã¦µÄϵͳ À´Ëµ£¬Ôò¿ÉÄÜÐèҪÿÌìÒ»´ÎÈ«Á¿±¸·Ý£¬Ã¿Ð¡Ê±Ò»´ÎÔöÁ¿±¸·Ý£¬ÉõÖÁ¸üƵ·±¡£ÎªÁ˲»Ó°ÏìÏßÉÏÒµÎñ£¬ÊµÏÖÔÚÏß±¸·Ý£¬²¢ÇÒÄÜÔöÁ¿±¸·Ý£¬×îºÃµÄ°ì·¨¾ÍÊDzÉÓÃÖ÷´Ó¸´ÖÆ»ú ÖÆ(replica ......
¡¡MySQLÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£MySQLÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqldºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£ÓÉÓÚÆäÔ´ÂëµÄ¿ª·ÅÐÔ¼°Îȶ¨ÐÔ£¬ÇÒÓëÍøÕ¾Á÷ÐÐ±à »ÓïÑ PHPµÄÍêÃÀ½áºÏ£¬ÏÖÔںܶàÕ¾µã¶¼ÀûÓÃÆäµ±×÷ºó¶ËÊý¾Ý¿â£¬Ê¹Æä»ñµÃÁ˹㷺ӦÓᣴ¦ÓÚ°²È«·½ÃæµÄ¿¼ÂÇ£¬ÐèҪΪÿһÓû§¸ ......
# cd /home/tmp (½øÈëѹËõ°üËùÔÚĿ¼)
# groupadd mysql (½¨Á¢mysql×é)
# useradd -g mysql mysql (ÔÚmysql×éÖн¨Á¢mysqlÓû§)
# tar -zxvf mysql-5.0.37.tar.gz (½âѹmysqlÔ´Âë,bz2ѹËõ°üÇëÓÓtar -jvxf ÎļþÃû”Ö¸Áî)
# cd mysql-5.0.37 (½øÈë½âѹĿ¼)
# ./configure --prefix=/usr/local/mysql (p ......
ÔÚphpmyadminµÄ¸ùĿ¼Ï½¨Á¢config.inc.php
дÈëÈçÏ´úÂ룺
<?php
//phpmyadmin ÅäÖÃÎļþ
//±¾µØMySQLÊý¾Ý¿â
$i=1;
$cfg['Servers'][$i]['host'] =
'localhost';
$cfg['Servers'][$i]['user'] ......
×î½üÊÕµ½·´À¡£¬ºÜ¶à¿Í»§Á¬MySql¶¼ÎÞ·¨ÕýÈ·°²×°¡£ÊÕµ½ÈÎÎñ£¬Òª½«MySql´òµ½²úÆ·ÖУ¬ºÍ²úÆ·Ò»Æð°²×°ºÍÐ¶ÔØ£¬À¿ª¼Ü
ʽ¸É°É£¬Ã»·¨×Ó¡£
Ñо¿Ò»Õ󣬷¢ÏÖ½«°²×°ºÃµÄMySqlÎļþ¼ÐCopyµ½ÆäËüµçÄÔÉÏ£¬ÔÙ½â¾öºÃÁ½¸öÎÊÌâÓ¦¸Ã¾Í¿ÉÒԺͰ²×°°æÒ»ÑùÕý³£Ê¹Óá£
1.Copyµ½ÁËÆäËüµçÄÔÉϵIJ»Í¬Ä¿Â¼£¬Ó¦¸ ......