初始化

guyue

2025-07-02 0a99c3a898976f64b53ca05751514bac8500ad60

初始化

 .gitignore

New file
@@ -0,0 +1,33 @@
HELP.md
target/
!.mvn/wrapper/maven-wrapper.jar
!**/src/main/**/target/
!**/src/test/**/target/

### STS ###
.apt_generated
.classpath
.factorypath
.project
.settings
.springBeans
.sts4-cache

### IntelliJ IDEA ###
.idea
*.iws
*.iml
*.ipr

### NetBeans ###
/nbproject/private/
/nbbuild/
/dist/
/nbdist/
/.nb-gradle/
build/
!**/src/main/**/build/
!**/src/test/**/build/

### VS Code ###
.vscode/

 pom.xml

New file
@@ -0,0 +1,87 @@
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.lingHu</groupId>
    <artifactId>lingHu</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>lingHu</name>
    <description>lingHu</description>
    <properties>
        <java.version>1.8</java.version>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <spring-boot.version>2.7.6</spring-boot.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
<!--            <version>1.18.26</version>-->
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>3.4.2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>${spring-boot.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.8.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <version>${spring-boot.version}</version>
                <configuration>
                    <mainClass>com.linghu.LingHuApplication</mainClass>
                    <skip>true</skip>
                </configuration>
                <executions>
                    <execution>
                        <id>repackage</id>
                        <goals>
                            <goal>repackage</goal>
                        </goals>
                    </execution>
                </executions>
            </plugin>
        </plugins>
    </build>

</project>

 src/main/java/com/linghu/LingHuApplication.java

New file
@@ -0,0 +1,15 @@
package com.linghu;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.linghu.mapper")
public class LingHuApplication {

    public static void main(String[] args) {
        SpringApplication.run(LingHuApplication.class, args);
    }

}

 src/main/java/com/linghu/controller/TypeController.java

New file
@@ -0,0 +1,106 @@
package com.linghu.controller;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.linghu.model.common.ResponseResult;
import com.linghu.model.entity.Type;
import com.linghu.service.TypeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping("/type")
public class TypeController {

    @Autowired
    private TypeService typeService;

    @PostMapping
    public ResponseResult<Type> add(@RequestBody Type type) {
        type.setDelFlag(0);
        boolean success = typeService.save(type);
        if (success) {
            return ResponseResult.success(type);
        }
        return ResponseResult.error("添加类型失败");
    }

    @PostMapping("/batch")
    public ResponseResult<Void> batchAdd(@RequestBody List<Type> types) {
        boolean success = typeService.saveBatch(types);
        if (success) {
            return ResponseResult.success();
        }
        return ResponseResult.error("批量添加类型失败");
    }

    @DeleteMapping("/{typeId}")
    public ResponseResult<Void> delete(@PathVariable Integer typeId) {
        Type type = new Type();
        type.setTypeId(typeId);
        type.setDelFlag(1);
        boolean success = typeService.updateById(type);
        if (success) {
            return ResponseResult.success();
        }
        return ResponseResult.error("删除类型失败");
    }

    @DeleteMapping("/batch")
    public ResponseResult<Void> batchDelete(@RequestBody List<Integer> typeIds) {
        boolean success = typeService.removeBatchByIds(typeIds);
        if (success) {
            return ResponseResult.success();
        }
        return ResponseResult.error("批量删除类型失败");
    }

    @PutMapping
    public ResponseResult<Void> update(@RequestBody Type type) {
        boolean success = typeService.updateById(type);
        if (success) {
            return ResponseResult.success();
        }
        return ResponseResult.error("更新类型失败");
    }

    @PutMapping("/batch")
    public ResponseResult<Void> batchUpdate(@RequestBody List<Type> types) {
        boolean success = typeService.updateBatchById(types);
        if (success) {
            return ResponseResult.success();
        }
        return ResponseResult.error("批量更新类型失败");
    }

    @GetMapping("/{typeId}")
    public ResponseResult<Type> getById(@PathVariable Integer typeId) {
        Type type = typeService.getById(typeId);
        if (type != null && type.getDelFlag() != 1) {
            return ResponseResult.success(type);
        }
        return ResponseResult.error("类型不存在");
    }

    @GetMapping("/list")
    public ResponseResult<?> list(
            @RequestParam(required = false) Integer pageNum,
            @RequestParam(required = false) Integer pageSize,
            @RequestParam(required = false) String typeName) {

        // 不传分页参数则返回全部数据
        if (pageNum == null || pageSize == null) {
            List<Type> types = typeService.listAllAvailable();
            return ResponseResult.success(types);
        }

        LambdaQueryWrapper<Type> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(Type::getDelFlag, 0)
                .like(typeName != null, Type::getTypeName, typeName);

        Page<Type> page = typeService.page(new Page<>(pageNum, pageSize), queryWrapper);
        return ResponseResult.success(page);
    }
}

 src/main/java/com/linghu/controller/baseController.java

New file
@@ -0,0 +1,13 @@
package com.linghu.controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class baseController {
    @RequestMapping("/ceshi")
    public String index(){
        return "index";
    }
}

 src/main/java/com/linghu/mapper/CallwordMapper.java

New file
@@ -0,0 +1,18 @@
package com.linghu.mapper;

import com.linghu.model.entity.Callword;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author xy
* @description 针对表【callword】的数据库操作Mapper
* @createDate 2025-07-02 16:32:19
* @Entity generator.entity.Callword
*/
public interface CallwordMapper extends BaseMapper<Callword> {

}





 src/main/java/com/linghu/mapper/KeywordMapper.java

New file
@@ -0,0 +1,18 @@
package com.linghu.mapper;

import com.linghu.model.entity.Keyword;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author xy
* @description 针对表【keyword】的数据库操作Mapper
* @createDate 2025-07-02 16:32:19
* @Entity generator.entity.Keyword
*/
public interface KeywordMapper extends BaseMapper<Keyword> {

}





 src/main/java/com/linghu/mapper/OrderMapper.java

New file
@@ -0,0 +1,18 @@
package com.linghu.mapper;

import com.linghu.model.entity.Order;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author xy
* @description 针对表【order】的数据库操作Mapper
* @createDate 2025-07-02 16:32:19
* @Entity generator.entity.Order
*/
public interface OrderMapper extends BaseMapper<Order> {

}





 src/main/java/com/linghu/mapper/PlatfromMapper.java

New file
@@ -0,0 +1,18 @@
package com.linghu.mapper;

import com.linghu.model.entity.Platfrom;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author xy
* @description 针对表【platfrom】的数据库操作Mapper
* @createDate 2025-07-02 16:32:19
* @Entity generator.entity.Platfrom
*/
public interface PlatfromMapper extends BaseMapper<Platfrom> {

}





 src/main/java/com/linghu/mapper/ResultMapper.java

New file
@@ -0,0 +1,18 @@
package com.linghu.mapper;

import com.linghu.model.entity.Result;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author xy
* @description 针对表【result】的数据库操作Mapper
* @createDate 2025-07-02 16:32:19
* @Entity generator.entity.Result
*/
public interface ResultMapper extends BaseMapper<Result> {

}





 src/main/java/com/linghu/mapper/TypeMapper.java

New file
@@ -0,0 +1,18 @@
package com.linghu.mapper;

import com.linghu.model.entity.Type;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author xy
* @description 针对表【type】的数据库操作Mapper
* @createDate 2025-07-02 16:32:19
* @Entity generator.entity.Type
*/
public interface TypeMapper extends BaseMapper<Type> {

}





 src/main/java/com/linghu/model/common/ResponseResult.java

New file
@@ -0,0 +1,36 @@
package com.linghu.model.common;

import lombok.Data;

@Data
public class ResponseResult<T> {
    private Integer code;
    private String message;
    private T data;

    public static <T> ResponseResult<T> success(T data) {
        ResponseResult<T> result = new ResponseResult<>();
        result.setCode(200);
        result.setMessage("操作成功");
        result.setData(data);
        return result;
    }

    public static <T> ResponseResult<T> success() {
        return success(null);
    }

    public static <T> ResponseResult<T> error(String message) {
        ResponseResult<T> result = new ResponseResult<>();
        result.setCode(500);
        result.setMessage(message);
        return result;
    }

    public static <T> ResponseResult<T> error(Integer code, String message) {
        ResponseResult<T> result = new ResponseResult<>();
        result.setCode(code);
        result.setMessage(message);
        return result;
    }
}

 src/main/java/com/linghu/model/entity/Callword.java

New file
@@ -0,0 +1,84 @@
package com.linghu.model.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import lombok.Data;

/**
 * 
 * @TableName callword
 */
@TableName(value ="callword")
@Data
public class Callword implements Serializable {
    /**
     * 提示词id
     */
    @TableId
    private String callwordId;

    /**
     * 关键词id
     */
    private Integer keywordId;

    /**
     * 提示词名称
     */
    private String callwordName;

    /**
     * 提示词状态，1-未采集，2-采集完成，3-采集报错
     */
    private String status;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;

    @Override
    public boolean equals(Object that) {
        if (this == that) {
            return true;
        }
        if (that == null) {
            return false;
        }
        if (getClass() != that.getClass()) {
            return false;
        }
        Callword other = (Callword) that;
        return (this.getCallwordId() == null ? other.getCallwordId() == null : this.getCallwordId().equals(other.getCallwordId()))
            && (this.getKeywordId() == null ? other.getKeywordId() == null : this.getKeywordId().equals(other.getKeywordId()))
            && (this.getCallwordName() == null ? other.getCallwordName() == null : this.getCallwordName().equals(other.getCallwordName()))
            && (this.getStatus() == null ? other.getStatus() == null : this.getStatus().equals(other.getStatus()));
    }

    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result + ((getCallwordId() == null) ? 0 : getCallwordId().hashCode());
        result = prime * result + ((getKeywordId() == null) ? 0 : getKeywordId().hashCode());
        result = prime * result + ((getCallwordName() == null) ? 0 : getCallwordName().hashCode());
        result = prime * result + ((getStatus() == null) ? 0 : getStatus().hashCode());
        return result;
    }

    @Override
    public String toString() {
        StringBuilder sb = new StringBuilder();
        sb.append(getClass().getSimpleName());
        sb.append(" [");
        sb.append("Hash = ").append(hashCode());
        sb.append(", callwordId=").append(callwordId);
        sb.append(", keywordId=").append(keywordId);
        sb.append(", callwordName=").append(callwordName);
        sb.append(", status=").append(status);
        sb.append(", serialVersionUID=").append(serialVersionUID);
        sb.append("]");
        return sb.toString();
    }
}

 src/main/java/com/linghu/model/entity/Keyword.java

