¡¡¡¡Õª Òª
¡¡¡¡±¾ÂÛÎÄËùÉè¼ÆµÄÊÇÒ»¸ö»ùÓÚ B/S ¼Ü¹¹µÄÆóÒµÈËʹÜÀíϵͳ,²ÉÓõÄÊÇ PHP ±à³ÌÓïÑÔºÍ MySQL Êý¾Ý¿â½øÐпª·¢µÄϵͳ.±¾ÏµÍ³Ö÷ҪʵÏÖ¶ÔÆÕͨԱ¹¤µÄ»ù±¾ÐÅÏ¢¹ÜÀí¡¢¿¼ÇڵĹÜÀíºÍн³ê¹ÜÀíµÈ¹¦ÄÜ.¿¼ÇÚ¹ÜÀí¸ù¾ÝÉèÖõĿ¼ÇÚʱ¼ä¿ÉÒÔ×Ô¶¯ÅжÏÊÇ·ñ³Ùµ½¡¢ÔçÍË¡¢¿õ¹¤¡¢¼Ó°àµÈÇé¿ö,·½±ãÁ˹ÜÀíÈËÔ±¶Ô¿¼ÇÚÇé¿öµÄ¹ÜÀí.н³ê¹ÜÀíʵÏÖÁËÖ»ÐèÉèÖûù±¾¹¤×ʵÈÐÅϢϵͳ¾Í»á×Ô¶¯¼ÆËã³ö×îºóµÄ¹¤×Ê,ÕâÑù¾ÍʡȥÁËÊÖ¶¯¼ÆË㹤×ʵÄÂé·³,Ϊ¹ÜÀíÈËÔ±¼ÆË㹤×ÊÌṩ·½±ã.
¡¡¡¡±¾ÏµÍ³°üº¬ÈýÖÖÓû§,·Ö±ðÊÇ:ÆÕͨԱ¹¤ºÍ²¿ÃŹÜÀíÈËÔ±¡¢³¬¼¶¹ÜÀíÔ±.ÆÕͨԱ¹¤Ö»Äܲ鿴ÓйØ×Ô¼ºµÄ¿¼ÇڼǼ¡¢Ð½³ê¼Ç¼µÈÒÔ¼°¿¼ÇÚ²Ù×÷.²¿ÃŹÜÀíÈËÔ±¸ºÔð¶Ô¸Ã²¿ÃŵįÕͨԱ¹¤µÄÐÅÏ¢½øÐйÜÀí¡¢Ð½³ê¼Ç¼²éѯ¡¢²é¿´¿¼ÇڼǼºÍ¿¼ÇÚÇ©µ½µÈ²Ù×÷.³¬¼¶¹ÜÀíÔ±¸ºÔð¶ÔËùÓÐÔ±¹¤µÄÐÅÏ¢½øÐйÜÀí¡¢¿¼ÇÚ¹ÜÀí¡¢Ð½³ê¹ÜÀí¡¢½±³Í¹ÜÀíµÈ.
¡¡¡¡¹Ø¼ü´Ê:PHP B/S ÈËʹÜÀí
¡¡¡¡Abstract
¡¡¡¡This paper designs an enterprise personnel management system based on B/Sarchitecture, which is developed by PHP programming language and MySQL database.This system mainly realizes basic information management, attendance management andsalary management for ordinary employees. The attendance management canautomatically judge whether it is late, early retirement, absenteeism, overtime and so on,which is convenient for managers to manage the attendance. The salary management canautomatically calculate the final salary by the information system that only needs to setbasic wages. This saves the trouble of manual calculation of wages and providesconvenience for the managers to calculate wages.
¡¡¡¡The system includes three kinds of users: ordinary employees, department managersand super administrators. Ordinary employees can only view their attendance records,salary records and attendance. Department managers are responsible for informationmanagement, salary record inquiry, attendance record and attendance attendance. Superadministrators are responsible for information management, attendance management,salary management, reward and punishment management for all employees.
¡¡¡¡Key Words: PHP;B/S;personnel management
¡¡¡¡Ä¿Â¼
¡¡¡¡1. ϵͳ¸ÅÊö¼°¿ÉÐÐÐÔ·ÖÎö............................................................................1
¡¡¡¡1.1 ϵͳ¸ÅÊö.................................................................................................................1
¡¡¡¡1.2 ¿ÉÐÐÐÔ·ÖÎö.............................................................................................................1
¡¡¡¡1.2.1 ¼¼Êõ¿ÉÐÐÐÔ·ÖÎö...........................................................................................1
¡¡¡¡1.2.2 ¾¼Ã¿ÉÐÐÐÔ·ÖÎö...........................................................................................1
¡¡¡¡1.2.3 ²Ù×÷¿ÉÐÐÐÔ·ÖÎö...........................................................................................2
¡¡¡¡2. ÐèÇó·ÖÎö....................................................................................................3
¡¡¡¡2.1 ϵͳ·ÖÎö..................................................................................................................3
¡¡¡¡2.2 ϵͳ¹¦ÄÜÐèÇó·ÖÎö..................................................................................................3
¡¡¡¡3. ϵͳÉè¼Æ....................................................................................................5
¡¡¡¡3.1 ϵͳ×ÜÌ幦ÄÜÄ£¿éÉè¼Æ.........................................................................................5
¡¡¡¡3.2 Êý¾Ý¿âÉè¼Æ.............................................................................................................7
¡¡¡¡3.2.1 Óû§±í(user) ...........................................................................................7
¡¡¡¡3.2.2 ¼òÀú±í(resume) ......................................................................................7
¡¡¡¡3.2.3 ²¿Ãűí(depart)........................................................................................8
¡¡¡¡3.2.4 ¿¼ÇÚ±í(attendance).................................................................................8
¡¡¡¡3.2.5 ¿¼ÇÚʱ¼äÉèÖñí(sign) ...........................................................................9
¡¡¡¡3.2.6 ¹¤×ʱí(salary) ........................................................................................9
¡¡¡¡3.2.7 ½±³Í±í(reward).....................................................................................10
¡¡¡¡3.2.8 ÉêÇë±í(request) ....................................................................................10
¡¡¡¡3.2.9 ¹¤×ÊÉ趨±í(remuneration)...................................................................10
¡¡¡¡3.2.10 ÐÅÏ¢·¢²¼±í(info) ...............................................................................11
¡¡¡¡3.2.11 ¹¤×ÊÄêÔÂÉú³É±í(salarygeneration) ...................................................11
¡¡¡¡4. ¹ÜÀíÔ±Ò³ÃæÊµÏÖ......................................................................................12
¡¡¡¡4.1 ʵÏָſö...............................................................................................................12
¡¡¡¡4.2 µÇ¼........................................................................................................................12
¡¡¡¡4.2.1 µÇ¼¸ÅÊö.....................................................................................................12
¡¡¡¡4.2.2 µÇ¼¹Ø¼ü´úÂë.............................................................................................12
¡¡¡¡4.2.3 µÇ¼ÔËÐнØÍ¼.............................................................................................13
¡¡¡¡4.3 Ô±¹¤¹ÜÀí................................................................................................................14
¡¡¡¡4.3.1 ¹Ø¼ü´úÂë.....................................................................................................14
¡¡¡¡4.3.2 ÔËÐнØÍ¼.....................................................................................................15
¡¡¡¡4.4 ¿¼ÇÚ¹ÜÀí................................................................................................................16
¡¡¡¡4.4.1 ¿¼ÇÚʱ¼äÉèÖÃ.............................................................................................16
¡¡¡¡4.4.2 ¿¼ÇڼǼºÍÎļþÉÏ´«.................................................................................16
¡¡¡¡4.4.3 ¹Ø¼ü´úÂë.....................................................................................................16
¡¡¡¡4.4.4 ÔËÐнØÍ¼.....................................................................................................18
¡¡¡¡4.5 н³ê¹ÜÀí...............................................................................................................18
¡¡¡¡4.5.1 н³êÉèÖÃ.....................................................................................................18
¡¡¡¡4.5.2 ¹¤×ʱí.........................................................................................................18
¡¡¡¡4.5.3 ¹Ø¼ü´úÂë.....................................................................................................19
¡¡¡¡4.5.4 ÔËÐнØÍ¼.....................................................................................................23
¡¡¡¡4.6 ½±³Í¹ÜÀí................................................................................................................24
¡¡¡¡4.7 ÉóºË¹ÜÀí................................................................................................................24
¡¡¡¡4.7.1 ¹Ø¼ü´úÂë.....................................................................................................24
¡¡¡¡4.7.2 ÔËÐнØÍ¼.....................................................................................................26
¡¡¡¡4.8 ¿¼ÇÚÇ©µ½................................................................................................................26
¡¡¡¡5. ÆÕͨԱ¹¤Ò³ÃæÊµÏÖ..................................................................................27
¡¡¡¡5.1 ¸ÅÊö........................................................................................................................27
¡¡¡¡5.2 ÐÞ¸ÄÃÜÂë................................................................................................................27
¡¡¡¡5.3 ¸öÈËÖÐÐÄ................................................................................................................27
¡¡¡¡5.4 ¿¼ÇÚ.......................................................................................................................28
¡¡¡¡5.4.1 ¹Ø¼ü´úÂë......................................................................................................28
¡¡¡¡5.4.2 ÔËÐнØÍ¼......................................................................................................30
¡¡¡¡5.5 ÉêÇë.......................................................................................................................31
¡¡¡¡6. ϵͳ²âÊÔ..................................................................................................32
¡¡¡¡6.1 µÇ¼²âÊÔ...............................................................................................................32
¡¡¡¡6.2 ½çÃæ²âÊÔ...............................................................................................................32
¡¡¡¡6.3 Ìí¼Ó¡¢É¾³ý¡¢Ð޸IJâÊÔ.......................................................................................33
¡¡¡¡½áÓï................................................................................................................36
¡¡¡¡²Î¿¼ÎÄÏ×........................................................................................................36
¡¡¡¡ÖÂл................................................................................................................36
¡¡¡¡1. ϵͳ¸ÅÊö¼°¿ÉÐÐÐÔ·ÖÎö
¡¡¡¡1.1 ϵͳ¸ÅÊö
¡¡¡¡¸ÃÈËʹÜÀíϵͳֻÐèʹÓõçÄÔÖеÄä¯ÀÀÆ÷¾Í¿É¶Ô¹«Ë¾µÄÏà¹ØÐÅÏ¢¡¢Ö°Ô±¡¢Ð½Ë®µÈÇé¿ö½øÐÐһϵÁеĹÜÀí,Ö÷Òª¾ÍÊÇΪÁË·½±ã¹ÜÀíÈËÔ±¶ÔÔ±¹¤ÐÅÏ¢µÄ¹ÜÀí,ÆÕͨԱ¹¤Ò²¿ÉÒÔͨ¹ý±¾ÏµÍ³²é¿´ÒÔ¼°ÐÞ¸Ä×Ô¼ºµÄÐÅÏ¢.
¡¡¡¡±¾ÏµÍ³ÉÏÓÐÈýÖÖÓû§:ÆÕͨµÄÔ±¹¤Óû§¡¢²¿ÃŹÜÀíÔ±ºÍ³¬¼¶¹ÜÀíÔ±.ÆÕͨԱ¹¤¿ÉÒԲ鿴¹ÜÀíÔ±·¢²¼ÐÅÏ¢¡¢Ð½³ê¼Ç¼¡¢½±³Í¼Ç¼¡¢¿¼ÇڼǼ,²é¿´¼°Ð޸ļòÀúÒÔ¼°Î´Í¨¹ýÉóºËµÄÉêÇë,ÆÕͨԱ¹¤Í¨¹ý±¾ÏµÍ³¿ÉÒÔ½øÐÐÇ©µ½µÈ²Ù×÷.²¿ÃŹÜÀíÔ±Ò²¿ÉÒÔ˵ÊDz¿ÃžÀí,²¿ÃžÀíµÄ¹¦ÄܰüÀ¨Ç©µ½¿¼ÇÚ¡¢¶Ô²¿ÃÅÔ±¹¤µÄ¹ÜÀí¡¢·¢²¼¹«¸æÍ¨Öª¡¢¿¼ÇڼǼ¡¢¹¤×ʼǼ¡¢¶ÔÖ°¹¤µÄÉêÇëÉóºË¡¢½±³Í¹ÜÀí.³¬¼¶¹ÜÀíÔ±ÔÚ¹«Ë¾ÀïÒ²¿ÉÒÔ˵ÊÇ×ܾÀí,×ܾÀíÐèÒªÔöÌíÖ°Ô±Ïà¹ØÐÅÏ¢¡¢¿¼ÇÚ¹ÜÀí¡¢Ð½³ê¹ÜÀí¡¢½±³Í¹ÜÀí,ÆäÖп¼ÇÚ¹ÜÀí°üº¬¿¼ÇÚ´ò¿¨Ê±¼äµÄÉèÖúÍËùÓÐÔ±¹¤µÄ¿¼ÇڼǼ,н³ê¹ÜÀí°üº¬Ð½³ê»ù´¡½ð¶îµÄÉèÖúÍËùÓÐÔ±¹¤µÄ¹¤×ʼǼ.
¡¡¡¡1.2 ¿ÉÐÐÐÔ·ÖÎö
¡¡¡¡±¾ÏµÍ³µÄ¿ÉÐÐÐÔ·ÖÎö°üÀ¨ÒÔϼ¸¸ö·½ÃæµÄÄÚÈÝ:
¡¡¡¡1.2.1 ¼¼Êõ¿ÉÐÐÐÔ·ÖÎö
¡¡¡¡¼¼Êõ¿ÉÐÐÐÔÐèҪ˼¿¼Èí¼þ¿ª·¢¼¼ÊõÈËÔ±ÏÖÔÚʹÓõļ¼ÊõÄܲ»Äܹ»Íê³É¿ª·¢µÄ¹¤×÷,Èí¼þºÍÓ²¼þµÄÅäÖÃÄÜ·ñÂú×㿪·¢¹ý³ÌÖеĿª·¢¼¼ÊõÈËÔ±¶ÔÈí¡¢Ó²¼þµÄÐèÇóµÈ.
¡¡¡¡±¾ÏµÍ³µÄ¿ª·¢²ÉÓõÄÊÇ PHP ÓïÑÔºÍ MySQL Êý¾Ý¿âËùÒÔʹÓÃÁËWampServer(Windows ƽ̨Ï嵀 Apache¡¢ Mysql¡¢ PHP ¼¯³É°²×°»·¾³),¿ª·¢²Ù×÷ϵͳʹÓõÄÊÇ Windows7,IDE ²ÉÓà EclipsePHPStudio3,Ëù²ÉÓõÄÕâЩ¼¼Êõ,ÎÞÂÛÊÇÔÚÎȶ¨ÐÔ,»¹ÊÇÔÚÐÔÄÜÉÏ,¶¼ÄÜÂú×㱾ϵͳ¿ª·¢µÄÒªÇó.
¡¡¡¡Òò´ËÔÚ¼¼ÊõÉÏÊÇ¿ÉÒÔʵÏÖµÄ.
¡¡¡¡1.2.2 ¾¼Ã¿ÉÐÐÐÔ·ÖÎö
¡¡¡¡¿ª·¢¸ÃϵͳËùʹÓõ½µÄ¹Ø¼ü¼¼ÊõÒÔ¼°¿ª·¢µÄ¹¤¾ßÈ«²¿¶¼ÊÇ¿ªÔ´»òÕßÃâ·ÑµÄ,ËùÐèÒªÓõ½µÄÏà¹Ø×ÊÁÏ¿ÉÒÔͨ¹ýÒѾÓеÄÏà¹ØÍøÕ¾½øÐвéѯ²É¼¯,ËùÒÔ,±¾ÏµÍ³µÄ¿ª·¢µÄ³É±¾Ïà¶Ô±È½ÏµÍ.ʹÓñ¾ÏµÍ³Ó봫ͳµÄÈËʹÜÀíϵͳÏà±È½ÏµÄ»°,Ìá¸ßÁ˹¤×÷µÄЧÂÊ¡¢½µµÍÁËÈ˹¤µÄ³É±¾¡¢Ìá¸ßÁ˹¤×÷ÖÊÁ¿µÄÌØµã,½ÚÔ¼ÁË´óÁ¿µÄÈËÁ¦¡¢ÎïÁ¦ºÍ²ÆÁ¦µÄ×ÊÔ´.
¡¡¡¡Òò´ËÔÚ¾¼Ã¿ÉÐÐÐÔÉÏÊÇ¿ÉÒÔʵÐеÄ.
¡¡¡¡1.2.3 ²Ù×÷¿ÉÐÐÐÔ·ÖÎö
¡¡¡¡±¾ÏµÍ³µÄ¼¼ÊõÏà¶ÔÀ´Ëµ²»ÊÇÌØ±ðÀ§ÄÑ,¸÷ÖÖ¿ª·¢ÐèÒªÓõ½µÄ¹¤¾ß¼°Èí¼þ¶¼¿ÉÒԺܷ½±ãµÄÕÒµ½,һЩºËÐĵļ¼ÊõÍøÉÏÒ²ÓÐһЩ°¸Àý,ËùÒÔ¿ª·¢ÉÏÃæµÄ²Ù×÷ÊDz»³ÉÎÊÌâµÄ.¶øÏÖÔÚµÄÐÅÏ¢»¯¼¼ÊõµÄʹÓÃÒѾ·Ç³£ÆÕ±é,±¾ÏµÍ³µÄ¼¼Êõ¶ÔÓÚÆóÒµµÄÔ±¹¤¡¢¹ÜÀíÈËÔ±µÄ²Ù×÷¶¼²»³ÉÎÊÌâµÄ,ÔÙ¼ÓÉÏÕâÖÖ»ùÓÚ B/S ģʽµÄÔÚÏßϵͳҲÒѾ±»¹ã·ºÊìÖª,²»»á³ÉΪʹÓÃÕßÕϰ,ËùÒÔÔÚ²Ù×÷ÉÏÒ²ÊÇ¿ÉÐеÄ.
¡¡¡¡×ܶøÑÔÖ®,±¾ÏµÍ³µÄ¿ª·¢ÎÞÂÛÊÇ´Ó¼¼ÊõÉÏ¡¢¾¼ÃÉÏ,²Ù×÷ÉÏÕâÈý¸ö·½Ãæ¶¼ÊÇÍêÈ«¿É¿¿µÄ.
¡¡¡¡Òò´Ë¿ª·¢¸ÃϵͳÊÇ¿ÉÐеÄ.
¡¡¡¡2. ÐèÇó·ÖÎö
¡¡¡¡2.1 ϵͳ·ÖÎö
¡¡¡¡ÈËʹÜÀíϵͳÊÇÈ󬼶¹ÜÀíÔ±¶ÔËùÓÐÔ±¹¤µÄÐÅÏ¢¹ÜÀí¡¢Ð½³ê¹ÜÀí¡¢¿¼ÇÚ¹ÜÀí¡¢½±³Í¹ÜÀíÒÔ¼°ÐÅÏ¢µÄ·¢²¼µÈ½øÐвÙ×÷.²¿ÃŹÜÀíÔ±¿ÉÒÔͨ¹ý±¾ÏµÍ³½øÐÐÇ©µ½¡¢¶Ô¸Ã²¿ÃÅÔ±¹¤µÄÐÅÏ¢¹ÜÀí¡¢¿¼ÇڼǼ¡¢¹¤×ʼǼ¡¢ÉêÇëµÄÉóºËºÍ½±³Í¹ÜÀí.ÆÕͨԱ¹¤¿ÉÒÔͨ¹ý±¾ÏµÍ³²é¿´×Ô¼ºµÄÐÅÏ¢¡¢¿¼ÇڼǼ¡¢¹¤×ʼǼ¡¢½±³Í¼Ç¼¡¢Çë¼Ù¡¢¹ÜÀíÔ±·¢²¼µÄÏûÏ¢ÒÔ¼°Ã¿ÈÕµÄÇ©µ½,×ÜÌåÀ´Ëµ,±¾ÏµÍ³Ö÷Òª¾ÍÊÇΪ¹«Ë¾µÄ¹ÜÀíÈËÔ±ÌṩÁ˹ÜÀíÆÕͨԱ¹¤µÄ±ãÀû.ÆÕͨԱ¹¤Ö»Äܲ鿴×Ô¼ºµÄÏà¹ØÐÅÏ¢ÒÔ¼°Ç©µ½,¸÷²¿ÃŹÜÀíÔ±Ö»ÄܹÜÀí¸Ã²¿ÃÅÄÚÔ±¹¤µÄÏà¹ØÐÅÏ¢ÒÔ¼°¸Ã¹ÜÀíÈËÔ±µÄÇ©µ½,³¬¼¶¹ÜÀíÔ±¹ÜÀíÔ±¾ÍÊǹÜÀíËùÓÐµÄÆÕͨԱ¹¤µÄÐÅÏ¢ÒÔ¼°Ò»Ð©Ð½³êÉèÖᢿ¼ÇÚʱ¼äµÄÉèÖᢹ¤×ʱíµÄÉú³ÉµÈµÈ.
¡¡¡¡2.2 ϵͳ¹¦ÄÜÐèÇó·ÖÎö
¡¡¡¡±¾ÏµÍ³Ö÷Òª°üÀ¨ÁËÒÔϼ¸¸ö·½Ãæ:
¡¡¡¡Ô±¹¤ÐÅÏ¢¹ÜÀí¡¢¿¼ÇÚ¹ÜÀí¡¢Ð½³ê¹ÜÀí¡¢ÉóºË¹ÜÀí¡¢½±³Í¹ÜÀíµÈ¹¦ÄÜ.
¡¡¡¡(1)Ô±¹¤ÐÅÏ¢¹ÜÀí
¡¡¡¡ÔÚ±¾ÏµÍ³ÖÐÓÐÁ½ÖÖ¹ÜÀíÔ±:³¬¼¶¹ÜÀíÔ±¡¢²¿ÃŹÜÀíÔ±,ËüÃÇÖж¼ÓÐÔ±¹¤ÐÅÏ¢¹ÜÀíÕâ¸ö¹¦ÄÜ.ËüÃÇÖж¼ÓÐÐ޸ĺÍɾ³ý¹¦ÄÜ,µ«ÊÇÐèҪעÒâµÄÊÇÌí¼ÓÕâ¸ö¹¦ÄÜÖ»ÔÚ³¬¼¶¹ÜÀíÔ±ÖÐʵÏÖ.Ô±¹¤ÐÅÏ¢¹ÜÀí¿ÉÒÔÉèÖÃÖ°Ô±µÄ²¿ÃÅÐÅÏ¢¡¢Ö°³Æ¡¢ÊÇ·ñÀëÖ°µÈÐÅÏ¢.³¬¼¶¹ÜÀíԱʵÏÖÁ˶ÔËùÓÐÔ±¹¤µÄ¹ÜÀí,²¿ÃŹÜÀíÔ±Ö»ÄܹÜÀí¸Ã²¿ÃÅÄÚµÄÔ±¹¤.
¡¡¡¡(2)¿¼ÇÚ¹ÜÀí
¡¡¡¡¿¼ÇÚ¹ÜÀí¿ÉÒÔ¸ù¾Ý¿¼ÇڵĴò¿¨Ê±¼ä,ϵͳ×Ô¶¯ÅжϿ¼Çڵijٵ½¡¢ÔçÍË¡¢¼Ó°à¡¢¿õ¹¤µÈÇé¿ö,½«ÕâЩÐÅÏ¢´æ·Åµ½Êý¾Ý¿âÖп¼ÇÚ±íÄÚ,¿¼ÇÚ±íÖеÄÊý¾ÝÓ빤×ʼÆËãÏà¹ØÁª.¸ÃϵͳµÄÎļþÉÏ´«¹¦ÄÜ,¿ÉÒÔ½« EXCEL ±í¸ñÖеĿ¼ÇÚÐÅÏ¢µÄµ¼Èëµ½Êý¾Ý¿âµÄ¿¼ÇÚ±íÖÐ.
¡¡¡¡(3)н³ê¹ÜÀí
¡¡¡¡Ð½³ê¹ÜÀíÖаüÀ¨ÉèÖù¤×ÊÏîºÍÉèÖÃÐèÒª¼ÆËãнˮµÄʱ¼ä(ÈçÐè¼ÆËã 2018 Äê 3ԵŤ×Ê¿ÉÒÔÉèÖÃʱ¼äΪ 2018-03-01 ÖÁ 2018-03-31).
¡¡¡¡Ð½Ë®¼ÆËãʱ»áµ÷ÓÃÉèÖõŤ×ÊÏî¡¢¿¼ÇÚ±í¡¢½±³Í±íºÍÇë¼Ù±íÖеÄÊý¾Ý½øÐÐнˮ¼ÆËã.Ôڲ鿴¼ÆËãºÃµÄ¹¤×ʱíʱ,¿ÉÒÔ½«¹¤×ʱíµÄÐÅÏ¢ÒÔ Excel ±í¸ñµÄÐÎʽµ¼³ö.
¡¡¡¡(4)ÉóºË¹ÜÀí
¡¡¡¡ÉóºË¹ÜÀíµÄÕâ¸ö¹¦ÄÜÊÇÔÚ²¿ÃŹÜÀíÔ±¹¦ÄÜÄ£¿éÖдæÔÚµÄ,ÉóºËµÄ¹¦ÄÜÊDZíʾ²¿ÃŹÜÀíÔ±¿ÉÒÔͨ¹ýÕâ¸ö¹¦ÄÜ¶ÔÆÕְͨԱÌá½»µÄÉêÇë½øÐÐÉóºË.
¡¡¡¡(5)½±³Í¹ÜÀí
¡¡¡¡½±³Í¹ÜÀíÖеĽ±³Í¼Ç¼µÄ½ð¶îÔÚнˮ¼ÆËãʱ»á±»Ê¹Óõ½.ÔÚ½±³Í¹ÜÀíÖе±È»»¹°üÀ¨Á˶Խ±³Í¼Ç¼µÄÌí¼Ó¡¢É¾³ýºÍÐ޸ĵIJÙ×÷,Ö»²»¹ýÕâЩ²Ù×÷³¬¼¶¹ÜÀíÔ±ÃæÏòËùÓÐÔ±¹¤µÄ½±³Í,²¿ÃŹÜÀíÔ±Ö»¹ÜÀíµ±Ç°²¿ÃÅÄÚµÄÖ°Ô±½±³Í.
¡¡¡¡…………ÓÉÓÚ±¾ÎÄÆª·ù½Ï³¤,²¿·ÖÄÚÈÝÊ¡ÂÔ,ÏêϸȫÎļûÎÄÄ©¸½¼þ
¡¡¡¡½áÓï
¡¡¡¡Ëæ×ž¼ÃµÄ¸ßËÙÔö³¤,¼ÆËã»úÆÕ¼°µÄ·¶Î§·Ç³£¹ã·º,¼ÆËã»úÒÑÔÚÆóÒµ¡¢½ÌÓý¡¢¿ÆÑеȷ½Ãæ¶¼ÓÐÁËÔ½À´Ô½¹ã·ºµÄÓ¦ÓÃ.ÐÅÏ¢»¯µÄÈËʹÜÀíϵͳÔÚÆóÒµÖж¼ÊDz»¿É»òȱµÄ,ËüΪÆóÒµµÄ¹ÜÀíÈËÔ±ÌṩÁ˸ü¼Ó±ã½ÝµÄ¹ÜÀí·½Ê½,Ö»Ðèͨ¹ý²Ù×÷¼ÆËã»ú¾Í¿ÉÒÔ¶ÔÔ±¹¤½øÐйÜÀí.ÈùÜÀíÈËÔ±½«¸ü¶àµÄ¾«Á¦·ÅÔÚÆóÒµµÄÔËÓªºÍÊÕÒæÉÏ.
¡¡¡¡Õâ¸öϵͳÖ÷Òª¾ÍÊÇΪÁË·½±ã¹ÜÀíÈËÔ±¶ÔÔ±¹¤µÄ¹ÜÀí,³ý´ËÖ®Í⻹֧³ÖÆÕͨԱ¹¤²é¿´×ÔÒѵÄÏà¹ØÐÅÏ¢¡¢¼Ç¼µÈ.±¾ÏµÍ³ÊµÏÖÁËÔ±¹¤ÐÅÏ¢¹ÜÀí¡¢¿¼ÇÚ¡¢¹¤×ʼÆËã¡¢½±³ÍµÈ¹¦ÄÜ,ͬʱ»¹Ö§³Ö Excel ±í¸ñµÄµ¼Èë¡¢µ¼³öµÈ¹¦ÄÜ.Ìá¸ßÁ˹«Ë¾ÔËÓªµÄЧÂʺ͹«Ë¾µÄ¹ÜÀíˮƽ,¸ø¹«Ë¾´øÀ´ÁËÏÔÖøµÄÐ§Òæ.±¾ÏµÍ³²ÉÓõÄÊÇ PHP ¿ª·¢µÄÈËʹÜÀíϵͳ.¿ª·¢µÄϵͳ»ù±¾ÉÏÍê³ÉÁË¿ª·¢µÄ³õ²½Ä¿±ê,¾ßÓÐÒÔϼ¸¸ö·½ÃæµÄÌØµã:
¡¡¡¡(1)ϵͳµÄÐÔÄÜÎȶ¨,ÔËÐÐÁ¼ºÃ.
¡¡¡¡(2)ͨ¹ý±¾ÏµÍ³,¿ÉÒÔËæÊ±ÕÆ¿ØÔ±¹¤µÄÐÅÏ¢¡¢¿¼ÇÚ¡¢¹¤×ʵÈÇé¿ö.
¡¡¡¡(3)Óû§½çÃæÃÀ¹Û,²Ù×÷¼òµ¥,ʹÓ÷½±ã.
¡¡¡¡±¾ÏµÍ³Íê³Éºó,ʵÏÖÁËÆóÒµµÄÈËʹÜÀí,¾¹ýʹÓ÷¢ÏÖ±¾ÏµÍ³»ù±¾¿ÉÒÔÂú×ãÆóÒµÈËʵÄÈËÔ±¹ÜÀí¡¢¿¼ÇÚ¹ÜÀí¡¢Ð½³ê¹ÜÀí,½ÚÔ¼ÁËÆóÒµ´óÁ¿µÄÈËÁ¦¡¢²ÆÁ¦¡¢ÎïÁ¦×ÊÔ´,Ìá¸ßÁ˹¤×÷ЧÂʼ°¾¼ÃÐ§Òæ.µ«ÊÇÓÉÓÚ±¾È˵ÄÄÜÁ¦ÓÐÏÞ¡¢Ê±¼ä²Ö´Ù,ÔÚÆóÒµµÄÈËʹÜÀíϵͳÉϵķÖÎöºÍÉè¼ÆÉÏÈÔ´æÔÚ×ÅÐí¶àµÄ²»×ãºÍȱÏݵĵط½,ÓдýÓÚ½øÒ»²½µÄ¸Ä½øºÍÍêÉÆ.ÈçÔÚÈÕÀú¿¼ÇÚÕâ¸ö¹¦ÄÜʱ,µã»÷ÈÕÀúÇ©µ½Ê±Ö»Äܵã»÷Ò»´Î,Ç©ÀëÊÇÓÃÒ»¸öÁ´½ÓÀ´ÊµÏÖµÄ,Õâ¸ö¹¦ÄÜ»¹ÓдýÍêÉÆ.
¡¡¡¡ÖÂл
¡¡¡¡×ªÑÛÒѼ´½«±ÏÒµ,ÔÚÕâ´óѧËÄÄêµÄʱ¼äÀï,Îҵõ½ÁËÐí¶àͬѧ¡¢ÀÏʦµÄ°ïÖúºÍ¹Ø»³.ÔÚ´ËÎÒÏë¶ÔÎÒµÄÀÏʦºÍͬѧ±íʾÓÉÖԵĸÐл.
¡¡¡¡Ê×ÏÈ,ÎÒÒª¸ÐлÎÒµÄÂÛÎÄÖ¸µ¼ÀÏʦ××ÀÏʦ.´ÓÂÛÎ͍Ìâµ½ÂÛÎĵ͍¸å,¶¼ÊÇÔÚµ¼Ê¦µÄÖ¸µ¼ÏÂÍê³ÉµÄ.ÔÚÂÛÎĵıàд¹ý³ÌÖÐ,ÀÏʦ¶¼ÊÇÈÏÕæµÄÅúÔÄ,ÑϸñÒªÇó,ÔÚ´Ë»ù´¡ÉÏÌá³öÁËÐí¶àÖпϵÄÐÞ¸ÄÒâ¼û,ʹÎÒÄܹ»Ë³ÀûÍê³ÉÂÛÎĵıàд¹¤×÷.
¡¡¡¡½ÓÏÂÀ´,ÎÒ»¹Òª¸ÐлÎÒµÄÅóÓѺÍͬѧÃÇÔÚÂÛÎıàдºÍϵͳÉè¼ÆÖиøÓèÎÒÖ§³Ö¡¢°ïÖúÒÔ¼°Æô·¢.ÔÚ´ËÎÒ»¹Òª¸ÐлËùÓн̵¼¹ýÎÒµÄÀÏʦÃÇ,¸ÐлÄãÃǵĽ̵¼,ûÓÐÕâЩÄêרҵ֪ʶµÄѧϰ,ÎҾͲ»ÄÜ˳ÀûÍê³É±¾´ÎµÄ±ÏÒµÉè¼Æ.
¡¡¡¡Òò´Ë,ÔÙ´ÎÕæ³ÏµÄ¶Ô¸÷λÀÏʦºÍͬѧÃDZíʾ¸Ðл.
¡¡¡¡²Î¿¼ÎÄÏ×
¡¡¡¡[1]Àîºì.¹ÜÀíÐÅϢϵͳ¿ª·¢ÓëÓ¦ÓÃ[M].±±¾©:µç×Ó¹¤Òµ³ö°æÉç,2003
¡¡¡¡[2]ÖÜÖ®Ó¢.ÏÖ´úÈí¼þ¹¤³Ì[M.±±¾©:¿ÆÑ§³ö°æÉç,2000
¡¡¡¡[3]Ѧ»ª³É.¹ÜÀíÐÅϢϵͳ,µÚ3°æ.±±¾©:Ç廪´óѧ³ö°æÉç,2009Äê9ÔÂ
¡¡¡¡[4]ÑîÎÄÁú,Ò¦ÊçÕä,ÎâÜ¿.Èí¼þ¹¤³Ì.±±¾©:µç×Ó¹¤Òµ³ö°æÉç,2008Äê7ÔÂ
¡¡¡¡[5]³ÂÏòÈÙ.ÓÉdzÈëÉîѧPHP.±±¾©:µç×Ó¹¤Òµ³ö°æÉç,2011
¡¡¡¡[6]¶¡Ô¹â,Ëï¸üÐÂ.PHP+Mysql¶¯Ì¬ÍøÕ¾¿ª·¢.±±¾©:Ç廪´óѧ³ö°æÉç,2008
¡¡¡¡[7]Ö£º£Éú.Áã»ù´¡Ñ§PHP+MySQL[M].±±¾©:»úе¹¤Òµ³ö°æÉç,2004
¡¡¡¡[8]ÐíµÇÍú.PHP³ÌÐò¿ª·¢·¶Àý±¦µä[M].±±¾©:ÖйúÌúµÀ³ö°æÉç,2006
¡¡¡¡[9]´ÞȺ·¨,ÀîÁ¢ÐÂ,ÕÅÇÕ.PHPWeb¿ª·¢Ñ§Ï°ÊµÂ¼[M].±±¾©:Ç廪´óѧ³ö°æÉç,2011
¡¡¡¡[10]¸ßÂå·å.ϸ˵PHP[M].±±¾©:µç×Ó¹¤Òµ³ö°æÉç,2009Äê
¡¡¡¡[11]³Â¾ü,ÕÅÑã.PHP+Mysql¾µä°¸ÀýÆÊÎö.±±¾©:Ç廪´óѧ³ö°æÉç,2008
¡¡¡¡[12]¸ß·åϼ.WEBÊý¾Ý¿â¿ª·¢¼¼Êõ[M].±±¾©:µç×Ó¹¤Òµ³ö°æÉç
¡¡¡¡[13]³ÂÃ÷ÖÒ,Ñî½ÜÓ¿.PHP¶¯Ì¬ÍøÕ¾¿ª·¢°¸Àý½Ì³Ì.±±¾©:Ç廪´óѧ³ö°æÉç,2017
¡¡¡¡[14]´«ÖDz©¿Í.PHP+MySQLÍøÕ¾¿ª·¢ÏîĿʽ½Ì³Ì.±±¾©:ÈËÃñÓʵç³ö°æÉç,2016
¡¡¡¡[15]David SklarÖø,°²µÀÒë.PHPѧϰÊÖ²á.±±¾©:ÖйúµçÁ¦³ö°æÉç,2017