CREATE PROCEDURE createChildLst (IN rootId INT,IN nDepth INT) BEGIN DECLARE done INT DEFAULT 0; DECLARE b INT; DECLARE cur1 CURSOR FOR SELECT id from treeNodes where pid=rootId; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
insert into tmpLst values (null,rootId,nDepth); OPEN cur1; FETCH cur1 INTO b; WHILE done=0 DO CALL createChildLst(b,nDepth+1); FETCH cur1 INTO b; END WHILE;
我用的是连接池做的，配连接池的方法应该没有错，为什就是出现这种问题 javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test 请问大侠们这是� ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
