´óѧ¾Æµê¹ÜÀíϵͳѧʿÂÛÎÄ×ÊÁÏ ÏÂÔØ±¾ÎÄ

req.setAttribute(\String targetURL = \dispatch(targetURL, req, res);}

³ÌÐòЧ¹ûͼÈçͼ5-13Ëùʾ¡£

ͼ5-13 ÐÂÎÅÐÅϢ¼Èë

2.ÐÂÎÅÐÅÏ¢¹ÜÀí£º¹ÜÀíÔ±µã»÷×ó²àµÄ²Ëµ¥¡°ÐÂÎÅÐÅÏ¢¹ÜÀí¡±£¬Ò³ÃæÌø×ªµ½ÐÂÎÅÐÅÏ¢¹ÜÀí½çÃæ£¬µ÷Óúǫ́µÄactionÀà²éѯ³öËùÓеĹ«¸æÐÅÏ¢£¬²¢°ÑÕâЩÐÅÏ¢·âתµ½Êý¾Ý¼¯ºÏnewsListÖУ¬°ó¶¨µ½request¶ÔÏó£¬È»ºóÒ³ÃæÌø×ªµ½ÏàÓ¦µÄJSP£¬ÏÔʾ³ö¹«¸æÐÅÏ¢¡£¹Ø¼ü´úÂëÈçÏ¡£

public void newsMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException{ List newsList=new ArrayList(); String sql=\Object[] params={}; DB mydb=new DB(); try{

mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()){

Tnews news=new Tnews(); news.setId(rs.getString(\news.setTitle(rs.getString(\

news.setContent(rs.getString(\news.setShijian(rs.getString(\newsList.add(news);} rs.close();}

catch(Exception e){ e.printStackTrace();} mydb.closed();

req.setAttribute(\

req.getRequestDispatcher(\

³ÌÐòЧ¹ûͼÈçͼ5-14Ëùʾ¡£

- 38 -

ͼ5-14 ÐÂÎÅÐÅÏ¢¹ÜÀíÒ³Ãæ

5.3.7 ÁôÑÔÐÅÏ¢¹ÜÀí

1.ÁôÑÔÐÅÏ¢¹ÜÀí£º¹ÜÀíÔ±µã»÷×ó²àµÄ²Ëµ¥¡°ÁôÑÔÐÅÏ¢¹ÜÀí¡±£¬Ò³ÃæÌø×ªµ½ÁôÑÔÐÅÏ¢¹ÜÀí½çÃæ£¬µ÷Óúǫ́µÄactionÀà²éѯËùÓÐÁôÑÔÐÅÏ¢¡£³ÌÐòЧ¹ûͼÈçͼ5-15Ëùʾ¡£

ͼ5-15 ÁôÑÔÐÅÏ¢¹ÜÀí

2.ÁôÑÔÐÅϢɾ³ý£ºÏÈÊǵã»÷ÁôÑÔÐÅÏ¢¹ÜÀí£¬Ò³ÃæÌø×ªµ½ÁôÑÔÐÅÏ¢¹ÜÀí½çÃæ£¬ä¯ÀÀËùÓеÄÁôÑÔÐÅÏ¢£¬µã»÷Ҫɾ³ýµÄÁôÑÔÐÅÏ¢£¬¼´¿Éɾ³ý¸ÃÁôÑÔÐÅÏ¢¡£¹Ø¼ü´úÂëÈçÏ¡£

public void liuyanDel(HttpServletRequest req,HttpServletResponse res){ String id=req.getParameter(\

String sql=\Object[] params={id}; DB mydb=new DB();

mydb.doPstm(sql, params); mydb.closed();

req.setAttribute(\²Ù×÷³É¹¦\

req.setAttribute(\String targetURL = \dispatch(targetURL, req, res);}

5.3.8 Ð޸ĸöÈËÃÜÂë

ÃèÊö£ºÊäÈëÓû§ÃûºÍÓû§µÄÔ­ÓÐÃÜÂ룬ÊäÈëÐÂÃÜÂëÒÔºóµã»÷Ð޸İ´Å¥

- 39 -

¼´¿ÉÐÞ¸ÄÃÜÂë³É¹¦¡£³ÌÐòЧ¹ûͼÈçͼ5-16Ëùʾ¡£

ͼ5-16 ÐÞ¸ÄÃÜÂë

5.4 ÍøÕ¾Ç°Ì¨Ä£¿é

5.4.1 ÍøÕ¾Ê×Ò³½çÃæ

ÃèÊö£º¾Æµê¹ÜÀíÏµÍ³ÍøÊ×Ò³·ÖΪ²Ëµ¥µ¼º½À¸Óë×îпͷ¿»òÕß²ËÆ·ÐÅÏ¢Á½²¿·Ö×é³É¡£¹Ø¼ü´úÂëÈçÏ¡£

public void caipinAll(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException{ List caipinList=new ArrayList();

String sql=\Object[] params={}; DB mydb=new DB(); try{

mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()){

Tcaipin caipin=new Tcaipin(); caipin.setId(rs.getString(\

caipin.setCaipinjianjie(rs.getString(\caipin.setCaipinming(rs.getString(\caipin.setCaipinjiage(rs.getInt(\caipin.setDel(rs.getString(\

caipin.setTupian(rs.getString(\caipinList.add(caipin);} rs.close();}

catch(Exception e){ e.printStackTrace();} mydb.closed();

req.setAttribute(\

req.getRequestDispatcher(\

³ÌÐòЧ¹ûͼÈçͼ5-17Ëùʾ¡£

- 40 -

ͼ5-17 ÍøÕ¾Ê×Ò³

5.4.2 Óû§×¢²á

ÃèÊö£ºÐÂÓû§Í¨¹ý¸ÃÄ£¿éʵÏÖÍøÕ¾×¢²á¹¦ÄܵÄʵÏÖ£¬×¢²áΪ»áÔ±¡£³ÌÐòЧ¹ûͼÈçͼ5-18Ëùʾ¡£

ͼ5-18 Óû§×¢²á½çÃæ

5.4.3 ²é¿´¿Í·¿ÐÅÏ¢

ÃèÊö£ºµã»÷¿Í·¿Í¼Æ¬£¬´ò¿ª¿Í·¿ÏêϸÐÅÏ¢²é¿´½çÃæ¡£¹Ø¼ü´úÂëÈçÏ¡£ public void kefangDetailQian(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException{

req.setAttribute(\req.getRequestDispatcher(\res);}

³ÌÐòЧ¹ûͼÈçͼ5-19Ëùʾ¡£

- 41 -