sql-springai+deepseek大模型结合数据库的智能客服

/*
Navicat MySQL Data Transfer

Source Server         : 127
Source Server Version : 80022
Source Host           : 127.0.0.1:3306
Source Database       : demoai2

Target Server Type    : MYSQL
Target Server Version : 80022
File Encoding         : 65001

Date: 2026-06-20 13:32:29
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for jf3q_contact
-- ----------------------------
DROP TABLE IF EXISTS `jf3q_contact`;
CREATE TABLE `jf3q_contact` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '姓名',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '电话',
  `gname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '商品',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='咨询商品';

-- ----------------------------
-- Records of jf3q_contact
-- ----------------------------

-- ----------------------------
-- Table structure for jf3q_goods
-- ----------------------------
DROP TABLE IF EXISTS `jf3q_goods`;
CREATE TABLE `jf3q_goods` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `gname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '商品名称',
  `gtype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '商品分类',
  `price` decimal(10,2) DEFAULT NULL COMMENT '价格',
  `spec` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '规格描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='商品';

-- ----------------------------
-- Records of jf3q_goods
-- ----------------------------
INSERT INTO `jf3q_goods` VALUES ('1', 'A4复印纸 70g', '办公用纸', '25.00', '500张/包, 纯木浆, 高白度');
INSERT INTO `jf3q_goods` VALUES ('2', 'A4打印纸 80g', '办公用纸', '32.00', '500张/包, 加厚型, 适用于激光打印机');
INSERT INTO `jf3q_goods` VALUES ('3', 'B5会议记录本', '办公用纸', '15.50', '80页/本, 横线内页, 软皮封面');
INSERT INTO `jf3q_goods` VALUES ('4', '生宣纸 四尺整张', '书画用纸', '8.50', '10张/刀, 半生熟, 适合写意国画');
INSERT INTO `jf3q_goods` VALUES ('5', '熟宣卡纸 A3', '书画用纸', '12.00', '20张/包, 白色加厚, 适合工笔书法');
INSERT INTO `jf3q_goods` VALUES ('6', '毛边纸 米字格', '书画用纸', '18.00', '100张/包, 竹纤维, 初学者专用');
INSERT INTO `jf3q_goods` VALUES ('7', '小学生作业本 拼音田字格', '作业笔记', '1.50', '32开, 20页/本, 护眼黄纸张');
INSERT INTO `jf3q_goods` VALUES ('8', '英语练习本 四线三格', '作业笔记', '1.80', '32开, 20页/本, 防渗透墨水');
INSERT INTO `jf3q_goods` VALUES ('9', '彩色折纸 15cm', '美工彩纸', '9.90', '100张/包, 10色混装, 双面同色');
INSERT INTO `jf3q_goods` VALUES ('10', 'A4彩色喷墨打印纸', '美工彩纸', '35.00', '100张/包, 高光防水, 适用照片打印');