Books Related to Java Technology

Sunday, January 4, 2009

Data Retrieval Process of JDBC

There are the following steps are used by jdbc to retrieve the data
  1. A JDBC driver would be loaded
  2. Using the DriverManager a database Connection object would be created
  3. Using the Connection object a Statement object would be created
  4. Using the Statement object a SQL Select statement would be executed
  5. SQL select statement returned a ResultSet
  6. The ResultSet would be used to returned the rows and examine the data.
This example illustrates how to create a connection from database table and how to access row of the table:

import java.sql.*;

public class JDBCMysqlConnection {
public static void main( String args[]) {
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbname = "test";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";

try {
con = DriverManager.getConnection(url+dbname,user,pass);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from tableName");
while ({
System.out.println("Name= " + rs.getString("name"));
} catch (SQLException e) {
} catch (Exception e) {
} finally {

No comments:

Post a Comment