New file
@@ -0,0 +1,84 @@
package com.linghu.model.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import lombok.Data;

/**
 * 
 * @TableName keyword
 */
@TableName(value ="keyword")
@Data
public class Keyword implements Serializable {
    /**
     * 关键词
     */
    @TableId(type = IdType.AUTO)
    private Integer keywordId;

    /**
     * 关联订单id
     */
    private String orderId;

    /**
     * 关键词名称
     */
    private String keywordName;

    /**
     * 采集轮数
     */
    private Integer num;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;

    @Override
    public boolean equals(Object that) {
        if (this == that) {
            return true;
        }
        if (that == null) {
            return false;
        }
        if (getClass() != that.getClass()) {
            return false;
        }
        Keyword other = (Keyword) that;
        return (this.getKeywordId() == null ? other.getKeywordId() == null : this.getKeywordId().equals(other.getKeywordId()))
            && (this.getOrderId() == null ? other.getOrderId() == null : this.getOrderId().equals(other.getOrderId()))
            && (this.getKeywordName() == null ? other.getKeywordName() == null : this.getKeywordName().equals(other.getKeywordName()))
            && (this.getNum() == null ? other.getNum() == null : this.getNum().equals(other.getNum()));
    }

    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result + ((getKeywordId() == null) ? 0 : getKeywordId().hashCode());
        result = prime * result + ((getOrderId() == null) ? 0 : getOrderId().hashCode());
        result = prime * result + ((getKeywordName() == null) ? 0 : getKeywordName().hashCode());
        result = prime * result + ((getNum() == null) ? 0 : getNum().hashCode());
        return result;
    }

    @Override
    public String toString() {
        StringBuilder sb = new StringBuilder();
        sb.append(getClass().getSimpleName());
        sb.append(" [");
        sb.append("Hash = ").append(hashCode());
        sb.append(", keywordId=").append(keywordId);
        sb.append(", orderId=").append(orderId);
        sb.append(", keywordName=").append(keywordName);
        sb.append(", num=").append(num);
        sb.append(", serialVersionUID=").append(serialVersionUID);
        sb.append("]");
        return sb.toString();
    }
}

 src/main/java/com/linghu/model/entity/Order.java

