Start Using JDBC

What is JDBC?

JDBC stands for Java Database Connectivity, is a set of Java API for accessing the relational databases from Java program. The Java API enables the programmers to execute the SQL statements against the JDBC complaint database.

JDBC allows the programmers to quickly develop small Java applications that interact with the databases. 

To develop an application programmer has to:

1. Develop the code to connect to the database 
2. Write the code to execute the query. 

Once the query is successfully executed and result is retrieved from the database, programmer can read the data programmatically from the result set object. 

How dose it Work ?

you will find the steps below sorted in steps :

1. Load the Driver class.
2. Create the connection using the static getConnection method
3. Create a Statement class to execute the SQL statement
4. Execute the SQL statement and get the results in a Resultset
5. Iterate through the ResultSet, 

Code Example:

1. // Change the connection string according to your db, ip, username and password
2. String connectionURL = "jdbc:postgresql://localhost:5432/movies;user=java;password=samples";
3. 
   
4. try {
5.  
6.     // 1_ Load the Driver class.
7.     Class.forName("org.postgresql.Driver");
8.     // If you are using any other database then load the right driver here.
9.  
10.     // 2_ Create the connection using the static getConnection method
11.     Connection con = DriverManager.getConnection (connectionURL);
12.  
13.     //3_ Create a Statement class to execute the SQL statement
14.     Statement stmt = con.createStatement();
15.  
16.     //4_ Execute the SQL statement and get the results in a Resultset
17.     ResultSet rs = stmd.executeQuery("select * from table ");
18.  
19.     // 5 _Iterate through the ResultSet, displaying two values
20.     // for each row using the getString method
21.  
22.     while (rs.next())
23.         System.out.println("Name= " + rs.getString("moviename") + " Date= " + rs.getString("releasedate");
24. }
25. catch (SQLException e) {
26.     e.printStackTrace();
27. }
28. catch (Exception e) {
29.     e.printStackTrace();
30. }
31. finally {
32.     // Close the connection
33.     con.close();
34. }