searchnews.java

新闻管理系统实现对新闻添加修改删除外挂了一个用户的注册还有一个外挂的投票

package com.vsked.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class searchNews extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public searchNews() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		if(request.getParameterValues("cb")!=null){
		String s[]=request.getParameterValues("cb");
		String sqls="select * from newst ";			
			for(int i=0;i<s.length;i++){
				System.out.println(s[i]);
				if(s[i].equals("0")){
					if(request.getParameter("name")!=null){
						sqls=sqls+" where newsname like'%"+request.getParameter("name")+"%'";	
					}else{
						sqls=sqls+" where newsname like'%%'";
					}
					if(s[i+1].equals("1")){
						if(request.getParameter("authors")!=null){
							sqls=sqls+" and authors like'%"+request.getParameter("authors")+"%'";
						}else{
							sqls=sqls+" and autors like'%'";
						}
						
					}
					if(s[i+2].equals("2")){
						if(request.getParameter("newsbody")!=null){
							sqls=sqls+" and newsbody like'%"+request.getParameter("newsbody")+"%'";
						}else{
							sqls=sqls+" and newsbody like'%'";
						}
					}
					if(s[i+3].equals("3")){
						if(request.getParameter("newsdate")!=null){
							sqls=sqls+" and newsdate like'%"+request.getParameter("newsdate")+"%'";
						}else{
							sqls=sqls+" and newsdate like'%%'";
						}
						
					}
					if(s[i].equals("4")){
						if(request.getParameter("typename")!=null){
							sqls=sqls+" and typeid="+request.getParameter("typename");										
						}
					}
					
				}
			System.out.println("语句是:"+sqls);
		  }
		}else{			
			response.sendRedirect("newsList.jsp");
		}	
		
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doGet(request, response);
		
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}