JSP 新闻发布会

---恢复内容开始---

首先 新闻发布会结合了JSP里的Servlet和request对象，response对象还有使用session对象和cookie对象跟踪用户信息等等。。。。。

 

 

列表

 

登陆

这是在Servlet里面写的 LoginServlet 登陆方法

private ServletRequest session;
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        
                try {
                    BaseDao dd=new BaseDao();
                    String uname=request.getParameter("uname");
                    String upwd=request.getParameter("upwd");
                            String sql="select * from user where userName=? and userPwd=?";
                            Object [] prams={uname,upwd};
                                      ResultSet flag=dd.executeSelect(sql, prams);
                    if(flag.next())
                    {
                        HttpSession session=request.getSession();
                        session.setAttribute("unamesession", uname);
                        Cookie cookie=new Cookie("unamesession",uname);
                        cookie.setMaxAge(60*60*24);
                        response.addCookie(cookie);
                        //out.print("<script type='text/javascript'>"+"alert('成功登陆!')");
                        request.getRequestDispatcher("/newspages/admin.jsp").forward(request, response);
                    }
                    else
                    { 
                        response.sendRedirect("/index.jsp");
                    }
                } catch (SQLException e) {
                    e.printStackTrace();
                }
    }

这是在jsp主页面上写的跳转

  <form action="LoginServlet"  method="doPost">
      <label> 登录名 </label>
      <input type="text" name="uname" value="" class="login_input" />
      <label> 密&#160;&#160;码 </label>
      <input type="password" name="upwd" value="" class="login_input" />
      <input type="submit" class="login_sub" value="登录" />
      <label id="error"> </label>
      <img src="images/friend_logo.gif" alt="Google" id="friend_logo" />
    </form>

登陆完跳转

接下来是  添加

 

这是在impl包里的NewsDaoimpl.java获取所有返回的方法

 

    //添加
    public boolean Add(News news) {
        String sql="INSERT INTO news ( ntid ,ntitle ,nauthor ,ncreatedate ,npicpath ,ncontent ,nmodifydate ,nsummary ) VALUES (?,?,?,?,?,?,?,?)";
        Object [] prams={news.getNtid(),news.getNtitle(),news.getNauthor(),news.getNcreatedate(),news.getNpicpath(),news.getNcontent(),news.getNmodifydate(),news.getNsummary()};
        boolean flag=executeUpdate(sql,prams);
        closeAll();
        return flag;
    }

 

这个是添加的Servlet类

public class AddServlet extends HttpServlet {
    public AddServlet() {
        super();
    }
    public void destroy() {
        super.destroy(); 
        
    }
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            doPost(request,response);
    }
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
                if(request.getMethod().equals("GET"))
                {
                    request.getRequestDispatcher("newspages/news_add.jsp").forward(request, response);
                }
                else
                {
                    String path=request.getContextPath();
                    String Basepath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+"/";
                    request.setCharacterEncoding("UTF-8");
                    response.setContentType("text/html;charset=UTF-8");
                    HttpSession session=request.getSession();
                    boolean flag=false;
                    try {
                        List<News> list=(List<News>) FormUtil.assembleObjectList(request, News.class);
                        News news= list.get(0);
                        
                        news.setNtid(request.getParameter("ntid"));
                        news.setNtitle(request.getParameter("ntitle"));
                        news.setNauthor(request.getParameter("nauthor"));
                        news.setNcreatedate(request.getParameter("nsummaryTime"));
                        news.setNpicpath(request.getParameter("file"));
                        news.setNcontent(request.getParameter("ncontent"));
                        NewsDaoimpl dao=new NewsDaoimpl();
                        flag=dao.Add(news);
                    } catch (NoSuchFieldException e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                    } catch (Exception e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                    }
                    if(flag)
                    {
                        response.sendRedirect(path+"/newspages/admin.jsp");
                    }
                    else
                    {
                        request.getRequestDispatcher("/index.jsp").forward(request, response);
                    }
                }
    }

}

 

接下来这个是添加的jsp

 <form action="<%=request.getContextPath()%>/AddServlet" method="post">
      <p>
        <label> 主题 </label>
        <select name="ntid">
        <%--
        <c:forEach var="item" items="${typelist} }">
        <option value="1">
        
            ${item.ntname}
       
        </option>
         </c:forEach>
        --%>
        
        
          <option value="1">选择</option>
          <option value='1'> 国内 </option>
          <option value='2'> 国际 </option>
          <option value='3'> 军事 </option>
          <option value='4'> 体育 </option>
          <option value='5'> 娱乐 </option>
          <option value='6'> 社会 </option>
          <option value='7'> 财经 </option>
          <option value='8'> 科技 </option>
          <option value='9'> 健康 </option>
          <option value='10'> 汽车 </option>
          <option value='11'> 教育 </option>
          <option value='12'> 房产 </option>
          <option value='13'> 家居 </option>
          <option value='14'> 旅游 </option>
          <option value='15'> 文化 </option>
          <option value='16'> 其他 </option>
          </select>
      </p>
      <p>
        <label> 标题 </label>
        <input name="ntitle" type="text" class="opt_input" />
      </p>
      <p>
        <label> 作者 </label>
        <input name="nauthor" type="text" class="opt_input" />
      </p>
      <p>
        <label> 时间 </label>
        <%--<textarea name="nsummary" cols="40" rows="3"></textarea>--%>
        <input id="meeting" type="date" value="2015-11-10" name="nsummaryTime"/>
      </p>
      <p>
        <label> 内容 </label>
        <textarea name="ncontent" cols="70" rows="10"></textarea>
      </p>
      <p>
        <label> 上传图片 </label>
        
        <input name="file" type="file" class="opt_input" />
      </p>
      <input name="action" type="hidden" value="addnews"/>
      <input type="submit" value="提交" class="opt_sub" action="NewsAddServlet" method="doPost" />
      <input type="reset" value="重置" class="opt_sub" />
    </form>

 

