我附上我的存储过程:数据库是MSSql
CREATE PROCEDURE infopagelist
@currentpage int,@keyword varchar(100)
asSET NOCOUNT ON
Declare @p1 int,@rowcount int,@pagesize int,@sqlstr varchar(1000)
set @pagesize=40
set @sqlstr='select id,title from T_info'
if @keyword!='' begin
set @sqlstr=@sqlstr+' where title like ''%'+@keyword+'%'''
end
set @sqlstr=@sqlstr+' order by id desc'exec sp_cursoropen @p1 output,@sqlstr,@scrollopt=1,@ccopt=1
--select ceiling(1.0*@rowcount/@pagesize) as totalpage
set @currentpage=(@currentpage-1)*@pagesize+1
exec sp_cursorfetch @p1,16,@currentpage,@pagesize
exec sp_cursorclose @p1
set nocount off
GO
如何取出记录集呢,我试两天了,也找了相关资料,一直没有成功,请求达大帮忙.
CREATE PROCEDURE infopagelist
@currentpage int,@keyword varchar(100)
asSET NOCOUNT ON
Declare @p1 int,@rowcount int,@pagesize int,@sqlstr varchar(1000)
set @pagesize=40
set @sqlstr='select id,title from T_info'
if @keyword!='' begin
set @sqlstr=@sqlstr+' where title like ''%'+@keyword+'%'''
end
set @sqlstr=@sqlstr+' order by id desc'exec sp_cursoropen @p1 output,@sqlstr,@scrollopt=1,@ccopt=1
--select ceiling(1.0*@rowcount/@pagesize) as totalpage
set @currentpage=(@currentpage-1)*@pagesize+1
exec sp_cursorfetch @p1,16,@currentpage,@pagesize
exec sp_cursorclose @p1
set nocount off
GO
如何取出记录集呢,我试两天了,也找了相关资料,一直没有成功,请求达大帮忙.
解决方案 »
- 新手请教:i is not public in newPackage.Class1; cannot be accessed 谢谢
- 求解:如何在JAVA中实现简单的的公式运算?
- 如何处理JNI中的字符串
- 再谈一个设计理念,献给所有想提高的java程序员!(续第一篇)
- 类中的Static方法讨论!
- ArrayList list = new ArrayList();怎么报错了 。
- 导出的excel文件如何设置复杂表头
- JAVA中如何实现C中的结构体数组的功能?
- 使用java备份oracle数据库之方案讨论(实用篇)
- 为什么HashMap中的内部类HashIterator和KeyIterator默认构造方法都有参数,但是定义时没有声明?
- 关于读取数据库大字段的问题?
- 我在启动tomcat时就出现这两个warn?
(
AS_YHM IN VARCHAR2, --用户名
AS_NSRSBH IN VARCHAR2, --纳税人识别号
AS_LX IN VARCHAR2, --类型
RC_GLJG OUT WEB_WSSB.PKG_TYPES.REF_CURSOR)
is
ac_msg varchar2(30);begin
OPEN RC_GLJG FOR
SELECT ac_msg FROM DUAL; //得到记录集
end P_YJ_YJGL;
Connection conn = null;
try {
Class.forName("org.gjt.mm.mysql.Driver");
try {
conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&
characterEncoding=GBK","root","ntsky");
} catch (SQLException e1) {
e1.printStackTrace();
}
}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
} public void testC() {
Connection conn = getConn();
ResultSet rs = null;
CallableStatement cs = null;
String a = null;
try {
CallableStatement cStmt = conn.prepareCall("{call p_test()}");
cStmt.executeUpdate();
} catch (Exception e) {
System.out.println("hahad" + e.getMessage());
} finally {
try {
conn.close();
} catch (Exception ex) {
System.out.println("ex : " + ex.getMessage());
}
} } public static void main(String[] args) {
new TestConn().testC();
}
}