idea开发 java web 旅游推荐系统bootstrap框架开发协同过滤算法web结构java编程计算机网页源码

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50067 Source Host : localhost:3306 Source Database : jsplytj Target Server Type : MYSQL Target Server Version : 50067 File Encoding : 65001 Date: 2022-04-18 20:22:33 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for gly -- ---------------------------- DROP TABLE IF EXISTS `gly`; CREATE TABLE `gly` ( `glyid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', `dh` varchar(40) default NULL COMMENT '电话', PRIMARY KEY (`glyid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gly -- ---------------------------- INSERT INTO `gly` VALUES ('1', 'admin', 'admin', 'admin', '102302103'); -- ---------------------------- -- Table structure for jdfl -- ---------------------------- DROP TABLE IF EXISTS `jdfl`; CREATE TABLE `jdfl` ( `jdflid` int(11) NOT NULL auto_increment, `flmc` varchar(40) default NULL COMMENT '分类名称', PRIMARY KEY (`jdflid`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of jdfl -- ---------------------------- INSERT INTO `jdfl` VALUES ('1', '湖泊风景区'); INSERT INTO `jdfl` VALUES ('2', '山岳风景区'); INSERT INTO `jdfl` VALUES ('3', '森林风景区'); INSERT INTO `jdfl` VALUES ('4', '山水风景'); -- ---------------------------- -- Table structure for jingdian -- ---------------------------- DROP TABLE IF EXISTS `jingdian`; CREATE TABLE `jingdian` ( `jdid` int(11) NOT NULL auto_increment, `jdmc` varchar(40) default NULL COMMENT '景点名称', `fl` varchar(40) default NULL COMMENT '分类', `js` varchar(4000) default NULL COMMENT '介绍', `tp` varchar(40) default NULL COMMENT '图片', `wz` varchar(40) default NULL COMMENT '位置', PRIMARY KEY (`jdid`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of jingdian -- ---------------------------- INSERT INTO `jingdian` VALUES ('1', '黄山', '湖泊风景区', '黄山黄山', '1650266229963.jpg', '安徽黄山'); INSERT INTO `jingdian` VALUES ('2', '镜泊湖', '湖泊风景区', '镜泊湖镜泊湖镜泊湖镜泊湖', '1650284243483.jpg', '牡丹江'); INSERT INTO `jingdian` VALUES ('3', '乡村土地', '山水风景', '乡村土地乡村土地乡村土地', '1650284336759.jpg', '乡村土地乡村土地'); INSERT INTO `jingdian` VALUES ('4', '水封湖', '山水风景', '水封湖水封湖', '1650284361378.jpg', '水封湖水封湖'); -- ---------------------------- -- Table structure for liulan -- ---------------------------- DROP TABLE IF EXISTS `liulan`; CREATE TABLE `liulan` ( `llid` int(11) NOT NULL auto_increment, `jd` varchar(40) default NULL COMMENT '景点', `yh` varchar(40) default NULL COMMENT '用户', `llsj` varchar(40) default NULL COMMENT '浏览时间', PRIMARY KEY (`llid`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of liulan -- ---------------------------- INSERT INTO `liulan` VALUES ('1', '1', '123', '2022-04-18 19:33:36'); INSERT INTO `liulan` VALUES ('3', '1', '123', '2022-04-18 19:33:54'); INSERT INTO `liulan` VALUES ('4', '1', '123', '2022-04-18 19:34:56'); INSERT INTO `liulan` VALUES ('5', '1', '123', '2022-04-18 19:35:22'); INSERT INTO `liulan` VALUES ('6', '1', '123', '2022-04-18 19:35:26'); INSERT INTO `liulan` VALUES ('7', '1', '123', '2022-04-18 19:37:10'); INSERT INTO `liulan` VALUES ('8', '1', '123', '2022-04-18 19:37:14'); INSERT INTO `liulan` VALUES ('9', '1', '123', '2022-04-18 19:37:52'); INSERT INTO `liulan` VALUES ('10', '1', '123', '2022-04-18 19:38:02'); INSERT INTO `liulan` VALUES ('11', '1', '123', '2022-04-18 19:38:04'); INSERT INTO `liulan` VALUES ('12', '3', '333', '2022-04-18 20:19:51'); INSERT INTO `liulan` VALUES ('13', '4', '333', '2022-04-18 20:19:55'); INSERT INTO `liulan` VALUES ('14', '4', '333', '2022-04-18 20:19:58'); INSERT INTO `liulan` VALUES ('15', '4', '333', '2022-04-18 20:19:59'); INSERT INTO `liulan` VALUES ('16', '4', '333', '2022-04-18 20:20:00'); INSERT INTO `liulan` VALUES ('17', '1', '333', '2022-04-18 20:20:02'); INSERT INTO `liulan` VALUES ('18', '2', '555', '2022-04-18 20:20:21'); INSERT INTO `liulan` VALUES ('19', '2', '555', '2022-04-18 20:20:23'); INSERT INTO `liulan` VALUES ('20', '2', '555', '2022-04-18 20:20:24'); INSERT INTO `liulan` VALUES ('21', '2', '555', '2022-04-18 20:20:24'); INSERT INTO `liulan` VALUES ('22', '2', '555', '2022-04-18 20:20:25'); INSERT INTO `liulan` VALUES ('23', '3', '555', '2022-04-18 20:21:37'); INSERT INTO `liulan` VALUES ('24', '4', '666', '2022-04-18 20:21:51'); INSERT INTO `liulan` VALUES ('25', '2', '666', '2022-04-18 20:21:54'); -- ---------------------------- -- Table structure for pinglun -- ---------------------------- DROP TABLE IF EXISTS `pinglun`; CREATE TABLE `pinglun` ( `plid` int(11) NOT NULL auto_increment, `jd` varchar(40) default NULL COMMENT '景点', `yh` varchar(40) default NULL COMMENT '用户', `plsj` varchar(40) default NULL COMMENT '评论时间', `nr` varchar(4000) default NULL COMMENT '内容', PRIMARY KEY (`plid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of pinglun -- ---------------------------- INSERT INTO `pinglun` VALUES ('1', 'null', '123', '2022-04-18 19:33:44', 'afadf '); INSERT INTO `pinglun` VALUES ('2', '1', '123', '2022-04-18 19:34:51', '阿道夫'); -- ---------------------------- -- Table structure for shouzang -- ---------------------------- DROP TABLE IF EXISTS `shouzang`; CREATE TABLE `shouzang` ( `szid` int(11) NOT NULL auto_increment, `jd` varchar(40) default NULL COMMENT '景点', `yh` varchar(40) default NULL COMMENT '用户', `szsj` varchar(40) default NULL COMMENT '收藏时间', PRIMARY KEY (`szid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of shouzang -- ---------------------------- INSERT INTO `shouzang` VALUES ('1', '1', 'null', '2022-04-18 19:35:25'); INSERT INTO `shouzang` VALUES ('3', '1', '123', '2022-04-18 19:38:04'); -- ---------------------------- -- Table structure for xinwen -- ---------------------------- DROP TABLE IF EXISTS `xinwen`; CREATE TABLE `xinwen` ( `xwid` int(11) NOT NULL auto_increment, `bt` varchar(40) default NULL COMMENT '标题', `nr` varchar(4000) default NULL COMMENT '内容', `fbsj` varchar(40) default NULL COMMENT '发布时间', PRIMARY KEY (`xwid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of xinwen -- ---------------------------- INSERT INTO `xinwen` VALUES ('1', '系统新闻阿', '大师傅', '2022-04-18 14:08:02'); -- ---------------------------- -- Table structure for yonghu -- ---------------------------- DROP TABLE IF EXISTS `yonghu`; CREATE TABLE `yonghu` ( `yhid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', `lxdh` varchar(40) default NULL COMMENT '联系电话', `lxdz` varchar(40) default NULL COMMENT '联系地址', `yx` varchar(40) default NULL COMMENT '邮箱', PRIMARY KEY (`yhid`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of yonghu -- ---------------------------- INSERT INTO `yonghu` VALUES ('1', '123', '123', '123', '12323', '12312333', '123@123.com'); INSERT INTO `yonghu` VALUES ('2', '333', '333', '333', '12312312', '1231