ÁªÏµÎÒÃǵĽçÃæÈçͼ4.6Ëùʾ¡£
ͼ4.6ÐÂÎÅ×ÊÑ¶Ò³Ãæ
4.1.6 ¶©µ¥¹ÜÀí½çÃæ
¶©µ¥¹ÜÀíÖ÷ÒªÓÃÓÚÓû§×Ô¼ºµÇ¼ϵͳºó²é¿´×Ô¼ºµÄ¶©µ¥ÁÐ±í¡£Óû§¿ÉÒÔ½øÐÐɾ³ýºÍ½áËã²Ù×÷
¶©µ¥¹ÜÀíÒ³ÃæÈçͼ4.7Ëùʾ¡£
ͼ4.7¶©µ¥¹ÜÀíÒ³Ãæ
4.2µÇÂ¼Ò³ÃæÉè¼Æ
±¾µç×ÓÉÌÎñÍøÕ¾²ÉÓõÄÊÇJSP¼¼Êõ×÷Ϊǰ¶ËÒ³ÃæÕ¹ÏÖ,ÓÉÓÚÿ¸öÄ£¿éµÄÒ³ÃæÊDz»Ò»ÑùµÄ£¬Òò´ËÔÚÉè¼ÆÒ³ÃæÊ±£¬ÒªºÏÀíµÄ°²ÅÅ£¬¾¡Á¿Ê¹Óû§Äܹ»ºÜ¿ìµÄÊìϤ±¾ÍøÕ¾µÄÖ÷Òª¹¦ÄÜ£¬Í¬Ê±ÐèÒª±£³Ö½çÃæµÄ¼ò½àºÍÒ»ÖÂÐÔ
µÇÂ¼Ò³ÃæÈçͼ4.8Ëùʾ¡£
ͼ4.8ϵͳµÇ½½çÃæ
ÔÚµÇÂ½Ò³ÃæÊäÈëÓû§ÃûºÍÃÜÂëÖ®ºó£¬µã»÷µÇ¼°´Å¥£¬Ìø×ªµ½µÇ½µÄservletÖУ¬¾ÓÉServlet½øÐÐÊý¾Ý´¦Àíºó·¢Ë͵½serviceÒ³ÃæÔÚ¸ÃserviceÖлá¶ÔÓû§Ãû£¬ÃÜÂë½øÐÐÅжϣ¬Èç¹ûÕýÈ·Ìáʾ¡°ok£¡¡±£¬½øÈëµ½¹ÜÀí½çÃæ£¬Èç¹û´íÎóÔòÌáʾ¡°Error!¡±£¬Ò³Ãæµ÷תµ½µÇ½ҳ¡£
¹Ø¼ü´úÂ룺
try
{ }
String name=u.getName(); String password=u.getPassword(); String
sql=\
*
from
admin
where
admin_name='\
and
admin_password=password('\
ResultSet rs=Conn.Select(sql); if(rs.next()) { } else { }
return -1;
String sql2=\admin_sort from admin where admin_name='\and ResultSet rs2=Conn.Select(sql2); if(rs2.next()) { } else { }
return -1;
sort=rs2.getInt(\return sort;
admin_password=password('\
}
catch(Exception e) {
return -1;
4.3ºǫ́¹ÜÀíÔ±Ö÷Ò³Ãæ
ÃèÊö£º¹ÜÀíÔ±Ö÷Ò³Ãæ£º×ó·½Ò³ÃæÕ¹Ê¾Á˹ÜÀíÔ±¿É²Ù×÷µÄ¹¦Äܲ˵¥£¬½øÈëÏà¹ØµÄ¹ÜÀíÒ³Ãæ¿ÉÒÔÁ´½Óµ½×Ӳ˵¥£¬Ã¿¸ö¹ÜÀíÄ£¿éÏÂÃæ¶¼ÓÐÏàÓ¦µÄ×Ӳ˵¥¡£
³ÌÐòÔËÐÐЧ¹ûͼÈçͼ4.9Ëùʾ¡£
ͼ4.9¹ÜÀíÔ±Ö÷Ò³Ãæ
ÔÚÿ¸öjspÒ³Ãæ½«»á¶ÔÓû§½øÐÐÀ¹½Ø²Ù×÷£¬ÕâÑù¿ÉÒÔÌá¸ß°²È«ÐÔ£¬·ÀÖ¹Óû§²»¾¹ýµÇÂ½Ò³Ãæ¶ø½øÈëÈκÎ×Ӳ˵¥Ò³Ã棺
if(session.getAttribute(\{
out.print(\ÇëÏȵǼ£¡');window.open('../index.jsp','_self')\}
4.3.1Óû§¹ÜÀí
Óû§¹ÜÀíÖ÷ÒªÓÃÓÚÕû¸öÍøÕ¾µÄȨÏÞ¹ÜÀí£¬¹ÜÀíÔ±¿ÉÒÔÔÚ´ËÌí¼ÓѧÉúÕË»§ºÍÀÏʦÕË»§¡£¹ÜÀíÔ±ÓµÓйÜÀíËùÓÐÓû§µÄȨÏÞ¡£
1£©Óû§Ìí¼Ó½çÃæÈçͼ4.10Ëùʾ¡£
ͼ4.10 Óû§Ìí¼Ó½çÃæ
public boolean addUser(User u){ }
try { }
catch(Exception e) { }
return false;
String name=u.getName(); String password=u.getPassword(); int sort=u.getSort(); String
sql=\
into
admin(admin_name,admin_password,admin_sort)
values('\
int result=Conn.Insert(sql); if(result==1) else
return false; return true;
2£©Óû§¹ÜÀí½çÃæÈçͼ4.11 Ëùʾ¡£
ͼ4.11 Óû§¹ÜÀí½çÃæ
4.3.2ÎÄÕ¹ÜÀí
1£©ÎÄÕÂÌí¼Ó
ÐÂÎÅ×ÊѶÓÃÓÚÌí¼ÓÍøÕ¾µÄÐÂÎÅ×ÊѶ£¬ÎÄÕÂÌí¼Ó°üÀ¨ÎÄÕµıêÌ⣬ÄÚÈݺÍͼƬµÈµÈ£¬ÎÄÕÂÌí¼ÓÊÇÓɹÜÀíÔ±Óû§½øÐйÜÀíÌí¼ÓµÄ¡£¹ÜÀíÔ±¿ÉÒÔÉèÖÃÎÄÕµÄÔªËØ¼¶±ð¡£ÉèÖÃÎÄÕÂÊÇ·ñÄÜÔÚÊ×Ò³ÏÔʾµÈÑ¡ÏÓÃÓÚ¿ØÖÆÎÄÕµÄǰ̨ÏÔʾλÖá£
ÎÄÕÂÌí¼ÓͼÈçͼ4.12Ëùʾ¡£
ͼ4.12 ÎÄÕÂÐÅϢ¼Èë
2£©ÎÄÕ¹ÜÀí
ÎÄÕ¹ÜÀíÓÃÓڲ鿴ËùÓеÄÎÄÕÂ״̬£¬ÐÞ¸ÄÒÔ¼°É¾³ýÎÄÕ¡£ÎÄÕ¹ÜÀíÖ÷ÒªÓÃÓÚ¹ÜÀíԱʵʱ¿É¼ûÎÄÕÂĿǰµÄ״̬¡£ÎÄÕ¹ÜÀí½çÃæ¶ÁÈ¡ÁËÊý¾Ý¿âÖеÄÈ«²¿ÎÄÕ²¢ÉèÖÃÓзÖҳЧ¹û
ÎÄÕ¹ÜÀíЧ¹ûͼÈçÏÂͼ4.13 Ëùʾ¡£
ͼ4.13 ÎÄÕÂÐÅÏ¢¹ÜÀíÒ³Ãæ
4.3.3ÉÌÆ·¹ÜÀí
1£©ÉÌÆ·Ìí¼Ó
ÉÌÆ·Ìí¼ÓÊÇÉÌÆ·ÉÏ´«µÄÖØÒª»·½Ú£¬ÊÇÍøÕ¾Ç°Ì¨ÏÔʾÉÌÆ·ÐÅÏ¢µÄÖØÒªÀ´Ô´£¬ÉÌÆ·Ìí¼ÓÐèÒª¹ÜÀíԱȨÏÞÏêϸµÄÎÄÕÂÉÌÆ·Ìí¼ÓÉÌÆ·Ìí¼ÓÒ³ÃæÖжÔÉÌÆ·ÔÚǰ̨½çÃæµÄÏÔʾ¿ØÖÆ£¬ÊÇÓÉÉóºË×´