Wednesday, 11 January 2012

The Connection

<%
String strStatus;
String username = "xxxx";
String password = "xxxx";
Connection conn = null;
Statement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String hostname = "172.16.60.13";
int port = 1521;
String sid = "orcl";
String oracleURL = "jdbc:oracle:thin:@"+hostname+":"+port+":"+sid;
conn = DriverManager.getConnection(oracleURL, username, password);
stmt = conn.createStatement();
strStatus = "Database Connected.";
} catch (ClassNotFoundException cnfe) {
strStatus = "Error loading driver: "+cnfe;
}
println(strStatus);
%>

No comments:

Post a Comment