ProudNet Docs
WebsiteProud ConsoleLanguage
  • ๐ŸŒProudNet ํ”„๋ผ์šฐ๋“œ๋„ท
    • ProudNet ์†Œ๊ฐœ
    • ๋‹ค์šด๋กœ๋“œ ๋ฐ ์„ค์น˜
      • ProudNet ๋ผ์ด์„ผ์Šค ์ธ์ฆ ๋ฐฉ๋ฒ•
      • AMI
    • ํ”„๋กœ์ ํŠธ ์„ค์ •
      • C++
      • C#
      • Mac Xcode
      • Linux
      • Unity3D
        • iOS ๋นŒ๋“œ
      • Unreal Engine 4
      • PIDL ์ปดํŒŒ์ผ๋Ÿฌ ์‹คํ–‰
    • ProudNet ์‚ฌ์šฉํ•˜๊ธฐ
      • ์„œ๋ฒ„์™€ ํด๋ผ์ด์–ธํŠธ
        • ์„œ๋ฒ„ ํ™œ์šฉ๋ฒ•
        • ํด๋ผ์ด์–ธํŠธ ํ™œ์šฉ๋ฒ•
      • RMI
        • RMI ํ™œ์šฉ๋ฒ•
      • PIDL
        • PIDL ํ™œ์šฉ๋ฒ•
      • ์ด๋ฒคํŠธ ํ•ธ๋“ค๋ง
      • ํ†ต์‹  ๋ฉ”์‹œ์ง€
      • P2P ํ†ต์‹ 
        • P2P ํ†ต์‹  ํ™œ์šฉ๋ฒ•
    • ProudNet ํ™œ์šฉํ•˜๊ธฐ
      • ํ™œ์šฉ ๋ฐฉ๋ฒ•
      • ์„ฑ๋Šฅ์„ ์œ„ํ•œ ํŒ
    • ProudNet์—์„œ DB ์‚ฌ์šฉํ•˜๊ธฐ
      • DB Cache System ver.2
        • DB Cache ์ด๋ก  ๋ฐ ์ดํ•ด
        • DB Cache ์„ค์น˜ ๋ฐ ๋„คํŠธ์›Œํฌ ์„ค์ •
        • DB Cache ์„œ๋ฒ„์™€ ํด๋ผ์ด์–ธํŠธ
        • DB Cache ์‚ฌ์šฉ ๋ฐ ํ™œ์šฉ
          • DB Cache ํ™œ์šฉ๋ฒ•
      • ADO API
      • ODBC API
    • ProudNet ์œ ํ‹ธ๋ฆฌํ‹ฐ
  • ProudNet ์ฐธ๊ณ ์ž๋ฃŒ
    • ๊ธฐ์ˆ ๋…ธํŠธ
      • ๋ฉ”์ธ ๋ฃจํ”„์˜ ์ดํ•ด
      • ์„œ๋ฒ„ ๋ฐฉํ™”๋ฒฝ ์„ค์ •
      • ์•”ํ˜ธํ™” ๋ฐ ๋ณตํ˜ธํ™”
      • ์—๋Ÿฌ๋ฐœ์ƒ ์‹œ ๋Œ€์ฒ˜์‚ฌํ•ญ
      • ์—๋Ÿฌ ๋ฉ”์‹œ์ง€ ๋ชฉ๋ก
      • ์บ๋ฆญํ„ฐ ์œ„์น˜ ๋™๊ธฐํ™”
      • ํด๋ผ์ด์–ธํŠธ-์„œ๋ฒ„ ํ†ต์‹ 
      • MiniDump (์˜ค๋ฅ˜๋คํ”„์‹œ์Šคํ…œ)
      • [1.6 ๋ฒ„์ „] ์„œ๋ฒ„ ๊ฐ„ LAN ํ†ต์‹ ๊ธฐ
    • ์šฉ์–ด์ง‘
    • Sample ์˜ˆ์ œ
  • ๐ŸŒํ”„๋ผ์šฐ๋“œ ์„œ๋น„์Šค
    • ์ฝ˜์†” ์ด์šฉ ์•ˆ๋‚ด
    • ProudChat
      • SDK ๋‹ค์šด๋กœ๋“œ
        • C++
        • C#
        • Unity3D
        • Unreal Engine 4
      • ์„œ๋น„์Šค ๊ธฐ๋Šฅ
Powered by GitBook
On this page
  • ๊ฐ์ฒด ์ •์˜
  • DB ์—ฐ๊ฒฐํ•˜๊ธฐ
  • DB ์‚ฌ์šฉํ•˜๊ธฐ
  • - Query ์‚ฌ์šฉํ•˜๊ธฐ
  • - Query prepare ์‚ฌ์šฉํ•˜๊ธฐ
  • - Stored procedure ์‚ฌ์šฉํ•˜๊ธฐ
  • - Recordset์œผ๋กœ ๋ฐ์ดํ„ฐ ์ฝ๊ธฐ

Was this helpful?

  1. ProudNet ํ”„๋ผ์šฐ๋“œ๋„ท
  2. ProudNet์—์„œ DB ์‚ฌ์šฉํ•˜๊ธฐ

ODBC API

PreviousADO APINextProudNet ์œ ํ‹ธ๋ฆฌํ‹ฐ

Last updated 1 year ago

Was this helpful?

