如何在java中调用sqlserver的存储过程？

Question

sql = "{call 名(?,?,?,?,?,?)}";

Answer 1

try{
    con = DriverManager.getConnection(url,"huangqiang","tidesoft");
         
            CallableStatement cs = con.prepareCall("{call huangqiang.C_TESTSQL_PROC(?,?,?,?,?)}");
                    cs.setString(1,"1");
                    cs.setString(2,"2");
                    cs.setString(3,"j");
                    cs.setString(4,"3");
                    cs.registerOutParameter(5,Types.VARCHAR);
                    result=cs.executeQuery();
  String sql=cs.getString(5);
  System.out.println("sql::::"+sql); while (result.next()){
String id=result.getString(1);
String fname= result.getString(2);
String lname= result.getString(3);
System.out.println(id+"-----"+fname+"---"+lname);
}
    
   
    cs.close();
    con.close();
}catch(SQLException ex){
System.err.println("SQLException: " + ex.getMessage());