介绍:
jsp:servlet:mysql:eclipse技术
效果截图:
数据库表:
CREATE TABLE (
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;