procedemo2.java

在 java中调用 sqlserver存储过程

import java.sql.*;
public class ProceDemo2
{
	public static void main(String [] args)
    {
    	try {
    		DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
			Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Demo","sa","ok");
    		CallableStatement cstmt = con.prepareCall("{call getsum(?,?)}");
    		cstmt.setInt(1,100);
    		//注册存储过程的第二个参数
    		cstmt.registerOutParameter(2,java.sql.Types.INTEGER);
    		cstmt.execute();//执行存储过程
    		//得到存储过程的输出参数值
    		System.out.println (cstmt.getInt(2));
    		con.close();
	    }
	    catch (SQLException ex) {
	    	ex.printStackTrace();
	    }
    	
    }
}