Apache Derby database engine and embedded JDBC driver technology architecture
Apache Derby database engine and embedded JDBC driver technology architecture
Overview:
Apache Derby is a Java -based relational database management system (RDBMS), which provides a lightweight database engine implemented by all Java.Derby is known for its embedded characteristics, which allows embedded databases into Java applications in applications without a separate database server.In addition, Derby also provides a standard JDBC (Java DataBase Connectivity) driver, so that developers can easily access and manage the Derby database through the Java code.
Technology Architecture:
The DERBY database engine and embedded JDBC driver are related to each other, and they cooperate to achieve the management and access of the database.The following is their technical architecture:
1. Derby database engine:
Derby database engine is part of Derby's core component, responsible for implementing the management and processing of databases.It adopts a modular architecture that consists of multiple subsystems, including storage management subsystems, query execution subsystems, and transaction management subsystems.Derby uses memory and disks to store data, and provides efficient index mechanisms to support data inquiry and access.As an embedded database engine, Derby can run directly in the application of the Java virtual machine without a separate database server process.
2. Embedded JDBC driver:
Derby's embedded JDBC driver is a Java library that provides an interface to interact with Derby database engine.It implements the JDBC specification and provides a set of Java classes and methods for connecting to Derby database, executing SQL query, handling transactions, etc.Developers can use the Java programming language to write the interactive logic with the database, and to realize the visit of the Derby database by embedded JDBC driver.
Example code:
Here are some examples of Java code, which demonstrates how to use Derby's embedded JDBC driver to connect and access the database:
1. Connect to the database:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DerbyExample {
public static void main(String[] args) {
// jdbc connection URL
String url = "jdbc:derby:myDB;create=true";
try {
// Load the derby driver
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
// Create a database connection
Connection conn = DriverManager.getConnection(url);
// Perform the database operation ...
// Turn off the connection
conn.close();
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
}
2. Execute SQL query:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DerbyExample {
public static void main(String[] args) {
String url = "jdbc:derby:myDB;create=true";
try {
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
Connection conn = DriverManager.getConnection(url);
// Create a statement object
Statement stmt = conn.createStatement();
// Execute the query
ResultSet rs = stmt.executeQuery("SELECT * FROM myTable");
// Process query results
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
System.out.println("ID: " + id + ", Name: " + name);
}
// Close the resource
rs.close();
stmt.close();
conn.close();
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
}
These examples show how to use Derby's embedded JDBC driver to connect to the database and perform SQL query.By learning and understanding Derby's technical architecture, developers can better use this powerful relationship database management system to build high -efficiency and reliable Java applications.
