ÎÒÓÐÒ»¸ö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&useUnicode=true&characterEncoding=UTF-8"
username="ProjUser"
password="123"
maxActive="20"
maxIdle="5"
maxWait="5000">
Ïà¹ØÎÊ´ð£º
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÏëÒª¸üÐÂij¸ö±íÅÅÐòºó¿¿Ç°µÄÊý¾Ý£¬ÓÚÊÇдÁËÒ»¸öÓï·¨£º
update dcproduct set pOrder=pOrder+2 order by pOrder desc,id desc limit 6£»Õâ¸öÊÇ¿ÉÒÔÔËÐе쬽á¹ûÊǸüÐÂÁËǰÁùÌõ¼Ç¼¡£
ºóÀ´·¢ÏÖ©Á˸öÌõ¼þÒªÁ¬± ......
ÎÒÏÖÔÚboÀïÃæÖ÷¼üÓõÄÊÇIntegerÀàÐ͵ģ¬ÎÒÏëÖ÷¼ü×Ô¶¯Ôö³¤£¬ÓÃidentityÕâ¸öÐÐô£¿
/**
* @return id
* @hibernate.id generator-class="identity"
*/
public Integer ge ......