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 -