New file
@@ -0,0 +1,117 @@
package com.linghu.model.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import java.util.Date;
import lombok.Data;

/**
 * 
 * @TableName order
 */
@TableName(value ="order")
@Data
public class Order implements Serializable {
    /**
     * 订单id,格式：日期-数量
     */
    @TableId
    private String orderId;

    /**
     * 客户名称
     */
    private String clientName;

    /**
     * 状态 1-待处理，2-执行中，3-已完成
     */
    private Integer status;

    /**
     * 0-未删除 1-已删除
     */
    private Integer delFlag;

    /**
     * 提交人
     */
    private String createBy;

    /**
     * 创建时间
     */
    private Date createTime;

    /**
     * 
     */
    private String updateBy;

    /**
     * 
     */
    private Date updateTime;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;

    @Override
    public boolean equals(Object that) {
        if (this == that) {
            return true;
        }
        if (that == null) {
            return false;
        }
        if (getClass() != that.getClass()) {
            return false;
        }
        Order other = (Order) that;
        return (this.getOrderId() == null ? other.getOrderId() == null : this.getOrderId().equals(other.getOrderId()))
            && (this.getClientName() == null ? other.getClientName() == null : this.getClientName().equals(other.getClientName()))
            && (this.getStatus() == null ? other.getStatus() == null : this.getStatus().equals(other.getStatus()))
            && (this.getDelFlag() == null ? other.getDelFlag() == null : this.getDelFlag().equals(other.getDelFlag()))
            && (this.getCreateBy() == null ? other.getCreateBy() == null : this.getCreateBy().equals(other.getCreateBy()))
            && (this.getCreateTime() == null ? other.getCreateTime() == null : this.getCreateTime().equals(other.getCreateTime()))
            && (this.getUpdateBy() == null ? other.getUpdateBy() == null : this.getUpdateBy().equals(other.getUpdateBy()))
            && (this.getUpdateTime() == null ? other.getUpdateTime() == null : this.getUpdateTime().equals(other.getUpdateTime()));
    }

    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result + ((getOrderId() == null) ? 0 : getOrderId().hashCode());
        result = prime * result + ((getClientName() == null) ? 0 : getClientName().hashCode());
        result = prime * result + ((getStatus() == null) ? 0 : getStatus().hashCode());
        result = prime * result + ((getDelFlag() == null) ? 0 : getDelFlag().hashCode());
        result = prime * result + ((getCreateBy() == null) ? 0 : getCreateBy().hashCode());
        result = prime * result + ((getCreateTime() == null) ? 0 : getCreateTime().hashCode());
        result = prime * result + ((getUpdateBy() == null) ? 0 : getUpdateBy().hashCode());
        result = prime * result + ((getUpdateTime() == null) ? 0 : getUpdateTime().hashCode());
        return result;
    }

    @Override
    public String toString() {
        StringBuilder sb = new StringBuilder();
        sb.append(getClass().getSimpleName());
        sb.append(" [");
        sb.append("Hash = ").append(hashCode());
        sb.append(", orderId=").append(orderId);
        sb.append(", clientName=").append(clientName);
        sb.append(", status=").append(status);
        sb.append(", delFlag=").append(delFlag);
        sb.append(", createBy=").append(createBy);
        sb.append(", createTime=").append(createTime);
        sb.append(", updateBy=").append(updateBy);
        sb.append(", updateTime=").append(updateTime);
        sb.append(", serialVersionUID=").append(serialVersionUID);
        sb.append("]");
        return sb.toString();
    }
}

 src/main/java/com/linghu/model/entity/Platfrom.java