์™€ ๋งˆ์ฐฌ๊ฐ€์ง€๋กœ ODBC๋ฅผ ํ™œ์šฉํ•˜์—ฌ DB ์‚ฌ์šฉํ•˜๊ธฐ ๋˜ํ•œ ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค.

์•„๋ž˜ ์„ค๋ช…์€ ๋ฅผ ๊ธฐ๋ฐ˜์œผ๋กœ ์ž‘์„ฑ๋˜์—ˆ์Šต๋‹ˆ๋‹ค.

๊ฐ์ฒด ์ •์˜

// ์—ฐ๊ฒฐ์„ ์„ค์ •ํ•  ๊ฐ์ฒด
Proud::COdbcConnection conn;
// ๋ช…๋ น์„ ์„ค์ •ํ•  ๊ฐ์ฒด
Proud::COdbcCommand cmd;
// ์ฟผ๋ฆฌ ๊ฒฐ๊ณผ๋ฅผ ๋‹ด์„ ๊ฐ์ฒด
Proud::COdbcRecordset record;
// ์ฟผ๋ฆฌ ์—๋Ÿฌ๋ฅผ ๋‹ด์„ ๊ฐ์ฒด๋กœ ์‚ฌ์šฉํ•˜์ง€ ์•Š์•„๋„ ๋ฌด๋ฐฉํ•ฉ๋‹ˆ๋‹ค.
Proud::COdbcWarnings warnings;

DB ์—ฐ๊ฒฐํ•˜๊ธฐ

conn.Open(Proud::String::NewFormat(L"Driver={ODBC Driver 17 for SQL Server};Server=localhost;Trusted_Connection=yes;"), &warnigs);
conn.Open(Proud::String::NewFormat(L"Driver={MySQL ODBC 8.0 Unicode Driver};Server=127.0.0.1;Port=3306;Uid=proud;Pwd=proudnet123;Option=3;"));

DB ์‚ฌ์šฉํ•˜๊ธฐ

- Query ์‚ฌ์šฉํ•˜๊ธฐ

conn.BeginTrans();

// ์‚ฌ์šฉ ์˜ˆ์‹œ 1
conn.Execute(_PNT("CREATE TABLE test(id int primary key, name nvarchar(30))"));

// ์‚ฌ์šฉ ์˜ˆ์‹œ 2
Proud::String query = _PNT("INSERT INTO test(id) VALUES(1)");
result = conn.Execute(query);

conn.CommitTrans();
// ์‚ฌ์šฉ ์˜ˆ์‹œ 1
conn.Execute(_PNT("CREATE TABLE test(id int primary key, name varchar(30))"));

// ์‚ฌ์šฉ ์˜ˆ์‹œ 2
Proud::String query = _PNT("INSERT INTO test(id) VALUES(1)");
result = conn.Execute(query);

- Query prepare ์‚ฌ์šฉํ•˜๊ธฐ

int id;
Proud::String name;

cmd.Prepare(conn, _PNT("INSERT INTO test(id, name) VALUES(?, ?)"));
cmd.AppendInputParameter(&id);
cmd.AppendInputParameter(&name);

id = 5;
name = _PNT("Nettention");
result = cmd.Execute();

- Stored procedure ์‚ฌ์šฉํ•˜๊ธฐ

int ret;
int id;
Proud::String name;

// input parameter๋งŒ ์žˆ์„ ๊ฒฝ์šฐ
cmd.Prepare(conn, _PNT("{call insertTest(?,?)}"));
cmd.AppendInputParameter(&id);
cmd.AppendInputParameter(&name);

id = 8;
name = _PNT("SPTest");
result = cmd.Execute();

// output parameter๊ฐ€ ์กด์žฌํ•  ๊ฒฝ์šฐ
cmd.Prepare(conn, _PNT("{? = call outputTest(?,?)}"));
cmd.AppendOutputParameter(&ret);
cmd.AppendInputParameter(&id);
cmd.AppendOutputParameter(&name);

id = 5;
name.GetBuffer(100);
result = cmd.Execute();
name.ReleaseBuffer();
int id;
Proud::String name;

// input
cmd.Prepare(conn, _PNT("call insertTest(?,?)"));
cmd.AppendInputParameter(&id);
cmd.AppendInputParameter(&name);

id = 8;
name = _PNT("SPTest");
result = cmd.Execute();

// output
cmd.Prepare(conn, _PNT("call outputTest(?,?)"));
cmd.AppendInputParameter(&id);
cmd.AppendOutputParameter(&name);

id = 5;
name.GetBuffer(100);
result = cmd.Execute();
name.ReleaseBuffer();

- Recordset์œผ๋กœ ๋ฐ์ดํ„ฐ ์ฝ๊ธฐ

int id;
Proud::String name;

result = conn.Execute(record, _PNT("SELECT * FROM test"));
while (record.MoveNext())
{
	id = record.GetFieldValue(_PNT("id"));
	name = record.GetFieldValue(_PNT("name"));
	_tprintf_s(_PNT("id = %d, name = %ws\n"), id, name.GetString());
}

Open ํ•จ์ˆ˜์— ํŒŒ๋ผ๋ฏธํ„ฐ๋กœ ๋“ค์–ด๊ฐ€๋Š” ๊ตฌ๋ฌธ์€ ๊ทœ์น™์„ ๋”ฐ๋ฆ…๋‹ˆ๋‹ค.

๐ŸŒ
ADO API
git ์˜ˆ์‹œ ์ฝ”๋“œ
Connection Strings