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 ํจ์์ ํ๋ผ๋ฏธํฐ๋ก ๋ค์ด๊ฐ๋ ๊ตฌ๋ฌธ์ ๊ท์น์ ๋ฐ๋ฆ ๋๋ค.