|
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestClassForNameNewInstanceApp {
public static void main(String args[]) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
} catch (ClassNotFoundException e) {
System.out.println("Oops! Can't find class oracle.jdbc.driver.OracleDriver");
System.exit(1);
} catch (IllegalAccessException e) {
System.out
.println("Uh Oh! You can't load oracle.jdbc.driver.OracleDriver");
System.exit(2);
} catch (InstantiationException e) {
System.out
.println("Geez! Can't instantiate oracle.jdbc.driver.OracleDriver");
System.exit(3);
}
Connection conn = null;
Statement stmt = null;
ResultSet rset = null;
try {
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@dssw2k01:1521:orcl", "scott", "tiger");
stmt = conn.createStatement();
rset = stmt
.executeQuery("select 'Hello '||USER||'!' result from dual");
while (rset.next())
System.out.println(rset.getString(1));
rset.close();
rset = null;
stmt.close();
stmt = null;
conn.close();
conn = null;
} catch (SQLException e) {
System.out.println("Darn! A SQL error: " + e.getMessage());
} finally {
if (rset != null)
try {
rset.close();
} catch (SQLException ignore) {
}
if (stmt != null)
try {
stmt.close();
} catch (SQLException ignore) {
}
if (conn != null)
try {
conn.close();
} catch (SQLException ignore) {
}
}
}
}
|