_searchresult__jsp.java

设备管理系统

/*
 * JSP generated by Resin-3.1.0 (built Fri, 22 Dec 2006 07:00:35 PST)
 */

package _jsp._news;
import javax.servlet.*;
import javax.servlet.jsp.*;
import javax.servlet.http.*;
import java.text.*;
import java.util.Date;
import java.util.*;
import java.lang.*;
import java.io.*;
import news.*;
import newscomm.*;

public class _searchresult__jsp extends com.caucho.jsp.JavaPage
{
  private final java.util.HashMap<String,java.lang.reflect.Method> _jsp_functionMap = new java.util.HashMap<String,java.lang.reflect.Method>();
  private boolean _caucho_isDead;

  
  	public final int MaxPerPage = 20;	//\u6bcf\u9875\u4fe1\u606f\u4e2a\u6570
  	public String IMG_SITE;
  	public String IMG_LABLE_F = "<P[space]align=center><IMG[space]SRC=";
  	public String IMG_LABLE_L = "></P><p>";
  	public String strBG1="#FFFFFF";
  	public String strBG2="#FEEC85";
  	public String strbg;
  
  //\u66ff\u6362\u5b57\u7b26\u4e32\u4e2d\u7684\u5b57\u7b26
  	public static String replaceString(String origStr, String oldStr, String newStr) {
         if (origStr == null || origStr.length() == 0 || oldStr == null ||
             oldStr.length() == 0 || newStr == null) {
             return origStr;
         }
         StringBuffer buffer = new StringBuffer();
         // find the oldStr's place in origStr
         while (origStr.indexOf(oldStr) != -1) {
             int index = origStr.indexOf(oldStr);
  		   buffer.append(origStr.substring(0, index));
  		   buffer.append(newStr);
  		   origStr = origStr.substring(index+oldStr.length());
       }
         buffer.append(origStr);
         return buffer.toString();
     }
  // \u5224\u65ad\u662f\u5426\u4e3a\u65b0\u4fe1\u606f
  	boolean isNew(String adate)
  	{
  		Calendar c=Calendar.getInstance();
  		SimpleDateFormat thismonth = new SimpleDateFormat("yyyy-MM-dd");
  		c.add(Calendar.DATE, -3);
  		String slastday=thismonth.format(c.getTime());
  			
  		if(slastday.compareTo(adate) <=0) return true;
  		else return false;
  	}
  
