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

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚMETA-INF/context.xmlÀïÅäÖÃÁ¬½Ó²ÎÊý£¬
²¢ÇÒmysql5.1.5.jarµÄÇý¶¯³ÌÐò²»¿ÉÒÔ¿½±´µ½<tomcat>/libĿ¼Ï£¬Ö»ÄÜ·ÅÔÚ<app>/WEB-INF/libĿ¼ÏÂ

Ôì³ÉÔËÐÐÎÒµÄÓ¦ÓóÌÐòʱ£¬³öÏÖÒÔÏ´íÎó£ºjava.lang.Exception : Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

Èç¹û°Ñmysql5.1.5.jar¿½±´µ½<tomcat>/libĿ¼Ï£¬Ôò¿ÉÒÔÕý³£ÔËÐУ¬µ«ÐéÄâÖ÷»ú¼¼ÊõÈËÔ±²»ÔÊÐí°Ñ´ËÇý¶¯³ÌÐò·ÅÈëµ½´ËĿ¼
ÎÒÓ¦¸ÃÔõô°ì£¿¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±¼±!!!!!!

<WebRoot/META-INF/context.xmlÎļþÄÚÈÝ>

<?xml version="1.0" encoding="UTF-8"?>
<Context reloadable="true" crossContext="true">
<!-- <WatchedResource>WEB-INF/web.xml</WatchedResource> -->
<Resource 
name="jdbc/clProj" 
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://127.0.0.1:3306/clproj?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"
username="ProjUser"
password="123"
maxActive="20"
maxIdle="5"
maxWait="5000">


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

mysql ¼òµ¥ÎÊÌâ

¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿

1  nike  100        ϵͳʱ¼ä
2  nike  300  &n ......

mysql´¢´æ¹ý³ÌµÄÎÊÌâ

ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