{"id":42543,"date":"2024-11-11T03:00:27","date_gmt":"2024-11-11T03:00:27","guid":{"rendered":"https:\/\/atmokpo.com\/w\/?p=42543"},"modified":"2024-11-26T06:35:08","modified_gmt":"2024-11-26T06:35:08","slug":"19-pro-c%ec%99%80-c%ec%9d%84-%ec%9d%b4%ec%9a%a9%ed%95%9c-%ec%8b%a4%ec%8b%9c%ea%b0%84-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%aa%a8%eb%8b%88%ed%84%b0%eb%a7%81-%ec%8b%9c%ec%8a%a4%ed%85%9c-%ea%b5%ac%ec%b6%95","status":"publish","type":"post","link":"https:\/\/atmokpo.com\/w\/42543\/","title":{"rendered":"19.Pro C\uc640 C#\uc744 \uc774\uc6a9\ud55c \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c \uad6c\ucd95, \ub0b4\uc6a9 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \uc2a4\ud2b8\ub9ac\ubc0d, C#\uc758 WPF WinForms\ub97c \uc774\uc6a9\ud55c \uc2dc\uac01\ud654, SignalR \ud65c\uc6a9."},"content":{"rendered":"

<\/p>\n

1. \uc11c\ub860<\/h2>\n

\ucd5c\uadfc \uae30\uc5c5 \ud658\uacbd\uc5d0\uc11c\ub294 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ucc98\ub9ac\uac00 \uc911\uc694\ud574\uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c\uc740 \ub370\uc774\ud130\ub97c \ube60\ub974\uac8c \uc218\uc9d1\ud558\uace0 \uc774\ub97c \uc2dc\uac01\uc801\uc73c\ub85c \ud45c\ud604\ud568\uc73c\ub85c\uc368 \uc758\uc0ac\uacb0\uc815\uc5d0\uc11c\uc758 \ud6a8\uc728\uc131\uc744 \uc99d\uac00\uc2dc\ud0b5\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 Oracle Pro*C\uc640 C#\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \uc2a4\ud2b8\ub9ac\ubc0d \ubc0f \uc2dc\uac01\ud654 \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n

2. \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \uc2a4\ud2b8\ub9ac\ubc0d<\/h2>\n

\uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \uc2a4\ud2b8\ub9ac\ubc0d\uc740 \ub370\uc774\ud130\ub97c \ubc1c\uc0dd\ud558\ub294 \uc989\uc2dc \ucc98\ub9ac\ud558\uace0 \uc804\ub2ec\ud558\ub294 \uacfc\uc815\uc785\ub2c8\ub2e4. Pro*C\ub294 Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc5f0\ub3d9\uc744 \uc704\ud574 \uc0ac\uc6a9\ub418\uba70, C#\uc740 \ud074\ub77c\uc774\uc5b8\ud2b8 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc73c\ub85c\uc11c \uc774 \uc2a4\ud2b8\ub9ac\ubc0d \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n

2.1 Pro*C\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc5f0\uacb0\ud558\uae30<\/h3>\n

Pro*C\ub294 C\/C++ \uc18c\uc2a4\ucf54\ub4dc \ub0b4\uc5d0\uc11c SQL \uba85\ub839\uc5b4\ub97c \uc791\uc131\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 Oracle\uc758 \ub3c4\uad6c\uc785\ub2c8\ub2e4. Pro*C\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc2e4\uc2dc\uac04\uc73c\ub85c \uc811\uadfc\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

\n        \n        #include <stdio.h>\n        #include <sqlca.h>\n        #include <sqlcpr.h>\n\n        EXEC SQL BEGIN DECLARE SECTION;\n            char username[20] = \"db_user\";\n            char password[20] = \"db_pass\";\n            char sql_query[200];\n        EXEC SQL END DECLARE SECTION;\n\n        int main() {\n            EXEC SQL CONNECT :username IDENTIFIED BY :password;\n\n            if (sqlca.sqlcode < 0) {\n                printf(\"\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0 \uc2e4\ud328: %d\\n\", sqlca.sqlcode);\n                return 1;\n            }\n\n            while(1) {\n                EXEC SQL DECLARE cur CURSOR FOR\n                SELECT data_field FROM real_time_table;\n\n                EXEC SQL OPEN cur;\n                \/\/ \ub370\uc774\ud130 \ucc98\ub9ac \ub85c\uc9c1...\n                EXEC SQL CLOSE cur;\n            }\n\n            EXEC SQL COMMIT;\n            EXEC SQL DISCONNECT;\n            return 0;\n        }\n        <\/code>\n    <\/pre>\n
2.2 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud2b8\ub9ac\uac70\uc640 \ud050<\/h3>\n
Oracle \ud050\ub294 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \uc2a4\ud2b8\ub9ac\ubc0d\uc744 \uac00\ub2a5\ud558\uac8c \ud558\ub294 \uac15\ub825\ud55c \uae30\ub2a5\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud2b8\ub9ac\uac70\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \ubcc0\uacbd \uc2dc \ud2b9\uc815 \ub3d9\uc791\uc744 \uc218\ud589\ud558\uac8c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\n        \n        CREATE OR REPLACE TRIGGER my_trigger\n        AFTER INSERT ON real_time_table\n        FOR EACH ROW\n        BEGIN\n            DBMS_AQ.ENQUEUE(\/* parameters *\/);\n        END;\n        <\/code>\n    <\/pre>\n
3. C#\uc758 WPF\/WinForms\ub97c \uc774\uc6a9\ud55c \uc2dc\uac01\ud654<\/h2>\n
C#\uc758 WPF(Windows Presentation Foundation) \ub610\ub294 WinForms\ub97c \uc774\uc6a9\ud558\uc5ec Pro*C\uc5d0\uc11c \uac00\uc838\uc628 \ub370\uc774\ud130\ub97c \uc2dc\uac01\uc801\uc73c\ub85c \ud45c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790 \uc778\ud130\ud398\uc774\uc2a4(UI)\ub97c \uad6c\uc131\ud558\uace0, \uc2e4\uc2dc\uac04\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub418\ub294 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\uc790\uc5d0\uac8c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n
3.1 C# \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc138\ud305<\/h3>\n
Visual Studio\ub97c \uc774\uc6a9\ud558\uc5ec WPF \ud504\ub85c\uc81d\ud2b8\ub97c \uc0dd\uc131\ud558\uace0, \ud544\uc694\ud55c \ub77c\uc774\ube0c\ub7ec\ub9ac\uc640 \ud504\ub808\uc784\uc6cc\ud06c\ub97c \uc124\uc815\ud569\ub2c8\ub2e4. SignalR \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \ud1b5\ud574 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \uc804\uc1a1 \ubc0f \uc218\uc2e0\uc744 \uad6c\ud604\ud569\ub2c8\ub2e4.<\/p>\n
\n        \n        \/\/ MainWindow.xaml.cs\n        using System.Windows;\n        using Microsoft.AspNetCore.SignalR.Client;\n\n        public partial class MainWindow : Window {\n            private HubConnection connection;\n\n            public MainWindow() {\n                InitializeComponent();\n                SetupSignalR();\n            }\n\n            private async void SetupSignalR() {\n                connection = new HubConnectionBuilder()\n                    .WithUrl(\"http:\/\/localhost:5000\/datastream\")\n                    .Build();\n\n                connection.On<string>(\"ReceiveData\", (data) => {\n                    \/\/ UI \uc5c5\ub370\uc774\ud2b8 \ub85c\uc9c1...\n                });\n\n                await connection.StartAsync();\n            }\n        }\n        <\/code>\n    <\/pre>\n
4. SignalR \ud65c\uc6a9<\/h2>\n
SignalR\uc740 \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \uc2e4\uc2dc\uac04 \uae30\ub2a5\uc744 \ucd94\uac00\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac\uc785\ub2c8\ub2e4. \ud074\ub77c\uc774\uc5b8\ud2b8\uc640 \uc11c\ubc84 \uac04\uc758 \uc2e4\uc2dc\uac04 \ud1b5\uc2e0\uc744 \uac00\ub2a5\ud558\uac8c \ud558\uba70, \uc774 \uae00\uc5d0\uc11c\ub294 \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \uc804\uc1a1\uc5d0 SignalR\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \ub2e4\ub8f9\ub2c8\ub2e4.<\/p>\n
4.1 SignalR \uc11c\ubc84 \uad6c\ucd95<\/h3>\n
ASP.NET Core\ub97c \uae30\ubc18\uc73c\ub85c SignalR \uc11c\ubc84\ub97c \uad6c\ucd95\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \uc218\uc2e0\ub420 \ub54c\ub9c8\ub2e4 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uac8c \ub370\uc774\ud130\ub97c \ud478\uc2dc\ud558\ub294 \uad6c\uc870\ub97c \uac16\uc2b5\ub2c8\ub2e4.<\/p>\n
\n        \n        using Microsoft.AspNetCore.SignalR;\n\n        public class DataStreamHub : Hub {\n            public async Task SendData(string data) {\n                await Clients.All.SendAsync(\"ReceiveData\", data);\n            }\n        }\n        <\/code>\n    <\/pre>\n
4.2 \ud074\ub77c\uc774\uc5b8\ud2b8\uc640\uc758 \uc5f0\uacb0<\/h3>\n
\ud074\ub77c\uc774\uc5b8\ud2b8\uac00 SignalR \uc11c\ubc84\uc5d0 \uc5f0\uacb0\ud558\uace0 \ub370\uc774\ud130\ub97c \uc218\uc2e0\ud558\ub294 \ubc29\ubc95\uc740 \uc704\uc5d0\uc11c \uc124\uba85\ud55c C# \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub0b4\uc5d0\uc11c \uad6c\ud604\ub429\ub2c8\ub2e4.<\/p>\n
5. \uacb0\ub860<\/h2>\n
\ubcf8 \uae00\uc5d0\uc11c \uc124\uba85\ud55c \ubc29\ubc95\uc744 \ud1b5\ud574 Pro*C\uc640 C#\uc744 \uacb0\ud569\ud55c \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc2dc\uc2a4\ud15c\uc740 Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \ud6a8\uc728\uc801\uc778 \uc0c1\ud638\uc791\uc6a9, \uc2e0\uc18d\ud55c \ub370\uc774\ud130 \ucc98\ub9ac, \uadf8\ub9ac\uace0 \uc6b0\uc218\ud55c \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc744 \uc81c\uacf5\ud558\ub294 \uc2dc\uac01\ud654 \uae30\ub2a5\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uae30\uc220\uc744 \ud65c\uc6a9\ud558\uc5ec \ub2e4\uc591\ud55c \uc0b0\uc5c5 \ubd84\uc57c\uc5d0\uc11c \uc2e4\uc2dc\uac04 \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ub370\uc774\ud130 \ubd84\uc11d\uc774 \uac00\ub2a5\ud574\uc9c8 \uac83\uc785\ub2c8\ub2e4.<\/p>\n
6. \ucc38\uace0 \uc790\ub8cc<\/h2>\n