New file
@@ -0,0 +1,125 @@
package com.linghu.model.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import java.util.Date;
import lombok.Data;

/**
 * 
 * @TableName platfrom
 */
@TableName(value ="platfrom")
@Data
public class Platfrom implements Serializable {
    /**
     * 平台id
     */
    @TableId(type = IdType.AUTO)
    private Integer platformId;

    /**
     * 类型id
     */
    private Integer typeId;

    /**
     * 平台名称
     */
    private String platformName;

    /**
     * 网址
     */
    private String platformUrl;

    /**
     * 
     */
    private Date createTime;

    /**
     * 
     */
    private String createBy;

    /**
     * 
     */
    private Date updateTime;

    /**
     * 
     */
    private String updateBy;

    /**
     * 0-未删除，1-已删除
     */
    private Integer delFlag;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;

    @Override
    public boolean equals(Object that) {
        if (this == that) {
            return true;
        }
        if (that == null) {
            return false;
        }
        if (getClass() != that.getClass()) {
            return false;
        }
        Platfrom other = (Platfrom) that;
        return (this.getPlatformId() == null ? other.getPlatformId() == null : this.getPlatformId().equals(other.getPlatformId()))
            && (this.getTypeId() == null ? other.getTypeId() == null : this.getTypeId().equals(other.getTypeId()))
            && (this.getPlatformName() == null ? other.getPlatformName() == null : this.getPlatformName().equals(other.getPlatformName()))
            && (this.getPlatformUrl() == null ? other.getPlatformUrl() == null : this.getPlatformUrl().equals(other.getPlatformUrl()))
            && (this.getCreateTime() == null ? other.getCreateTime() == null : this.getCreateTime().equals(other.getCreateTime()))
            && (this.getCreateBy() == null ? other.getCreateBy() == null : this.getCreateBy().equals(other.getCreateBy()))
            && (this.getUpdateTime() == null ? other.getUpdateTime() == null : this.getUpdateTime().equals(other.getUpdateTime()))
            && (this.getUpdateBy() == null ? other.getUpdateBy() == null : this.getUpdateBy().equals(other.getUpdateBy()))
            && (this.getDelFlag() == null ? other.getDelFlag() == null : this.getDelFlag().equals(other.getDelFlag()));
    }

    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result + ((getPlatformId() == null) ? 0 : getPlatformId().hashCode());
        result = prime * result + ((getTypeId() == null) ? 0 : getTypeId().hashCode());
        result = prime * result + ((getPlatformName() == null) ? 0 : getPlatformName().hashCode());
        result = prime * result + ((getPlatformUrl() == null) ? 0 : getPlatformUrl().hashCode());
        result = prime * result + ((getCreateTime() == null) ? 0 : getCreateTime().hashCode());
        result = prime * result + ((getCreateBy() == null) ? 0 : getCreateBy().hashCode());
        result = prime * result + ((getUpdateTime() == null) ? 0 : getUpdateTime().hashCode());
        result = prime * result + ((getUpdateBy() == null) ? 0 : getUpdateBy().hashCode());
        result = prime * result + ((getDelFlag() == null) ? 0 : getDelFlag().hashCode());
        return result;
    }

    @Override
    public String toString() {
        StringBuilder sb = new StringBuilder();
        sb.append(getClass().getSimpleName());
        sb.append(" [");
        sb.append("Hash = ").append(hashCode());
        sb.append(", platformId=").append(platformId);
        sb.append(", typeId=").append(typeId);
        sb.append(", platformName=").append(platformName);
        sb.append(", platformUrl=").append(platformUrl);
        sb.append(", createTime=").append(createTime);
        sb.append(", createBy=").append(createBy);
        sb.append(", updateTime=").append(updateTime);
        sb.append(", updateBy=").append(updateBy);
        sb.append(", delFlag=").append(delFlag);
        sb.append(", serialVersionUID=").append(serialVersionUID);
        sb.append("]");
        return sb.toString();
    }
}

 src/main/java/com/linghu/model/entity/Result.java