  	public String getName(String Userid)throws Exception
  	{
  	  try{
  		User o_user = new User();
  		o_user.setUserName(Userid);
  		if(o_user.getUser())
  		  {
  			return o_user.getEmpName();
  		  }
  	  }catch(Exception e)
          {System.out.println(e.toString());}
  	  return "";
  	}
  	// \u5224\u65ad\u7528\u6237\u662f\u5426\u5b58\u5728
  	public boolean IsUser(String userid,String passwd)throws Exception
  	{	
  		try{
  			if(userid.length()==0 || passwd.length()==0)
  				return false;
  			else{
  				// \u5b9a\u4e49\u7528\u6237\u5bf9\u8c61\uff0c\u8bbe\u7f6e\u5176\u7528\u6237\u540d\u548c\u5bc6\u7801
  				User o_user = new User();
  				o_user.setUserName(userid);
  				o_user.setUserPwd(passwd);
  				// \u5224\u65ad\u662f\u5426\u5b58\u5728\u6b64\u7528\u6237\u4fe1\u606f\uff0c\u5982\u679c\u5b58\u5728\u6b64\u7528\u6237\u5219\u8fd4\u56detrue
  				if(o_user.getUser())
  				{
  					return true;
  				}
  			}
  		}catch(Exception e){
  			e.printStackTrace();
  		}
  		return false;
  	}
  	// \u5224\u65ad\u7528\u6237\u7c7b\u578b
  	public int getType(String userid)throws Exception
  	{	
  		try{
  			if(userid.length()==0)
  				return 0;
  			else{
  				// \u5b9a\u4e49\u7528\u6237\u5bf9\u8c61\uff0c\u8bbe\u7f6e\u5176\u7528\u6237\u540d\u548c\u5bc6\u7801
  				User o_user = new User();
  				o_user.setUserName(userid);
  				// \u5224\u65ad\u662f\u5426\u5b58\u5728\u6b64\u7528\u6237\u4fe1\u606f\uff0c\u5982\u679c\u5b58\u5728\u6b64\u7528\u6237\u5219\u8fd4\u56detrue
  				if(o_user.getUser())
  					return o_user.getUserType();
  			}
  		}catch(Exception e){
  			e.printStackTrace();
  		}
  		return 0;
  	}
  
  


  
  	String strSQL="",searchcontent1,fanwei,searchfanwei,searchcontent;
  	String sDate,eDate,strSqlPTime,sCateTitle;

  
  public void
  _jspService(javax.servlet.http.HttpServletRequest request,
              javax.servlet.http.HttpServletResponse response)
    throws java.io.IOException, javax.servlet.ServletException
  {
    javax.servlet.http.HttpSession session = request.getSession(true);
    com.caucho.server.webapp.WebApp _jsp_application = _caucho_getApplication();
    javax.servlet.ServletContext application = _jsp_application;
    com.caucho.jsp.PageContextImpl pageContext = com.caucho.jsp.QJspFactory.allocatePageContext(this, _jsp_application, request, response, null, session, 8192, true, false);
    javax.servlet.jsp.JspWriter out = pageContext.getOut();
    final javax.el.ELContext _jsp_env = pageContext.getELContext();
    javax.servlet.ServletConfig config = getServletConfig();
    javax.servlet.Servlet page = this;
    response.setContentType("text/html;charset=gb2312");
    request.setCharacterEncoding("GB2312");
    try {
      out.write(_jsp_string0, 0, _jsp_string0.length);
      
IMG_SITE = "/servlet/news.ReadImage?ImgId=";

      out.write(_jsp_string1, 0, _jsp_string1.length);
      
	sDate = "";
	eDate = "";
	strSqlPTime = "";
	strSQL = "";
try{
	// \u63d0\u53d6\u53d1\u5e03\u65f6\u95f4\u67e5\u8be2\u8303\u56f4
	sDate = request.getParameter("sdate");
	eDate = request.getParameter("edate");
	// \u6839\u636e\u65f6\u95f4\u5b57\u6bb5\u8bbe\u7f6e\u67e5\u8be2\u8bed\u53e5\uff0c\u9700\u8981\u628a\u65f6\u95f4\u5b57\u7b26\u4e32\u8f6c\u6362\u4e3a\u65e5\u671f\u578b
	if(sDate.length()>0 && eDate.length()>0)
	{
		strSqlPTime = " where PostTime>=to_date('" + sDate + "','YYYY-MM-DD')";
		strSqlPTime = strSqlPTime + " and PostTime<=to_date('" + eDate + "','YYYY-MM-DD')";
	}
	else if(sDate.length()>0 && eDate.length()==0)
		strSqlPTime = " where PostTime>=to_date('" + sDate + "','YYYY-MM-DD')";
	else if(sDate.length()==0 && eDate.length()>0)
		strSqlPTime = " where PostTime<=to_date('" + eDate + "','YYYY-MM-DD')";
	// \u53d6\u5f97\u67e5\u8be2\u5173\u952e\u5219
	searchcontent1 = request.getParameter("searchcontent");
	fanwei = request.getParameter("fanwei");
	if(fanwei.equals("all"))
		searchcontent = searchcontent1;
	else
		searchcontent = "%" + searchcontent1 + "%";
	// \u53d6\u5f97\u67e5\u8be2\u5b57\u6bb5\u503c
	searchfanwei = request.getParameter("D1");
	if(searchfanwei.equals("title"))
	{
		out.println("<h4><font color=#7966C6>\u6309 \u4fe1\u606f\u6807\u9898 \u67e5\u8be2\u7684\u7ed3\u679c</font></h4><br>");
		strSQL = " title like'"+searchcontent+"' order by posttime desc";
	}
	else if(searchfanwei.equals("content"))
	{
		// \u4fe1\u606f\u5185\u5bb9\u4e3aClob\uff0c\u5bf9Lob\u7684\u67e5\u8be2\u4f7f\u7528Oracle\u7684\u5305dbms_lob\u63d0\u4f9b\u7684\u51fd\u6570instr()
		out.println("<h4><font color=#7966C6>\u6309 \u4fe1\u606f\u5185\u5bb9 \u67e5\u8be2\u7684\u7ed3\u679c</font></h4><br>");
		strSQL = " dbms_lob.instr(News.Content,'"+searchcontent1+"',1,1)>0 order by posttime desc";
	}
	if(strSqlPTime.length()==0)
		strSQL = " where " + strSQL;
	else
		strSQL = strSqlPTime + " and " + strSQL;
//	out.println("sql :"+strSQL);
	// \u5b9a\u4e49\u6570\u7ec4\u5bf9\u8c61\u63a5\u53d7\u67e5\u8be2\u7684\u8bb0\u5f55\u4fe1\u606f
	ArrayList schList = new ArrayList();
	// \u5b9a\u4e49\u5b57\u7b26\u4e32\u6570\u7ec4
	String sNews[] = new String[7];
	News o_News = new News();
	schList = o_News.getSearchResult(strSQL);
	if(schList.size()==0)
		out.println("<b>\u65e0</b>");
	else
	{
		out.println("<table width='100%'>");
		out.println("<tr>");
		out.println("<td align=middle width='10%'><b>\u5e8f\u53f7</b></td>");
		out.println("<td align=left width='30%'><b>\u4fe1\u606f\u6807\u9898</b></td>");
		out.println("<td align=middle width='14%'><b>\u6240\u5c5e\u7c7b\u522b</b></td>");
		out.println("<td align=middle width='10%'><b>\u5185\u5bb9\u957f\u5ea6</b></td>");
		out.println("<td align=middle width='16%'><b>\u63d0\u4ea4\u4eba</b></td>");
		out.println("<td align=middle width='20%'><b>\u63d0\u4ea4\u65f6\u95f4</b></td>");
		out.println("</tr>");
		int a=1;
		for(int j=0;j<schList.size();j++)
		{
			sNews = (String[])schList.get(j);
			if(a%2==1)
				out.println("<tr bgColor=Lavender style='COLOR:Purple;'>");
			else
				out.println("<tr bgColor=LightSteelBlue style='COLOR:Purple;'>");

			out.println("<td align=middle>"+(j+1)+"</td>");
			out.println("<td><a href='ShowNews.jsp?id="+sNews[0]+"' onClick='return newwin(this.href);'>"+sNews[4]+"</a>");
			// \u5224\u65ad\u662f\u5426\u6709\u56fe\u7247
			if (sNews[3].equals("1"))
				out.println("(\u9644\u56fe)");
			out.println("</td>");
			// \u53d6\u5f97\u4fe1\u606f\u5206\u7c7b\u540d\u79f0
			Categories o_Cate = new Categories();
			o_Cate.setCateId(Integer.parseInt(sNews[1]));
			if(o_Cate.getCategory())
				sCateTitle = o_Cate.getCateTitle();
			out.println("<td align=middle>"+sCateTitle+"</td>");
			int nlength;
			// \u8ba1\u7b97\u5185\u5bb9\u5927\u5c0f
			if(sNews[5].equals("--"))
				nlength=0;
			else
				nlength = sNews[5].length();
			// \u8f93\u51fa\u5185\u5bb9\u5927\u5c0f\u3001\u63d0\u4ea4\u4eba\u59d3\u540d
			out.println("<td align=middle>"+nlength+"&nbsp;Bytes</td>");
			out.println("<td align=middle>"+getName(sNews[6])+"</td>");
			out.println("<td align=middle>"+sNews[7]+"</td>");
			out.println("</tr>");
			a=a+1;
		}
	}
	out.println("</table>");
}catch(Exception e)
{throw new Exception(e.getMessage());}

      out.write(_jsp_string2, 0, _jsp_string2.length);
    } catch (java.lang.Throwable _jsp_e) {
      pageContext.handlePageException(_jsp_e);
    } finally {
      com.caucho.jsp.QJspFactory.freePageContext(pageContext);
    }
  }

