高手帮忙-急等

druide 2003-09-12 09:58:47

<%@ page contentType="text/html;charset=GBK"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="songjun.connSql1" />
<%
request.setCharacterEncoding("GBK");
%>

<%!
ResultSet rs=null;
String sql1="";
int PageSize=10;
int Page=5;
int totalPage=1;
String str="";
public String ShowOnePage(ResultSet rs,int Page,int PageSize){
str="";
try{
rs.absolute((Page-1)*PageSize+1);
}catch(SQLException e){}
for (int iPage=1;iPage<=PageSize;iPage++){
str+=RsToGbook(rs);
try{
if(!rs.next()) break;
}catch(Exception e){}
}
return str;
}
public String RsToGbook(ResultSet rs){
String tt="";
try{
tt+="<tr align='center'>";
tt+="<td>"+rs.getInt("id")+"</td>";
tt+="<td>"+rs.getString("datecome")+"</td>";
tt+="<td>"+rs.getString("department")+"</td>";
tt+="<td>"+rs.getString("number")+"</td>";
tt+="<td><a href=more.jsp?id="+rs.getInt("id")+">"+rs.getString("title")+"</a></td>";
tt+="</tr>";
}catch(Exception e){}
return tt;
}
%>
<%!
public String getSql(String tempStr,String tempStr1){
if(tempStr==null)
{
System.out.println("字段非法");
return null;
}
if(tempStr1==null)
{
System.out.println("条件值非法");
return null;
}
String sql="";
if(tempStr.equals("id"))
sql="select id,datecome,department,number,title from mytable where id like '%"+tempStr1+"%'";
else if(tempStr.equals("datecome"))
sql="select id,datecome,department,number,title from mytable where datecome like '%"+tempStr1+"%'";
else if(tempStr.equals("department"))
sql="select id,datecome,department,number,title from mytable where department like '%"+tempStr1+"%'";
else if(tempStr.equals("number"))
sql="select id,datecome,department,number,title from mytable where number like '%"+tempStr1+"%'";
else if(tempStr.equals("title"))
sql="select id,datecome,department,number,title from mytable where title like '%"+tempStr1+"%'";
else if(tempStr.equals("note"))
sql="select id,datecome,department,number,title from mytable where note like '%"+tempStr1+"%'";
else if(tempStr.equals("status"))
sql="select id,datecome,department,number,title from mytable where status like '%"+tempStr1+"%'";
else if(tempStr.equals("additional"))
sql="select id,datecome,department,number,title from mytable where additional like '%"+tempStr1+"%'";
return sql;
}
%>
<%
String str1=request.getParameter("myselect");
String str2=request.getParameter("text1");
sql1=getSql(str1,str2);
System.out.println("sql="+sql1);
int totalrecord=0;
try{
rs=conn.executeQuery(sql1);
rs.last();
totalrecord=rs.getRow();
System.out.println("totalrecord="+totalrecord);
rs.beforeFirst();
}catch(Exception e) {}
%>
<html>
<body>
<center>
<h2>您的查询结果如下：</h2>
<br/>
<table border="1" width="85%">
<tr align="center">
<td>
编号:
</td>
<td>
日期:
</td>
<td>
来文单位:
</td>
<td>
来文编号:
</td>
<td>
标题:
</td>
</tr>
<%
if(totalrecord%PageSize==0) totalPage=totalrecord/PageSize;
else totalPage=(int)Math.floor(totalrecord/PageSize)+1;
if(totalPage==0) totalPage=1;
try{
if(request.getParameter("Page")==null || request.getParameter("Page").equals(""))
Page=1;
else
Page=Integer.parseInt(request.getParameter("Page"));
}catch(java.lang.NumberFormatException e){Page=1;}
if(Page<1) Page=1;
if(Page>totalPage) Page=totalPage;
out.println(ShowOnePage(rs,Page,PageSize));
%>
</table>
</center>
<center>
<form Action="myselect1.jsp" method="GET">
<%
for(int j=1;j<=totalPage;j++){
out.println("<a href=myselect1.jsp?Page="+j+"&myselect="+str1+"&text1="+str2+">"+j+"</a>");
}
rs.close();
%>
</form>
</center>
</body>
</html>

输出的标题栏无内容也无连接！

...全文