New file
@@ -0,0 +1,117 @@
package com.linghu.model.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import java.util.Date;
import lombok.Data;

/**
 * 
 * @TableName result
 */
@TableName(value ="result")
@Data
public class Result implements Serializable {
    /**
     * 结果id
     */
    @TableId
    private Integer resultId;

    /**
     * 类型id
     */
    private Integer typeId;

    /**
     * 平台id
     */
    private Integer platformId;

    /**
     * 标题
     */
    private String title;

    /**
     * 重复次数
     */
    private Integer repetitionNum;

    /**
     * 创建时间
     */
    private Date createTime;

    /**
     * 采集轮数
     */
    private Integer num;

    /**
     * 来源url
     */
    private String url;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;

    @Override
    public boolean equals(Object that) {
        if (this == that) {
            return true;
        }
        if (that == null) {
            return false;
        }
        if (getClass() != that.getClass()) {
            return false;
        }
        Result other = (Result) that;
        return (this.getResultId() == null ? other.getResultId() == null : this.getResultId().equals(other.getResultId()))
            && (this.getTypeId() == null ? other.getTypeId() == null : this.getTypeId().equals(other.getTypeId()))
            && (this.getPlatformId() == null ? other.getPlatformId() == null : this.getPlatformId().equals(other.getPlatformId()))
            && (this.getTitle() == null ? other.getTitle() == null : this.getTitle().equals(other.getTitle()))
            && (this.getRepetitionNum() == null ? other.getRepetitionNum() == null : this.getRepetitionNum().equals(other.getRepetitionNum()))
            && (this.getCreateTime() == null ? other.getCreateTime() == null : this.getCreateTime().equals(other.getCreateTime()))
            && (this.getNum() == null ? other.getNum() == null : this.getNum().equals(other.getNum()))
            && (this.getUrl() == null ? other.getUrl() == null : this.getUrl().equals(other.getUrl()));
    }

    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result + ((getResultId() == null) ? 0 : getResultId().hashCode());
        result = prime * result + ((getTypeId() == null) ? 0 : getTypeId().hashCode());
        result = prime * result + ((getPlatformId() == null) ? 0 : getPlatformId().hashCode());
        result = prime * result + ((getTitle() == null) ? 0 : getTitle().hashCode());
        result = prime * result + ((getRepetitionNum() == null) ? 0 : getRepetitionNum().hashCode());
        result = prime * result + ((getCreateTime() == null) ? 0 : getCreateTime().hashCode());
        result = prime * result + ((getNum() == null) ? 0 : getNum().hashCode());
        result = prime * result + ((getUrl() == null) ? 0 : getUrl().hashCode());
        return result;
    }

    @Override
    public String toString() {
        StringBuilder sb = new StringBuilder();
        sb.append(getClass().getSimpleName());
        sb.append(" [");
        sb.append("Hash = ").append(hashCode());
        sb.append(", resultId=").append(resultId);
        sb.append(", typeId=").append(typeId);
        sb.append(", platformId=").append(platformId);
        sb.append(", title=").append(title);
        sb.append(", repetitionNum=").append(repetitionNum);
        sb.append(", createTime=").append(createTime);
        sb.append(", num=").append(num);
        sb.append(", url=").append(url);
        sb.append(", serialVersionUID=").append(serialVersionUID);
        sb.append("]");
        return sb.toString();
    }
}

 src/main/java/com/linghu/model/entity/Type.java

New file
@@ -0,0 +1,76 @@
package com.linghu.model.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import lombok.Data;

