updateadvnewsservlet.java

该系统具体分为2个部分：前台和后台。 1．前台主要用于用户进行浏览和搜索

package ynuServlet;
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import ynuBean.Advice;
import ynuBean.UpdateAdvNewsBean;
import ynuBean.News;

public class UpdateAdvNewsServlet extends HttpServlet {
	public void init()throws ServletException
    {
    	
    }
    
    public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException
    {
    	sendsql(request,response);
    }
    
    public void sendsql(HttpServletRequest request, HttpServletResponse response)
    throws ServletException,IOException
    {  	  
    	HttpSession session = request.getSession();   	
    	String toJsp = "/advice.jsp";
    	UpdateAdvNewsBean aBean = new UpdateAdvNewsBean();
    	String way = request.getParameter("addway");
        	
    	if(way.equals("addadvice"))
    	{
    		String content = request.getParameter("content");
    		String adminname = request.getParameter("adminname");
    		content = new String(content.getBytes("UTF-8"),"UTF-8");
    		//adminname = new String(adminname.getBytes("ISO-8859-1"),"UTF-8");
    		String msg = aBean.addAdvice(content, adminname);
    		session.setAttribute("message1", msg);
    		toJsp="/advice.jsp";
    		
    	}
    	else if(way.equals("addnews"))
    	{
    		String content = request.getParameter("content");
    		String title = request.getParameter("title");
    		String adminname = request.getParameter("adminname");
    		String msg = aBean.addNews(title, content, adminname);
    		session.setAttribute("message2", msg);
    		toJsp="/report.jsp";
    	}
    	else if(way.equals("deletenews"))
    	{
    		String title = request.getParameter("ntitle");
    		String msg = aBean.DeleteNews(title);
    		session.setAttribute("dmsg", msg);
    		toJsp="/report.jsp";
    	}
    	else if(way.equals("editnews"))
    	{
    		String title = request.getParameter("ntitle");
    		String content = request.getParameter("content");
    		session.setAttribute("NewsTitle", title);
    		session.setAttribute("NewsContent", content);
    		//News aNews = request.getParameter("news");
    		
    		toJsp="/report.jsp";
    	}
    	else if(way.equals("deleteadvice"))
    	{
    		int advicenum = Integer.parseInt(request.getParameter("advicenum"));
    		String msg = aBean.DeleteAdvice(advicenum);
    		session.setAttribute("dmsg", msg);
    		toJsp="/advice.jsp";
    	}
    	else if(way.equals("editadvice"))
    	{
    		int advicenum = Integer.parseInt(request.getParameter("advicenum"));
    		Advice aAdvice = aBean.getAdvice(advicenum);
    		session.setAttribute("Advice", aAdvice);
    		//News aNews = request.getParameter("news");
    		
    		toJsp="/advice.jsp";
    	}
    	
    	RequestDispatcher dispatcher = request.getRequestDispatcher(toJsp);	
    	//dispatcher = request.getRequestDispatcher(toJsp);   	
    	response.setHeader("Refresh", "0.1; URL=/PesticideInfoManagement"+toJsp+"");
    	dispatcher.forward(request, response);
    }
    
    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException
    {
        doGet(request, response);
    }
}