СµÜÒÔǰûѧ¹ýmysql£¬×î½ü²Å½Ó´¥£¬ÓõÄÊÇmysql5.0Ãâ°²×°°æºÍSql-Front£¬µ¼Èë±ðÈ˵ÄÊý¾Ý
¿âºó£¬±íÖÐÔÓÐÊý¾ÝÖÐÎÄÈ«ÊÇÂÒÂ룬²»¹ýÎÒ×Ô¼ºÍù±íÖвåÈëÖÐÎÄÊý¾ÝÈ»ºó²éѯû³öÏÖÂÒÂ룬
ÎÒÔÚÍøÉϲéÁËһϣ¬ÊÔÁ˺ü¸ÖÖ½â¾ö·½·¨»¹ÊÇû½â¾ö£¬µ¼ÈëµÄsqlÎļþµÚÒ»ÐУº-- MySQL
dump 10.11 ÊDz»Êǰ汾ÎÊÌ⣿»¹Ó ......
mysqlÊý¾Ý¿âµ¼ÈëºÍµ¼³öµÄÎÊÌ⣡
´Ó±¾µØÏòÔ¶³Ì·þÎñÆ÷µ¼ÈëÊý¾Ý£¬µ¼ÈëÒ»ÇÐÕý³£
ÓÃmyeclipseµÄ¹¤¾ßDB Browser²é¿´£¬Êý¾ÝÒ²Õý³££¬
µ«ÊÇÍøÒ³·ÃÎÊʱ±¨org.apache.jasper.JasperException: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hiber ......
ÓÐ4¸ö±í
user ×Ö¶Î user_id,user_regtime(user_regtime Ϊʱ¼ä Y-m-d H:i:s)
liket ×Ö¶Î liket_w,user_id
info ×Ö¶Î info_name,info_ww,user_id
tyu ×Ö¶Î tyu_dd,user_id
ÎÒÏë²é³öÀ´11ÔÂ12ºÅÒÔºóµÄÒÔÉϸö×ֶζÔÓ¦µÄÐÅÏ¢sqlÓï¾ä¸ÃÔõÃ´Ð´ÄØ£¿ÏÂÃæÊÇÎÒдµÄ£¬¿ÉÒÔ²é³öÀ´£¬µ«ÊÇwhereºóÃæµÄÌõ¼þÒ»Ö±²»Ä ......
±¾µØ ÊÖ¶¯Ð´ÈëMYSQL ÖÐÎÄÊÇ¿ÉÒÔµÄ
´ÓÊÖ»úдÈëMYSQL¶¼ÊÇ¡°£¿£¿£¿£¿¡±
ÊÖ»úÊÇÓÃHTTP ·ÃÎÊurl
url = MainCanvas.url_add+"&Uname="+Uname+"&Uage="+Uage+"&Usex="+Usex+"&Upass="+Upass;
Uname ÊÇÓ¢ÎĵľͺÜÕý³£ ÖÐÎľͲ»¿ÉÒÔÁË
J2ME ÀïÃæÒѾh ......
°²×°MysqlʱÓöµ½ÎÊÌ⣬Ìáʾlibc.so.6£¨Glibc_2.3.4) is needed by Mysql¡¡
libpthread.so.0£¨Glibc_2.3.4£©is needed by ¡¡
rtld£¨GUN_hash)is needed by ¡¡
ÇëÎÊÎÒ¸ÃÈçºÎ¼ÌÐø°²×°£¬ÔÚlibĿ¼Ï·¢ÏÖ´æÔÚlibc.so.6Ôõô³öÏÖÕâÖÖÌáʾ£¬ÎҵĻ·¾³redhat linux9
²»¶®....
libc.so.6ÊDz»ÊÇÒªÖØÐ°²×°Ï£¿£¿£¿
......
SQL code:
create procedure(in w varchar(20),out c int)
begin
set @sqlcount=concat('select count(*) into @c from scms_product where ',w);
prepare stm1 from @sqlcount;
execute stm1;
set c=@c;
set @sql=concat('select * from scms_product where ',w);
prepare stm2 from @sql;
execute stm2;
en ......