Jsp怎么调用sql server 2000的存储过程

Question

使用CallableStatement
如：
CallableStatement cs=con.prepareCall("{call 你的存储过程(?)}");
cs.setString(1,"你的参数");
ResultSet rs=cs.executeQuery();

Answer 1

public String executeProc(String s)
    {
        rs = null;
        String s2 = "{call PROC_AUTOID(?,?)}";
        String s1;
        try
        {
            if(conn != null)
                conn.close();
            conn = DriverManager.getConnection(sConnStr, UseName, PassWord);
            CallableStatement callablestatement = conn.prepareCall(s2);
            callablestatement.setString(1, s);
            callablestatement.registerOutParameter(2, 1);
            rs = callablestatement.executeQuery();
            rs.next();
            String s3 = rs.getString(1);
            s1 = callablestatement.getString(2);
            rs.close();
            callablestatement.close();
            conn.close();
            conn = null;
        }
        catch(Exception exception)
        {
            return null;
        }
        return s1;
    }