1
CREATE DATIF NOT EXISTS mini_app DEFAULT CHARACTER SET utf8mb4;
2
-- 把 'your_password' 改成自己的强密码，记住它
3
CREATE USER 'appuser'@'localhost' IDENTIFIED BY 'your_password';
4
GRANT ALL PRIVILEGES ON mini_app.* TO 'appuser'@'localhost';
5
FLUSH PRIVILEGES;
6
EXIT;

1
<dependency>
2
    <groupId>org.springframework.boot</groupId>
3
    <artifactId>spring-boot-starter-data-jpa</artifactId>
4
</dependency>
5
<dependency>
6
    <groupId>com.mysql</groupId>
7
    <artifactId>mysql-connector-j</artifactId>
8
    <scope>runtime</scope>
9
</dependency>

1
spring.datasource.url=jdbc:mysql://你的IP地址:3306/mini_app?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
2
spring.datasource.username=appuser
3
spring.datasource.password=你的密码
4
spring.jpa.hibernate.ddl-auto=update
5
spring.jpa.show-sql=true

1
package com.example.demo.entity;
2
import jakarta.persistence.*;
3
import java.time.LocalDateTime;
4

5
@Entity
6
@Table(name = "image_records")
7
public class ImageRecord {
8
    @Id
9
    @GeneratedValue(strategy = GenerationType.IDENTITY)
10
    private Long id;
11

12
    private String originalFilename;
13

14
    @Column(columnDefinition = "TEXT")
15
    private String imageUrl;        // 存储路径或base64
16
    private String recognitionResult;
17
    private LocalDateTime createTime;
18

19
    // 必须有无参构造
20
    public ImageRecord() {}
21

22
    // 快捷构造
23
    public ImageRecord(String originalFilename, String imageUrl) {
24
        this.originalFilename = originalFilename;
25
        this.imageUrl = imageUrl;
26
        this.createTime = LocalDateTime.now();
27
    }
28

29
    // Getter / Setter （IDE生成，篇幅限制省略，你全加上）
30
    // 至少需要：getId setId getOriginalFilename setOriginalFilename ...
31
}

1
package com.example.demo.repository;
2
import com.example.demo.entity.ImageRecord;
3
import org.springframework.data.jpa.repository.JpaRepository;
4
public interface ImageRecordRepository extends JpaRepository<ImageRecord, Long> {}

1
package com.example.demo.controller;
2
import com.example.demo.entity.ImageRecord;
3
import com.example.demo.repository.ImageRecordRepository;
4
import org.springframework.beans.factory.annotation.Autowired;
5
import org.springframework.web.bind.annotation.*;
6
import java.util.List;
7

8
@RestController
9
@RequestMapping("/api/images")
10
public class ImageController {
11
    @Autowired
12
    private ImageRecordRepository repository;
13

14
    @PostMapping
15
    public ImageRecord create(@RequestBody ImageRecord record) {
16
        return repository.save(record);
17
    }
18

19
    @GetMapping
20
    public List<ImageRecord> list() {
21
        return repository.findAll();
22
    }
23

24
    @GetMapping("/{id}")
25
    public ImageRecord getById(@PathVariable Long id) {
26
        return repository.findById(id).orElse(null);
27
    }
28

29
    @DeleteMapping("/{id}")
30
    public String delete(@PathVariable Long id) {
31
        repository.deleteById(id);
32
        return "deleted";
33
    }
34
}

1
spring.servlet.multipart.max-file-size=10MB
2
spring.servlet.multipart.max-request-size=10MB
3
file.upload-dir=./uploads

1
import org.springframework.beans.factory.annotation.Value;
2
import org.springframework.web.multipart.MultipartFile;
3
import java.io.File;
4
import java.io.IOException;
5
import java.nio.file.*;
6

7
@Value("${file.upload-dir}")
8
private String uploadDir;
9

10
@PostMapping("/upload")
11
public ImageRecord upload(@RequestParam("file") MultipartFile file) throws IOException {
12
    // 保证目录存在
13
    Files.createDirectories(Paths.get(uploadDir));
14

15
    // 保存文件
16
    String filename = System.currentTimeMillis() + "_" + file.getOriginalFilename();
17
    File dest = new File(uploadDir + "/" + filename);
18
    file.transferTo(dest);
19

20
    // 存数据库
21
    ImageRecord record = new ImageRecord(file.getOriginalFilename(), "/uploads/" + filename);
22
    return repository.save(record);
23
}

1
package com.example.demo.config;
2
import org.springframework.context.annotation.Configuration;
3
import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry;
4
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
5

6
@Configuration
7
public class WebConfig implements WebMvcConfigurer {
8
    @Override
9
    public void addResourceHandlers(ResourceHandlerRegistry registry) {
10
        registry.addResourceHandler("/uploads/**")
11
                .addResourceLocations("file:./uploads/");
12
    }
13
}

1
package com.example.demo.service;
2
import org.springframework.stereotype.Service;
3
import org.springframework.web.client.RestTemplate;
4
import java.util.Map;
5

6
@Service
7
public class AiService {
8
    private final RestTemplate restTemplate = new RestTemplate();
9
    private final String AI_BASE_URL = "http://localhost:5000";
10

11
    public Map<String, Object> predict(Map<String, Object> input) {
12
        return restTemplate.postForObject(
13
            AI_BASE_URL + "/predict", input, Map.class);
14
    }
15

16
    public Map<String, Object> health() {
17
        return restTemplate.getForObject(AI_BASE_URL + "/health", Map.class);
18
    }
19
}

1
@Autowired
2
private AiService aiService;
3

4
@PostMapping("/upload-and-recognize")
5
public ImageRecord uploadAndRecognize(@RequestParam("file") MultipartFile file) throws IOException {
6
    // 1. 保存文件（复用上面的上传逻辑）
7
    Files.createDirectories(Paths.get(uploadDir));
8
    String filename = System.currentTimeMillis() + "_" + file.getOriginalFilename();
9
    File dest = new File(uploadDir + "/" + filename);
10
    file.transferTo(dest);
11

12
    // 2. 调用笔记本 AI 推理
13
    Map<String, Object> aiInput = Map.of("imageUrl", "/uploads/" + filename);
14
    Map<String, Object> result = aiService.predict(aiInput);
15

16
    // 3. 存库
17
    ImageRecord record = new ImageRecord(file.getOriginalFilename(), "/uploads/" + filename);
18
    record.setRecognitionResult(result.toString());  // 实际项目解析具体字段
19
    return repository.save(record);
20
}