本文共 1295 字,大约阅读时间需要 4 分钟。
版权声明
本文首发自CSDN博客:http://blog.csdn.net/sisyphus_z;
作者:alex_zuo
无需授权即可转载,但请自觉保留以上版权声明。
技术点:使用Sqlite3实现递归查询,分页查询
向下递归
向上递归WITH RECURSIVE down(id,name,pid,layer,sort,type_id,is_piece,piece_Id,type_tree_id,group_id) AS ( SELECT id,name,pid,layer,sort,type_id,is_piece,piece_Id,type_tree_id,group_id FROM t_product_tree WHERE id='2014112411014156812' UNION SELECT a.id,a.name,a.pid,a.layer,a.sort,a.type_id,a.is_piece,a.piece_Id,a.type_tree_id,a.group_id FROM t_product_tree a,down b WHERE b.id = a.pid ) SELECT * from down WITH RECURSIVE up(id,name,pid,layer,sort,type_id,is_piece,piece_Id,type_tree_id,group_id) AS ( SELECT id,name,pid,layer,sort,type_id,is_piece,piece_Id,type_tree_id,group_id FROM t_product_tree WHERE id='2014112411014156812' UNION SELECT a.id,a.name,a.pid,a.layer,a.sort,a.type_id,a.is_piece,a.piece_Id,a.type_tree_id,a.group_id FROM t_product_tree a,up b WHERE b.pid = a.id ) SELECT * from up