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();
}
}