Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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">


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

mysql updateÓï¾äµÄÎÊÌâ

ÎÒÏëÒª¸üÐÂij¸ö±íÅÅÐòºó¿¿Ç°µÄÊý¾Ý£¬ÓÚÊÇдÁËÒ»¸öÓï·¨£º
update dcproduct set pOrder=pOrder+2 order by pOrder desc,id desc limit 6£»Õâ¸öÊÇ¿ÉÒÔÔËÐеģ¬½á¹ûÊǸüÐÂÁËÇ°ÁùÌõ¼Ç¼¡£
ºóÀ´·¢ÏÖ©Á˸öÌõ¼þÒªÁ¬± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