Open links in new tab
    • Work Report
    • Email
    • Rewrite
    • Speech
    • Title Generator
    • Smart Reply
    • Poem
    • Essay
    • Joke
    • Instagram Post
    • X Post
    • Facebook Post
    • Story
    • Cover Letter
    • Resume
    • Job Description
    • Recommendation Letter
    • Resignation Letter
    • Invitation Letter
    • Greeting Message
    • Try more templates
  1. 123

    JDBC (Java Database Connectivity) is an API that enables Java applications to interact with databases. Below is an example of establishing a connection to a MySQL database, executing a query, and retrieving data.

    import java.sql.*;

    public class JDBCExample {
    public static void main(String[] args) {
    String url = "jdbc:mysql://localhost:3306/testdb"; // Database URL
    String user = "yourusername"; // Database username
    String password = "yourpassword"; // Database password
    String query = "SELECT * FROM students"; // SQL query

    try {
    // Load MySQL JDBC driver (optional for JDBC 4.0+)
    Class.forName("com.mysql.cj.jdbc.Driver");

    // Establish connection
    Connection con = DriverManager.getConnection(url, user, password);
    System.out.println("Connection Established!");

    // Create a statement
    Statement stmt = con.createStatement();

    // Execute the query
    ResultSet rs = stmt.executeQuery(query);

    // Process the results
    while (rs.next()) {
    System.out.println("Name: " + rs.getString("name"));
    }

    // Close resources
    rs.close();
    stmt.close();
    con.close();
    } catch (Exception e) {
    e.printStackTrace();
    }
    }
    }
    Copied!
    Feedback
  2. GeeksForGeeks
    https://www.geeksforgeeks.org › java › connection-interface-in-java-jdbc

    Connection Interface in Java JDBC - GeeksforGeeks

    1 day ago · The Connection interface in Java JDBC represents a session between a Java application and a database. It is used to establish communication, execute SQL queries, and manage transactions.

  3. TutorialsPoint
    https://www.tutorialspoint.com › jdbc › jdbc-sample-code

    JDBC - Sample, Example Code - Online Tutorials Library

    • There are following six steps involved in building a JDBC application − 1. Import the packages − Requires that you include the packages containing the JDBC classes needed for database programming. Most often, using import java.sql.*will suffice. 2. Open a connection − Requires using the DriverManager.getConnection()method to create a Connection obj...
    See more on tutorialspoint.com

    Code sample

    static final String DB_URL = "jdbc:mysql://localhost/TUTORIALSPOINT";
    static final String USER = "guest";
    static final String PASS = "guest123";
    static final String QUERY = "SELECT id, first, last, age FROM Employees";
    public static void main(String[] args) {...
  4. Software Testing Help
    https://www.softwaretestinghelp.com › jdbc-connection-steps

    Java JDBC Connection Tutorial With Programming Example

      1. Import Packages. First, we need to import the existing packages to use it in our …
      2. Load Driver. First, we should load/register the driver in the program before …
      3. Establish Connection. After loading the driver, the next step is to create and …
      4. Create And Execute Statement. Once the connection has established, we can …
      5. Retrieve Results. When we execute the queries using the executeQuery() …
      See full list on softwaretestinghelp.com
  5. oracle.com
    https://docs.oracle.com › javase › tutorial › jdbc › basics › connecting.html

    Establishing a Connection (The Java™ Tutorials > JDBC ... - Oracle

    This JDBC Java tutorial describes how to use JDBC API to create, insert into, update, and query tables. You will also learn how to use simple and prepared statements, stored procedures and perform …

  6. javaspring.net
    https://www.javaspring.net › javaexamples › connecting...

    Connecting to a Database using JDBC in Java - javaspring.net

    This blog post will guide you through the process of connecting to a database using JDBC in Java, covering fundamental concepts, usage methods, common practices, and best practices.

  7. DEV Community
    https://dev.to

    JDBC in Java: A Detailed Guide - DEV Community

    Jul 31, 2025 · JDBC (Java Database Connectivity) is an API in Java that enables applications to interact with different databases. It acts as a bridge that allows …

  8. Medium
    https://medium.com

    javaHow to Establish a JDBC Connection in Java - Medium

    Jan 9, 2026 · Before performing any database operations in Java, you first need to establish a connection using JDBC. This connection acts as a communication channel between your Java …

  9. codingtechroom.com
    https://codingtechroom.com › tutorial › java-connecting-to-database-with-jdbc

    Connecting to a Database with JDBC: A Complete Guide

    Learn how to connect to a database using JDBC in Java. This guide covers everything from setup to advanced techniques.

  10. developerindian.com
    https://www.developerindian.com › articles › ...

    Introduction to JDBC in Java: A Beginner’s Guide with Examples

    Aug 16, 2025 · JDBC acts as a bridge between Java applications and databases, making it possible to write database-independent code. In this guide, we’ll explore JDBC architecture, drivers, steps to …

  11. Baeldung
    https://www.baeldung.com › java-jdbc

    Introduction to JDBC - Baeldung

    Jan 8, 2024 · In this article, we’re going to take a look at JDBC (Java Database Connectivity) which is an API for connecting and executing queries on a …

  12. People also ask
    Unable to load answer

    Feedback
Content was generated with AI. Learn more