求代码（马上揭贴）--java类调用存储过程的代码

Question

如题，急需帮忙
谢谢个位

Answer 1

callableStatement=con.prepareCall(sql);

Answer 2

public class TestDB {
public static void main(String[] args) {
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test";
String userName = "sa";
String userPwd = "";
Connection dbConn;try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);String call = "{call Test_Query}";
CallableStatement cs = dbConn.prepareCall(call);
ResultSet rs = cs.executeQuery();
while (rs.next()) {
.....
}
catch (Exception e) {
e.printStackTrace();
}
}
}

Answer 3

用google搜索吧，就用你自己的标题就行，学会用网络资源。

Answer 4

存储过程里有一个IN项是userid，一个输出项是ncount（数目）
哪位大侠能够给个例子？
急，谢谢

Answer 5

CREATE OR REPLACE procedure procGetTaskCount(userId IN varchar2 ,nCount OUT number ) isbegin
  nCount:=0;
  select count(*) into nCount from
    (select a.id from bpm_taskinstance a where a.actorid=userid and a.isopen=1
    union
    select a.id from bpm_taskinstance a,bpm_taskinstance_auth b
       where a.ID=b.taskinstance and  a.isopen=1 and b.toid=userid);
exception
  when others then
    nCount:=0;
end procGetTaskCount;这个是存储过程

Answer 6

CallableStatement proc = null;          proc = con.prepareCall("{ call procGetTaskCount(?, ?) }");         proc.setInt(1, userId);           proc.setInt(2, 0);           ResultSet rs = proc.executeQuery(); 

Answer 7

再帮我看下代码
晕了
String count = "0";
                Connection conn = null;
                ResultSet rs = null;
                try{
                        conn = getConnection();
                        System.out.println("begin cs..");
CallableStatement cs = conn.prepareCall("{call PROCGETTASKCOUNT(?,?)}");
cs.setString(1, userid);
cs.setInt(2,0);
System.out.println("prepare cs..");
//cs.execute();
//System.out.println("execute cs..");
                        //rs = (ResultSet) cs.getObject(1);
                        rs = cs.executeQuery();
                        while(rs.next()){
                         System.out.println("got cs..");
                         count = (String)rs.getObject(1);
                        }
                }catch(SQLException sqle){
                        System.err.println("JDBCAction.updateUser() 获取数据库SQL异常！");
                        throw sqle;
                }catch(Exception e){
                        System.err.println("JDBCAction.updateUser() 获取数据库未知L异常！");
                        throw e;
                }finally{
                        if(null != conn){
                                try{
                                        conn.close();
                                }catch(Exception e){
                                }
                        }
                        conn = null;
                }
                return count;
        }
非常感谢啊

Answer 8

搞顶拉！！！！
呵呵
kevinliuu(@_@) 
给你80分