小问题,高手赐教---在线等 取 id title 用这个语法试试<%=new String(sqlRst.getString("classid").getBytes("ISO-8859-1"),"GBK")%> 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 如果没有rs.next();请加入。如果没有id或title数据库字段,请加入,并注意拼写是否真却如果以上都正确,那就没办法了祝你好运! 最好先定义一个tt再叫tt 去执行 += <%@ 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>输出的标题栏无内容也无连接! 谁有struts2开发经验请帮个忙呗? 各位神仙,帮帮忙啊,数据库链接问题!!!!! 请大家帮忙,tomcat5占用内存一直增加,最后内存溢出,分不够另加! select ? ajax能够返回正确的xml,却无误读取 请大家给个好点 JSP好点的上传组件 输入框中的换行,在JSP中怎么读出来啊? 请教:有类似vb中的split的方法吗? 关于用尽的ResultSet 续问 Java建网站用什么框架呢? 关于JSP中的端口问题 JSP简单问题,在线等待
如果没有id或title数据库字段,请加入,并注意拼写是否真却
如果以上都正确,那就没办法了祝你好运!
再叫tt 去执行 +=
<%@ 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>输出的标题栏无内容也无连接!