즐거운 개발

● tomcat server.xml
--------------------------------------------------------------------
<Context path="/neouser" docBase="neouser"
debug="5" reloadable="false" crossContext="true">
<Resource name="jdbc/SampleDS" auth="Container" type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/SampleDS">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>

<parameter>
<name>username</name>
<value>sample</value>
</parameter>
<parameter>
<name>password</name>
<value>samplepwd</value>
</parameter>

<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>

<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/sample</value>

● ConnectionManager.java
--------------------------------------------------------------------
import java.sql.Connection;
import java.sql.SQLException;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class ConnectionManager {
    protected static final Log logger = LogFactory.getLog(ConnectionManager.class);

    public static Connection getConnection() {
        try {
            Context ctx = new InitialContext();
            // Tomcat Server에서 DataSource를 Lookup
            DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/sampleDS");

            return ds.getConnection();
         } catch (NamingException e) {
              if (logger.isErrorEnabled()) {
                 logger.error(e.getMessage(), e);
             }
             throw new DBNotConnectedException(e.getMessage(), e);
         } catch (SQLException e) {
              if (logger.isErrorEnabled()) {
                 logger.error(e.getMessage(), e);
             }
             throw new DBNotConnectedException(e.getMessage(), e);
         }
     }
}

package test.jdbc;

import java.sql.*;

public class DriverTest {
    public static void main(String args[]){
    //데이터베이스 접속 연결 정보를 가지고 있는 객체입니다.
    Connection con;

    try{
        //JDBC드라이버를 로딩합니다.
        Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

        //데이터베이스에 연결을 합니다. Oracle Server IP:Port:SID 계정명 패스워드
        con=DriverManager.getConnection   ("jdbc:oracle:thin:@127.0.0.1:1521:ora9","neouser","neouser");

        System.out.println("데이터 베이스 접속이 성공했습니다.");
    }catch(SQLException ex){
        System.out.println("SQLException:"+ex);
    }catch(Exception ex){
       System.out.println("Exception:"+ex.toString());
    }
  }
}