怪事

对不起，放错了，应该是这段代码，我们能给我看看，第一次出现错误：java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT 字段不正确 
但后退回去以后再搜索时却得出了结果。为什么
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<%
        String type1,keyword;
        type1=request.getParameter("ttt");
keyword=request.getParameter("keyword");
         %>
<html>
<head>
<title>搜索结果</title>
<style>
a{font-size=9pt;}
</style>
</head>
<body style="font-size:9pt;"><%
        int pgsz,page_no,page_count,rs_count;
        
        pgsz=5; 
        String temp=request.getParameter("page_no");
        if(temp==null)        
            page_no=1;
        else
            page_no=Integer.valueOf(temp).intValue();  
       
        String sql,sql1;
        //sql1="select count(*) as count1 from book";
sql="select * from 111 where "+type1+" like '%"+keyword+"%'"; 
    
             try{
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                String url="jdbc:odbc:source";
                Connection con=DriverManager.getConnection(url);
                Statement statement=con.createStatement();
                ResultSet result=statement.executeQuery(sql);
                
                rs_count=0;
                while(result.next()) rs_count++;
                if (rs_count%pgsz==0)
                     page_count=rs_count/pgsz;
                else
                     page_count=rs_count/pgsz+1;
 %>              
<center>
  <font color="red" size="4">共有书目</font><font color="red"> <font size="4">
  <%out.println(rs_count);%>
  </font> <font size="4">本</font></font> 
  <table border="0" cellspacing="0" cellpadding="0" width="434" bgcolor="#FFCC99" align="center">
    <%
     String book_publisher,book_name,book_author;

             result=statement.executeQuery(sql);             for(int i=0;i<(page_no-1)*pgsz;i++) result.next();   
             for(int j=0;j<pgsz;j++)
                if(result.next())
          { 
             book_name=result.getString("书名");
             book_publisher=result.getString("出版社");
             book_author=result.getString("作者");
            
%>
   <tr><td height="93" width="400"> 
      <p><a href="search_link.jsp"><%=book_name%></a></p>
      <p>作者：<%=book_author%> 出版社：<%=book_publisher%> 出版日期：</p>
    </td></tr>
    <%               }
%>
    <tr bgcolor="yellow"> 
      <td colspan="5" align="center"> 
        <%if (page_no>1){%>
        <a href="save.jsp?ttt=<%=type1%>&keyword=<%=keyword%>&page_no=1">[首页]</a>&nbsp; 
        <a href="save.jsp?ttt=<%=type1%>&keyword=<%=keyword%>&page_no=<%=page_no-1%>">[上一页]</a>&nbsp; 
        <%}for (int i=1;i<=page_count;i++){%>
        <%if (page_no!=i){%>
        <a href="save.jsp?ttt=<%=type1%>&keyword=<%=keyword%>&page_no=<%=i%>"><%=i%></a>&nbsp; 
        <%}else{%>
        <%=i%>&nbsp; 
        <%}}if (page_no<page_count){%>
        <a href="save.jsp?ttt=<%=type1%>&keyword=<%=keyword%>&page_no=<%=page_count%>">[尾页]</a>&nbsp; 
        <a href="save.jsp?ttt=<%=type1%>&keyword=<%=keyword%>&page_no=<%=page_no+1%>">[下一页]</a>&nbsp; 
        <%}%>
      </td>
    </tr>
    <%     
              con.close();
              }catch(Exception e)
           {out.println(e);}
%>
  </table>
</center>
</body>
</html>

解决方案 »

  1.   

    对不起，应该是这段代码，第一次出现错误：java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT 字段不正确 
    但后退回去以后再搜索时却得出了结果。为什么，我头都大了<%@ page import="java.sql.*" %>
    <%@ page contentType="text/html;charset=gb2312"%>
    <%
            String type1,keyword;
            type1=request.getParameter("ttt");
    keyword=request.getParameter("keyword");
             %>
    <html>
    <head>
    <title>搜索结果</title>
    <style>
    a{font-size=9pt;}
    </style>
    </head>
    <body style="font-size:9pt;"><%
            int pgsz,page_no,page_count,rs_count;
            
            pgsz=5; 
            String temp=request.getParameter("page_no");
            if(temp==null)        
                page_no=1;
            else
                page_no=Integer.valueOf(temp).intValue();  
           
            String sql,sql1;
            //sql1="select count(*) as count1 from book";
    sql="select * from 111 where "+type1+" like '%"+keyword+"%'"; 
        
                 try{
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    String url="jdbc:odbc:source";
                    Connection con=DriverManager.getConnection(url);
                    Statement statement=con.createStatement();
                    ResultSet result=statement.executeQuery(sql);
                    
                    rs_count=0;
                    while(result.next()) rs_count++;
                    if (rs_count%pgsz==0)
                         page_count=rs_count/pgsz;
                    else
                         page_count=rs_count/pgsz+1;
     %>              
    <center>
      <font color="red" size="4">共有书目</font><font color="red"> <font size="4">
      <%out.println(rs_count);%>
      </font> <font size="4">本</font></font> 
      <table border="0" cellspacing="0" cellpadding="0" width="434" bgcolor="#FFCC99" align="center">
        <%
         String book_publisher,book_name,book_author;

                 result=statement.executeQuery(sql);             for(int i=0;i<(page_no-1)*pgsz;i++) result.next();   
                 for(int j=0;j<pgsz;j++)
                    if(result.next())
              { 
                 book_name=result.getString("书名");
                 book_publisher=result.getString("出版社");
                 book_author=result.getString("作者");
                
    %>
       <tr><td height="93" width="400"> 
          <p><a href="search_link.jsp"><%=book_name%></a></p>
          <p>作者：<%=book_author%> 出版社：<%=book_publisher%> 出版日期：</p>
        </td></tr>
        <%               }
    %>
        <tr bgcolor="yellow"> 
          <td colspan="5" align="center"> 
            <%if (page_no>1){%>
            <a href="save.jsp?ttt=<%=type1%>&keyword=<%=keyword%>&page_no=1">[首页]</a>&nbsp; 
            <a href="save.jsp?ttt=<%=type1%>&keyword=<%=keyword%>&page_no=<%=page_no-1%>">[上一页]</a>&nbsp; 
            <%}for (int i=1;i<=page_count;i++){%>
            <%if (page_no!=i){%>
            <a href="save.jsp?ttt=<%=type1%>&keyword=<%=keyword%>&page_no=<%=i%>"><%=i%></a>&nbsp; 
            <%}else{%>
            <%=i%>&nbsp; 
            <%}}if (page_no<page_count){%>
            <a href="save.jsp?ttt=<%=type1%>&keyword=<%=keyword%>&page_no=<%=page_count%>">[尾页]</a>&nbsp; 
            <a href="save.jsp?ttt=<%=type1%>&keyword=<%=keyword%>&page_no=<%=page_no+1%>">[下一页]</a>&nbsp; 
            <%}%>
          </td>
        </tr>
        <%     
                  con.close();
                  }catch(Exception e)
               {out.println(e);}
    %>
      </table>
    </center>
    </body>
    </html>