What are some examples of using JDBC and ODBC?

What are some examples of using JDBC and ODBC?

JDBC (Java Database Connectivity) and ODBC (Open Database Connectivity) are both APIs for connecting to databases. For example, you can use JDBC to connect a Java application to a MySQL database, while ODBC can be used to connect a C# application to an SQL Server database.

Can you give me a specific code example for JDBC?

Sure! Here's a simple JDBC example:

import java.sql.*;

public class JdbcExample {
    public static void main(String[] args) {
        try {
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "user", "password");
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM users");
            while (rs.next()) {
                System.out.println(rs.getString("username"));
            }
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

What about an ODBC example?

Here's a basic ODBC example in Python using pyodbc:

import pyodbc

conn = pyodbc.connect('DSN=mydatasource;UID=user;PWD=password')
cursor = conn.cursor()
cursor.execute('SELECT * FROM users')
for row in cursor:
    print(row.username)
conn.close()