[JDBC 예제] OracleDataSource를 사용하여 insert하기.

package query;

import java.sql.*;

import oracle.jdbc.pool.OracleDataSource;

public class Query2 {
 OracleDataSource ds;
 
 public Query2() {
  try {
   ds = new OracleDataSource();
   ds.setURL("jdbc:oracle:thin:@211.234.53.67:1521:orcl");
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } 
 }
 
 private void execute() {
  Connection conn = null;
  Statement stmt = null;
  try {
   conn = ds.getConnection("scott", "tiger");
   stmt = conn.createStatement();
   
 // update, delete, insert -> DML executeUpdate
 
    StringBuffer sql = new StringBuffer();

//   sql.append("INSERT INTO DEPT (DEPTNO, DNAME, LOC)  \n");
//   sql.append("VALUES (99, '모델부', 'KH C반')       \n");

   sql.append("update dept      \n");
   sql.append("set dname='요리부'   \n");
   sql.append("where deptno = 99   \n");
   int result = stmt.executeUpdate(sql.toString());
   System.out.println(result + " 행이 수정되었습니다.");
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   try {
    if(stmt != null) stmt.close();
    if(conn != null) conn.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
 }

 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO 꼭 작성해야됨
  // 이건 꼭 해야하는 부분
  new Query2().execute();
 }

}