  private java.util.ArrayList _caucho_depends = new java.util.ArrayList();

  public java.util.ArrayList _caucho_getDependList()
  {
    return _caucho_depends;
  }

  public void _caucho_addDepend(com.caucho.vfs.PersistentDependency depend)
  {
    super._caucho_addDepend(depend);
    com.caucho.jsp.JavaPage.addDepend(_caucho_depends, depend);
  }

  public boolean _caucho_isModified()
  {
    if (_caucho_isDead)
      return true;
    if (com.caucho.server.util.CauchoSystem.getVersionId() != 5022137076587403036L)
      return true;
    for (int i = _caucho_depends.size() - 1; i >= 0; i--) {
      com.caucho.vfs.Dependency depend;
      depend = (com.caucho.vfs.Dependency) _caucho_depends.get(i);
      if (depend.isModified())
        return true;
    }
    return false;
  }

  public long _caucho_lastModified()
  {
    return 0;
  }

  public java.util.HashMap<String,java.lang.reflect.Method> _caucho_getFunctionMap()
  {
    return _jsp_functionMap;
  }

  public void init(ServletConfig config)
    throws ServletException
  {
    super.init(config);
    com.caucho.server.webapp.WebApp webApp
      = (com.caucho.server.webapp.WebApp) config.getServletContext();
    com.caucho.jsp.TaglibManager manager = webApp.getJspApplicationContext().getTaglibManager();
  }