/**
 * 
 * @TableName type
 */
@TableName(value ="type")
@Data
public class Type implements Serializable {
    /**
     * 类型
     */
    @TableId(type = IdType.AUTO)
    private Integer typeId;

    /**
     * 名字
     */
    private String typeName;

    /**
     * 0-未删除 1-删除
     */
    private Integer delFlag;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;

    @Override
    public boolean equals(Object that) {
        if (this == that) {
            return true;
        }
        if (that == null) {
            return false;
        }
        if (getClass() != that.getClass()) {
            return false;
        }
        Type other = (Type) that;
        return (this.getTypeId() == null ? other.getTypeId() == null : this.getTypeId().equals(other.getTypeId()))
            && (this.getTypeName() == null ? other.getTypeName() == null : this.getTypeName().equals(other.getTypeName()))
            && (this.getDelFlag() == null ? other.getDelFlag() == null : this.getDelFlag().equals(other.getDelFlag()));
    }

    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result + ((getTypeId() == null) ? 0 : getTypeId().hashCode());
        result = prime * result + ((getTypeName() == null) ? 0 : getTypeName().hashCode());
        result = prime * result + ((getDelFlag() == null) ? 0 : getDelFlag().hashCode());
        return result;
    }

    @Override
    public String toString() {
        StringBuilder sb = new StringBuilder();
        sb.append(getClass().getSimpleName());
        sb.append(" [");
        sb.append("Hash = ").append(hashCode());
        sb.append(", typeId=").append(typeId);
        sb.append(", typeName=").append(typeName);
        sb.append(", delFlag=").append(delFlag);
        sb.append(", serialVersionUID=").append(serialVersionUID);
        sb.append("]");
        return sb.toString();
    }
}

 src/main/java/com/linghu/service/CallwordService.java

New file
@@ -0,0 +1,13 @@
package com.linghu.service;

import com.linghu.model.entity.Callword;
import com.baomidou.mybatisplus.extension.service.IService;

/**
* @author xy
* @description 针对表【callword】的数据库操作Service
* @createDate 2025-07-02 16:32:19
*/
public interface CallwordService extends IService<Callword> {

}

 src/main/java/com/linghu/service/KeywordService.java

New file
@@ -0,0 +1,13 @@
package com.linghu.service;

import com.linghu.model.entity.Keyword;
import com.baomidou.mybatisplus.extension.service.IService;

/**
* @author xy
* @description 针对表【keyword】的数据库操作Service
* @createDate 2025-07-02 16:32:19
*/
public interface KeywordService extends IService<Keyword> {

}

 src/main/java/com/linghu/service/OrderService.java

New file
@@ -0,0 +1,13 @@
package com.linghu.service;

import com.linghu.model.entity.Order;
import com.baomidou.mybatisplus.extension.service.IService;

/**
* @author xy
* @description 针对表【order】的数据库操作Service
* @createDate 2025-07-02 16:32:19
*/
public interface OrderService extends IService<Order> {

}

 src/main/java/com/linghu/service/PlatfromService.java

New file
@@ -0,0 +1,13 @@
package com.linghu.service;

import com.linghu.model.entity.Platfrom;
import com.baomidou.mybatisplus.extension.service.IService;

/**
* @author xy
* @description 针对表【platfrom】的数据库操作Service
* @createDate 2025-07-02 16:32:19
*/
public interface PlatfromService extends IService<Platfrom> {

}

 src/main/java/com/linghu/service/ResultService.java

New file
@@ -0,0 +1,13 @@
package com.linghu.service;

import com.linghu.model.entity.Result;
import com.baomidou.mybatisplus.extension.service.IService;

/**
* @author xy
* @description 针对表【result】的数据库操作Service
* @createDate 2025-07-02 16:32:19
*/
public interface ResultService extends IService<Result> {

}

 src/main/java/com/linghu/service/TypeService.java

New file
@@ -0,0 +1,44 @@
package com.linghu.service;

import com.linghu.model.entity.Type;
import com.baomidou.mybatisplus.extension.service.IService;

import java.util.List;

/**
 * @author xy
 * @description 针对表【type】的数据库操作Service
 * @createDate 2025-07-02 16:32:19
 */
public interface TypeService extends IService<Type> {
    /**
     * 批量添加类型
     * 
     * @param types 类型列表
     * @return 是否成功
     */
    boolean saveBatch(List<Type> types);

    /**
     * 批量更新类型
     * 
     * @param types 类型列表
     * @return 是否成功
     */
    boolean updateBatchById(List<Type> types);

    /**
     * 批量删除类型
     * 
     * @param typeIds 类型ID列表
     * @return 是否成功
     */
    boolean removeBatchByIds(List<Integer> typeIds);

