mysqlÁ¬½Ó - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
mysqlÔõôÓëmyeclipseÁ¬½Ó
¸½£ºmysqlÊDz»ÊÇÖ»ÄÜÔÚDOSÏÂÔËÐÐ
лл£¡
jackham0 (jackham0)
'½ØÖÁ2010-05-04 12:37:34 Óû§½áÌûÂÊ0.00%
µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
Ïà¹ØÎÊ´ð£º
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......
begin
insert into userInfo(userName,userCode,delOrNot) values(in_userName,in_userCode,0);
end
´æ´¢¹ý³Ì£¬Á¬MYSQL NAVICATÀïÃæÐ´µÄ£¬²âÊÔ£¬²ÎÊý²»ÊÇÖÐÎľÍOK£¬¿ÉÒÔÔËÐÐ
±ÈÈçÎÒ²ÎÊý: 'wangwu','cctv-2010'ÔË ......
ÔõôÕÒµ½Êý¾Ý¿âµÄλÖ𡣿Çë¸÷λǰ±²Ö¸½Ìһϣ¿Ð¡µÄ·Ç³£¸Ðл£¡
ÏÈÕÒµ½my.cnfÎļþ£¬´ò¿ªºó¿´[data]ϵÄdatadir
2¡¢½øÈëmysqlÖÕ¶Ë£º
mysql>show variables like '%datadir%';
ÔÙ²»ÐÐÈ«ÅÌËÑË÷£º¡¡frmÎļþ
......