2011-10-10 0:24:49

本文详细解析了libavformat中的file协议实现,包括文件的打开、读取、写入、定位和关闭操作。
2011-10-10 0:24:49 


libavformat/file.c文件的file协议:


static int file_open(URLContext *h, const char *filename, int flags)
{
    int access;
    int fd;


    av_strstart(filename, "file:", &filename);


    if (flags & URL_RDWR) {
        access = O_CREAT | O_TRUNC | O_RDWR;
    } else if (flags & URL_WRONLY) {
        access = O_CREAT | O_TRUNC | O_WRONLY;
    } else {
        access = O_RDONLY;
    }
#ifdef O_BINARY
    access |= O_BINARY;
#endif
    fd = open(filename, access, 0666);
    if (fd == -1)
        return AVERROR(errno);
    h->priv_data = (void *) (intptr_t) fd;
    return 0;
}


文件打开 




static int file_read(URLContext *h, unsigned char *buf, int size)
{
    int fd = (intptr_t) h->priv_data;
    return read(fd, buf, size);
}
文件读取


static int file_write(URLContext *h, unsigned char *buf, int size)
{
    int fd = (intptr_t) h->priv_data;
    return write(fd, buf, size);
}
文件写






/* XXX: use llseek */
static int64_t file_seek(URLContext *h, int64_t pos, int whence)
{
    int fd = (intptr_t) h->priv_data;
    if (whence == AVSEEK_SIZE) {
        struct stat st;
        int ret = fstat(fd, &st);
        return ret < 0 ? AVERROR(errno) : st.st_size;
    }
    return lseek(fd, pos, whence);
}


static int file_close(URLContext *h)
{
    int fd = (intptr_t) h->priv_data;
    return close(fd);
}


static int file_get_handle(URLContext *h)
{
    return (intptr_t) h->priv_data;
}


URLProtocol file_protocol = {
    "file",
    file_open,
    file_read,
    file_write,
    file_seek,
    file_close,
    .url_get_file_handle = file_get_handle,
};










