import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.osgi.framework.BundleActivator;
import org.osgi.framework.BundleContext;
public class JDBCBridge implements BundleActivator {
@Override
public void start(BundleContext context) throws Exception {
Connection conn = getDatabaseConnection();
String query = "SELECT * FROM users";
ResultSet result = executeQuery(conn, query);
while (result.next()) {
String username = result.getString("username");
System.out.println("Username: " + username);
}
conn.close();
}
@Override
public void stop(BundleContext context) throws Exception {
}
private Connection getDatabaseConnection() throws SQLException {
String dbURL = "jdbc:mysql://localhost:3306/mydb";
String username = "root";
String password = "password";
return DriverManager.getConnection(dbURL, username, password);
}
private ResultSet executeQuery(Connection conn, String query) throws SQLException {
Statement statement = conn.createStatement();
return statement.executeQuery(query);
}
}
