求大神帮忙

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<html>
 <head>
 <title>测试商品搜索</title>
 </head>
 <body>
 <%@include file="convert.jsp"%>
 <%
 Connection conn=null;
 ResultSet rsAll=null;
 Statement stmt=null;
 try
 {
 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
 String strConn="jdbc:sqlserver://localhost:1433;DatabaseName=ShopSystem";
 String strUser="sa";
 String strPassword="sa";
 conn=DriverManager.getConnection(strConn,strUser,strPassword);
 stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
 String strItem=request.getParameter("item");
 String strContent=Bytes(request.getParameter("co"));
 String strSql="";
 if(strItem==null||strItem=="")
 {
 strSql="select p_id,p_type,p_name,p_price,p_quantity,p_time from product";
 }
 else
 {
 strSql="select p_id,p_type,p_name,p_price,p_quantity,p_time from product where "+strItem.trim()+"LIKE'%"+strContent.trim()+"%'";
 }
 rsAll=stmt.executeQuery("strSql");
 }
 catch(Exception e){e.printStackTrace();}
 %>
 <table width=80% border=1 cellspacing=0 align=center>
 <tr>
 <td>商品编号</td>
 <td>商品类别</td>
 <td>商品名称</td>
 <td>商品价格</td>
 <td>商品数量</td>
 <td>上架日期</td>
 </tr>
 <%
 String str=(String)request.getParameter("page");
 if(str==null)
 {
 str="0";
 }
 int pagesize=10;
 rsAll.last();
 int recordCount=rsAll.getRow();
 int maxPage=0;
 maxPage=(recordCount%pagesize==0)?(recordCount/pagesize):(recordCount/pagesize+1);
 int currentPage=Integer.parseInt(str);
 if(currentPage<1)
 {
 currentPage=1;
 }
 else
 {
 if(currentPage>maxPage){currentPage=maxPage;}
 }
 rsAll.absolute((currentPage-1)*pagesize+1);
 for(int i=1;i<pagesize;i++)
 {
 %>
 <tr>
 <td><%= rsAll.getString("p_id") %></td>
 <td><%= rsAll.getString("p_type") %></td>
 <td><%= rsAll.getString("p_name") %></td>
 <td><%= rsAll.getString("p_price") %></td>
 <td><%= rsAll.getString("p_quantity") %></td>
 <td><%= rsAll.getString("p_time") %></td>
 <td><a href="#">详情</a></td>
 <td><a href="#">购买</a></td>
 </tr>
 <%
 try
 {
 if(!rsAll.next())
 {
 break;}
 }
 catch(Exception e){}
 }
 %>
 </table>
 跳转到：<input type=text name=page size=3>当前页数：【<%= currentPage%>/<%=maxPage%>】 ;
 <%
 if(currentPage>1)
 {
 %>
 <a href="search_result.jsp?page=1">第一页</a>
 <a href="search_result.jsp?page=<%=currentPage-1 %>">上一页</a>
 <%
 }
 if(currentPage<maxPage)
 {
 %>
 <a href="search_result.jsp?page=<%=currentPage+1%>">下一页</a>
 <a href="search_result.jsp?page=<%=maxPage %>"></a>
 <%
 }
 rsAll.close();
 stmt.close();
 conn.close();
 %>
 
 </body>
</html>
数据库在下面网址里
http://pan.baidu.com/share/link?shareid=145847&uk=2551188755

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

告诉你"LIKE'%"like前后缺少空格。
不对啊，错误提示如下：
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /shiyong/search_result.jsp at line 5249:         str="0";
50:       }
51:       int pagesize=10;
52:       rsAll.last();
53:       int recordCount=rsAll.getRow();
54:       int maxPage=0;
55:        maxPage=(recordCount%pagesize==0)?(recordCount/pagesize):(recordCount/pagesize+1);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.lang.NullPointerException
org.apache.jsp.shiyong.search_005fresult_jsp._jspService(search_005fresult_jsp.java:128)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.
--------------------------------------------------------------------------------Apache Tomcat/6.0.29
rsAll 为null你的代码段：
rsAll=stmt.executeQuery("strSql");
修改成：
rsAll=stmt.executeQuery(strSql);
我下载了你的数据库文件，然后调试了一下，
发现你的sql语句拼接错了，你可以在Console打印下sql,然后到数据库执行下，就知道了。
还是不对，就是找不到错误啊，你们身边有myeclipse的话就调试一下吧，数据库下面那网址里有，跪求答案啊