在利用PL/SQL存储过读取数据在JSP上打印出错
过程包如下:
create or replace package pagination_package as
type guestbook_cursor_type is ref cursor;
end pagination_package;
//***************************************************************************//
//****************************************************************************//
create or replace procedure emp_page
(
tableName in varchar2, --表名
page_size in number, --每页显示记录数
pageNow in number, --当前页
myrows out number, -- 总记录数
myPageCount out number, --总页数
my_cursor out pagination_package.guestbook_cursor_type --返回的结果集
)
is
v_sql varchar2(1000);
v_begin number := (pageNow-1)*page_size+1;
v_end number := pageNow*page_size;
begin
v_sql:='select * from (select e.*,rownum rn from (select * from '||tableName||')e where rownum<='||v_end||')where rn>='||v_begin;
open my_cursor for v_sql;
v_sql:='select count(*) from '||tableName;
execute immediate v_sql into myrows;
if mod(myrows,page_size)=0 then myPageCount:= myrows/page_size;
else myPageCount:= myrows/page_size+1;
end if;
end;
//***************************************************************************//
//****************************************************************************//
jsp代码如下:
<%Connection conn=null;
ResultSet rs=null;
CallableStatement cs=null;
try{
Class.forName("oracle.jdbc.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
cs=conn.prepareCall("{call emp_page(?,?,?,?,?,?)}");
// 表名
cs.setString(1,"scott.emp");
//每页显示记录条数
cs.setInt(2,5);
//String page_Ye=request.getParameter("page_ye");
//显示第几页的记录
//cs.setInt(3,Integer.parseInt(page_Ye));
cs.setInt(3,1);
//总记录数
cs.registerOutParameter(4,oracle.jdbc.OracleTypes.NUMBER);
//总页数
cs.registerOutParameter(5,oracle.jdbc.OracleTypes.NUMBER);
//游标
cs.registerOutParameter(6,oracle.jdbc.OracleTypes.CURSOR);
cs.execute();
int recordNum=cs.getInt(4);
int pageNum=cs.getInt(5);
out.println(recordNum);
out.println(pageNum);
rs = (ResultSet)cs.getObject(6);
out.println(recordNum);
out.println(pageNum);
while(rs.next()){
out.print("<tr>");
out.print("<td>"+rs.getInt(1)+"</td><td>"+rs.getString(2)+"</td>");
out.print("</tr>");
}
for(int i=1;i<=pageNum;i++)
{
out.print("<a href=Proicedure.jsp?page_ye="+i+">["+i+"]</a>");
}
}catch(Exception e){
e.printStackTrace();
}
finally{
try{
//rs.close();
conn.close();
cs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block e.printStackTrace();
}
}
%>
ResultSet数据集报错;
Multiple annotations found at this line:
- Line breakpoint:ProicedureTest.jsp
[line: 68]
- Debug Current Instruction Pointer
在console无输出
直接跳转到这里rs = (ResultSet)cs.getObject(6);
------解决方案--------------------
[line: 68]:这行是哪行?
是rs = (ResultSet)cs.getObject(6);这行么?