添加主题

 

这是在impl包里的NewsDaoimpl.java获取所有返回的方法

//添加主题
        @Override
        public boolean Addtype(Type type) {
                String sql="INSERT INTO TYPE(ntname) VALUES(?)";
                Object [] prams={type.getNtname()};
                boolean flag=executeUpdate(sql, prams);
                closeAll();
            return flag;
        }

这是添加主题的Servlet类

public class TypezhuAddServlet extends HttpServlet {

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request,response);
    }


    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            if(request.getMethod().equals("GET"))
            {
                request.getRequestDispatcher("newspages/news_add.jsp").forward(request, response);
            }
            else
            {
                String path=request.getContextPath();
                request.setCharacterEncoding("UTF-8");
                boolean flag=false;
                try {
                    List<Type> list=(List<Type>) FormUtil.assembleObjectList(request, Type.class);
                    Type type=list.get(0);
                    type.setNtname(request.getParameter("ntname"));
                    NewsDaoimpl dao=new NewsDaoimpl();
                    flag=dao.Addtype(type);
                } catch (NoSuchFieldException e) {
                    e.printStackTrace();
                } catch (Exception e) {
                    e.printStackTrace();
                }
                if(flag)
                {
                    response.sendRedirect(path+"/newspages/admin.jsp");
                }
                else
                {
                    request.getRequestDispatcher("/index.jsp").forward(request, response);
                }
            }
    }

}

添加主题的jsp

 <div id="opt_area">
    <h1 id="opt_type"> 添加主题： </h1>
    <form action="<%=request.getContextPath()%>/TypezhuAddServlet" method="post" onsubmit="return check()">
     
      <p>
        <label> 主题名称 </label>
        <input name="ntname" type="text" class="opt_input" id="tname"/>
      </p>
      <input name="action" type="hidden" value="addtopic"/>
      <input type="submit" value="提交" class="opt_sub" />
      <input type="reset" value="重置" class="opt_sub" />
    </form>
  </div>
</div>

 

动态加载新闻主题和新闻分页

这是在impl包里的NewsDaoimpl.java获取所有返回的方法

    //分页查询
    public List<News> selectNews() {
        QueryRunner query=new QueryRunner();
        
            String sql="SELECT * FROM news WHERE nid LIMIT 3";
            List<News> list=null;
             try {
                list = query.query(getConnection(), sql,new BeanListHandler<News>(News.class));
            } catch (SQLException e) {
                e.printStackTrace();
            }
        return list;
    }
    /*
     * 根据新闻类型编号查询新闻
     */
    public List<News> selectNewsByTypeid(int tid) {
        QueryRunner query=new QueryRunner();
        String sql="select * from news where ntid=?";
        List<News> list=null;
        try {
            list = query.query(getConnection(), sql, new BeanListHandler<News>(News.class),tid);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;
    }

这是分页和动态主题的Servlet

public class TypeServlet extends HttpServlet {
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request,response);
    }
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
            NewsDaoimpl dao=new NewsDaoimpl();
            List<Type> list = dao.type();
            request.setAttribute("typelist",list);
            
            String date= request.getParameter("tid");
            if(date!=null && date.equals(""))
            {
                int tid=Integer.parseInt(date);
                NewsDaoimpl newsdao=new NewsDaoimpl();
                List<News> listdao=newsdao.selectNewsByTypeid(tid);
                request.setAttribute("newslist", listdao);
            }
            else
            {
                NewsDaoimpl topdao=new NewsDaoimpl();
                List<News> newslist=topdao.selectNews();
                request.setAttribute("newslist", newslist);
            }
            
            
            request.getRequestDispatcher("/index.jsp").forward(request, response);
    }

}

主页的jsp

<div class="main">
    <div class="class_type"> <img src="images/class_type.gif" alt="新闻中心" /> </div>
    <div class="content">
      <ul class="class_date">
        <li id='class_month'>
        
        <c:forEach var="item" items="${typelist}">
        <a style="color:pink;" href='${pageContext.request.contextPath}/TypeServlet?tid=${item.ntid}'>
        ${item.ntname}
        </a>
        </c:forEach>
        </li>
      </ul>
      <ul class="classlist">
      <c:forEach var="item" items="${newslist}">
          <li><a href='newspages/news_read.jsp'>${item.ntitle }</a><span>${item.ncreatedate }</span></li>
      </c:forEach>
        <p align="right"> 当前页数:[1/2]&nbsp; <a href="#">下一页</a> <a href="#">末页</a> </p>
      </ul>
    </div>

 待续、、