My First JDBC Program

Prerequisites

1. Downloading, installing and configuring the database

See the installation and configuration note for your database.

2. Create table and insert data as:

Create table employee(empName varchar(20), id int PRIMARY KEY)

insert into employee values (‘name1’,1)

insert into employee values (‘name2’,2)

This example has been tested with Oracle XE and should most probably work with other database as well. See the installation and configuration note for your database.

3. Installing required jar files

Download and install the required jar files for your database. Please refer to javajee.com/jdbc-drivers-and-connection-strings and see if your database is listed there. Else use a google search and find out.

4. Find out the connection string for your particular database driver. Please refer to javajee.com/jdbc-drivers-and-connection-strings and see if your database is listed there.

Below example uses the connection url for Oracle XE and hence if you are using Oracle XE you don't have to make any changes:

String url = "jdbc:oracle:thin:@localhost:1521:XE";

Please replace it with the one for your database. 

 

Program – MyFirstJDBCProgram.java

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

 

public class MyFirstJDBCProgram {

 

  public static void main(String args[]) {

    try {

      String url = "jdbc:oracle:thin:@localhost:1521:XE";

      String username = "javaapp";

      String password = "javaapp";

      Connection con = DriverManager.getConnection(url, username, password);

      System.out.println("connected");

      Statement st = con.createStatement();

      ResultSet rs = st.executeQuery("select * from employee");

      while (rs.next()) {

        System.out.println(rs.getString("empname"));

      }

    } catch (SQLException e) {

      e.printStackTrace();

    }

  }

}

 

Now execute the program and see the result.

Note: You might have to modify the url based on your installation.

Comments

shams.tabrez.9's picture

"Error: Could not find or load main class MyFirstJDBCProgram"  this message has been shown in the console. what is the wrong here ?

You voted 'DOWN'.
Was it useful?

Please try running using command line and see.

Was it useful?

Quick Notes Finder Tags

Activities (1) advanced java (1) agile (3) App Servers (6) archived notes (2) Arrays (1) Best Practices (12) Best Practices (Design) (3) Best Practices (Java) (7) Best Practices (Java EE) (1) BigData (3) Chars & Encodings (6) coding problems (2) Collections (15) contests (3) Core Java (All) (55) course plan (2) Database (12) Design patterns (8) dev tools (3) downloads (2) eclipse (9) Essentials (1) examples (14) Exception (1) Exceptions (4) Exercise (1) exercises (6) Getting Started (18) Groovy (2) hadoop (4) hibernate (77) hibernate interview questions (6) History (1) Hot book (5) http monitoring (2) Inheritance (4) intellij (1) java 8 notes (4) Java 9 (1) Java Concepts (7) Java Core (9) java ee exercises (1) java ee interview questions (2) Java Elements (16) Java Environment (1) Java Features (4) java interview points (4) java interview questions (4) javajee initiatives (1) javajee thoughts (3) Java Performance (6) Java Programmer 1 (11) Java Programmer 2 (7) Javascript Frameworks (1) Java SE Professional (1) JPA 1 - Module (6) JPA 1 - Modules (1) JSP (1) Legacy Java (1) linked list (3) maven (1) Multithreading (16) NFR (1) No SQL (1) Object Oriented (9) OCPJP (4) OCPWCD (1) OOAD (3) Operators (4) Overloading (2) Overriding (2) Overviews (1) policies (1) programming (1) Quartz Scheduler (1) Quizzes (17) RabbitMQ (1) references (2) restful web service (3) Searching (1) security (10) Servlets (8) Servlets and JSP (31) Site Usage Guidelines (1) Sorting (1) source code management (1) spring (4) spring boot (3) Spring Examples (1) Spring Features (1) spring jpa (1) Stack (1) Streams & IO (3) Strings (11) SW Developer Tools (2) testing (1) troubleshooting (1) user interface (1) vxml (8) web services (1) Web Technologies (1) Web Technology Books (1) youtube (1)