ASPNETMyMusic.zip

前台音乐搜索，播放，后台对歌曲，歌手，专辑进行管理，五张表，分别是管理员用户表，专辑表，歌曲信息表，歌手信心表，还有歌手写真表 create table admins( AdminID int identity(10000,1) primary key, AdminName varchar(100) not null, AdminPwd varchar(100) not null ) create table Singers( SingerID int identity(10000,1) primary key, SingerName nvarchar(50) not null, SingerSex char(4), SingerBornDate date, SingerMark varchar(1000), SingerAddress varchar(300), SingerImage varchar(500), ) create table SongS( SongsID int identity(10000,1) primary key, SongName nvarchar(200) not null, SingerID int, SongAlbumID int, SongUrl nvarchar(1000), SongLrc text, SongDate date ) create table SongAlbum( SongAlbumID int identity(10000,1) primary key, SongAlbumName nvarchar(100) not null, SongAlbumDate date, SongAlbumCompany nvarchar(300), SongAlbumMark nvarchar(200), SingerID int, ) create table SingerImg( SingerImgId int identity(10000,1) primary key, SingerImgUrl nvarchar(1000), SingerImgUr2 nvarchar(1000), SingerImgUr3 nvarchar(1000), SingerId int )