Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÅäÖÃ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


Ïà¹ØÎĵµ£º

mysql±¸·Ý

¶ÔÓÚÖеȼ¶±ðÒµÎñÁ¿µÄϵͳÀ´Ëµ£¬±¸·Ý²ßÂÔ¿ÉÒÔÕâô¶¨£ºµÚÒ»´ÎÈ«Á¿±¸·Ý£¬Ã¿ÌìÒ»´ÎÔöÁ¿±¸·Ý£¬Ã¿ÖÜÔÙ×öÒ»´ÎÈ«Á¿±¸·Ý£¬Èç´ËÒ»Ö±ÖØ¸´¡£¶ø¶ÔÓÚÖØÒªµÄÇÒ·±Ã¦µÄϵͳ À´Ëµ£¬Ôò¿ÉÄÜÐèҪÿÌìÒ»´ÎÈ«Á¿±¸·Ý£¬Ã¿Ð¡Ê±Ò»´ÎÔöÁ¿±¸·Ý£¬ÉõÖÁ¸üƵ·±¡£ÎªÁ˲»Ó°ÏìÏßÉÏÒµÎñ£¬ÊµÏÖÔÚÏß±¸·Ý£¬²¢ÇÒÄÜÔöÁ¿±¸·Ý£¬×îºÃµÄ°ì·¨¾ÍÊDzÉÓÃÖ÷´Ó¸´ÖÆ»ú ÖÆ(replica ......

MySQLÖÐÐÞ¸ÄÃÜÂë¼°·ÃÎÊÏÞÖÆÉèÖÃÏê½â

¡¡MySQLÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£MySQLÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqldºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£ÓÉÓÚÆäÔ´ÂëµÄ¿ª·ÅÐÔ¼°Îȶ¨ÐÔ£¬ÇÒÓëÍøÕ¾Á÷ÐÐ±à »ÓïÑ PHPµÄÍêÃÀ½áºÏ£¬ÏÖÔںܶàÕ¾µã¶¼ÀûÓÃÆäµ±×÷ºó¶ËÊý¾Ý¿â£¬Ê¹Æä»ñµÃÁ˹㷺ӦÓᣴ¦ÓÚ°²È«·½ÃæµÄ¿¼ÂÇ£¬ÐèҪΪÿһÓû§¸ ......

ÔÚLinuxÏ£¬°²×°Mysql£¨tar£©

# 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Á¬½Ó¶à¸öMySQLÊý¾Ý¿â


ÔÚphpmyadminµÄ¸ùĿ¼Ï½¨Á¢config.inc.php
дÈëÈçÏ´úÂ룺
<?php
//phpmyadmin ÅäÖÃÎļþ
//±¾µØMySQLÊý¾Ý¿â
$i=1;
$cfg['Servers'][$i]['host']          =
'localhost';
$cfg['Servers'][$i]['user']          ......

²úÆ· °²×°ÖÐµÄ MySql ÂÌ»¯½Ì³Ì

    ×î½üÊÕµ½·´À¡£¬ºÜ¶à¿Í»§Á¬MySql¶¼ÎÞ·¨ÕýÈ·°²×°¡£ÊÕµ½ÈÎÎñ£¬Òª½«MySql´òµ½²úÆ·ÖУ¬ºÍ²úÆ·Ò»Æð°²×°ºÍÐ¶ÔØ£¬À­¿ª¼Ü
ʽ¸É°É£¬Ã»·¨×Ó¡£
    Ñо¿Ò»Õ󣬷¢ÏÖ½«°²×°ºÃµÄMySqlÎļþ¼ÐCopyµ½ÆäËüµçÄÔÉÏ£¬ÔÙ½â¾öºÃÁ½¸öÎÊÌâÓ¦¸Ã¾Í¿ÉÒԺͰ²×°°æÒ»ÑùÕý³£Ê¹Óá£
1.Copyµ½ÁËÆäËüµçÄÔÉϵIJ»Í¬Ä¿Â¼£¬Ó¦¸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