1. JSP

<%@ page import=java.sql.* %>

Oracle jdbc conn sample

<%
Class.forName(oracle.jdbc.driver.OracleDriver);

String DB_IP =oracle.ID.cafe24.com;
String DB_PORT =1521;
String DB_SID =orcl;
String DB_USERID =아이디;
String DB_USERPW =패스워드;

Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql;

try {
conn = DriverManager.getConnection(jdbc:oracle:thin:@+DB_IP+:+DB_PORT+:+DB_SID+, DB_USERID, DB_USERPW);
stmt = conn.createStatement();
sql = select sysdate from dual;
rs = stmt.executeQuery(sql);
while(rs.next()) {
out.println(rs.getString(sysdate));
}
rs.close();
} catch(SQLException e) {
out.println(e);
e.printStackTrace();
} finally {
try {
if(rs!=null){ try{rs.close();}catch(Exception e){} }
if(stmt!=null){ try{stmt.close();}catch(Exception e){} }
if(conn != null){ try{conn.close();} catch(Exception ex){}}
} catch(Exception e){}
}
%>


2.PHP

<?
echo

PHP Oracle conn test

;
$conn = OCILogon(고객님의아이디, 암호,
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)
(HOST = oracle.ID.cafe24.com)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
);
?>