基于jsp+java的音乐网站

news/2024/5/19 15:04:36/文章来源:https://blog.csdn.net/qq_1102255374/article/details/122400399

介绍：
jsp+servlet+mysql+eclipse技术

效果截图：在这里插入图片描述

数据库表：
CREATE TABLE admin (
id int(11) NOT NULL AUTO_INCREMENT,
adminName varchar(20) COLLATE utf8_bin DEFAULT NULL,
adminPwd varchar(20) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

– Records of admin

INSERT INTO admin VALUES (‘1’, ‘admin’, ‘admin’);
INSERT INTO admin VALUES (‘2’, ‘1’, ‘1’);

– Table structure for collection

DROP TABLE IF EXISTS collection;
CREATE TABLE collection (
CollectionId int(11) NOT NULL AUTO_INCREMENT,
CollectionName varchar(20) COLLATE utf8_bin DEFAULT NULL,
userId int(11) DEFAULT NULL,
PRIMARY KEY (CollectionId)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

– Records of collection

INSERT INTO collection VALUES (‘7’, ‘收藏列表’, ‘5’);
INSERT INTO collection VALUES (‘8’, ‘收藏列表’, ‘7’);
INSERT INTO collection VALUES (‘9’, ‘收藏列表’, ‘10’);
INSERT INTO collection VALUES (‘10’, ‘收藏列表’, ‘11’);

– Table structure for collectionlist

DROP TABLE IF EXISTS collectionlist;
CREATE TABLE collectionlist (
CollectionId int(11) DEFAULT NULL,
musicId int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

– Records of collectionlist

INSERT INTO collectionlist VALUES (‘8’, ‘6’);
INSERT INTO collectionlist VALUES (‘8’, ‘3’);
INSERT INTO collectionlist VALUES (‘8’, ‘3’);
INSERT INTO collectionlist VALUES (‘8’, ‘3’);
INSERT INTO collectionlist VALUES (‘8’, ‘10’);
INSERT INTO collectionlist VALUES (‘8’, ‘10’);
INSERT INTO collectionlist VALUES (‘8’, ‘10’);
INSERT INTO collectionlist VALUES (‘8’, ‘7’);
INSERT INTO collectionlist VALUES (‘8’, ‘7’);
INSERT INTO collectionlist VALUES (‘8’, ‘7’);
INSERT INTO collectionlist VALUES (‘8’, ‘4’);
INSERT INTO collectionlist VALUES (‘8’, ‘4’);
INSERT INTO collectionlist VALUES (‘8’, ‘4’);
INSERT INTO collectionlist VALUES (‘9’, ‘3’);
INSERT INTO collectionlist VALUES (‘9’, ‘3’);
INSERT INTO collectionlist VALUES (‘9’, ‘3’);
INSERT INTO collectionlist VALUES (‘9’, ‘3’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);
INSERT INTO collectionlist VALUES (‘10’, ‘5’);
INSERT INTO collectionlist VALUES (‘10’, ‘3’);
INSERT INTO collectionlist VALUES (‘10’, ‘7’);
INSERT INTO collectionlist VALUES (‘10’, ‘9’);
INSERT INTO collectionlist VALUES (‘10’, ‘11’);
INSERT INTO collectionlist VALUES (‘10’, ‘4’);
INSERT INTO collectionlist VALUES (‘10’, ‘6’);
INSERT INTO collectionlist VALUES (‘10’, ‘15’);
INSERT INTO collectionlist VALUES (‘10’, ‘15’);
INSERT INTO collectionlist VALUES (‘10’, ‘15’);
INSERT INTO collectionlist VALUES (‘10’, ‘13’);
INSERT INTO collectionlist VALUES (‘10’, ‘15’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);
INSERT INTO collectionlist VALUES (‘9’, ‘6’);

– Table structure for music

DROP TABLE IF EXISTS music;
CREATE TABLE music (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(50) COLLATE utf8_bin DEFAULT NULL,
photoURL varchar(50) COLLATE utf8_bin DEFAULT NULL,
singerID int(11) DEFAULT NULL,
Hot int(11) DEFAULT NULL,
lyricURL varchar(50) COLLATE utf8_bin DEFAULT NULL,
typeId int(11) DEFAULT NULL,
songURL varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：http://www.luyixian.cn/news_show_883301.aspx

如若内容造成侵权/违法违规/事实不符，请联系dt猫网进行投诉反馈email:809451989@qq.com，一经查实，立即删除！