Introduction to the technical introduction of Apache Derby database engine and embedded JDBC driver
Apache Derby is an open source relationship database management system, which is a full -featured relationship database engine written by Java.It supports standard SQL query language and has the characteristics of stability, reliability and high performance.
Apache Derby provides the ability to directly access the database using the embedded JDBC (Java DataBase Connectivity) driver.The embedded JDBC driver enables the application to integrate the DERBY database inside it without communication through the network and other processes.This design model helps simplify the deployment and maintenance of the application, while providing higher performance.
The following is a Java code example using the Apache Derby database engine and an embedded JDBC driver:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Main {
public static void main(String[] args) {
// Specify the connection URL of the DERBY database
String dbUrl = "jdbc:derby:mydb;create=true";
try {
// Load the Derby driver
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
// Get the database connection
Connection connection = DriverManager.getConnection(dbUrl);
// Create a table
Statement statement = connection.createStatement();
String createTableQuery = "CREATE TABLE books (id INT, title VARCHAR(50))";
statement.executeUpdate(createTableQuery);
// Insert data
String insertDataQuery = "INSERT INTO books VALUES (1, 'Java Programming')";
statement.executeUpdate(insertDataQuery);
// Query data
String selectDataQuery = "SELECT * FROM books";
ResultSet resultSet = statement.executeQuery(selectDataQuery);
// Print the query results
while (resultSet.next()) {
int id = resultSet.getInt("id");
String title = resultSet.getString("title");
System.out.println("ID: " + id + ", Title: " + title);
}
// Close connection and resources
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
In the above code example, we first loaded the Derby driver and used the specified connection URL to obtain the database connection.Then, we created a Books table containing the ID and Title column and inserted a piece of data.Next, by executing the query statement, we obtained the results set and printed the query results.Finally, we closed the result set, period and connection.
In summary, by combining the Apache Derby database engine and embedded JDBC driver, we can easily integrate and use the DERBY database to achieve high -performance database access and management.The flexibility and convenience of this technology make it one of the reliable database solutions in developing Java applications.
