我的存储过程是
create store procedure user(0 as
select * from a group by id,m order by id,m
我是在Java里调用这个存储过程(执行返回行集)
问java代码如何取存储过程返回的行集.
create store procedure user(0 as
select * from a group by id,m order by id,m
我是在Java里调用这个存储过程(执行返回行集)
问java代码如何取存储过程返回的行集.
给个例子你自己去看看吧:http://hi.baidu.com/mylove6084/blog/item/a09a9ff2d1152858342acc53.html
while(rs.haxNext){
bean = new UserBean();
UserBean bean = new UserBean();bean .setId()= rs.getInt(1);
bean.setName()=rs.getString(2);
...
}
return bean;