public class Airline {
private String name;
private String code;
public Airline(String name, String code) {
this.name = name;
this.code = code;
}
public String getName() {
return name;
}
public String getCode() {
return code;
}
}
public class Main {
public static void main(String[] args) {
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnectionPool {
private static final String DB_URL = "jdbc:mysql://localhost:3306/airlines";
private static final String DB_USER = "root";
private static final String DB_PASSWORD = "root";
private static final int MAX_CONNECTIONS = 10;
private static final int INITIAL_CONNECTIONS = 5;
private static Connection[] connections;
private static boolean[] inUse;
static {
connections = new Connection[MAX_CONNECTIONS];
inUse = new boolean[MAX_CONNECTIONS];
for (int i = 0; i < INITIAL_CONNECTIONS; i++) {
try {
connections[i] = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static Connection getConnection() {
for (int i = 0; i < MAX_CONNECTIONS; i++) {
if (!inUse[i]) {
inUse[i] = true;
return connections[i];
}
}
return null;
}
public static void releaseConnection(Connection connection) {
for (int i = 0; i < MAX_CONNECTIONS; i++) {
if (connections[i] == connection) {
inUse[i] = false;
break;
}
}
}
}