    /**
     * 获取所有未删除的类型
     * 
     * @return 类型列表
     */
    List<Type> listAllAvailable();
}

 src/main/java/com/linghu/service/impl/CallwordServiceImpl.java

New file
@@ -0,0 +1,22 @@
package com.linghu.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.linghu.model.entity.Callword;
import com.linghu.service.CallwordService;
import com.linghu.mapper.CallwordMapper;
import org.springframework.stereotype.Service;

/**
* @author xy
* @description 针对表【callword】的数据库操作Service实现
* @createDate 2025-07-02 16:32:19
*/
@Service
public class CallwordServiceImpl extends ServiceImpl<CallwordMapper, Callword>
    implements CallwordService{

}





 src/main/java/com/linghu/service/impl/KeywordServiceImpl.java

New file
@@ -0,0 +1,22 @@
package com.linghu.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.linghu.model.entity.Keyword;
import com.linghu.service.KeywordService;
import com.linghu.mapper.KeywordMapper;
import org.springframework.stereotype.Service;

/**
* @author xy
* @description 针对表【keyword】的数据库操作Service实现
* @createDate 2025-07-02 16:32:19
*/
@Service
public class KeywordServiceImpl extends ServiceImpl<KeywordMapper, Keyword>
    implements KeywordService{

}





 src/main/java/com/linghu/service/impl/OrderServiceImpl.java

New file
@@ -0,0 +1,22 @@
package com.linghu.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.linghu.model.entity.Order;
import com.linghu.service.OrderService;
import com.linghu.mapper.OrderMapper;
import org.springframework.stereotype.Service;

/**
* @author xy
* @description 针对表【order】的数据库操作Service实现
* @createDate 2025-07-02 16:32:19
*/
@Service
public class OrderServiceImpl extends ServiceImpl<OrderMapper, Order>
    implements OrderService{

}





 src/main/java/com/linghu/service/impl/PlatfromServiceImpl.java

New file
@@ -0,0 +1,22 @@
package com.linghu.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.linghu.model.entity.Platfrom;
import com.linghu.service.PlatfromService;
import com.linghu.mapper.PlatfromMapper;
import org.springframework.stereotype.Service;

/**
* @author xy
* @description 针对表【platfrom】的数据库操作Service实现
* @createDate 2025-07-02 16:32:19
*/
@Service
public class PlatfromServiceImpl extends ServiceImpl<PlatfromMapper, Platfrom>
    implements PlatfromService{

}





 src/main/java/com/linghu/service/impl/ResultServiceImpl.java

New file
@@ -0,0 +1,22 @@
package com.linghu.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.linghu.model.entity.Result;
import com.linghu.service.ResultService;
import com.linghu.mapper.ResultMapper;
import org.springframework.stereotype.Service;

/**
* @author xy
* @description 针对表【result】的数据库操作Service实现
* @createDate 2025-07-02 16:32:19
*/
@Service
public class ResultServiceImpl extends ServiceImpl<ResultMapper, Result>
    implements ResultService{

}





 src/main/java/com/linghu/service/impl/TypeServiceImpl.java

New file
@@ -0,0 +1,49 @@
package com.linghu.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.linghu.model.entity.Type;
import com.linghu.service.TypeService;
import com.linghu.mapper.TypeMapper;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

/**
 * @author xy
 * @description 针对表【type】的数据库操作Service实现
 * @createDate 2025-07-02 16:32:19
 */
