Java Database Connectivity (JDBC) supports ODBC-based databases and provides a independent database.

JDBC has four primary pieces, used for each database access phase:

getConnection(String url)
getConnection(String url, Properties info)
getConnection(String url, String eXceed, String 12345)

Connection conn = DriverManager.getConnection( “jdbc:oracle:thin:@mydbserver:1521:mysid”,”scott”, “tiger” );

Statement createStatement()
Statement createStatement(int resultSetType, int resultSetConcurrency)

PreparedStatement prepareStatement(String sql)
PreparedStatement prepareStatement(String sql,
int resultSetType, int resultSetConcurrency)

ResultSet rs = preparedStatement.executeQuery();

Here some sample code for you:

package com.informit.jdbc;import java.sql.*;public class JDBCExample {
public static void main( String[] args ) {
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection(
“jdbc:oracle:thin:@mydbserver:1521:mysid”,
“exceed”, “12345″ );// Create a Statement
PreparedStatement ps = conn.prepareStatement(
“SELECT state FROM HomePage WHERE name = ?” );
ps.setString( 1, “Ronald” );ResultSet rs = ps.executeQuery();
// Iterate through the result and print the employee names
while (rs.next ()) {
System.out.println( “State: ” + rs.getString( “state” ) );
}
}
catch( Exception e ) {
e.printStackTrace();
}
}
}

here some more example links for you:
http://www.javacoffeebreak.com/articles/jdbc/
http://www.acm.org/crossroads/columns/ovp/march2001.html

Tweet This Post