# newssites

**Repository Path**: lilingyan/newssites

## Basic Information

- **Project Name**: newssites
- **Description**: No description available
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2018-03-01
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# newssites 新闻发布系统

文件支持分片上传下载
header(头字段  不加则都为全上传 全下载)
上传:
文件名必须是第一次上传的标记号(id)
Segment:0   0否 1是   #续传文件标记
Range:pos-length      #pos:文件起始位(不加则为从头) length:写入长度(不加则为到最后)
下载：
Range:pos-length      #pos:文件起始位 length:下载长度

#递归获取子目录id
DROP FUNCTION IF EXISTS `getCatChildList`;
DELIMITER //
CREATE FUNCTION `getCatChildList` (nodeId INT) RETURNS VARCHAR (2000)
BEGIN
  DECLARE str VARCHAR (2000);
  DECLARE cid VARCHAR (11);
  SET str = '';
  SET cid = CAST(nodeId AS CHAR);
  WHILE
    (cid IS NOT NULL) DO 
    IF (str = '')
    THEN SET str = cid;
    ELSE SET str = CONCAT(str, ',', cid);
    END IF;
    SELECT
      GROUP_CONCAT(id) INTO cid
    FROM
      `cat`
    WHERE FIND_IN_SET(pid, cid) > 0;
  END WHILE;
  RETURN str;
END //