Question

Java程序进行编译的时候。提示找不到符号 类：cachedrowsetimpl。

程序代码如下：
// Java Document
package tom.jiafei;
import java.sql.*;
import com.sun.rowset.*;
public class ShowRecordByPage{
int pageSize=10;
int pageAllCount=0;
int showPage=1;
StringBuffer presentPageResult;
CachedRowSetlmpl rowSet;
String databaseName="";
String tableName="";
String user="";
String password="";
String zd[]=new String[100];
int zdgs=0;
public ShowRecordByPage()
{ Connection con;
Statement sql;
ResultSet rs;
presentPageRusult=new StringBuffer();
try{Class.forName("oracle.jdbc.driver.OracleDriver");}
catch(Exception e){out.print(e);}
}
public void setPageSize(int size)
{ pageSize=size;
zdgs=0;
String url="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.106.129.16)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = jlqbcc)))";
String user="sjcj";
String passwd="sjcj789";
try{
Connection con=DriverManager.getConnection(url,user,passwd);
DatabaseMetaData metadata=con.getMetaData();
ResultSet rs1=metadata.getColumns(null,null,tableName,null);
int k=0;
while(rs1.next()){
zdgs++;
zd[k]=rs1.getString(4);
k++; }

Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery("select dwbm,sjzl,sjl,sum(sjl) from wrs_qbcount_2 t group by dwbm,sjzl,sjl ");
rowSet=new CachedRowSetlmpl();
rowSet.populate(rs);
con.close();
rowSet.last();
int m=rowset.getRow();
int n=pageSize;
pageAllCount=((m%n)==0)?(m/n):(m/n+1);
}
catch (Exception exp){}

}
public int getPageSize(){ return pageSize ; }
public int getPageAllCount(){ return pageAllCount; }
public void setShowPage(int n){ showPage=n; }
public int getShowPage(){ return showPage; }
public StringBuffer GetPresentPageResult(){
if(showPage>pageAllCount)
showPage=1;
if (showPage<+0)
showPage=pageAllCount;
presentPageResult=show(showPage);
return presentPageResult;
}
public StringBuffer show(int page){
StringBuffer str=new StringBuffer();
str.append("<table border=1>");
str.append("<tr>");
for (int i=0;i<zdgs;i++){
str.append("<th>"+zd[i]+"</th>");
}
str.append("</tr>");
try { rowSet.absolute((page-1)*pageSize+1);
for (int i=0;i<=pageSize;i++){
str.append("<tr>");
for (int k=0;k<zdgs;k++){
str.append("<td>"+rowSet.getString(k)+"</td>");
}
str.append("</tr>");
rowSet.next();
}

}
catch(SQLException exp){}
str.append("</table>");
}

}

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励10（财富值+成长值）+提问者悬赏5（财富值+成长值）

Answer 1

楼主，你有使用CachedRowSetlmpl但没见有CachedRowSetlmpl的类的定义