newsservlet.java

一个由jsp+servlet+MySQL简单的新闻发布系统

package com.news.servlet;

import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.news.bean.News;
import com.news.dao.NewsDao;
import com.news.dao.impl.NewsDaoImpl;

public class NewsServlet extends HttpServlet{

	@Override
	public void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		this.doPost(req, resp);
	}
	@Override
	public void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		
		News news = new News();
		NewsDao nd = new NewsDaoImpl();
		String cmd = req.getParameter("cmd");//请求名称
		String id = req.getParameter("id");//("id");
		String title = req.getParameter("title");
		String pic = req.getParameter("pic");
		String sort = req.getParameter("sort");
		String writer = req.getParameter("writer");
		String dates = req.getParameter("dates");
		String shows = req.getParameter("shows");
		String hits = req.getParameter("hits");//("hits");
		String message = req.getParameter("message");
		if(id!=null){
			news.setId(Integer.valueOf(id));
		}
		news.setTitle(title);
		news.setPic(pic);
		news.setSort(sort);
		news.setWriter(writer);
		news.setDates(dates);
		news.setShows(shows);
		if(hits!=null){
			news.setHits(Integer.valueOf(hits));
		}
		news.setMessage(message);
		if(cmd!=null){ 
			if(cmd.equals("list")){	//显示列表(暂时无分页)
				//System.out.println("news.equals('list')"+"==="+news.equals("list"));
				
				List<News> list = nd.list(new HashMap<String, String>());
				//System.out.println("list"+"==="+list);
				req.setAttribute("list", list);
				req.getRequestDispatcher("newsList.jsp").forward(req,resp);
				//resp.sendRedirect("news?cmd=list");
			}if(cmd.equals("add")){	//添加
				nd.add(news);
				//System.out.println(cmd.equals("add"));
				//System.out.println("nd.add(news)"+"="+nd.add(news));
				//req.getRequestDispatcher("newsList.jsp").forward(req,resp);
				resp.sendRedirect("news?cmd=list");
			}if(cmd.equals("edit")){	//修改
				nd.edit(news);
				//System.out.println("id"+"="+id);
				//System.out.println("cmd.equals('edit')"+"="+cmd.equals("edit"));
				//System.out.println("nd.edit(news)"+"="+nd.edit(news));
				//req.getRequestDispatcher("newsList.jsp").forward(req,resp);
				resp.sendRedirect("news?cmd=loadedit&id=" + id);
			}if(cmd.equals("del")){	//删除
				nd.delete(Integer.valueOf(id));
				//req.getRequestDispatcher("newsList.jsp").forward(req,resp);
				resp.sendRedirect("news?cmd=list");
			}if(cmd.equals("get")){	//获取信息
				nd.get(Integer.valueOf(id));
				//req.getRequestDispatcher("newsList.jsp").forward(req,resp);
				resp.sendRedirect("news?cmd=list&id="+id);
			}
			if(cmd.equals("loadedit")){
				News ne = nd.get(Integer.valueOf(id));
				req.setAttribute("ne", ne);
				req.getRequestDispatcher("newsEdit.jsp").forward(req, resp);
				
			}
			
		}
	}
}