2008-03-25

java调用存储过程

drop procedure testProc
go
create procedure testProc(@in varchar(10),@out int OUTPUT) as
select @out=count(*) from rh.T_BASE_AREA
go
testProc 1,1



package com.etong.util;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Types;
public class T3 {

public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
Class.forName("net.sourceforge.jtds.jdbc.Driver");

// DriverManager.registerDriver(new net.sourceforge.jtds.jdbc.Driver());
String dbUrl = "jdbc:jtds:sqlserver://localhost:1433;Databasename=rhsys";
Connection conn = java.sql.DriverManager.getConnection(dbUrl,"sa","sa");

String sql="{call testProc(?,?)}";
CallableStatement cs=conn.prepareCall(sql);

cs.setString(1,"1039");
cs.registerOutParameter(2,Types.INTEGER);
cs.execute();
System.out.println(cs.getObject(2));
// ResultSet rs = (ResultSet)cs.getObject(2);
// while (rs.next()){
// System.out.println(rs.getObject(1));
// }
cs.close();
conn.close();
}
}
评论
发表评论

您还没有登录，请登录后发表评论

kayo
搜索本博客
我的相册
Ad1461d2-8745-3eba-ab39-18389260fce2-thumb
s1125472579
共 14 张
最近加入圈子
存档
最新评论