@Service
public class TypeServiceImpl extends ServiceImpl<TypeMapper, Type>
        implements TypeService {

    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean saveBatch(List<Type> types) {
        types.forEach(type -> type.setDelFlag(0));
        return super.saveBatch(types);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean updateBatchById(List<Type> types) {
        return super.updateBatchById(types);
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean removeBatchByIds(List<Integer> typeIds) {
        List<Type> types = this.listByIds(typeIds);
        types.forEach(type -> type.setDelFlag(1));
        return this.updateBatchById(types);
    }

    @Override
    public List<Type> listAllAvailable() {
        LambdaQueryWrapper<Type> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(Type::getDelFlag, 0);
        return this.list(queryWrapper);
    }
}

 src/main/resources/application.yml

New file
@@ -0,0 +1,11 @@

server:
  port: 8080


spring:
  datasource:
    url: jdbc:mysql://192.168.110.21:3306/linghu_geo_system?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&characterEncoding=UTF-8
    username: root
    password: "123456"
    driver-class-name: com.mysql.cj.jdbc.Driver

 src/main/resources/mapper/CallwordMapper.xml

New file
@@ -0,0 +1,18 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.linghu.mapper.CallwordMapper">

    <resultMap id="BaseResultMap" type="com.linghu.model.entity.Callword">
            <id property="callwordId" column="callword_id" jdbcType="VARCHAR"/>
            <result property="keywordId" column="keyword_id" jdbcType="INTEGER"/>
            <result property="callwordName" column="callword_name" jdbcType="VARCHAR"/>
            <result property="status" column="status" jdbcType="VARCHAR"/>
    </resultMap>

    <sql id="Base_Column_List">
        callword_id,keyword_id,callword_name,
        status
    </sql>
</mapper>

 src/main/resources/mapper/KeywordMapper.xml

New file
@@ -0,0 +1,18 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.linghu.mapper.KeywordMapper">

    <resultMap id="BaseResultMap" type="com.linghu.model.entity.Keyword">
            <id property="keywordId" column="keyword_id" jdbcType="INTEGER"/>
            <result property="orderId" column="order_id" jdbcType="VARCHAR"/>
            <result property="keywordName" column="keyword_name" jdbcType="VARCHAR"/>
            <result property="num" column="num" jdbcType="INTEGER"/>
    </resultMap>

    <sql id="Base_Column_List">
        keyword_id,order_id,keyword_name,
        num
    </sql>
</mapper>

 src/main/resources/mapper/OrderMapper.xml

New file
@@ -0,0 +1,23 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.linghu.mapper.OrderMapper">

    <resultMap id="BaseResultMap" type="com.linghu.model.entity.Order">
            <id property="orderId" column="order_id" jdbcType="VARCHAR"/>
            <result property="clientName" column="client_name" jdbcType="VARCHAR"/>
            <result property="status" column="status" jdbcType="TINYINT"/>
            <result property="delFlag" column="del_flag" jdbcType="TINYINT"/>
            <result property="createBy" column="create_by" jdbcType="VARCHAR"/>
            <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
            <result property="updateBy" column="update_by" jdbcType="VARCHAR"/>
            <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/>
    </resultMap>

    <sql id="Base_Column_List">
        order_id,client_name,status,
        del_flag,create_by,create_time,
        update_by,update_time
    </sql>
</mapper>

 src/main/resources/mapper/PlatfromMapper.xml

New file
@@ -0,0 +1,24 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.linghu.mapper.PlatfromMapper">

    <resultMap id="BaseResultMap" type="com.linghu.model.entity.Platfrom">
            <id property="platformId" column="platform_id" jdbcType="INTEGER"/>
            <result property="typeId" column="type_id" jdbcType="INTEGER"/>
            <result property="platformName" column="platform_name" jdbcType="VARCHAR"/>
            <result property="platformUrl" column="platform_url" jdbcType="VARCHAR"/>
            <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
            <result property="createBy" column="create_by" jdbcType="VARCHAR"/>
            <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/>
            <result property="updateBy" column="update_by" jdbcType="VARCHAR"/>
            <result property="delFlag" column="del_flag" jdbcType="TINYINT"/>
    </resultMap>

    <sql id="Base_Column_List">
        platform_id,type_id,platform_name,
        platform_url,create_time,create_by,
        update_time,update_by,del_flag
    </sql>
</mapper>

 src/main/resources/mapper/ResultMapper.xml

New file
@@ -0,0 +1,23 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.linghu.mapper.ResultMapper">

    <resultMap id="BaseResultMap" type="com.linghu.model.entity.Result">
            <id property="resultId" column="result_id" jdbcType="INTEGER"/>
            <result property="typeId" column="type_id" jdbcType="INTEGER"/>
            <result property="platformId" column="platform_id" jdbcType="INTEGER"/>
            <result property="title" column="title" jdbcType="VARCHAR"/>
            <result property="repetitionNum" column="repetition_num" jdbcType="INTEGER"/>
            <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
            <result property="num" column="num" jdbcType="INTEGER"/>
            <result property="url" column="url" jdbcType="VARCHAR"/>
    </resultMap>

    <sql id="Base_Column_List">
        result_id,type_id,platform_id,
        title,repetition_num,create_time,
        num,url
    </sql>
</mapper>

 src/main/resources/mapper/TypeMapper.xml

New file
@@ -0,0 +1,16 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.linghu.mapper.TypeMapper">

    <resultMap id="BaseResultMap" type="com.linghu.model.entity.Type">
            <id property="typeId" column="type_id" jdbcType="INTEGER"/>
            <result property="typeName" column="type_name" jdbcType="VARCHAR"/>
            <result property="delFlag" column="del_flag" jdbcType="TINYINT"/>
    </resultMap>

    <sql id="Base_Column_List">
        type_id,type_name,del_flag
    </sql>
</mapper>

 src/main/resources/static/index.html

New file
@@ -0,0 +1,6 @@
<html>
<body>
<h1>hello word!!!</h1>
<p>this is a html page</p>
</body>
</html>

 src/test/java/com/linghu/LingHuApplicationTests.java

New file
@@ -0,0 +1,13 @@
package com.linghu;

import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class LingHuApplicationTests {

    @Test
    void contextLoads() {
    }

}