Register the driver you want:
static{
Create a connection object:
Now just open the connection:
static{
// register Oracle JDBC driver with DriverManager Class.forName("oracle.jdbc.driver.OracleDriver");}
Create a connection object:
//Create a method, in which we will create connection
public void createConnection(){
Connection conn=null;
Now just open the connection:
try{ // get a connection to the database conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:XE", "scott", "tiger"); // construct a Statement Statement stmt = conn.createStatement(); // run query ResultSet rs = stmt.executeQuery("SELECT 'Hello World' FROM DUAL;"); // iterate through the result set while (rs.next()) { System.out.println(rs.getString(1)); } } catch(Exception ex){//deal with exception}
}//end method
No comments:
Post a Comment