mysql ¸Ä¸öº¯Êý - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
create table treeNodes
(
id int primary key,
nodename varchar(20),
pid int
);
CREATE FUNCTION `getChildLst`(rootId INT)
RETURNS varchar(1000)
BEGIN
DECLARE sTemp VARCHAR(1000);
DECLARE sTempChd VARCHAR(1000);
SET sTemp = '$';
SET sTempChd =cast(rootId as CHAR);
WHILE sTempChd is not null DO
SET sTemp = concat(sTemp,',',sTempChd);
SELECT group_concat(id) INTO sTempChd from treeNodes where FIND_IN_SET(pid,sTempChd)>0;
END WHILE;
RETURN sTemp;
END
Õâ¸öÊDzé³öËùÓÐ×Ó½Úµãid $,1,2,3,4,5,6,7
ÎÒÏëÒª²é³öËùÓи¸±²½Úµãid £¬Éî¶ÈΪ10 (¾ÍÊÇÖ»²é10¸ö¸¸±²½Úµã)£¬Èç¹û³¬¹ý10¸öºóÃæµÄ¾Í²»²é²»À´
ɾ³ý½á¹û '1','2','3','4'
½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£
²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓµÄÌáÎÊ·½Ê½http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html
1. ÄãµÄ create table xxx .. Óï¾ä
2. ÄãµÄ insert into xxx ... Óï¾ä
3. ½á¹ûÊÇʲôÑù£¬£¨²¢¸øÒÔ¼òµ¥µÄËã·¨ÃèÊö£©
4. ÄãÓõÄÊý¾Ý¿âÃû³ÆºÍ°æ±¾(¾³£ÓÐÈËÔÚMS SQL server°æÎÊ MySQL)
&nbs
Ïà¹ØÎÊ´ð£º
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......
ÎÒÒѾ°²×°mysqlÁË£¬ÉèÖõĿª»ú²»Æô¶¯£¬µ«ÔÚÎҵĵçÄÔ'->'¹ÜÀí'->'·þÎñºÍÓ¦ÓóÌÐò'->·þÎñÖÐÕÒ²»µ½mysql£¬ÕâÑù¾Íû·¨Æô¶¯ÁË£¬ÎÒÏëѯÎÊÒ»ÏÂÕâµ½µ×ÊÇÔõô»ØÊ£¬ÏÈллÁË
ÓÐºÃ¶àµØ·½ÄØ
×¢²á±í
Æô¶¯Îļþ¼ÐµÈ
......