Embedding Database Configuration Directly in Java Code

Step	Description
1	Include database driver
2	Define connection parameters
3	Establish connection
4	Create statement object
5	Execute SQL command
6	Process query results
7	Release resources

Include Database Driver

Ensure the appropriate JDBC driver is availible in the project's classpath. For MySQL, this typically involves adding the MySQL Connector/J library.

Define Connection Parameters

String dbUrl = "jdbc:mysql://localhost:3306/sample_db";
String user = "admin";
String pass = "secret";

Establish Connection

Connection connection = DriverManager.getConnection(dbUrl, user, pass);

Create Statement Object

Statement statement = connection.createStatement();

Execute SQL Command

String query = "SELECT * FROM employees";
ResultSet result = statement.executeQuery(query);

Process Query Results

while (result.next()) {
    int employeeId = result.getInt("id");
    String employeeName = result.getString("name");
    // Additional processing
}

Release Resources

result.close();
statement.close();
connection.close();