jdbc hello world
I am in a java mood today, let’s check how to print hello world with jdbc ![]()
import java.sql.*;
public class HelloWorld {
public static void main(String[] args) throws SQLException {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
ResultSet res = DriverManager.
getConnection("jdbc:oracle:thin:@srv1:1521:DB01", "scott", "tiger").
prepareCall("select 'Hello World' txt from dual").
executeQuery();
res.next();
System.out.println(res.getString("TXT"));
}
}
let’s compile
javac -classpath $ORACLE_HOME/jdbc/lib/classes12.jar HelloWorld.java
and run
$ java -classpath $ORACLE_HOME/jdbc/lib/classes12.jar:. HelloWorld
Hello World
that’s all folks!
Tags: Class Helloworld, Getconnection, Getstring, Hello World, Import Java, Java Classpath, Jdbc Oracle, Lib, Main String, Nbsp Nbsp Nbsp Nbsp Nbsp, Oracle, ORACLE BLOGS, Oracle Home, Oracle Jdbc, Quot Quot, Resultset, Run Java, Srv1, String Args, Tiger