<!-- Spring AI JDBC 聊天记忆核心依赖 -->
<dependency>
    <groupId>org.springframework.ai</groupId>
    <artifactId>spring-ai-starter-model-chat-memory-repository-jdbc</artifactId>
</dependency>
<!-- Spring Boot JDBC Starter -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- MySQL 驱动 -->
<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <scope>runtime</scope>
</dependency>

<!-- Spring AI Alibaba Redis 记忆 Starter -->
<dependency>
    <groupId>com.alibaba.cloud.ai</groupId>
    <artifactId>spring-ai-alibaba-starter-memory-redis</artifactId>
</dependency>
<!-- Jedis 客户端依赖 -->
<dependency>
    <groupId>redis.clients</groupId>
    <artifactId>jedis</artifactId>
    <version>${jedis.version}</version>
</dependency>

server:
  port: 18081
spring:
  ai:
    dashscope:
      api-key: sk-8718a83408d7443b9544cXXXXXXXX
    chat:
      memory:
        repository:
          jdbc:
            initialize-schema: always
            schema: classpath:/sql/schema-mysql.sql

　　　memory:
  　　　# Redis 配置必须放在 spring.ai 下，层级要和你的 @Value 匹配
  　　　redis:
    　　　host: 192.168.91.165  # 你的 Redis 地址
    　　　port: 6379
    　　　timeout: 5000
    　　　# password: 123456  # 有密码再打开

  datasource:
    url: jdbc:mysql://192.168.91.165:3306/springai?useSSL=false&serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
logging:
  level:
    org.springframework.ai.chat.client.advisor.SimpleLoggerAdvisor: debug
    #org.springframework.ai.chat.client.advisor: debug

import org.springframework.stereotype.Service;
//票务服务
@Service
public class TicketService {
    //退票
    public void cancel(String ticketNumber, String name) {
        // 实际业务逻辑：调用数据库/API执行退票
        System.out.println("退票成果");
    }
}

import com.sb.dashscope18081.service.ToolService;
import org.springframework.ai.chat.client.ChatClient;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
/**
 * @author Administrator
 */
@RequestMapping("/openai")
@ResponseBody
@Controller
public class ChatclientToolController {
    @Autowired
    private ChatClient.Builder chatClientBuilder;
//
    @Autowired
    private ToolService toolService;
    //ChatClient chatClient;
//    public ChatclientToolController(ChatClient.Builder chatClientBuilder, ToolService toolService) {
//        chatClient= chatClientBuilder
//                .defaultTools(toolService)
//                .build();
//    }
    @GetMapping("/simple/tool")
    public String tool(
            @RequestParam(value = "message",
                    defaultValue = "讲个笑话") String message
    )  {
//        // 构建ChatClient并调用
        ChatClient chatClient = chatClientBuilder
                .build();
        String content = chatClient.prompt()
                .user(message)
                .call()
                .content();
        System.out.println(content);
        return content;
    }
    @GetMapping("/simple/tool2")
    public String tool2(
            @RequestParam(value = "message",
                    defaultValue = "讲个笑话") String message
    )  {
//        // 构建ChatClient并调用
        ChatClient chatClient = chatClientBuilder
                //底层就会告诉大模型提供什么
                //.defaultTools(toolService)
                .build();
        String content = chatClient.prompt()
                .user(message)
                .tools(toolService)//用 .tools() 替代 defaultTools()
                .call()
                .content();
        System.out.println(content);
        return content;
    }
}