  public void destroy()
  {
      _caucho_isDead = true;
      super.destroy();
  }

  public void init(com.caucho.vfs.Path appDir)
    throws javax.servlet.ServletException
  {
    com.caucho.vfs.Path resinHome = com.caucho.server.util.CauchoSystem.getResinHome();
    com.caucho.vfs.MergePath mergePath = new com.caucho.vfs.MergePath();
    mergePath.addMergePath(appDir);
    mergePath.addMergePath(resinHome);
    com.caucho.loader.DynamicClassLoader loader;
    loader = (com.caucho.loader.DynamicClassLoader) getClass().getClassLoader();
    String resourcePath = loader.getResourcePathSpecificFirst();
    mergePath.addClassPath(resourcePath);
    com.caucho.vfs.Depend depend;
    depend = new com.caucho.vfs.Depend(appDir.lookup("news/searchResult.jsp"), 912574348154600802L, false);
    com.caucho.jsp.JavaPage.addDepend(_caucho_depends, depend);
    depend = new com.caucho.vfs.Depend(appDir.lookup("news/admin/NewsComm.jsp"), 7147789067385854643L, false);
    com.caucho.jsp.JavaPage.addDepend(_caucho_depends, depend);
  }

  private final static char []_jsp_string2;
  private final static char []_jsp_string0;
  private final static char []_jsp_string1;
  static {
    _jsp_string2 = "\r\n</center>\r\n<p align=\"center\">\r\n<input type=\"button\" value=\" \u8fd4 \u56de \" LANGUAGE =javascript onclick=\"history.back();\">\r\n</p>\r\n</body></html>".toCharArray();
    _jsp_string0 = "    \r\n\r\n\r\n".toCharArray();
    _jsp_string1 = "\r\n\r\n\r\n<html><head>\r\n<link rel=\"stylesheet\" href=\"style.css\">\r\n<script LANGUAGE=\"javascript\">\r\n// \u6253\u5f00\u65b0\u7a97\u53e3\r\nfunction newwin(url) {\r\nvar newwin=window.open(url,\"newwin\",\"toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=650,height=550\");\r\nnewwin.focus();\r\nreturn false;\r\n}\r\n</script>\r\n</head>\r\n<body vlink=\"#1155AA\" bgcolor=\"#FFFFFF\"><center>\r\n".toCharArray();
  }
}