Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......

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

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

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

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

ÎÒÏëÒª¸üÐÂij¸ö±íÅÅÐòºó¿¿Ç°µÄÊý¾Ý£¬ÓÚÊÇдÁËÒ»¸öÓï·¨£º
update dcproduct set pOrder=pOrder+2 order by pOrder desc,id desc limit 6£»Õâ¸öÊÇ¿ÉÒÔÔËÐе쬽á¹ûÊǸüÐÂÁËǰÁùÌõ¼Ç¼¡£
ºóÀ´·¢ÏÖ©Á˸öÌõ¼þÒªÁ¬± ......

Hibernate MySql Ö÷¼üÉú³ÉÎÊÌâ

ÎÒÏÖÔÚboÀïÃæÖ÷¼üÓõÄÊÇIntegerÀàÐ͵ģ¬ÎÒÏëÖ÷¼ü×Ô¶¯Ôö³¤£¬ÓÃidentityÕâ¸öÐÐô£¿

/**
  * @return id
  * @hibernate.id generator-class="identity"
*/
public Integer ge ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