新闻web小酌

首页如上

类图如下：

添加新闻的方法（dao）：

public boolean Add(News news) {
        boolean flag=false;
                Connection con =getConnectionData();
                QueryRunner queryRunner = new QueryRunner();
                String sql="INSERT INTO newscon(newstype,title,author,abstrac ,content,picture) VALUE(?,?,?,?,?,?)";
                Object[] paras={news.getNewstype(),news.getTitle(),news.getAuthor(),news.getAbstrac(),news.getContent(),news.getUrl()};
                int count=0;
                try {
                     count= queryRunner.update(con,sql,paras);
                } catch (SQLException e) {
                    throw new RuntimeException(e.getMessage(),e);
                }
                 closeAll();
                 if(count>0){
                    flag=true; 
                 }
                return flag;
    } 

servlet方法：

public class AddNews 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 {
        request.setCharacterEncoding("utf-8");
        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() + path + "/";
            response.setContentType("text/html;charset=UTF-8");
            request.setCharacterEncoding("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);
                NewsDaoimpl dao=new NewsDaoimpl();
                flag = dao.Add(news);
                
            } catch (NoSuchFieldException e) {
                e.printStackTrace();
            } catch (Exception e) {
                e.printStackTrace();
            }
            if (flag) {
                response.sendRedirect(path);
                
            }else {
                request.getRequestDispatcher("/index.jsp").forward(request,
                        response);
            }
            
        }
    }

}

插入标题：

public class AddTitleServlet 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 {
        request.setCharacterEncoding("utf-8");
        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()
                    + path + "/";
            response.setContentType("text/html;charset=UTF-8");
            request.setCharacterEncoding("UTF-8");
            HttpSession session = request.getSession();
            boolean flag = false;
            try {
                List<Topic> list = (List<Topic>) FormUtil.assembleObjectList(
                        request, Topic.class);
                Topic topic = list.get(0);
                NewsDaoimpl dao = new NewsDaoimpl();
                flag = dao.AddTitle(topic);

            } catch (NoSuchFieldException e) {
                e.printStackTrace();
            } catch (Exception e) {
                e.printStackTrace();
            }
            if (flag) {
                response.sendRedirect(path);

            } else {
                request.getRequestDispatcher("/index.jsp").forward(request,
                        response);
            }
        }
    }

}

标题的动态加载：

index：

<c:forEach var="item" items="${requestScope.Toplist}">
             <a style="color:blue;font-size:16px;" href='${pageContext.request.contextPath }/DoIndexServlet?id=${item.nid}'>
                ${item.newstype}
             </a>
         </c:forEach>
        </li>
      </ul>
      <ul class="classlist">
        <c:forEach var="item" items="${requestScope.newsList }">
           <li><a href='newspages/news_read.jsp'>${item.title }</a>
           <span>  
                   <c:forEach var="item1" items="${TimeList}">
                       ${item1.beginDatetime}
                   </c:forEach>
           </span>
           </li>
        </c:forEach>

impl：

public List<Topic> AllTitle() {
    
        Connection con=getConnectionData();
        String sql="select nid,newstype from type";
        QueryRunner query=new QueryRunner();
        List<Topic> list=null;
        try {
        
            list= query.query(con, sql,new BeanListHandler<Topic>(Topic.class));
        } catch (SQLException e) {
            new RuntimeException(e.getMessage());
            
        }
        return list;
    }