notesearchaction.java

java web开发宝典源代码

package com.yxq.myaction;

import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.yxq.bean.Change;
import com.yxq.bean.DBO;


public class NoteSearchAction implements MyAction {

	public void runOne(HttpServlet servlet,HttpServletRequest request,HttpServletResponse response) {
		HttpSession session=request.getSession();
		String condition="";
		String searchType=request.getParameter("searchType");
		if(searchType==null)
			searchType="";
		if(searchType.equals("searchC")){
			String subsql=request.getParameter("subsql");
			if(subsql.equals("all")){
				condition="select * from tb_note order by sender_time desc";
			}
			else{
				String sqlvalue=Change.EncodingChange(request.getParameter("sqlvalue"));
				condition="select * from tb_note where "+subsql+" like '%"+sqlvalue+"%' order by sender_time desc";
			}
			session.setAttribute("linkcondition", condition);
		}		
		else if(searchType.equals("searchA")){
			condition="select * from tb_note order by sender_time desc";
			session.setAttribute("linkcondition", condition);
		}
		if(searchType.equals("link"))			
			condition=(String)session.getAttribute("linkcondition");
	
		int currentP=1;
		String strCP=request.getParameter("showpage");
		if(strCP==null||strCP.equals(""))
			strCP="1";
		try{
			currentP=Integer.parseInt(strCP);
		}catch(Exception e){
			currentP=1;
		}
		
		DBO db=new DBO();
		List currentlist=db.getCurrentList(currentP,condition);
		session.setAttribute("currentlist",currentlist);
		session.setAttribute("pageinfo",db.getCreatepage().PrintPageInfo());
		session.setAttribute("pagelink",db.getCreatepage().PrintPageLink("module/note/noteSearchAction?&searchType=link"));
		
		RequestDispatcher rd=request.getRequestDispatcher("/view/default.jsp");
		try {
			rd.forward(request,response);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}