/**************調用存儲過程****************/
?public static void main(String[] args) {
??try {
???Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
??} catch (ClassNotFoundException e) {
???// TODO Auto-generated catch block
???e.printStackTrace();
??}
??Connection conn = null;
??CallableStatement callStm = null;
??try {
???conn = DriverManager.getConnection(
?????"jdbc:sqlserver://localhost:1434;databaseName=StuDB", "sa",
?????"sasa");
???//創建執行存儲過程命令對象
???callStm = conn.prepareCall("{call proc_getStudentNameByNum(?,?)}");//(?,?)表示存儲過程的參數
???callStm.setInt("stuNum", 123906);//給輸入參數賦值
???callStm.registerOutParameter("stuName", java.sql.Types.NVARCHAR);//設置輸出參數
???callStm.executeUpdate();//執行存儲過程
???String result = callStm.getString("stuName");//獲取輸出參數的值
???System.out.println(result);
??} catch (SQLException e) {
???// TODO Auto-generated catch block
???e.printStackTrace();
??}finally{
???try {
????callStm.close();
????conn.close();
???} catch (SQLException e) {
????// TODO Auto-generated catch block
????e.printStackTrace();
???}
??}
?}

調用存儲過程