远程空间里的javabean传值?
在本地测试的好好的.上传到远程空间后运行结果变了.文件是直接上传的.数据库的结构和数据也都是一样的?
代码如下:
/*
* 按分类显示帖子主题
* 分页显示.每页20条记录
*/
package mybean;
import java.sql.*;
import mybean.DBConnSource;
public class OnStyleList {
private String pageid="";//当前要显示的页数.第一次显示时为1,
private int pagesize=20;//每页显示20条记录
private int pagecount=0;
private int showpage=1;//总页数
private String style;
private Statement stmt;
public OnStyleList(){
try{
DBConnSource dbc=new DBConnSource("jdbc/myweb");
stmt=dbc.getStmt();
}catch(Exception e){
System.out.print("不能连接到数据源");
}
}
public void setStyle(String style){
this.style=style;
}
public StringBuffer getBuffer(){
StringBuffer buffer=new StringBuffer();
try{
String strsql="SELECT * FROM adver WHERE style='"+style+"' ORDER BY Id DESC";
ResultSet rs = stmt.executeQuery(strsql);
rs.last();
int lastrow=rs.getRow();
pagecount=(lastrow%pagesize==0)?(lastrow/pagesize):(lastrow/pagesize+1); try{
showpage=Integer.parseInt(pageid);
}catch(Exception e){
showpage=1;
}//把字符型的pageid转换成整型
if(showpage<=1){
showpage=1;
}
if(showpage>=pagecount){
showpage=pagecount;
}
int posion=(showpage-1)*pagesize+1;
if(posion==0){
posion=1;
}
rs.absolute(posion);
if(lastrow == 0){
buffer.append("此分类下暂无记录");
buffer.append("<br/>");
}
for(int i=1;i<=pagesize;i++)
{
String title=rs.getString("title");
buffer.append("<a href='cont.jsp?nid="+rs.getInt("id")+"' target=_blank>"+title+"</a><br/>");
if(!rs.next())
break;
}
rs.close();
stmt.close();
}catch(SQLException e){
System.out.print(e.toString());
}
buffer.append(" 共"+pagecount+"页>>>");
for(int j=1;j<=pagecount;j++){
if(j==showpage){
buffer.append("[");
}
buffer.append("<A href=style.jsp?pageid="+j+">");
buffer.append(""+j);
buffer.append("</A>");
if(j==showpage){
buffer.append("]<br/>");
}
buffer.append(" ");
}
return buffer;
}
}