LQ07_04

三羊献瑞:
观察下面的加法算式:


      祥 瑞 生 辉
  +   三 羊 献 瑞
-------------------
   三 羊 生 瑞 气


(如果有对齐问题,可以参看【图1.jpg】)


其中,相同的汉字代表相同的数字,不同的汉字代表不同的数字。


请你填写“三羊献瑞”所代表的4位数字(答案唯一),不要填写任何多余内容。


#include<iostream>
using namespace std;
int main()  
{  
    int a,b,c,d,f,g,h;  
    int numOne,numTwo,sum;  
    for(a=2;a<=9;a++)  
    {  
        for(b=0;b<=9;b++)  
        {  
            for(c=0;c<=9;c++)  
            {  
                for(d=0;d<=9;d++)  
                {  
                    for(f=0;f<=9;f++)  
                    {  
                        for(g=0;g<=9;g++)  
                        {  
                            for(h=0;h<=9;h++)  
                            {  
                                if(a!=b && a!=c && a!=d && a!=f && a!=g && a!=h  
                                && b!=c && b!=d && b!=f && b!= g &&b!=h  
                                && c!=d && c!=f && c!= g && c!=h  
                                && d!=f && d!=g &&d!=h  
                                && f!=g && f!=h  
                                && g!=h) 
                                && a!=1 && b!=1 && c!=1 && d!=1 && f!=1 && g!=1 && h!=1)  
                                {  
                                    numOne=a*1000 + b*100 + c*10 + d;  
                                    numTwo=1*1000 + f*100 + g*10 + b;  
                                    sum=1*10000 + f*1000 + c*100 + b*10 + h;  
                                    if(sum==(numOne + numTwo))  
                                    {  
                                        cout<<1<<f<<g<<b<<endl;  
                                    }                         
                                }  
                                  
                            }  
                              
                        }  
                    }  
                }  
            }  
        }         
    }  
    return 0;  
}



两要点:1*各各数互相不等;2*因第一个条件,然后只有三为1所以其它汉字不可能为1

VIA:转载于https://blog.youkuaiyun.com/rl529014/article/details/50733199,这题暴力破解啊


