* µ¥Çú¹ÜÀí£º¿ÉÒÔ½«¸èÇú²¥·Å¡¢ÏÂÔز¢ÇÒ¿ÉÒÔ¶ÔËü½øÐÐÆÀ·Ö¡£
* ÊÕ¼¯¸èÇúÐÅÏ¢£ºÊÕ¼¯Ã¿¸ö¸èÇúµÄÐÅÏ¢£¬±ÈÈçÊÕ¼¯¸èÇúµÄ²¥·Å´ÎÊý£¬ÆÀ·ÖºóµÄ¸èÇúµÄ·ÖÊý£¬¸èÇúµÄÀàÐͺ͸èÊÖÐÅÏ¢¡£½«ÕâЩÐÅÏ¢·ÅÈëÊý¾Ý¿âÖжÔϵͳÒôÀÖÍƼö×ö×¼±¸¡£
* Óû§ÐÅÏ¢£ºÐÂÓû§ÐèҪע²áÒÔºó²ÅÄܶÔÒôÀÖ½øÐÐÆÀ·Ö£¬²¢Äܲ鿴¡¢ÐÞ¸Ä×Ô¼ºµÄµÇ¼ÐÅÏ¢¡£
* ÒôÀÖ¼ìË÷£º×¢²áÓû§¿ÉÒÔ½«½øÐÐϵͳÄÚµÄÒôÀÖËÑË÷²Ù×÷¡£
* ÒôÀÖÍƼö£ºÏµÍ³½«°´ÕÕ¸èÇúµÄÆÀ·Ö½øÐÐÐͬ¹ýÂ˲ٺó¸øÓû§É¸Ñ¡¸èÇú¡£
3.4.1 ÒôÀÖÉÏ´«Éè¼Æ
ÒôÀÖÉÏ´«¹¦ÄÜ£º¹ÜÀíÔ±¶ÔÉÏ´«µÄÒôÀÖ½øÐзÖÀà°üÀ¨ÒôÀÖµØÇøµÄ·ÖÀ࣬ÒôÀÖ·ç¸ñµÄ·ÖÀ࣬ÒôÀÖÀàÐ͵ķÖÀ࣬¸èÊÖÀàÐÍ·ÖÀà¡£
ÏÂÃæÊÇÒôÀÖÉÏ´«¹¦ÄܵÄÉè¼Æ¡£
¹ÜÀíÔ±´Ó¹ÜÀíԱģ¿éÉÏ´«¸èÇúʱ´ÓÒôÀÖµØÇø£¬ÒôÀÖ·ç¸ñ£¬ÒôÀÖÀàÐÍ£¬¸èÊÖÀàÐÍÖÐһһѡÔñÊôÐÔ¶Ô¸ÃÒôÀÖ½øÐÐÃèÊö£¬´ËʱÉú³É¸èÇúidºÍ¸èÇúËù¶ÔÓ¦µÄµØÇø¡¢·ç¸ñ¡¢ÀàÐÍ¡¢¸èÊÖµÄÃû³Æ²¢½«Ëü´æÈëÊý¾Ý¿â¡£
Óû§¿ÉÒÔÔÚÊ×Ò³¿´µ½ÒôÀÖµØÇø¡¢ÒôÀÖ·ç¸ñ¡¢ÒôÀÖÀàÐͺ͸èÊÖÀàÐÍ£¬½«Êó±êÒƶ¯µ½¸÷×ÔµÄÀ¸Ä¿¾Í»á·¢ÏÖËù¶ÔÓ¦µÄÊôÐÔ£¬µã»÷ÊôÐԵĻ°»á³öÏÖÊôÐÔËù¶ÔÓ¦µÄÒôÀÖ¡£
3.4.2 µ¥Çú¹ÜÀíÉè¼Æ
Óû§¿ÉÒÔ´ÓϵͳÊ×Ò³½øÈëÒôÀÖ²¥·ÅÒ³Ãæ²¥·Å¸èÇú£¬²¢¿ÉÒÔ½«ÒôÀÖÏÂÔØ£»¹ÜÀíÔ±¿ÉÒÔ´Ó¹ÜÀíԱģ¿é½øÈëϵͳ²¢ÐÞ¸ÄÒôÀÖ¡£
3.4.3 ÊÕ¼¯¸èÇúÐÅÏ¢Éè¼Æ
ÊÕ¼¯¸èÇúÐÅÏ¢£º¶ÔÿһÊ׸èÇúµÄÐÅÏ¢£¨¸èÇúµØÇø¡¢¸èÇú·ç¸ñ¡¢¸èÇúÀàÐÍ¡¢¸èÊÖ¡¢ÆÀ·Ö¡¢²¥·ÅÁ¿£©½øÐÐÊÕ¼¯²¢´æÈëÊý¾Ý¿â¡£
ÊÕ¼¯¸èÇúÐÅÏ¢¹¦ÄÜÈçÏ¡£
´¦Àí£ºÔÚÊý¾Ý¿âÖвéѯ²¢ÊÕ¼¯¸èÇúÐÅÏ¢¡£
Êä³ö£º¸èÇú±àºÅ¡¢¸èÇúÀàÐÍ¡¢¸èÇúµØÇø¡¢¸èÇú·ç¸ñ¡¢¸èÊÖÐÅÏ¢¡¢²¥·Å´ÎÊý¡¢ÆÀ·Ö½á¹û¡£
3.4.4 ÒôÀÖ¼ìË÷Éè¼Æ
¿ÉÒÔÓøèÊÖ»òÕ߸èÇúÃûÀ´¼ìË÷¶ÔÓ¦µÄÒôÀÖ£¬±¾Ä£¿é¹¦ÄÜÈçÏ¡£ ÊäÈ룺¸èÊÖÃû£¬¸èÇúÃû¡£
´¦Àí£ºÑéÖ¤ÊäÈëÊÇ·ñΪ¿Õ¡£»ñÈ¡ÊäÈëÊý¾Ý²»¿Õ£¬ÔòÔÚÊý¾Ý¿âÖвéѯÏà¹ØÒôÀֵĸèÊÖ»òÕ߸èÃû¡£
Êä³ö£º¶ÔÓ¦µÄ¸èÇú¡£
3.4.5 ÒôÀÖÍƼöÉè¼Æ
ÒôÀÖÍƼöϵͳ¹¦ÄÜ£ºÒôÀÖÍƼöϵͳ¹¦ÄÜÊǸù¾ÝÓû§Ï²»¶µÄÒôÀÖÀ´ÍƼöÆäËûÀàÐÍÒôÀÖ¡£
ÏÂÃæÊÇÒôÀÖ·ÖÀ๦ÄܵÄÉè¼Æ¡£
µÇ¼Óû§´Ó²¥·ÅÄ£¿é¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄϲºÃÆÀ·Öµ±Ç°¸èÇú£¬ÆÀ·ÖÀàÐÍÓв¡¢Ò»°ã¡¢Ï²»¶ºÍ·Ç³£Ï²»¶¡£Ã¿¸öÀàÐͶÔÓ¦µÄ·ÖÊýÓв-2·Ö£¬Ò»°ã-3·Ö£¬Ï²»¶-4·ÖºÍ·Ç³£Ï²»¶-5·Ö¡£µ±Óû§Ñ¡ÔñÁËϲ»¶»ò·Ç³£Ï²»¶µÄʱºòϵͳ½«Óû§ÐÅÏ¢ºÍ¸èÇúÐÅÏ¢´æÈëÊý¾Ý±í£¬¶øµ±Óû§Ñ¡ÔñÁ˲»òÒ»°ãµÄʱºòϵͳ²»»á½²Óû§ÐÅÏ¢ºÍ¸èÇúÐÅÏ¢´æÈëÊý¾Ý±í¡£µ±ÐÅÏ¢´æÈëÊý¾Ý±íºóϵͳ½«Ö´ÐÐÐͬ¹ýÂËËã·¨À´¹ýÂ˵ôÆÀ·ÖµÍµÄ¸èÇú²¢½«ÆÀ·Ö¸ßµÄ¸èÇúÍƼö¸øÓû§£¬Óû§¿ÉÒÔÔÚÊ×Ò³·¢ÏÖÓиöÀ¸Ä¿½Ð×öϵͳÍƼöµÄÒôÀÖ£¬Óû§¿ÉÒÔ´ÓÕâÀïÊÕÌýÆäËûÀàÐ͵ĸèÇú¡£
3.5Êý¾Ý¿âÉè¼Æ
MySQL[9]ÓÐÒ»¸öÇ¿´óµÄÊý¾Ý´æ´¢ºÍ²éѯÏà¹Ø¾Û¼¯µÄ¹¦ÄÜ,ÊÇÒ»¸öСÐ͵ĹØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬MySQL±»¹ã·ºÓ¦ÓÃÔÚInternetÉϵÄÖÐСÐÍÍøÕ¾¡£ÒòΪËüµÄ³ß´çС£¬¸ßËٶȣ¬ÕûÌåµÄ³É±¾µÍ£¬ÌرðÊǶÔÓÚÐí¶àÖÐСÐÍÍøÕ¾¿ªÔ´µÄÌØÐÔ£¬ÒÔ¼õÉÙÕ¾µãµÄÕûÌå³É±¾£¬ËùÒÔ½«MySQLÑ¡Ôñ×÷Ϊһ¸öÍøÕ¾Êý¾Ý¿â¡£°ÑËü×÷ΪÊý¾Ý¿âƽ̨¡£ÏÂÃæÒ»½ÚÊÇÒôÀÖÍƼöϵͳģ¿éµÄÊý¾Ý¿â±íÉè¼Æ¡£
3.5.1 Êý¾Ý¿â¸ÅÄî½á¹¹Éè¼Æ£¨E-Rͼ£©
ÔÚϵͳÖвÉÓÃE-Rͼ[10]À´·ÖÎöÊý¾Ý¹ØϵµÄ¡£ÏÂÃæ¾ßÌåÁгö¸öÐÔ»¯ÒôÀÖÍƼöϵͳÖÐÖ÷ÒªµÄʵÌåͼ¼°E-Rͼ¡£
¸èÇúÐÅÏ¢±íE-RͼÈçͼ3-2Ëùʾ£ºÖ÷ÒªÓиèÇúID¡¢¸èÇúÃû³Æ¡¢µØÇø¡¢·ç¸ñµÈ»ù±¾Êý¾Ý¡£ÊÕ¼¯Ã¿Ò»Ê׸èÇúµÄ»ù±¾ÐÅÏ¢£¬ÒÔ±ãÓÚϵͳÍƼö¸èÇú¡£
ÒôÀÖ¸èÇúid¸èÇúÃû³ÆµØÇøURLURL·ç¸ñ ͼ3-2 ¸èÇúÐÅϢʵÌåͼ
Óû§»ù±¾ÐÅÏ¢±íE-RͼÈçͼ3-3Ëùʾ£ºÖ÷Òª°üÀ¨Óû§±àºÅ¡¢Óû§Ãû¡¢Óû§ÃÜÂ룬ÆäÖÐͨ¹ýÓû§±àºÅÀ´Çø·Ö²»Í¬µÄÓû§¡£
Óû§Óû§ÃûÓû§±àºÅÓû§ÃÜÂë ͼ3-3 Óû§ÐÅϢʵÌåͼ
¸èÊÖÐÅÏ¢±íE-RͼÈçͼ3-4Ëùʾ£ºÖ÷Òª°üÀ¨¸èÊÖ±àºÅ¡¢Ãû³Æ¡¢ÀàÐÍ¡¢ÐԱ𡢵ØÇø¡¢ÀÖÍűàºÅ¡¢×éºÏ±àºÅ¡£ÍêÕûµØ¼Ç¼ÿһλ¸èÊÖ¡¢×éºÏ»òÀÖÍŵĻù±¾ÐÅÏ¢¡£
¸èÊÖ¸èÊÖÀàÐ͵ØÇøÐÕÃûÐÔ±ð×éºÏ±àºÅ¸èÊÖ±àºÅÀÖÍűàºÅ ͼ3-4 ¸èÊÖÐÅϢʵÌåͼ
ÿһ¸ö¹ÜÀíÔ±¿ÉÒÔ¹ÜÀí¶à¸öÓû§ºÍ¸èÇú£¬Í¬Ê±Óû§ÐÅÏ¢¡¢¸èÇúÀà±ð¡¢¸èÇúÐÅÏ¢¿ÉÒÔ±»¶à¸ö¹ÜÀíÔ±¹ÜÀí¡£Óû§¿ÉÒÔÊղضàÊ׸èÇú¡£Ã¿¸öÄ£¿éÖ®¼äµÄE-RͼÈçͼ3-5Ëùʾ¡£
1MN11Óû§¹ÜÀíÔ±¸èÇú¹ÜÀíÊղعÜÀí¸èÇúN ͼ3-5 ʵÌå-¹Øϵͼ
3.5.2 ÒôÀÖÍƼöϵͳÊý¾Ý¿â±íÉè¼Æ
´Ë±íÊÇÒôÀÖµØÇøÊý¾Ý±í£¬ÓÃÓÚ·ÖÀàÒôÀÖµØÇø¡£ÆäÖаüº¬ÒôÀÖµØÇø±àºÅAreaID£¬²»¿ÉÖظ´£¬±ØÐëÌîд£»ÒôÀÖµØÇøÃû³ÆAreaName£¬±ØÐëÌîд¡£
ÒôÀÖµØÇø±àºÅAreaIDÊÇÒôÀÖÐÅÏ¢±íµÄÍâ¼ü¡£ÓÉÓÚ²»Í¬ÒôÀÖÓв»Í¬µØÇø£¬Éè¼Æ¡°ÒôÀÖµØÇøÊý¾Ý±í¡±Èç±í3-1Ëùʾ¡£
±í3-1ÒôÀÖµØÇøÊý¾Ý±í£¨±íÃû£ºt_music_area£© ×Ö¶ÎÃûÀàÐͳ¤¶ÈÃèÊö˵Ã÷
AreaID int 11 ÒôÀÖµØÇø±àºÅÖ÷¼ü£¬×Ô¶¯Ôö¼Ó AreaName varchar 255 ÒôÀÖµØÇøÃû³Æ·Ç¿Õ
´Ë±íÊÇÒôÀÖ·ç¸ñÊý¾Ý±í£¬ÓÃÓÚ·ÖÀàÒôÀÖ·ç¸ñ¡£ÆäÖаüº¬ÒôÀÖ·ç¸ñ±àºÅStyleID£¬²»¿ÉÖظ´£¬±ØÐëÌîд£»ÒôÀÖ·ç¸ñÃû³ÆStyleName£¬±ØÐëÌîд¡£
ÒôÀÖ·ç¸ñ±àºÅStyleIDÊÇÒôÀÖÐÅÏ¢±íµÄÍâ¼ü¡£ÓÉÓÚ²»Í¬ÒôÀÖÓв»Í¬·ç¸ñ£¬Éè¼Æ¡°ÒôÀÖ·ç¸ñÊý¾Ý±í¡±Èç±í3-2Ëùʾ¡£
±í3-2ÒôÀÖ·ç¸ñÊý¾Ý±í£¨±íÃû£ºt_music_style£© ×Ö¶ÎÃûÀàÐͳ¤¶ÈÃèÊö˵Ã÷
StyleID int 11 ÒôÀÖ·ç¸ñ±àºÅÖ÷¼ü£¬×Ô¶¯Ôö¼Ó StyleName varchar 255 ÒôÀÖ·ç¸ñÃû³Æ·Ç¿Õ
´Ë±íÊÇÒôÀÖÀàÐÍÊý¾Ý±í£¬ÓÃÓÚ·ÖÀàÒôÀÖÀàÐÍ¡£ÆäÖаüº¬ÒôÀÖÀàÐͱàºÅTypeID£¬²»¿ÉÖظ´£¬±ØÐëÌîд£»ÒôÀÖÀàÐÍÃû³ÆTypeName£¬±ØÐëÌîд¡£
ÒôÀÖÀàÐͱàºÅTypeIDÊÇÒôÀÖÐÅÏ¢±íµÄÍâ¼ü¡£ÓÉÓÚ²»Í¬ÒôÀÖÓв»Í¬ÀàÐÍ£¬Éè¼Æ¡°ÒôÀÖÀàÐÍÊý¾Ý±í¡±Èç±í3-3Ëùʾ¡£
±í3-3ÒôÀÖÀàÐÍÊý¾Ý±í£¨±íÃû£ºt_music_type£© ×Ö¶ÎÃûÀàÐͳ¤¶ÈÃèÊö˵Ã÷
TypeID int 11 ÒôÀÖÀàÐͱàºÅÖ÷¼ü£¬×Ô¶¯Ôö¼Ó TypeName varchar 255 ÒôÀÖÀàÐÍÃû³Æ·Ç¿Õ
´Ë±íÊǹÜÀíÔ±ÐÅÏ¢µÄÊý¾Ý±í£¬ÓÃÓڼǼ¹ÜÀíÔ±µÇ¼ÐÅÏ¢¡£´Ë±í°üº¬¹ÜÀíÔ±±àºÅSysuserID£»¹ÜÀíÔ±Óû§ÃûSysuserName£»¹ÜÀíÔ±ÃÜÂëUserpassword¡£
ÓÉÓÚ²»Í¬¹ÜÀíÔ±Óв»Í¬¸öÈËÐÅÏ¢£¬Éè¼Æ¡°¹ÜÀíÔ±Êý¾Ý±í¡±Èç±í3-4Ëùʾ¡£ ±í3-4¹ÜÀíÔ±Êý¾Ý±í£¨±íÃû£ºt-sysuser£© ×Ö¶ÎÃûÀàÐͳ¤¶ÈÃèÊö˵Ã÷
SysuserID int 11 ¹ÜÀíÔ±±àºÅÖ÷¼ü£¬×Ô¶¯Ôö¼Ó SysuserName int 11 ¹ÜÀíÔ±Óû§Ãû·Ç¿Õ SysuserPassword varchar 150 ¹ÜÀíÔ±ÃÜÂë·Ç¿Õ
´Ë±íÊÇÓû§ÐÅÏ¢µÄÊý¾Ý±í£¬ÓÃÓڼǼÓû§µÇ¼ÐÅÏ¢¡£´Ë±í°üº¬Óû§Ãû±àºÅUserID£»Óû§ÃûUName£»Óû§µØÖ·UserAddress£»ÓÊÏäµØÖ·UserEmail£»Óû§
ÉúÈÕUserBirth;Óû§ÐÔ±ðUserGender;Óû§ÐÕÃûUserName£ºÓû§ÃÜÂëUserPasswd;Óû§µç»°UserCell¡£
ÓÉÓÚ²»Í¬Óû§Óв»Í¬¸öÈËÐÅÏ¢£¬Éè¼Æ¡°Óû§Êý¾Ý±í¡±Èç±í3-5Ëùʾ¡£ ±í3-5Óû§ÐÅÏ¢Êý¾Ý±í£¨±íÃû£ºt_user£© ×Ö¶ÎÃûÀàÐͳ¤¶ÈÃèÊö˵Ã÷
UserID int 11 Óû§±àºÅÖ÷¼ü, ×Ô¶¯Ôö¼Ó UName varchar 20 Óû§êdzƷǿÕ
UserAddress varchar 100 Óû§µØÖ·Íâ¼üÒýÓá°ÒôÀÖµØÇøÊý¾Ý±í¡± UserBirth varchar 10 Óû§ÉúÈÕ UserEmail varchar 50 Óû§ÓÊÏä UserGender int 11 Óû§ÐÔ±ð UserName varchar 20 Óû§ÐÕÃû·Ç¿Õ UserPasswd varchar 150 Óû§ÃÜÂë UserCell varchar 255 Óû§µç»°
´Ë±íÊÇɸѡ½á¹ûÊý¾Ý±í£¬ÓÃÓÚɸѡÓÃÓÚϲ»¶µÄÒôÀÖ¡£ÆäÖаüº¬É¸Ñ¡½á¹û±àºÅResultID£¬²»¿ÉÖظ´£¬×Ô¶¯Ôö¼Ó£»ÒôÀÖ±àºÅMusicID£¬²»¿ÉÖظ´;Óû§±àºÅUserID£¬²»¿ÉÖظ´¡£
ÓÉÓÚ²»Í¬Óû§Óв»Í¬É¸Ñ¡½á¹û£¬Éè¼Æ¡°É¸Ñ¡½á¹û±í¡±Èç±í3-6Ëùʾ¡£ ×Ö¶ÎÃûÀàÐͳ¤¶ÈÃèÊö˵Ã÷
ResultID int 11 ɸѡ½á¹û±àºÅÖ÷¼ü£¬×Ô¶¯Ôö¼Ó MusicID varchar 255 ÒôÀÖ±àºÅÍâ¼üÒýÓá°ÒôÀÖÐÅÏ¢±í¡± UserID int 11 Óû§±àºÅÍâ¼üÒýÓá°Óû§ÐÅÏ¢Êý¾Ý±í¡± ±í3-6 ɸѡ½á¹û±í£¨±íÃû£ºt_filtling_result£©
´Ë±íÊÇÒôÀÖÐÅÏ¢Êý¾Ý±í£¬ÓÃÓÚÊÕ¼¯ÒôÀÖÐÅÏ¢¡£ÆäÖаüº¬ÒôÀÖ±àºÅMusicID£»²»¿ÉÖظ´£»ÒôÀÖ·¾¶Filepath;ÒôÀÖµã»÷Á¿Hits;¸è´ÊLyrics;ÒôÀÖÃû³ÆName;¸èÊÖSinger£»ÒôÀÖµØÇø±àºÅAreaID;ÒôÀÖ·ç¸ñ±àºÅStyleID;ÒôÀÖÀàÐͱàºÅTypeID;Óû§Ï²»¶´ÎÊýLikes;ÒôÀÖÆÀ·ÖScore¡£
ÓÉÓÚ²»Í¬ÒôÀÖÓв»Í¬ÐÅÏ¢£¬Éè¼Æ¡°ÒôÀÖÐÅÏ¢±í¡±Èç±í3-7Ëùʾ¡£ ±í3-7 ÒôÀÖÐÅÏ¢±í£¨±íÃû£ºt_music£©