libavformat/allformats.c文件的av_register_all函数注册了file协议:
#define REGISTER_PROTOCOL(X,x) { \
    extern URLProtocol x##_protocol; \
    if(CONFIG_##X##_PROTOCOL) av_register_protocol(&x##_protocol); }






void av_register_all(void)
{
    /* 省略部分代码 */
    /* protocols */
    REGISTER_PROTOCOL (FILE, file);
    /* 省略部分代码 */
}


把注册协议函数也贴出来吧:


URLProtocol *first_protocol = NULL;




int av_register_protocol(URLProtocol *protocol)
{
    URLProtocol **p;
    p = &first_protocol;
    while (*p != NULL) p = &(*p)->next;
    *p = protocol;
    protocol->next = NULL;
    return 0;
}
Script ===================== 工具路径 布局名称 问题图斑占用永久基本农田叠加分析图 索引图层 陇把镇\原始数据\问题图斑范围 排除图层 YJJBNTBHTB核实处置 输出文件夹 I:\占耕建房\新建文件夹 输出文件前缀 2 输出格式 JPEG ===================== 消息 开始时间: 2025年11月25日 10:08:28 [2025-11-25 10:08:28] INFO: ================================================================================ [2025-11-25 10:08:28] INFO: 开始处理布局: 问题图斑占用永久基本农田叠加分析图 [2025-11-25 10:08:28] INFO: 索引图层路径: 陇把镇\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 排除图层: YJJBNTBHTB核实处置 [2025-11-25 10:08:28] INFO: 输出文件夹: I:\占耕建房\新建文件夹 [2025-11-25 10:08:28] INFO: 输出前缀: 2 [2025-11-25 10:08:28] INFO: 输出格式: jpeg [2025-11-25 10:08:28] INFO: ================================================================================ [2025-11-25 10:08:28] INFO: 检查地图框 '地图框' 中的地图 '地图' [2025-11-25 10:08:28] INFO: 找到索引图层: 陇把镇\原始数据\问题图斑范围 (位于地图 '地图') [2025-11-25 10:08:28] INFO: 将应用过滤的图层: c533124陇川县_原始下发点_SpatialJoin7 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: c533124陇川县_原始下发点_SpatialJoin5 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇图斑\户撒乡 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇图斑\景罕镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇图斑\章凤镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇图斑\城子 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇图斑\户撒乡 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇图斑\景罕镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇图斑\章凤镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇图斑\城子 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 533124陇川县_原始下发点数据 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇川县2018-2024年农村宅基地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤拉勐村委会\主房_附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤拉勐村委会\主房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤拉勐村委会\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤拉勐村委会\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤拉勐村委会\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤拉勐村委会\主房_附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤拉勐村委会\主房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤拉勐村委会\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤拉勐村委会\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤拉勐村委会\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\附房1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\院场1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\主房1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\宗地_ClearZM_SpatialJoin [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\附房1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\院场1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\主房1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\宗地_ClearZM_SpatialJoin [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\附房1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\院场1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\主房1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\宗地_ClearZM_SpatialJoin [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\附房1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\院场1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\主房1_ClearZM [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 章凤芒拉村委会\原始数据\宗地_ClearZM_SpatialJoin [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\房屋庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\房屋庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\房屋庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\房屋庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 景罕镇\景罕广宋\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇范围\城子镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇范围\章凤镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇范围\景罕镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇范围\户撒乡 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇范围\城子镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇范围\章凤镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇范围\景罕镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 乡镇范围\户撒乡 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 结构表\问题图斑属性结构表 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 结构表\问题图斑庭院属性结构表 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 结构表\压占永久基本农田图斑属性结构表 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 结构表\问题图斑附房用房属性结构表 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 结构表\问题图斑主房属性结构表 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 结构表\问题图斑属性结构表 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 结构表\问题图斑庭院属性结构表 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 结构表\压占永久基本农田图斑属性结构表 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 结构表\问题图斑附房用房属性结构表 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 结构表\问题图斑主房属性结构表 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\主房附房庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\主房附房庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\庭院 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\附房 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\房屋建筑图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\宗地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇\原始数据\问题图斑范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 不动产\ZRZ [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 不动产\SHYQZD [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 不动产\ZRZ [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 不动产\SHYQZD [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 建设用地报批成果 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇川县2010年至2024年5月农转用 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 规划用地用海(国空) [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\GHDLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 村规\规划地类图斑 [2025-11-25 10:08:28] INFO: 排除图层: YJJBNTBHTB核实处置 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19变更二调耕地 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2019年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2018年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2017年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2016年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2015年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2014年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2013年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2012年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2011年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2010年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2019年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2018年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2017年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2016年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2015年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2014年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2013年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2012年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2011年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 10-19年变更\2010年DLTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇川坝区范围 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 陇把镇 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 信息采集-房屋图斑202510281127 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 2、陇把镇航飞总图纸.dwg\2、陇把镇航飞总图纸-Annotation [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 2、陇把镇航飞总图纸.dwg\2、陇把镇航飞总图纸-Point [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 2、陇把镇航飞总图纸.dwg\2、陇把镇航飞总图纸-Polyline [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 2、陇把镇航飞总图纸.dwg\2、陇把镇航飞总图纸-Polygon [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 2、陇把镇航飞总图纸.dwg\2、陇把镇航飞总图纸-MultiPatch [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 2、陇把镇航飞总图纸.dwg\2、陇把镇航飞总图纸-Annotation [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 2、陇把镇航飞总图纸.dwg\2、陇把镇航飞总图纸-Point [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 2、陇把镇航飞总图纸.dwg\2、陇把镇航飞总图纸-Polyline [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 2、陇把镇航飞总图纸.dwg\2、陇把镇航飞总图纸-Polygon [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 2、陇把镇航飞总图纸.dwg\2、陇把镇航飞总图纸-MultiPatch [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\DLMCZJ [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\线状地物 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\JSYDGZQ [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\BQFW [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\GHJBNTBHQ [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\TDGHDL [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\DLMCZJ [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\地类图斑 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\线状地物 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\JSYDGZQ [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\BQFW [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\GHJBNTBHQ [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 二调\TDGHDL [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 三调 [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 三区三线\STBHHX [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 三区三线\YJJBNTBHTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 三区三线\GDBHMB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 三区三线\CZKFBJ [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 三区三线\STBHHX [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 三区三线\YJJBNTBHTB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 三区三线\GDBHMB [2025-11-25 10:08:28] INFO: 将应用过滤的图层: 三区三线\CZKFBJ [2025-11-25 10:08:28] INFO: 开始处理 138 个页面... [2025-11-25 10:08:29] INFO: 处理页面 1/138 [2025-11-25 10:08:29] ERROR: 处理页面 1 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:29] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:30] INFO: 处理页面 2/138 [2025-11-25 10:08:30] ERROR: 处理页面 2 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:30] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:31] INFO: 处理页面 3/138 [2025-11-25 10:08:31] ERROR: 处理页面 3 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:31] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:31] INFO: 处理页面 4/138 [2025-11-25 10:08:32] ERROR: 处理页面 4 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:32] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:33] INFO: 处理页面 5/138 [2025-11-25 10:08:33] ERROR: 处理页面 5 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:33] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:34] INFO: 处理页面 6/138 [2025-11-25 10:08:34] ERROR: 处理页面 6 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:34] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:35] INFO: 处理页面 7/138 [2025-11-25 10:08:35] ERROR: 处理页面 7 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:35] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:36] INFO: 处理页面 8/138 [2025-11-25 10:08:36] ERROR: 处理页面 8 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:36] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:37] INFO: 处理页面 9/138 [2025-11-25 10:08:37] ERROR: 处理页面 9 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:37] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:38] INFO: 处理页面 10/138 [2025-11-25 10:08:38] ERROR: 处理页面 10 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:38] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:39] INFO: 处理页面 11/138 [2025-11-25 10:08:39] ERROR: 处理页面 11 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:39] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:40] INFO: 处理页面 12/138 [2025-11-25 10:08:40] ERROR: 处理页面 12 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:40] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:41] INFO: 处理页面 13/138 [2025-11-25 10:08:41] ERROR: 处理页面 13 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:41] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:41] INFO: 处理页面 14/138 [2025-11-25 10:08:41] ERROR: 处理页面 14 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:41] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:42] INFO: 处理页面 15/138 [2025-11-25 10:08:42] ERROR: 处理页面 15 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:42] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:43] INFO: 处理页面 16/138 [2025-11-25 10:08:43] ERROR: 处理页面 16 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:43] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:44] INFO: 处理页面 17/138 [2025-11-25 10:08:44] ERROR: 处理页面 17 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:44] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:45] INFO: 处理页面 18/138 [2025-11-25 10:08:45] ERROR: 处理页面 18 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:45] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:46] INFO: 处理页面 19/138 [2025-11-25 10:08:46] ERROR: 处理页面 19 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:46] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:47] INFO: 处理页面 20/138 [2025-11-25 10:08:47] ERROR: 处理页面 20 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:47] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:48] INFO: 处理页面 21/138 [2025-11-25 10:08:48] ERROR: 处理页面 21 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:48] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:49] INFO: 处理页面 22/138 [2025-11-25 10:08:49] ERROR: 处理页面 22 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:49] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:50] INFO: 处理页面 23/138 [2025-11-25 10:08:50] ERROR: 处理页面 23 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:50] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:51] INFO: 处理页面 24/138 [2025-11-25 10:08:51] ERROR: 处理页面 24 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:51] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:52] INFO: 处理页面 25/138 [2025-11-25 10:08:52] ERROR: 处理页面 25 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:52] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:53] INFO: 处理页面 26/138 [2025-11-25 10:08:53] ERROR: 处理页面 26 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:53] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:54] INFO: 处理页面 27/138 [2025-11-25 10:08:54] ERROR: 处理页面 27 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:54] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:55] INFO: 处理页面 28/138 [2025-11-25 10:08:55] ERROR: 处理页面 28 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:55] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:55] INFO: 处理页面 29/138 [2025-11-25 10:08:55] ERROR: 处理页面 29 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:55] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:56] INFO: 处理页面 30/138 [2025-11-25 10:08:56] ERROR: 处理页面 30 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:56] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:57] INFO: 处理页面 31/138 [2025-11-25 10:08:57] ERROR: 处理页面 31 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:57] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:58] INFO: 处理页面 32/138 [2025-11-25 10:08:58] ERROR: 处理页面 32 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:58] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:59] INFO: 处理页面 33/138 [2025-11-25 10:08:59] ERROR: 处理页面 33 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:08:59] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:00] INFO: 处理页面 34/138 [2025-11-25 10:09:00] ERROR: 处理页面 34 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:00] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:01] INFO: 处理页面 35/138 [2025-11-25 10:09:01] ERROR: 处理页面 35 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:01] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:02] INFO: 处理页面 36/138 [2025-11-25 10:09:02] ERROR: 处理页面 36 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:02] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:03] INFO: 处理页面 37/138 [2025-11-25 10:09:03] ERROR: 处理页面 37 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:03] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:04] INFO: 处理页面 38/138 [2025-11-25 10:09:04] ERROR: 处理页面 38 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:04] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:05] INFO: 处理页面 39/138 [2025-11-25 10:09:05] ERROR: 处理页面 39 时出错: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:05] ERROR: Traceback (most recent call last): File "I:\arcgispro工具箱\自制工具箱.atbx\Script.tool\tool.script.execute.py", line 162, in main AttributeError: 'pageRow' object has no attribute 'getValue' [2025-11-25 10:09:06] INFO: 恢复图层原始状态... [2025-11-25 10:09:06] INFO: 恢复图层: c533124陇川县_原始下发点_SpatialJoin7 [2025-11-25 10:09:06] INFO: 恢复图层: c533124陇川县_原始下发点_SpatialJoin5 [2025-11-25 10:09:07] INFO: 恢复图层: 户撒乡 [2025-11-25 10:09:07] INFO: 恢复图层: 景罕镇 [2025-11-25 10:09:07] INFO: 恢复图层: 章凤镇 [2025-11-25 10:09:07] INFO: 恢复图层: 城子 [2025-11-25 10:09:07] INFO: 恢复图层: 户撒乡 [2025-11-25 10:09:07] INFO: 恢复图层: 景罕镇
11-26
-- MySQL dump 10.13 Distrib 8.0.42, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: tlias -- ------------------------------------------------------ -- Server version 8.0.42 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `clazz` -- DROP TABLE IF EXISTS `clazz`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `clazz` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID,主键', `name` varchar(30) NOT NULL COMMENT '班级名称', `room` varchar(20) DEFAULT NULL COMMENT '班级教室', `begin_date` date NOT NULL COMMENT '开课时间', `end_date` date NOT NULL COMMENT '结课时间', `master_id` int unsigned DEFAULT NULL COMMENT '班主任ID, 关联员工表ID', `subject` tinyint unsigned NOT NULL COMMENT '学科, 1:java, 2:前端, 3:大数据, 4:Python, 5:Go, 6: 嵌入式', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='班级表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `clazz` -- LOCK TABLES `clazz` WRITE; /*!40000 ALTER TABLE `clazz` DISABLE KEYS */; INSERT INTO `clazz` VALUES (1,'JavaEE就业163期','212','2025-04-30','2025-06-29',10,1,'2024-06-01 17:08:23','2024-06-01 17:39:58'),(2,'前端就业90期','210','2024-07-10','2024-01-20',3,2,'2024-06-01 17:45:12','2024-06-01 17:45:12'),(3,'JavaEE就业165期','108','2024-06-15','2024-12-25',6,1,'2024-06-01 17:45:40','2024-06-01 17:45:40'),(4,'JavaEE就业166期','105','2024-07-20','2024-02-20',20,1,'2024-06-01 17:46:10','2024-06-01 17:46:10'),(5,'大数据就业58期','209','2024-08-01','2024-02-15',7,3,'2024-06-01 17:51:21','2024-06-01 17:51:21'),(6,'JavaEE就业167期','325','2025-11-20','2026-05-10',36,1,'2024-11-15 11:35:46','2024-12-13 14:31:24'); /*!40000 ALTER TABLE `clazz` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dept` -- DROP TABLE IF EXISTS `dept`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `dept` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID, 主键', `name` varchar(10) NOT NULL COMMENT '部门名称', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dept` -- LOCK TABLES `dept` WRITE; /*!40000 ALTER TABLE `dept` DISABLE KEYS */; INSERT INTO `dept` VALUES (1,'学工部','2025-05-04 22:32:58','2025-05-13 19:48:47'),(2,'教研部','2025-03-25 09:47:40','2025-03-25 15:17:04'),(3,'咨询部','2025-03-25 09:47:40','2025-03-30 21:26:24'),(4,'就业部','2025-03-25 09:47:40','2025-03-30 09:47:40'),(5,'人事部','2025-03-25 09:47:40','2025-03-30 09:47:40'),(10,'财务部','2025-05-04 22:33:52','2025-05-06 21:34:02'),(11,'后勤部','2025-05-04 23:55:36','2025-05-04 23:58:49'); /*!40000 ALTER TABLE `dept` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emp` -- DROP TABLE IF EXISTS `emp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `emp` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID,主键', `username` varchar(20) NOT NULL COMMENT '用户名', `password` varchar(32) DEFAULT '123456' COMMENT '密码', `name` varchar(10) NOT NULL COMMENT '姓名', `gender` tinyint unsigned NOT NULL COMMENT '性别, 1:男, 2:女', `phone` char(11) NOT NULL COMMENT '手机号', `job` tinyint unsigned DEFAULT NULL COMMENT '职位, 1 班主任, 2 讲师 , 3 学工主管, 4 教研主管, 5 咨询师', `salary` int unsigned DEFAULT NULL COMMENT '薪资', `image` varchar(255) DEFAULT NULL COMMENT '头像', `entry_date` date DEFAULT NULL COMMENT '入职日期', `dept_id` int unsigned DEFAULT NULL COMMENT '部门ID', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `phone` (`phone`) ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='员工表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emp` -- LOCK TABLES `emp` WRITE; /*!40000 ALTER TABLE `emp` DISABLE KEYS */; INSERT INTO `emp` VALUES (1,'shinaian','123456','施耐庵',1,'13309090001',4,15000,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2000-01-01',2,'2023-10-20 16:35:33','2023-11-16 16:11:26'),(2,'songjiang','123456','宋江',1,'13309090002',2,8600,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2015-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:35:37'),(3,'lujunyi','123456','卢俊义',1,'13309090003',2,8900,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2008-05-01',2,'2023-10-20 16:35:33','2023-10-20 16:35:39'),(4,'wuyong','123456','吴用',1,'13309090004',2,9200,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2007-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:35:41'),(5,'gongsunsheng','123456','公孙胜',1,'13309090005',2,9500,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2012-12-05',2,'2023-10-20 16:35:33','2023-10-20 16:35:43'),(6,'huosanniang','123456','扈三娘',2,'13309090006',3,6500,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2013-09-05',1,'2023-10-20 16:35:33','2023-10-20 16:35:45'),(7,'chaijin','123456','柴进',1,'13309090007',1,4700,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2005-08-01',1,'2023-10-20 16:35:33','2023-10-20 16:35:47'),(8,'likui','123456','李逵',1,'13309090008',1,4800,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2014-11-09',1,'2023-10-20 16:35:33','2023-10-20 16:35:49'),(9,'wusong','123456','武松',1,'13309090009',1,4900,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2011-03-11',1,'2023-10-20 16:35:33','2023-10-20 16:35:51'),(10,'linchong','123456','林冲',1,'13309090010',1,5000,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2013-09-05',1,'2023-10-20 16:35:33','2023-10-20 16:35:53'),(11,'huyanzhuo','123456','呼延灼',1,'13309090011',2,9700,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2007-02-01',2,'2023-10-20 16:35:33','2023-10-20 16:35:55'),(12,'xiaoliguang','123456','小李广',1,'13309090012',2,10000,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2008-08-18',2,'2023-10-20 16:35:33','2023-10-20 16:35:57'),(13,'yangzhi','123456','杨志',1,'13309090013',1,5300,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2012-11-01',1,'2023-10-20 16:35:33','2023-10-20 16:35:59'),(14,'shijin','123456','史进',1,'13309090014',2,10600,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2002-08-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:01'),(15,'sunerniang','123456','孙二娘',2,'13309090015',2,10900,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2011-05-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:03'),(16,'luzhishen','123456','鲁智深',1,'13309090016',2,9600,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2010-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:05'),(17,'liying','55555','李应',1,'13309090017',1,5800,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2015-03-21',1,'2023-10-20 16:35:33','2025-05-11 14:33:07'),(18,'shiqian','123456','时迁',1,'13309090018',2,10200,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2015-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:09'),(19,'gudasao','123456','顾大嫂',2,'13309090019',2,10500,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2008-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:11'),(20,'ruanxiaoer','123456','阮小二',1,'13309090020',2,10800,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2018-01-01',2,'2023-10-20 16:35:33','2023-10-20 16:36:13'),(21,'ruanxiaowu','123456','阮小五',1,'13309090021',5,5200,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2015-01-01',3,'2023-10-20 16:35:33','2023-10-20 16:36:15'),(22,'ruanxiaoqi','123456','阮小七',1,'13309090022',5,5500,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2016-01-01',3,'2023-10-20 16:35:33','2023-10-20 16:36:17'),(23,'ruanji','123456','阮籍',1,'13309090023',5,5800,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2012-01-01',3,'2023-10-20 16:35:33','2023-10-20 16:36:19'),(24,'tongwei','123456','童威',1,'13309090024',5,5000,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2006-01-01',3,'2023-10-20 16:35:33','2023-10-20 16:36:21'),(25,'tongmeng','123456','童猛',1,'13309090025',5,4800,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2002-01-01',3,'2023-10-20 16:35:33','2023-10-20 16:36:23'),(26,'yanshun','123456','燕顺',1,'13309090026',5,5400,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2011-01-01',3,'2023-10-20 16:35:33','2023-11-08 22:12:46'),(27,'lijun','123456','李俊',1,'13309090027',2,6600,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2004-01-01',2,'2023-10-20 16:35:33','2023-11-16 17:56:59'),(28,'lizhong','123456','李忠',1,'13309090028',5,5000,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2007-01-01',3,'2023-10-20 16:35:33','2023-11-17 16:34:22'),(30,'liyun','123456','李云',1,'13309090030',NULL,NULL,'https://web-framework.oss-cn-hangzhou.aliyuncs.com/2023/1.jpg','2020-03-01',NULL,'2023-10-20 16:35:33','2023-10-20 16:36:31'),(36,'guoyujia','123456','郭宇佳',1,'13309243078',2,8001,'https://java-ai-28.oss-cn-beijing.aliyuncs.com/2025/06/c57f4f9c-941f-4ff8-8125-ec63f67ff5c2.jpg','2025-05-01',1,'2025-05-12 11:38:23','2025-06-19 16:39:44'),(44,'maodie','123456','耄耋',1,'13022111045',4,50000,'https://java-ai-28.oss-cn-beijing.aliyuncs.com/2025/05/f41cebb4-082c-4f84-b1c4-d0050412ac09.png','2025-03-15',10,'2025-05-10 23:49:59','2025-05-10 23:49:59'),(45,'pengqian','123456','彭谦',1,'18729903553',5,10000000,'https://java-ai-28.oss-cn-beijing.aliyuncs.com/2025/06/be8baca2-732b-490f-a56a-1d18b9b7c614.jpg','2025-06-02',3,'2025-06-02 23:19:54','2025-06-02 23:19:54'),(48,'fengborui','123456','冯博睿',1,'15888888887',2,3000,'https://java-ai-28.oss-cn-beijing.aliyuncs.com/2025/06/08ddac82-9432-47fd-8f0a-0850e4623440.jpg','2025-06-18',11,'2025-06-19 16:42:12','2025-06-19 16:42:12'); /*!40000 ALTER TABLE `emp` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emp_expr` -- DROP TABLE IF EXISTS `emp_expr`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `emp_expr` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID, 主键', `emp_id` int unsigned DEFAULT NULL COMMENT '员工ID', `begin` date DEFAULT NULL COMMENT '开始时间', `end` date DEFAULT NULL COMMENT '结束时间', `company` varchar(50) DEFAULT NULL COMMENT '公司名称', `job` varchar(50) DEFAULT NULL COMMENT '职位', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='工作经历'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emp_expr` -- LOCK TABLES `emp_expr` WRITE; /*!40000 ALTER TABLE `emp_expr` DISABLE KEYS */; INSERT INTO `emp_expr` VALUES (6,44,'2022-05-05','2024-05-30','白手套','猫财神'),(7,45,'2025-03-12','2025-06-02','三角洲行动','摸金少校'),(8,48,'2025-03-13','2025-04-25','陕理工附中','校长'); /*!40000 ALTER TABLE `emp_expr` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `operate_log` -- DROP TABLE IF EXISTS `operate_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `operate_log` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `operate_emp_id` int unsigned DEFAULT NULL COMMENT '操作人ID', `operate_time` datetime DEFAULT NULL COMMENT '操作时间', `class_name` varchar(100) DEFAULT NULL COMMENT '操作的类名', `method_name` varchar(100) DEFAULT NULL COMMENT '操作的方法名', `method_params` varchar(2000) DEFAULT NULL COMMENT '方法参数', `return_value` varchar(2000) DEFAULT NULL COMMENT '返回值', `cost_time` bigint unsigned DEFAULT NULL COMMENT '方法执行耗时, 单位:ms', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='操作日志表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `operate_log` -- LOCK TABLES `operate_log` WRITE; /*!40000 ALTER TABLE `operate_log` DISABLE KEYS */; INSERT INTO `operate_log` VALUES (1,1,'2025-05-14 16:17:14','org.example.controller.DeptController','add','[Dept(id=null, name=678, createTime=2025-05-14T16:17:13.590562200, updateTime=2025-05-14T16:17:13.590562200)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',12),(2,1,'2025-05-14 16:17:20','org.example.controller.DeptController','update','[Dept(id=12, name=678666, createTime=2025-05-14T16:17:14, updateTime=2025-05-14T16:17:20.396796900)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',6),(3,1,'2025-05-14 16:17:23','org.example.controller.DeptController','delete','[12]','{\"code\":1,\"msg\":\"success\",\"data\":null}',6),(4,36,'2025-05-14 23:52:40','org.example.controller.DeptController','add','[Dept(id=null, name=666, createTime=2025-05-14T23:52:39.992155700, updateTime=2025-05-14T23:52:39.992155700)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',28),(5,36,'2025-05-14 23:52:44','org.example.controller.DeptController','update','[Dept(id=13, name=666888, createTime=2025-05-14T23:52:40, updateTime=2025-05-14T23:52:44.173557500)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',8),(6,36,'2025-05-14 23:52:46','org.example.controller.DeptController','delete','[13]','{\"code\":1,\"msg\":\"success\",\"data\":null}',7),(7,NULL,'2025-05-27 20:07:38','org.example.controller.DeptController','add','[Dept(id=null, name=, createTime=2025-05-27T20:07:38.466774100, updateTime=2025-05-27T20:07:38.466774100)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',29),(8,NULL,'2025-05-29 15:35:25','org.example.controller.DeptController','add','[Dept(id=null, name=搞笑部, createTime=2025-05-29T15:35:25.066868500, updateTime=2025-05-29T15:35:25.066868500)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',15),(9,NULL,'2025-05-29 15:35:45','org.example.controller.DeptController','add','[Dept(id=null, name=搞笑部, createTime=2025-05-29T15:35:44.727359400, updateTime=2025-05-29T15:35:44.727359400)]','null',399),(10,NULL,'2025-05-29 15:36:43','org.example.controller.DeptController','add','[Dept(id=null, name=搞笑部, createTime=2025-05-29T15:36:43.372420500, updateTime=2025-05-29T15:36:43.372420500)]','null',4),(11,NULL,'2025-05-29 16:47:32','org.example.controller.DeptController','add','[Dept(id=null, name=, createTime=2025-05-29T16:47:31.852988600, updateTime=2025-05-29T16:47:31.852988600)]','null',5),(12,NULL,'2025-05-29 16:52:17','org.example.controller.DeptController','add','[Dept(id=null, name=32, createTime=2025-05-29T16:52:16.564102800, updateTime=2025-05-29T16:52:16.564102800)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',5),(13,NULL,'2025-05-29 17:12:29','org.example.controller.DeptController','add','[Dept(id=null, name=搞笑部, createTime=2025-05-29T17:12:29.474613400, updateTime=2025-05-29T17:12:29.474613400)]','null',5),(14,NULL,'2025-05-29 18:03:31','org.example.controller.DeptController','update','[Dept(id=14, name=123, createTime=2025-05-27T20:07:38, updateTime=2025-05-29T18:03:30.662468)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',9),(15,NULL,'2025-05-29 18:04:06','org.example.controller.DeptController','update','[Dept(id=19, name=233333, createTime=2025-05-29T16:52:17, updateTime=2025-05-29T18:04:06.350611100)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',4),(16,NULL,'2025-05-29 18:32:13','org.example.controller.DeptController','delete','[19]','{\"code\":1,\"msg\":\"success\",\"data\":null}',15),(17,NULL,'2025-05-29 18:34:17','org.example.controller.DeptController','delete','[14]','{\"code\":1,\"msg\":\"success\",\"data\":null}',4),(18,NULL,'2025-05-29 18:37:32','org.example.controller.DeptController','delete','[15]','{\"code\":1,\"msg\":\"success\",\"data\":null}',5),(19,NULL,'2025-05-29 18:38:58','org.example.controller.DeptController','add','[Dept(id=null, name=沙增乐部, createTime=2025-05-29T18:38:57.904253900, updateTime=2025-05-29T18:38:57.904253900)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',4),(20,NULL,'2025-05-29 18:39:03','org.example.controller.DeptController','update','[Dept(id=21, name=沙增乐, createTime=2025-05-29T18:38:58, updateTime=2025-05-29T18:39:02.502901)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',3),(21,NULL,'2025-05-29 18:39:15','org.example.controller.DeptController','delete','[21]','{\"code\":1,\"msg\":\"success\",\"data\":null}',3),(22,NULL,'2025-05-29 22:27:39','org.example.controller.DeptController','add','[Dept(id=null, name=asdasdasd, createTime=2025-05-29T22:27:39.396613400, updateTime=2025-05-29T22:27:39.396613400)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',5),(23,NULL,'2025-05-29 22:27:57','org.example.controller.DeptController','delete','[22]','{\"code\":1,\"msg\":\"success\",\"data\":null}',3),(24,NULL,'2025-06-02 21:11:31','org.example.controller.DeptController','add','[Dept(id=null, name=沙增乐部, createTime=2025-06-02T21:11:31.464335100, updateTime=2025-06-02T21:11:31.464335100)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',24),(25,NULL,'2025-06-02 21:11:44','org.example.controller.DeptController','delete','[23]','{\"code\":1,\"msg\":\"success\",\"data\":null}',9),(26,NULL,'2025-06-02 21:12:13','org.example.controller.DeptController','add','[Dept(id=null, name=456, createTime=2025-06-02T21:12:12.517675600, updateTime=2025-06-02T21:12:12.517675600)]','{\"code\":1,\"msg\":\"success\",\"data\":null}',4),(27,NULL,'2025-06-02 21:17:43','org.example.controller.DeptController','delete','[24]','{\"code\":1,\"msg\":\"success\",\"data\":null}',5); /*!40000 ALTER TABLE `operate_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student` -- DROP TABLE IF EXISTS `student`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `student` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID,主键', `name` varchar(10) NOT NULL COMMENT '姓名', `no` char(10) NOT NULL COMMENT '学号', `gender` tinyint unsigned NOT NULL COMMENT '性别, 1: 男, 2: 女', `phone` varchar(11) NOT NULL COMMENT '手机号', `id_card` char(18) NOT NULL COMMENT '身份证号', `is_college` tinyint unsigned NOT NULL COMMENT '是否来自于院校, 1:是, 0:否', `address` varchar(100) DEFAULT NULL COMMENT '联系地址', `degree` tinyint unsigned DEFAULT NULL COMMENT '最高学历, 1:初中, 2:高中, 3:大专, 4:本科, 5:硕士, 6:博士', `graduation_date` date DEFAULT NULL COMMENT '毕业时间', `clazz_id` int unsigned NOT NULL COMMENT '班级ID, 关联班级表ID', `violation_count` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '违纪次数', `violation_score` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '违纪扣分', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_time` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`id`), UNIQUE KEY `no` (`no`), UNIQUE KEY `phone` (`phone`), UNIQUE KEY `id_card` (`id_card`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='学员表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student` -- LOCK TABLES `student` WRITE; /*!40000 ALTER TABLE `student` DISABLE KEYS */; INSERT INTO `student` VALUES (1,'段誉','2022000001',1,'18800000001','110120000300200001',1,'北京市昌平区建材城西路1号',1,'2021-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-15 16:20:59'),(2,'萧峰','2022000002',1,'18800210003','110120000300200002',1,'北京市昌平区建材城西路2号',2,'2022-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(3,'虚竹','2022000003',1,'18800013001','110120000300200003',1,'北京市昌平区建材城西路3号',2,'2024-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(4,'萧远山','2022000004',1,'18800003211','110120000300200004',1,'北京市昌平区建材城西路4号',3,'2024-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(5,'阿朱','2022000005',2,'18800160002','110120000300200005',1,'北京市昌平区建材城西路5号',4,'2020-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(6,'阿紫','2022000006',2,'18800000034','110120000300200006',1,'北京市昌平区建材城西路6号',4,'2021-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(7,'游坦之','2022000007',1,'18800000067','110120000300200007',1,'北京市昌平区建材城西路7号',4,'2022-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(8,'康敏','2022000008',2,'18800000077','110120000300200008',1,'北京市昌平区建材城西路8号',5,'2024-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(9,'徐长老','2022000009',1,'18800000341','110120000300200009',1,'北京市昌平区建材城西路9号',3,'2024-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(10,'云中鹤','2022000010',1,'18800006571','110120000300200010',1,'北京市昌平区建材城西路10号',2,'2020-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(11,'钟万仇','2022000011',1,'18800000391','110120000300200011',1,'北京市昌平区建材城西路11号',4,'2021-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-15 16:21:24'),(12,'崔百泉','2022000012',1,'18800000781','110120000300200018',1,'北京市昌平区建材城西路12号',4,'2022-07-05',3,6,17,'2024-11-14 21:22:19','2024-12-13 14:33:58'),(13,'耶律洪基','2022000013',1,'18800008901','110120000300200013',1,'北京市昌平区建材城西路13号',4,'2024-07-01',2,0,0,'2024-11-14 21:22:19','2024-11-15 16:21:21'),(14,'天山童姥','2022000014',2,'18800009201','110120000300200014',1,'北京市昌平区建材城西路14号',4,'2024-07-01',1,0,0,'2024-11-14 21:22:19','2024-11-15 16:21:17'),(15,'刘竹庄','2022000015',1,'18800009401','110120000300200015',1,'北京市昌平区建材城西路15号',3,'2020-07-01',4,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(16,'李春来','2022000016',1,'18800008501','110120000300200016',1,'北京市昌平区建材城西路16号',4,'2021-07-01',4,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(17,'王语嫣','2022000017',2,'18800007601','110120000300200017',1,'北京市昌平区建材城西路17号',2,'2022-07-01',4,0,0,'2024-11-14 21:22:19','2024-11-14 21:22:19'),(18,'郑成功','2024001101',1,'13309092345','110110110110110110',0,'北京市昌平区回龙观街道88号',5,'2021-07-01',3,2,7,'2024-11-15 16:26:18','2024-11-15 16:40:10'); /*!40000 ALTER TABLE `student` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-06-19 20:26:22 为什么在Navicat Premium 15中运行不了
06-20
从关闭蓝牙到然后我们直接马上打开想重连,但是从日志上可以看到,花费了接近一分钟才尝试重新连接,正常应该在关闭之后10s内实现打开、尝试重连、并重连成功的操作,请问我该怎么去定位问题,怎么知道这一分钟出现了什么错误导致03-24 15:42:25.021才开始尝试重连: Line 41174: 03-24 15:41:36.469 5535 5535 D BluetoothGatt: close() Line 41175: 03-24 15:41:36.469 5535 5535 D BluetoothGatt: unregisterApp() - mClientIf=6 Line 41211: 03-24 15:41:36.482 5535 14917 D BluetoothGatt: onClientConnectionState() - status=0 clientIf=6 connected=false device=EF:B8:39:25:0B:28 Line 60027: 03-24 15:42:25.021 5535 5535 D BluetoothGatt: connect() - device: XX:XX:XX:XX:0B:28, auto: false, eattSupport: false Line 60028: 03-24 15:42:25.021 5535 5535 D BluetoothGatt: registerApp() Line 60029: 03-24 15:42:25.022 5535 5535 D BluetoothGatt: registerApp() - UUID=65f6d13c-55fd-43aa-a124-f2c161c6d710 Line 60036: 03-24 15:42:25.035 5535 26044 D BluetoothGatt: onClientRegistered() - status=0 clientIf=6 这个BUG出现的场景是:ID:8932855 标题:【23699_15.0_V】【QY_专项】【PVT】【TC3】【穿戴类设备兼容性】【OPPO手环】OPPO手环关开蓝牙回连速度慢,需回到桌面再进去APP才能重连,关开蓝牙弹框无响应(10/10)根据上面的问题定位方向的第三点检查下面的日志有问题吗: Line 21729: 03-24 15:40:54.684 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:244 unregister_client: Client unregistered Line 21741: 03-24 15:40:54.686 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:229 register_client: Client registered Line 46661: 03-24 15:41:45.348 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:244 unregister_client: Client unregistered Line 46806: 03-24 15:41:45.502 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:229 register_client: Client registered Line 46808: 03-24 15:41:45.503 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:244 unregister_client: Client unregistered Line 46814: 03-24 15:41:45.504 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:229 register_client: Client registered根据上面的看看下面这个有问题吗:Line 46806: 03-24 15:41:45.502 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:229 register_client: Client registered Line 46808: 03-24 15:41:45.503 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:244 unregister_client: Client unregistered Line 46814: 03-24 15:41:45.504 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:229 register_client: Client registered Line 60088: 03-24 15:42:25.067 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:659 OnCommandComplete: Received command complete with op_code LE_ADD_DEVICE_TO_FILTER_ACCEPT_LIST(0x2011) Line 60089: 03-24 15:42:25.067 24295 24357 I bluetooth: system/gd/hci/le_address_manager.cc:347 resume_registered_clients: Resuming registered clients
03-28
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值