<%//調用存儲過程更新記錄
 String procedure_name="update_user_data";//執行的存儲過程名稱
 String call_procedure_string="{call "+procedure_name+"(?,?,?,?,?,?,?)}";//調用存儲過程的語句
 try 
    { Connection con;
      Statement sql;
      ResultSet rs;
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse","sa","6599996");
      CallableStatement callable_statement = con.prepareCall(call_procedure_string);//創建對象
      //設置調用存儲過程的參數
      callable_statement.setString(1,username);
      callable_statement.setString(2,usertruename);
      callable_statement.setInt(3,ageint);
      callable_statement.setString(4,sex);
      callable_statement.setString(5,address);
      callable_statement.setString(6,telephone);
      callable_statement.setLong(7,user_id);
      callable_statement.executeUpdate();
      con.close();
    }
 catch(SQLException e1) 
    {
      /ut.print("SQL異常！");
    }
%>