[예제] Adapter의 SQL Command 확인하기[재직자무료교육/프로그래머교육/구로디지털IT교육,오라클/자바/닷넷/C#/iOS/안드로이드/아이폰교육]

[예제] Adapter의 SQL Command 확인하기[재직자무료교육/프로그래머교육/구로디지털IT교육,오라클/자바/닷넷/C#/iOS/안드로이드/아이폰교육]

using System;
using System.Data;
using System.Data.OleDb;

class Sample
{
        public static void Main()
        {
                string ConStr = ("Provider=MSDAORA;data source=oraclejava;User ID=scott;Password=tiger");
                OleDbConnection Conn = new OleDbConnection(ConStr);

                OleDbDataAdapter thisAdapter = new
                        OleDbDataAdapter("select * from emp", Conn);

                OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);

                Console.WriteLine("SELECT Command :\n{0}\n",
                        thisAdapter.SelectCommand.CommandText);

                OleDbCommand updateCommand = thisBuilder.GetUpdateCommand();
                Console.WriteLine("UPDATE Command :\n{0}\n",
                        updateCommand.CommandText);

                OleDbCommand insertCommand = thisBuilder.GetInsertCommand();
                Console.WriteLine("INSERT Command :\n{0}\n",
                        insertCommand.CommandText);

                OleDbCommand deleteCommand = thisBuilder.GetDeleteCommand();
                Console.WriteLine("DELETE Command :\n{0}",
                        deleteCommand.CommandText);

                Conn.Close();
        }
}


==============================================================

[결과]
SELECT Command :
select * from emp

UPDATE Command :
UPDATE EMP SET EMPNO = ? , ENAME = ? , JOB = ? , MGR = ? , HIREDATE = ? , SAL =
? , COMM = ? , DEPTNO = ? WHERE ( (EMPNO = ?) AND ((? IS NULL AND ENAME IS NULL)
 OR (ENAME = ?)) AND ((? IS NULL AND JOB IS NULL) OR (JOB = ?)) AND ((? IS NULL
AND MGR IS NULL) OR (MGR = ?)) AND ((? IS NULL AND HIREDATE IS NULL) OR (HIREDAT
E = ?)) AND ((? IS NULL AND SAL IS NULL) OR (SAL = ?)) AND ((? IS NULL AND COMM
IS NULL) OR (COMM = ?)) AND ((? IS NULL AND DEPTNO IS NULL) OR (DEPTNO = ?)) )

INSERT Command :
INSERT INTO EMP( EMPNO , ENAME , JOB , MGR , HIREDATE , SAL , COMM , DEPTNO ) VA
LUES ( ? , ? , ? , ? , ? , ? , ? , ? )

DELETE Command :
DELETE FROM  EMP WHERE ( (EMPNO = ?) AND ((? IS NULL AND ENAME IS NULL) OR (ENAM
E = ?)) AND ((? IS NULL AND JOB IS NULL) OR (JOB = ?)) AND ((? IS NULL AND MGR I
S NULL) OR (MGR = ?)) AND ((? IS NULL AND HIREDATE IS NULL) OR (HIREDATE = ?)) A
ND ((? IS NULL AND SAL IS NULL) OR (SAL = ?)) AND ((? IS NULL AND COMM IS NULL)
OR (COMM = ?)) AND ((? IS NULL AND DEPTNO IS NULL) OR (DEPTNO = ?)) )

 

JAVA

ORACLE

iPhone/Android

.NET

표준웹/HTML5

채용/취업무료교육

초보자(재학생)코스

[기업100%환급]Spring ,MyBatis,Hibernate실무과정	총	5일	40시간		01-13
[기업100%환급]자바기초에서 JDBC, Servlet/JSP까지	총	5일	40시간		01-20
자바기초에서JSP,Ajax,jQuery,Spring3.2,MyBatis까지	총	24일	72시간		01-24
Spring3.X, MyBatis, Hibernate실무과정	총	12일	36시간		02-03
Spring3.X, MyBatis, Hibernate실무과정	총	5일	35시간		01-11
JAVA&WEB프레임워크실무과정	총	14일	98시간		01-11