Java School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Welcome to Dream.In.Code
Become a Java Expert!

Join 309,260 Java Programmers for FREE! Get instant access to thousands of Java experts, tutorials, code snippets, and more! There are 2,460 people online right now. Registration is fast and FREE... Join Now!




> Java connecting with an ODBC, JDBC

eXceed69
Group Icon



post 26 Nov, 2006 - 09:56 PM
Post #1


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

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

• DriverManager: the DriverManager class loads and configures a database driver on the database
• Connection: the Connection class performs confectioning and authentication to a database

CODE

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


The usual password and username of a database especially the oracle

CODE

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


• Statement / PreparedStatement: the Statement and PreparedStatement classes send SQL statements to the database engine for preprocessing and eventually execution
CODE

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


…..

CODE

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


• ResultSet: the ResultSet class allows for the inspection of results from executions

CODE
      
ResultSet rs = preparedStatement.executeQuery();



Here some sample code for you:

CODE


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:

Getting Started with JDBC

Java Database Connectivity



For more example here are some links for you:
Sample Code

This post has been edited by eXceed69: 10 Dec, 2006 - 08:10 PM
Go to the top of the page
+Quote Post


Register to Make This Ad Go Away!


Posts in this topic


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 


Lo-Fi Version Time is now: 11/26/09 10:05AM

Live Java Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

Java Tutorials

Reference Sheets

Java Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month