-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- 主机: sql.m762.vhostgo.com -- 生成日期: 2025-08-04 11:29:37 -- 服务器版本: 5.6.51 -- PHP 版本: 7.2.7 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; /*!40101 SET NAMES utf8mb4 */; -- -- 数据库: `winstin` -- -- -------------------------------------------------------- -- -- 表的结构 `bancai` -- CREATE TABLE `bancai` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `houdu` double DEFAULT NULL, `caizhi_id` int(11) DEFAULT NULL, `kucun_id` int(11) DEFAULT NULL, `mupi1_id` int(11) DEFAULT NULL, `mupi2_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `bancai` -- INSERT INTO `bancai` (`id`, `deleted`, `deleted_at`, `last_updated`, `houdu`, `caizhi_id`, `kucun_id`, `mupi1_id`, `mupi2_id`) VALUES (1, 0, NULL, '2025-06-29 19:58:31', 15, 1, NULL, 1, 1), (2, 0, NULL, '2025-07-01 07:43:57', 3, 1, NULL, 2, 2), (5, 0, NULL, '2025-07-01 12:33:30', 3, 1, NULL, 2, 3), (6, 0, NULL, '2025-07-01 12:36:40', 3, 1, NULL, 4, 2), (7, 0, NULL, '2025-07-01 12:43:47', 5, 1, NULL, 2, 2), (8, 0, NULL, '2025-07-01 12:46:40', 5, 1, NULL, 2, 5), (9, 0, NULL, '2025-07-01 12:49:02', 6, 1, NULL, 2, 2), (10, 0, NULL, '2025-07-01 12:49:29', 6, 1, NULL, 1, 2), (26, 0, NULL, '2025-07-02 11:38:06', 6, 1, NULL, 2, 7), (27, 0, NULL, '2025-07-02 11:40:24', 6, 1, NULL, 2, 8), (28, 0, NULL, '2025-07-02 11:44:33', 6, 1, NULL, 1, 5), (29, 0, NULL, '2025-07-02 11:46:27', 9, 1, NULL, 9, 5), (30, 0, NULL, '2025-07-02 11:46:47', 9, 1, NULL, 2, 5), (31, 0, NULL, '2025-07-02 11:47:00', 9, 1, NULL, 2, 2), (32, 0, NULL, '2025-07-02 11:47:13', 9, 1, NULL, 2, 3), (33, 0, NULL, '2025-07-02 11:51:16', 12, 1, NULL, 1, 2), (34, 0, NULL, '2025-07-02 11:51:38', 15, 1, NULL, 2, 8), (35, 0, NULL, '2025-07-02 11:52:03', 15, 1, NULL, 1, 5), (36, 0, NULL, '2025-07-02 11:52:23', 15, 1, NULL, 1, 2), (37, 0, NULL, '2025-07-02 11:53:16', 18, 1, NULL, 9, 2), (38, 0, NULL, '2025-07-02 11:53:31', 18, 1, NULL, 2, 2), (39, 0, NULL, '2025-07-02 12:23:46', 55, 1, NULL, 2, 3), (40, 0, NULL, '2025-07-02 12:57:24', 15, 1, NULL, 2, 7), (41, 0, NULL, '2025-07-02 13:07:13', 3, 1, NULL, 1, 3), (42, 0, NULL, '2025-07-02 13:07:30', 5, 1, NULL, 4, 2), (43, 0, NULL, '2025-07-02 13:08:10', 6, 1, NULL, 1, 1), (44, 0, NULL, '2025-07-02 13:08:22', 9, 1, NULL, 1, 1), (45, 0, NULL, '2025-07-02 13:09:42', 5, 1, NULL, 4, 13), (46, 0, NULL, '2025-07-02 13:09:55', 12, 1, NULL, 4, 13), (47, 0, NULL, '2025-07-02 13:10:09', 18, 1, NULL, 1, 1), (49, 0, NULL, '2025-07-02 13:20:03', 6, 1, NULL, 4, 5), (56, 0, NULL, '2025-07-03 02:10:26', 9, 1, NULL, 4, 7), (57, 0, NULL, '2025-07-03 02:11:42', 15, 1, NULL, 4, 7), (58, 0, NULL, '2025-07-03 03:29:35', 9, 1, NULL, 2, 14), (59, 0, NULL, '2025-07-08 14:33:23', 88888, 2, NULL, 2, 3); -- -------------------------------------------------------- -- -- 表的结构 `caizhi` -- CREATE TABLE `caizhi` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `caizhi` -- INSERT INTO `caizhi` (`id`, `deleted`, `deleted_at`, `last_updated`, `name`) VALUES (1, 0, NULL, '2025-06-29 19:58:33', '纤维板'), (2, 0, NULL, '2025-07-01 12:35:55', '香杉'); -- -------------------------------------------------------- -- -- 表的结构 `chanpin` -- CREATE TABLE `chanpin` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `bianhao` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `chanpin` -- INSERT INTO `chanpin` (`id`, `deleted`, `deleted_at`, `last_updated`, `bianhao`) VALUES (1, 0, NULL, '2025-06-29 19:58:34', 'AN-1210'), (2, 0, NULL, '2025-06-30 07:09:34', 'AN-1208'), (3, 0, NULL, '2025-07-01 07:39:46', 'AN-1140'), (4, 0, NULL, '2025-07-01 12:30:30', 'AN-1133'), (5, 0, NULL, '2025-07-01 12:34:49', 'AN-1157'), (6, 0, NULL, '2025-07-01 12:37:35', 'AN-1159'), (7, 0, NULL, '2025-07-01 12:43:09', 'AN-1212'), (8, 0, NULL, '2025-07-02 13:05:30', 'AN-1081-H'), (9, 0, NULL, '2025-07-02 13:06:11', 'AP-1109-H'), (10, 0, NULL, '2025-07-02 13:19:23', 'AP-1278'), (11, 0, NULL, '2025-07-02 13:23:57', 'AP-1271'), (13, 0, NULL, '2025-07-03 03:24:33', 'AN-1032'), (14, 0, NULL, '2025-08-04 02:13:39', 'sssssssssssss'); -- -------------------------------------------------------- -- -- 表的结构 `chanpin_zujian` -- CREATE TABLE `chanpin_zujian` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `one_howmany` double DEFAULT NULL, `zujianshu` double DEFAULT NULL, `bancai_id` int(11) DEFAULT NULL, `chanpin_id` int(11) DEFAULT NULL, `zujian_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `chanpin_zujian` -- INSERT INTO `chanpin_zujian` (`id`, `deleted`, `deleted_at`, `last_updated`, `one_howmany`, `zujianshu`, `bancai_id`, `chanpin_id`, `zujian_id`) VALUES (1, 0, NULL, '2025-06-29 19:58:34', 20, NULL, 1, 1, 1), (2, 0, NULL, '2025-06-30 08:00:42', 11, NULL, 1, 2, 1), (3, 0, NULL, '2025-07-01 15:05:59', 1, NULL, 1, 3, 1), (4, 0, NULL, '2025-07-03 03:26:52', 1, NULL, 8, 13, 2); -- -------------------------------------------------------- -- -- 表的结构 `dingdan` -- CREATE TABLE `dingdan` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `jiaohuo` datetime DEFAULT NULL, `number` varchar(255) DEFAULT NULL, `xiadan` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `dingdan` -- INSERT INTO `dingdan` (`id`, `deleted`, `deleted_at`, `last_updated`, `jiaohuo`, `number`, `xiadan`) VALUES (1, 0, NULL, '2025-06-29 19:58:35', NULL, '2025-31', '2025-06-28 00:00:00'), (2, 0, NULL, '2025-06-30 03:43:23', NULL, '2025-33', NULL), (3, 0, NULL, '2025-07-01 07:39:01', NULL, '2025-034', '2025-07-01 00:00:00'), (4, 0, NULL, '2025-07-02 12:44:38', NULL, '2025-034增加单', '2025-07-02 00:00:00'), (5, 0, NULL, '2025-07-02 12:54:57', NULL, '2025-031', '2025-07-02 00:00:00'), (6, 0, NULL, '2025-07-02 13:04:50', '2025-07-13 00:00:00', '2025-036', '2025-06-13 00:00:00'), (7, 0, NULL, '2025-07-02 13:19:03', '2025-07-16 00:00:00', '2025-037', '2025-06-16 00:00:00'), (8, 0, NULL, '2025-07-02 13:23:35', '2025-08-17 00:00:00', '2025-038', '2025-06-17 00:00:00'), (44, 0, NULL, '2025-07-03 03:24:17', '2025-08-03 00:00:00', '梦5', '2025-07-03 00:00:00'); -- -------------------------------------------------------- -- -- 表的结构 `dingdan_bancai` -- CREATE TABLE `dingdan_bancai` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `shuliang` int(11) DEFAULT NULL, `bancai_id` int(11) DEFAULT NULL, `chanpin_id` int(11) DEFAULT NULL, `dingdan_id` int(11) DEFAULT NULL, `zujian_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `dingdan_bancai` -- INSERT INTO `dingdan_bancai` (`id`, `deleted`, `deleted_at`, `last_updated`, `shuliang`, `bancai_id`, `chanpin_id`, `dingdan_id`, `zujian_id`) VALUES (1, 0, NULL, '2025-06-29 13:50:38', 0, 1, 1, 1, 1), (2, 0, NULL, '2025-07-01 07:44:59', 42, 2, 3, 3, NULL), (3, 0, NULL, '2025-07-01 12:31:33', 16, 2, 4, 3, NULL), (4, 0, NULL, '2025-07-01 12:34:10', 15, 5, 4, 3, NULL), (5, 0, NULL, '2025-07-01 12:53:36', 12, 6, 5, 3, NULL), (6, 0, NULL, '2025-07-01 12:38:15', 14, 5, 6, 3, NULL), (7, 0, NULL, '2025-07-01 12:44:31', 20, 7, 7, 3, NULL), (8, 0, NULL, '2025-07-01 12:47:31', 6, 8, 7, 3, NULL), (9, 0, NULL, '2025-07-01 12:48:00', 6, 8, 5, 3, NULL), (10, 0, NULL, '2025-07-01 12:50:00', 20, 9, 7, 3, NULL), (11, 0, NULL, '2025-07-01 12:50:21', 25, 9, 3, 3, NULL), (12, 0, NULL, '2025-07-01 12:50:41', 15, 9, 4, 3, NULL), (13, 0, NULL, '2025-07-01 12:52:12', 15, 10, 6, 3, NULL), (14, 0, NULL, '2025-07-02 11:38:58', 14, 26, 3, 3, NULL), (15, 0, NULL, '2025-07-02 11:40:48', 9, 27, 5, 3, NULL), (16, 0, NULL, '2025-07-02 11:45:06', 15, 28, 4, 3, NULL), (17, 0, NULL, '2025-07-02 11:47:49', 4, 29, 7, 3, NULL), (18, 0, NULL, '2025-07-02 11:48:22', 18, 30, 7, 3, NULL), (19, 0, NULL, '2025-07-02 11:48:54', 12, 31, 7, 3, NULL), (20, 0, NULL, '2025-07-02 11:49:18', 14, 32, 3, 3, NULL), (21, 0, NULL, '2025-07-02 11:49:39', 18, 32, 4, 3, NULL), (22, 0, NULL, '2025-07-02 11:54:16', 14, 33, 6, 3, NULL), (23, 0, NULL, '2025-07-02 11:54:43', 15, 34, 5, 3, NULL), (24, 0, NULL, '2025-07-02 11:55:20', 29, 35, 4, 3, NULL), (25, 0, NULL, '2025-07-02 11:55:59', 9, 36, 4, 3, NULL), (26, 0, NULL, '2025-07-02 11:56:55', 15, 1, 4, 3, NULL), (27, 0, NULL, '2025-07-02 11:57:27', 48, 37, 7, 3, NULL), (28, 0, NULL, '2025-07-02 11:57:48', 20, 38, 7, 3, NULL), (29, 0, NULL, '2025-07-02 12:17:42', 2222, 1, 1, 2, 1), (30, 0, NULL, '2025-07-02 12:49:30', 14, 2, 4, 4, NULL), (31, 0, NULL, '2025-07-02 12:49:54', 13, 5, 4, 4, NULL), (32, 0, NULL, '2025-07-02 12:50:33', 13, 9, 4, 4, NULL), (33, 0, NULL, '2025-07-02 12:51:06', 13, 28, 4, 4, NULL), (34, 0, NULL, '2025-07-02 12:51:36', 16, 32, 4, 4, NULL), (35, 0, NULL, '2025-07-02 12:52:09', 26, 35, 4, 4, NULL), (36, 0, NULL, '2025-07-02 12:52:39', 8, 36, 4, 4, NULL), (37, 0, NULL, '2025-07-02 12:52:54', 13, 1, 4, 4, NULL), (38, 0, NULL, '2025-07-02 12:58:45', 14, NULL, NULL, NULL, NULL), (39, 0, NULL, '2025-07-02 13:14:51', 17, 41, 8, 6, NULL), (40, 0, NULL, '2025-07-02 13:15:44', 25, 42, 9, 6, NULL), (41, 0, NULL, '2025-07-02 13:16:15', 32, 7, 8, 6, NULL), (42, 0, NULL, '2025-07-02 13:16:39', 32, 43, 8, 6, NULL), (43, 0, NULL, '2025-07-02 13:17:01', 66, 44, 8, 6, NULL), (44, 0, NULL, '2025-07-02 13:17:23', 6, 47, 8, 6, NULL), (45, 0, NULL, '2025-07-02 13:17:46', 42, 45, 9, 6, NULL), (46, 0, NULL, '2025-07-02 13:18:02', 70, 46, 9, 6, NULL), (47, 0, NULL, '2025-07-02 13:20:48', 15, 49, 10, 7, NULL), (48, 0, NULL, '2025-07-03 02:09:29', 6, 42, 11, 8, NULL), (49, 0, NULL, '2025-07-03 02:09:53', 9, 49, 11, 8, NULL), (50, 0, NULL, '2025-07-03 02:11:24', 9, 56, 11, 8, NULL), (51, 0, NULL, '2025-07-03 02:12:03', 15, 57, 11, 8, NULL), (52, 0, NULL, '2025-07-03 03:27:48', 57, 8, 13, 44, 2), (53, 0, NULL, '2025-07-03 03:30:58', 112, NULL, NULL, NULL, NULL), (54, 0, NULL, '2025-07-03 03:38:24', 7, 40, 1, 5, NULL); -- -------------------------------------------------------- -- -- 表的结构 `dingdan_chanpin` -- CREATE TABLE `dingdan_chanpin` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `shuliang` int(11) DEFAULT NULL, `chanpin_id` int(11) DEFAULT NULL, `dingdan_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `dingdan_chanpin` -- INSERT INTO `dingdan_chanpin` (`id`, `deleted`, `deleted_at`, `last_updated`, `shuliang`, `chanpin_id`, `dingdan_id`) VALUES (5, 0, NULL, '2025-07-01 07:41:38', 200, 3, 3), (6, 0, NULL, '2025-07-01 12:30:48', 220, 4, 3), (7, 0, NULL, '2025-07-01 12:35:02', 200, 5, 3), (8, 0, NULL, '2025-07-01 12:37:58', 300, 6, 3), (9, 0, NULL, '2025-07-01 12:43:26', 40, 7, 3), (10, 0, NULL, '2025-07-01 15:03:30', 1, 1, 2), (11, 0, NULL, '2025-07-01 15:05:22', 1, 2, 2), (12, 0, NULL, '2025-07-01 15:05:29', 1, 3, 2), (13, 0, NULL, '2025-07-02 12:45:01', 200, 4, 4), (14, 0, NULL, '2025-07-02 12:56:20', 30, 1, 5), (15, 0, NULL, '2025-07-02 13:05:53', 500, 8, 6), (16, 0, NULL, '2025-07-02 13:06:30', 500, 9, 6), (17, 0, NULL, '2025-07-02 13:19:41', 500, 10, 7), (32, 0, NULL, '2025-07-03 02:08:44', 200, 11, 8), (33, 0, NULL, '2025-07-03 03:25:03', 5000, 13, 44); -- -------------------------------------------------------- -- -- 表的结构 `jinhuo` -- CREATE TABLE `jinhuo` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `date` datetime DEFAULT NULL, `shuliang` int(11) DEFAULT NULL, `text` varchar(255) DEFAULT NULL, `the_type_of_operation` int(11) DEFAULT NULL, `dingdan_bancai_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `jinhuo` -- INSERT INTO `jinhuo` (`id`, `deleted`, `deleted_at`, `last_updated`, `date`, `shuliang`, `text`, `the_type_of_operation`, `dingdan_bancai_id`, `user_id`) VALUES (3, 0, NULL, '2025-07-01 07:45:00', '2025-07-01 07:47:35', 42, NULL, NULL, 2, 1), (4, 0, NULL, '2025-07-01 12:31:34', '2025-07-01 12:34:11', 16, NULL, NULL, 3, 1), (5, 0, NULL, '2025-07-01 12:34:10', '2025-07-01 12:36:47', 15, NULL, NULL, 4, 1), (6, 0, NULL, '2025-07-01 12:37:12', '2025-07-01 12:39:49', 6, NULL, NULL, 5, 1), (7, 0, NULL, '2025-07-01 12:38:15', '2025-07-01 12:40:52', 14, NULL, NULL, 6, 1), (8, 0, NULL, '2025-07-01 12:44:31', '2025-07-01 12:47:08', 20, NULL, NULL, 7, 1), (9, 0, NULL, '2025-07-01 12:47:31', '2025-07-01 12:50:08', 6, NULL, NULL, 8, 1), (10, 0, NULL, '2025-07-01 12:48:01', '2025-07-01 12:50:38', 6, NULL, NULL, 9, 1), (11, 0, NULL, '2025-07-01 12:50:01', '2025-07-01 12:52:37', 20, NULL, NULL, 10, 1), (12, 0, NULL, '2025-07-01 12:50:21', '2025-07-01 12:52:58', 25, NULL, NULL, 11, 1), (13, 0, NULL, '2025-07-01 12:50:41', '2025-07-01 12:53:18', 15, NULL, NULL, 12, 1), (14, 0, NULL, '2025-07-01 12:52:12', '2025-07-01 12:54:49', 15, NULL, NULL, 13, 1), (15, 0, NULL, '2025-07-01 12:53:36', '2025-07-01 12:56:13', 12, NULL, NULL, 5, 1), (16, 0, NULL, '2025-07-02 11:39:01', '2025-07-02 11:41:39', 14, NULL, NULL, 14, 1), (17, 0, NULL, '2025-07-02 11:40:49', '2025-07-02 11:43:28', 9, NULL, NULL, 15, 1), (18, 0, NULL, '2025-07-02 11:45:07', '2025-07-02 11:47:46', 15, NULL, NULL, 16, 1), (19, 0, NULL, '2025-07-02 11:47:49', '2025-07-02 11:50:29', 4, NULL, NULL, 17, 1), (20, 0, NULL, '2025-07-02 11:48:22', '2025-07-02 11:51:01', 18, NULL, NULL, 18, 1), (21, 0, NULL, '2025-07-02 11:48:54', '2025-07-02 11:51:34', 12, NULL, NULL, 19, 1), (22, 0, NULL, '2025-07-02 11:49:18', '2025-07-02 11:51:58', 14, NULL, NULL, 20, 1), (23, 0, NULL, '2025-07-02 11:49:39', '2025-07-02 11:52:18', 18, NULL, NULL, 21, 1), (24, 0, NULL, '2025-07-02 11:54:16', '2025-07-02 11:56:56', 14, NULL, NULL, 22, 1), (25, 0, NULL, '2025-07-02 11:54:43', '2025-07-02 11:57:23', 15, NULL, NULL, 23, 1), (26, 0, NULL, '2025-07-02 11:55:21', '2025-07-02 11:58:00', 29, NULL, NULL, 24, 1), (27, 0, NULL, '2025-07-02 11:55:59', '2025-07-02 11:58:38', 9, NULL, NULL, 25, 1), (28, 0, NULL, '2025-07-02 11:56:56', '2025-07-02 11:59:35', 15, NULL, NULL, 26, 1), (29, 0, NULL, '2025-07-02 11:57:27', '2025-07-02 12:00:07', 48, NULL, NULL, 27, 1), (30, 0, NULL, '2025-07-02 11:57:48', '2025-07-02 12:00:27', 20, NULL, NULL, 28, 1), (31, 0, NULL, '2025-07-02 12:17:42', '2025-07-02 12:17:42', 2222, NULL, NULL, 29, NULL), (32, 0, NULL, '2025-07-02 12:17:43', '2025-07-02 12:17:42', 2222, NULL, NULL, 29, 1), (33, 0, NULL, '2025-07-02 12:49:30', '2025-07-02 12:49:30', 14, NULL, NULL, 30, NULL), (34, 0, NULL, '2025-07-02 12:49:30', '2025-07-02 12:52:10', 14, NULL, NULL, 30, 1), (35, 0, NULL, '2025-07-02 12:49:54', '2025-07-02 12:49:54', 13, NULL, NULL, 31, NULL), (36, 0, NULL, '2025-07-02 12:49:55', '2025-07-02 12:52:34', 13, NULL, NULL, 31, 1), (37, 0, NULL, '2025-07-02 12:50:33', '2025-07-02 12:50:33', 13, NULL, NULL, 32, NULL), (38, 0, NULL, '2025-07-02 12:50:33', '2025-07-02 12:53:13', 13, NULL, NULL, 32, 1), (39, 0, NULL, '2025-07-02 12:51:06', '2025-07-02 12:51:06', 13, NULL, NULL, 33, NULL), (40, 0, NULL, '2025-07-02 12:51:07', '2025-07-02 12:53:45', 13, NULL, NULL, 33, 1), (41, 0, NULL, '2025-07-02 12:51:36', '2025-07-02 12:51:36', 16, NULL, NULL, 34, NULL), (42, 0, NULL, '2025-07-02 12:51:36', '2025-07-02 12:54:15', 16, NULL, NULL, 34, 1), (43, 0, NULL, '2025-07-02 12:52:09', '2025-07-02 12:52:09', 26, NULL, NULL, 35, NULL), (44, 0, NULL, '2025-07-02 12:52:09', '2025-07-02 12:54:49', 26, NULL, NULL, 35, 1), (45, 0, NULL, '2025-07-02 12:52:39', '2025-07-02 12:52:39', 8, NULL, NULL, 36, NULL), (46, 0, NULL, '2025-07-02 12:52:39', '2025-07-02 12:55:19', 8, NULL, NULL, 36, 1), (47, 0, NULL, '2025-07-02 12:52:54', '2025-07-02 12:52:54', 13, NULL, NULL, 37, NULL), (48, 0, NULL, '2025-07-02 12:52:54', '2025-07-02 12:55:33', 13, NULL, NULL, 37, 1), (49, 0, NULL, '2025-07-02 12:58:15', '2025-07-02 12:58:15', 7, NULL, NULL, 38, NULL), (50, 0, NULL, '2025-07-02 12:58:15', '2025-07-02 13:00:54', 7, NULL, NULL, 38, 1), (51, 0, NULL, '2025-07-02 12:58:45', '2025-07-02 12:58:45', 7, NULL, NULL, 38, NULL), (52, 0, NULL, '2025-07-02 12:58:45', '2025-07-02 13:01:25', 14, NULL, NULL, 38, 1), (53, 0, NULL, '2025-07-02 13:14:51', '2025-07-02 13:14:51', 17, NULL, NULL, 39, NULL), (54, 0, NULL, '2025-07-02 13:14:52', '2025-07-02 13:17:31', 17, NULL, NULL, 39, 1), (55, 0, NULL, '2025-07-02 13:15:44', '2025-07-02 13:15:44', 25, NULL, NULL, 40, NULL), (56, 0, NULL, '2025-07-02 13:15:44', '2025-07-02 13:18:23', 25, NULL, NULL, 40, 1), (57, 0, NULL, '2025-07-02 13:16:15', '2025-07-02 13:16:15', 32, NULL, NULL, 41, NULL), (58, 0, NULL, '2025-07-02 13:16:15', '2025-07-02 13:18:55', 32, NULL, NULL, 41, 1), (59, 0, NULL, '2025-07-02 13:16:39', '2025-07-02 13:16:39', 32, NULL, NULL, 42, NULL), (60, 0, NULL, '2025-07-02 13:16:39', '2025-07-02 13:19:19', 32, NULL, NULL, 42, 1), (61, 0, NULL, '2025-07-02 13:17:01', '2025-07-02 13:17:01', 66, NULL, NULL, 43, NULL), (62, 0, NULL, '2025-07-02 13:17:01', '2025-07-02 13:19:41', 66, NULL, NULL, 43, 1), (63, 0, NULL, '2025-07-02 13:17:23', '2025-07-02 13:17:23', 6, NULL, NULL, 44, NULL), (64, 0, NULL, '2025-07-02 13:17:23', '2025-07-02 13:20:03', 6, NULL, NULL, 44, 1), (65, 0, NULL, '2025-07-02 13:17:46', '2025-07-02 13:17:46', 42, NULL, NULL, 45, NULL), (66, 0, NULL, '2025-07-02 13:17:47', '2025-07-02 13:20:26', 42, NULL, NULL, 45, 1), (67, 0, NULL, '2025-07-02 13:18:02', '2025-07-02 13:18:02', 70, NULL, NULL, 46, NULL), (68, 0, NULL, '2025-07-02 13:18:02', '2025-07-02 13:20:42', 70, NULL, NULL, 46, 1), (69, 0, NULL, '2025-07-02 13:20:48', '2025-07-02 13:20:48', 15, NULL, NULL, 47, NULL), (70, 0, NULL, '2025-07-02 13:20:49', '2025-07-02 13:23:28', 15, NULL, NULL, 47, 1), (71, 0, NULL, '2025-07-03 02:09:29', '2025-07-03 02:09:29', 6, NULL, NULL, 48, NULL), (72, 0, NULL, '2025-07-03 02:09:30', '2025-07-03 02:12:10', 6, NULL, NULL, 48, 1), (73, 0, NULL, '2025-07-03 02:09:54', '2025-07-03 02:09:54', 9, NULL, NULL, 49, NULL), (74, 0, NULL, '2025-07-03 02:09:54', '2025-07-03 02:12:34', 9, NULL, NULL, 49, 1), (75, 0, NULL, '2025-07-03 02:11:24', '2025-07-03 02:11:24', 9, NULL, NULL, 50, NULL), (76, 0, NULL, '2025-07-03 02:11:24', '2025-07-03 02:14:05', 9, NULL, NULL, 50, 1), (77, 0, NULL, '2025-07-03 02:12:03', '2025-07-03 02:12:03', 15, NULL, NULL, 51, NULL), (78, 0, NULL, '2025-07-03 02:12:04', '2025-07-03 02:14:44', 15, NULL, NULL, 51, 1), (79, 0, NULL, '2025-07-03 03:27:48', '2025-07-03 03:27:48', 57, NULL, NULL, 52, NULL), (80, 0, NULL, '2025-07-03 03:27:48', '2025-07-03 03:27:57', 57, NULL, NULL, 52, 2), (81, 0, NULL, '2025-07-03 03:30:27', '2025-07-03 03:30:27', 56, NULL, NULL, 53, NULL), (82, 0, NULL, '2025-07-03 03:30:27', '2025-07-03 03:30:36', 56, NULL, NULL, 53, 2), (83, 0, NULL, '2025-07-03 03:30:58', '2025-07-03 03:30:58', 56, NULL, NULL, 53, NULL), (84, 0, NULL, '2025-07-03 03:30:58', '2025-07-03 03:31:07', 112, NULL, NULL, 53, 2), (85, 0, NULL, '2025-07-03 03:33:53', '2025-07-03 03:33:53', -2200, '手动调整库存: 2250 → 50', NULL, NULL, 1), (86, 0, NULL, '2025-07-03 03:37:26', '2025-07-03 03:37:26', -7, '手动调整库存: 7 → 0', NULL, NULL, 1), (87, 0, NULL, '2025-07-03 03:38:24', '2025-07-03 03:38:24', 7, NULL, NULL, 54, NULL), (88, 0, NULL, '2025-07-03 03:38:24', '2025-07-03 03:38:24', 7, NULL, NULL, 54, 1); -- -------------------------------------------------------- -- -- 表的结构 `kucun` -- CREATE TABLE `kucun` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `shuliang` int(11) DEFAULT NULL, `bancai_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `kucun` -- INSERT INTO `kucun` (`id`, `deleted`, `deleted_at`, `last_updated`, `shuliang`, `bancai_id`) VALUES (2, 0, NULL, '2025-07-02 12:49:30', 72, 2), (3, 0, NULL, '2025-07-02 12:49:54', 42, 5), (4, 0, NULL, '2025-07-01 12:53:36', 6, 6), (6, 0, NULL, '2025-07-02 13:16:15', 52, 7), (8, 0, NULL, '2025-07-03 03:27:48', 69, 8), (11, 0, NULL, '2025-07-02 12:50:33', 73, 9), (12, 0, NULL, '2025-07-01 12:52:12', 15, 10), (29, 0, NULL, '2025-07-02 11:39:00', 14, 26), (31, 0, NULL, '2025-07-02 11:40:49', 9, 27), (33, 0, NULL, '2025-07-02 12:51:06', 28, 28), (37, 0, NULL, '2025-07-02 12:51:36', 48, 32), (38, 0, NULL, '2025-07-02 11:47:50', 4, 29), (39, 0, NULL, '2025-07-02 11:48:23', 18, 30), (40, 0, NULL, '2025-07-02 11:48:55', 12, 31), (41, 0, NULL, '2025-07-02 11:54:16', 14, 33), (42, 0, NULL, '2025-07-02 11:54:43', 15, 34), (43, 0, NULL, '2025-07-02 12:52:09', 55, 35), (44, 0, NULL, '2025-07-02 12:52:39', 17, 36), (45, 0, NULL, '2025-07-02 11:57:27', 48, 37), (46, 0, NULL, '2025-07-02 11:57:48', 20, 38), (47, 0, NULL, '2025-07-03 03:33:53', 50, 1), (49, 0, NULL, '2025-07-03 03:38:24', 7, 40), (53, 0, NULL, '2025-07-02 13:14:51', 17, 41), (54, 0, NULL, '2025-07-03 02:09:29', 31, 42), (55, 0, NULL, '2025-07-02 13:16:39', 32, 43), (56, 0, NULL, '2025-07-02 13:17:01', 66, 44), (57, 0, NULL, '2025-07-02 13:17:46', 42, 45), (58, 0, NULL, '2025-07-02 13:18:02', 70, 46), (59, 0, NULL, '2025-07-02 13:17:23', 6, 47), (60, 0, NULL, '2025-07-03 02:09:54', 24, 49), (68, 0, NULL, '2025-07-03 02:11:24', 9, 56), (70, 0, NULL, '2025-07-03 02:12:03', 15, 57), (72, 0, NULL, '2025-07-03 03:30:27', 56, 58), (74, 0, NULL, '2025-07-03 03:30:58', 56, NULL), (76, 0, NULL, '2025-07-08 14:33:24', 0, 59); -- -------------------------------------------------------- -- -- 表的结构 `mupi` -- CREATE TABLE `mupi` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `name` varchar(255) DEFAULT NULL, `you` bit(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `mupi` -- INSERT INTO `mupi` (`id`, `deleted`, `deleted_at`, `last_updated`, `name`, `you`) VALUES (1, 0, NULL, '2025-06-29 19:58:37', '桃花心', b'1'), (2, 0, NULL, '2025-07-01 07:43:23', '桃花芯', b'1'), (3, 0, NULL, '2025-07-01 12:33:13', '无', b'1'), (4, 0, NULL, '2025-07-01 12:36:20', '香杉', b'1'), (5, 0, NULL, '2025-07-01 12:46:09', '杂皮', b'1'), (6, 0, NULL, '2025-07-02 11:35:59', '', b'1'), (7, 0, NULL, '2025-07-02 11:37:46', '杂皮20C', b'1'), (8, 0, NULL, '2025-07-02 11:39:59', '花梨', b'1'), (9, 0, NULL, '2025-07-02 11:46:02', '黑橡', b'1'), (12, 0, NULL, '2025-07-02 12:51:16', '黑橡', b'1'), (13, 0, NULL, '2025-07-02 13:09:19', '科技黑檀', b'1'), (14, 0, NULL, '2025-07-03 03:29:15', '科技花梨', b'1'); -- -------------------------------------------------------- -- -- 表的结构 `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `andy` varchar(255) NOT NULL, `incumbency` int(11) NOT NULL, `name` varchar(255) NOT NULL, `pass` varchar(255) NOT NULL, `role` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `user` -- INSERT INTO `user` (`id`, `deleted`, `deleted_at`, `last_updated`, `andy`, `incumbency`, `name`, `pass`, `role`) VALUES (1, 0, NULL, '2025-07-01 07:34:48', 'winstin', 0, '超管', '$2a$12$v/PRjTPl9PcrrN.09YK3nOsnsM3sLdJp42rFQp8tDjILF295XRple', 3), (2, 0, NULL, '2025-07-03 02:01:35', '吴蓉', 0, '吴蓉', '$2a$12$NmbaLeziwxvJ0FZpZ1gY.uDqopho/ig4H9KzvTdX6QDRgqtfOUsuS', 2); -- -------------------------------------------------------- -- -- 表的结构 `wechat_user` -- CREATE TABLE `wechat_user` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `avatar_url` varchar(255) DEFAULT NULL, `create_time` datetime NOT NULL, `nickname` varchar(255) DEFAULT NULL, `openid` varchar(255) NOT NULL, `phone_number` varchar(255) DEFAULT NULL, `session_key` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `user_id` int(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 表的结构 `zujian` -- CREATE TABLE `zujian` ( `id` int(11) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `deleted_at` datetime DEFAULT NULL, `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- 转存表中的数据 `zujian` -- INSERT INTO `zujian` (`id`, `deleted`, `deleted_at`, `last_updated`, `name`) VALUES (1, 0, NULL, '2025-06-29 19:58:38', '侧板'), (2, 0, NULL, '2025-07-03 03:25:49', '底板'); -- -- 转储表的索引 -- -- -- 表的索引 `bancai` -- ALTER TABLE `bancai` ADD PRIMARY KEY (`id`), ADD KEY `FKaqqiwbo1buldyylxfd10t6s9i` (`caizhi_id`), ADD KEY `FKhho2rndsbrfcuoxh2v5ckpita` (`kucun_id`), ADD KEY `FKgtpa2iv2jjkpn6p1nupuf48ox` (`mupi1_id`), ADD KEY `FKdvk13swyjj5lq6tbj5hghw1we` (`mupi2_id`); -- -- 表的索引 `caizhi` -- ALTER TABLE `caizhi` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `UK46crvqr6m8o69hxu1fu3ctmeb` (`name`); -- -- 表的索引 `chanpin` -- ALTER TABLE `chanpin` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `UK6p18raa21f5nawnh7dmxy0f0k` (`bianhao`); -- -- 表的索引 `chanpin_zujian` -- ALTER TABLE `chanpin_zujian` ADD PRIMARY KEY (`id`), ADD KEY `FKjt74g1bjy5lnga2o8xw5132ox` (`bancai_id`), ADD KEY `FKqngnl03a9s8phk062o30cljy` (`chanpin_id`), ADD KEY `FKgxbe3qiv95l9u9njm6v9vv5n6` (`zujian_id`); -- -- 表的索引 `dingdan` -- ALTER TABLE `dingdan` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `UKl8nwl8iqj6auj1gb2t5fdaq0v` (`number`); -- -- 表的索引 `dingdan_bancai` -- ALTER TABLE `dingdan_bancai` ADD PRIMARY KEY (`id`), ADD KEY `FKlgqich8uvb1awk3109pxqmx5v` (`bancai_id`), ADD KEY `FK1pg8lh7gtykip0t05f9mk14ys` (`chanpin_id`), ADD KEY `FK9vsra9m3j8dcj4eci750llh62` (`dingdan_id`), ADD KEY `FKkj9ko6sx8f5drnlqbivovgg3d` (`zujian_id`); -- -- 表的索引 `dingdan_chanpin` -- ALTER TABLE `dingdan_chanpin` ADD PRIMARY KEY (`id`), ADD KEY `FK54x70yfucrdc76kqmutvf4fgj` (`chanpin_id`), ADD KEY `FKsj1dcqlcg8jjx5xevfbrvr0me` (`dingdan_id`); -- -- 表的索引 `jinhuo` -- ALTER TABLE `jinhuo` ADD PRIMARY KEY (`id`), ADD KEY `FKeyk51dk8uw0ykh665tpbkyx8f` (`dingdan_bancai_id`), ADD KEY `FKmdwa2a1qj1ln6mepmop8896r8` (`user_id`); -- -- 表的索引 `kucun` -- ALTER TABLE `kucun` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `UK5dbsvfo4b6xk8is5lo6d4lucl` (`bancai_id`); -- -- 表的索引 `mupi` -- ALTER TABLE `mupi` ADD PRIMARY KEY (`id`); -- -- 表的索引 `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`); -- -- 表的索引 `wechat_user` -- ALTER TABLE `wechat_user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `UK_kjbpuy6m988ge98tbn765ho08` (`openid`), ADD UNIQUE KEY `UK_4lovtxwijxu13sj2g0khuxq04` (`user_id`); -- -- 表的索引 `zujian` -- ALTER TABLE `zujian` ADD PRIMARY KEY (`id`); -- -- 在导出的表使用AUTO_INCREMENT -- -- -- 使用表AUTO_INCREMENT `bancai` -- ALTER TABLE `bancai` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60; -- -- 使用表AUTO_INCREMENT `caizhi` -- ALTER TABLE `caizhi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 使用表AUTO_INCREMENT `chanpin` -- ALTER TABLE `chanpin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- 使用表AUTO_INCREMENT `chanpin_zujian` -- ALTER TABLE `chanpin_zujian` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- 使用表AUTO_INCREMENT `dingdan` -- ALTER TABLE `dingdan` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- 使用表AUTO_INCREMENT `dingdan_bancai` -- ALTER TABLE `dingdan_bancai` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55; -- -- 使用表AUTO_INCREMENT `dingdan_chanpin` -- ALTER TABLE `dingdan_chanpin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- 使用表AUTO_INCREMENT `jinhuo` -- ALTER TABLE `jinhuo` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89; -- -- 使用表AUTO_INCREMENT `kucun` -- ALTER TABLE `kucun` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77; -- -- 使用表AUTO_INCREMENT `mupi` -- ALTER TABLE `mupi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- 使用表AUTO_INCREMENT `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 使用表AUTO_INCREMENT `wechat_user` -- ALTER TABLE `wechat_user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- 使用表AUTO_INCREMENT `zujian` -- ALTER TABLE `zujian` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 限制导出的表 -- -- -- 限制表 `bancai` -- ALTER TABLE `bancai` ADD CONSTRAINT `FKaqqiwbo1buldyylxfd10t6s9i` FOREIGN KEY (`caizhi_id`) REFERENCES `caizhi` (`id`), ADD CONSTRAINT `FKdvk13swyjj5lq6tbj5hghw1we` FOREIGN KEY (`mupi2_id`) REFERENCES `mupi` (`id`), ADD CONSTRAINT `FKgtpa2iv2jjkpn6p1nupuf48ox` FOREIGN KEY (`mupi1_id`) REFERENCES `mupi` (`id`), ADD CONSTRAINT `FKhho2rndsbrfcuoxh2v5ckpita` FOREIGN KEY (`kucun_id`) REFERENCES `kucun` (`id`); -- -- 限制表 `chanpin_zujian` -- ALTER TABLE `chanpin_zujian` ADD CONSTRAINT `FKgxbe3qiv95l9u9njm6v9vv5n6` FOREIGN KEY (`zujian_id`) REFERENCES `zujian` (`id`), ADD CONSTRAINT `FKjt74g1bjy5lnga2o8xw5132ox` FOREIGN KEY (`bancai_id`) REFERENCES `bancai` (`id`), ADD CONSTRAINT `FKqngnl03a9s8phk062o30cljy` FOREIGN KEY (`chanpin_id`) REFERENCES `chanpin` (`id`); -- -- 限制表 `dingdan_bancai` -- ALTER TABLE `dingdan_bancai` ADD CONSTRAINT `FK1pg8lh7gtykip0t05f9mk14ys` FOREIGN KEY (`chanpin_id`) REFERENCES `chanpin` (`id`), ADD CONSTRAINT `FK9vsra9m3j8dcj4eci750llh62` FOREIGN KEY (`dingdan_id`) REFERENCES `dingdan` (`id`), ADD CONSTRAINT `FKkj9ko6sx8f5drnlqbivovgg3d` FOREIGN KEY (`zujian_id`) REFERENCES `zujian` (`id`), ADD CONSTRAINT `FKlgqich8uvb1awk3109pxqmx5v` FOREIGN KEY (`bancai_id`) REFERENCES `bancai` (`id`); -- -- 限制表 `dingdan_chanpin` -- ALTER TABLE `dingdan_chanpin` ADD CONSTRAINT `FK54x70yfucrdc76kqmutvf4fgj` FOREIGN KEY (`chanpin_id`) REFERENCES `chanpin` (`id`), ADD CONSTRAINT `FKsj1dcqlcg8jjx5xevfbrvr0me` FOREIGN KEY (`dingdan_id`) REFERENCES `dingdan` (`id`); -- -- 限制表 `jinhuo` -- ALTER TABLE `jinhuo` ADD CONSTRAINT `FKeyk51dk8uw0ykh665tpbkyx8f` FOREIGN KEY (`dingdan_bancai_id`) REFERENCES `dingdan_bancai` (`id`), ADD CONSTRAINT `FKmdwa2a1qj1ln6mepmop8896r8` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`); -- -- 限制表 `kucun` -- ALTER TABLE `kucun` ADD CONSTRAINT `FK49m3supvamn3l93c5amcu3vlg` FOREIGN KEY (`bancai_id`) REFERENCES `bancai` (`id`); COMMIT; /*!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 */; ------------------业务主要是板材的购入和使用,估算30m的MySQL5.6数据库空间大概可以多少条数据
最新发布
08-05
#include "stm32f10x.h" #include "LQ12864.h" #include "adc.h" #include "dth11.h" #define PUSH_UP 1 #define PUSH_DOWN 2 #define PUSH_OK 3 #define PUSH_NONE 4 void main_delay(int ms) { int i,j; while(ms--) { for(i = 0;i < 5;i++) for(j = 0;j < 512;j++); } } void LED_Init() { GPIO_InitTypeDef GPIO_InitStruct; RCC_APB2PeriphClockCmd(RCC_APB2Periph_GPIOA,ENABLE); GPIO_InitStruct.GPIO_Mode = GPIO_Mode_Out_PP; GPIO_InitStruct.GPIO_Pin = GPIO_Pin_4 | GPIO_Pin_5; GPIO_InitStruct.GPIO_Speed = GPIO_Speed_50MHz; GPIO_Init(GPIOA,&GPIO_InitStruct); GPIO_SetBits(GPIOA,GPIO_Pin_4); GPIO_SetBits(GPIOA,GPIO_Pin_5); } void Buzzer_Init() { GPIO_InitTypeDef GPIO_InitStruct; RCC_APB2PeriphClockCmd(RCC_APB2Periph_GPIOA,ENABLE); GPIO_InitStruct.GPIO_Pin = GPIO_Pin_6; GPIO_InitStruct.GPIO_Mode = GPIO_Mode_Out_PP; GPIO_InitStruct.GPIO_Speed = GPIO_Speed_50MHz; GPIO_Init(GPIOA,&GPIO_InitStruct); GPIO_SetBits(GPIOA,GPIO_Pin_6); } void Fan_Init() { GPIO_InitTypeDef GPIO_InitStruct; RCC_APB2PeriphClockCmd(RCC_APB2Periph_GPIOA,ENABLE); GPIO_InitStruct.GPIO_Pin = GPIO_Pin_7; GPIO_InitStruct.GPIO_Mode = GPIO_Mode_Out_PP; GPIO_InitStruct.GPIO_Speed = GPIO_Speed_50MHz; GPIO_Init(GPIOA,&GPIO_InitStruct); GPIO_SetBits(GPIOA,GPIO_Pin_7); } void key_init(){ GPIO_InitTypeDef init; RCC_APB2PeriphClockCmd(RCC_APB2Periph_GPIOA, ENABLE); init.GPIO_Pin = GPIO_Pin_0 | GPIO_Pin_1 | GPIO_Pin_2| GPIO_Pin_3; init.GPIO_Mode = GPIO_Mode_IPU; GPIO_Init(GPIOA, &init); } int key_read(){ if(GPIO_ReadInputDataBit(GPIOA,GPIO_Pin_0)==0){ return PUSH_UP; }else if(GPIO_ReadInputDataBit(GPIOA,GPIO_Pin_1)==0){ return PUSH_DOWN; }else if(GPIO_ReadInputDataBit(GPIOA,GPIO_Pin_2)==0){ return PUSH_OK; } else return PUSH_NONE; } unsigned char Bmp013[] = { /*------------------------------------------------------------------------------ Ô´Îļþ / ÎÄ×Ö : ¿í¡Á¸ß£¨ÏñËØ£©: 64¡Á32 ------------------------------------------------------------------------------*/ 0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x80,0xC0,0xE0,0x70,0xF8,0xFC, 0x0C,0x04,0x00,0xF8,0xF8,0x00,0x00,0x80,0xC0,0xE0,0x70,0x38,0x00,0x00,0x00,0x00, 0x00,0x00,0x00,0x00,0x00,0x00,0x1C,0x38,0x70,0xE0,0x00,0x00,0x00,0x00,0x60,0x60, 0x60,0x60,0xF0,0xF0,0x60,0x60,0x60,0x60,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00, 0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x3F,0x3F, 0x00,0xC0,0xC0,0x3F,0x3F,0x33,0x33,0x33,0x31,0x30,0x38,0x38,0x00,0x00,0x00,0x00, 0x00,0x00,0x00,0x00,0x00,0x00,0x1C,0x38,0x70,0xE0,0x00,0x00,0x60,0x66,0x66,0x66, 0x66,0x66,0x7F,0x7F,0x66,0x66,0x66,0x66,0x66,0x60,0x00,0x00,0x00,0x00,0x00,0x00, 0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x03,0x03,0x03,0x03,0x03,0x03,0x03,0x03,0x03, 0x03,0xFF,0xFF,0x03,0x03,0x03,0x03,0x03,0x03,0x03,0x03,0x03,0x03,0x03,0x03,0x03, 0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x80,0xC0,0xE0,0x70,0x00,0x00,0x00,0xFF,0xFF, 0x9B,0x9B,0x9B,0x9B,0x9B,0x9B,0xFF,0xFF,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00, 0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00, 0x00,0x7F,0x7F,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00, 0x00,0x00,0x00,0x00,0x1C,0x0E,0x07,0x03,0x01,0x00,0x00,0x00,0x00,0x00,0x7F,0x7F, 0x01,0x01,0x01,0x01,0x31,0x61,0x7F,0x7F,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0x00 }; int main(void) { int i = 2; int j; int led1 = 0, led2 = 0; //±íʾÁ½¸öµÆµÄ³õʼ״̬£º0¡ª¡ªÃ𣬠1¡ª¡ªÁÁ int beep = 0; //±íʾ·äÃùÆ÷µÄ״̬ int fan = 0; //±íʾ·çÉȵÄ״̬ uint16_t val; u8 temp,hum; char buf_temp[100]={0}; LED_Init(); LCD_Init(); Buzzer_Init(); Fan_Init(); Adc_Init(); DHT11_Init(); key_init(); //LCD_CLS(); //main_delay(1000); //LCD_CLS(); while(1){ int key; DHT11_Read_Data(&temp,&hum); val = Get_Adc(); sprintf(buf_temp,"temp:%d hum:%d",temp,hum); LCD_P6x8Str(0,0,(unsigned char *)buf_temp); sprintf(buf_temp,"Light: %d",val); LCD_P6x8Str(0,1,(unsigned char *)buf_temp); LCD_P6x8Str(0,2,"LED1 "); LCD_P6x8Str(0,3,"LED2 "); LCD_P6x8Str(0,4,"BEEP "); LCD_P6x8Str(0,5,"FAN "); LCD_P6x8Str(40,i,"*"); sprintf(buf_temp,"L1:%d L2:%d BP:%d FAN:%d",led1,led2,beep,fan); LCD_P6x8Str(0,6,(unsigned char *)buf_temp); if(temp > 28 || hum > 85){ GPIO_ResetBits(GPIOA,GPIO_Pin_6); GPIO_ResetBits(GPIOA,GPIO_Pin_7); beep = 1; fan = 1; }else{ GPIO_SetBits(GPIOA,GPIO_Pin_6); GPIO_SetBits(GPIOA,GPIO_Pin_7); main_delay(100); key = key_read(); if(key == PUSH_UP){ i--; if(i < 2){ i = 5; } }else if(key == PUSH_DOWN){ i++; if(i > 5){ i = 2; } }else if(key == PUSH_OK){ if(i == 2){ //¿ØÖÆLED1µÄÁÁÃð if(led1 == 0){ GPIO_ResetBits(GPIOA,GPIO_Pin_4); led1 = 1; }else{ GPIO_SetBits(GPIOA,GPIO_Pin_4); led1 = 0; } }else if(i == 3){ //¿ØÖÆLED2µÄÁÁÃð if(led2 == 0){ GPIO_ResetBits(GPIOA,GPIO_Pin_5); led2 = 1; }else{ GPIO_SetBits(GPIOA,GPIO_Pin_5); led2 = 0; } }else if(i == 4){ //¿ØÖÆ·äÃùÆ÷µÄ¿ª¹Ø if(beep == 0){ GPIO_ResetBits(GPIOA,GPIO_Pin_6); beep = 1; }else{ GPIO_SetBits(GPIOA,GPIO_Pin_6); beep = 0; } }else{ //¿ØÖÆ·çÉȵÄÁÁÃð if(fan == 0){ GPIO_ResetBits(GPIOA,GPIO_Pin_7); fan = 1; }else{ GPIO_SetBits(GPIOA,GPIO_Pin_7); fan = 0; } } } } } } 详细解释下这段代码
07-24
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值