convert java to python online
public class Bank {
private static Map<String, String> bankList = new HashMap<String, String>();
public static void generateList() {
Connection conn = null;
Statement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(DATABASE_URL, DATABASE_USER, DATABASE_PASSWORD);
//String sql = "SELECT institution_id_code, bank_full_name FROM IRIS.tblnpsbinstitutionid";
String sql = "SELECT institution_id_code, bank_full_name FROM BBL_IRISINAPP.tblnpsbinstitutionid";
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
String instCode = rs.getString("institution_id_code");
String name = rs.getString("bank_full_name");
bankList.put(instCode, name);
}
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
System.out.println("Error in generating bank list");
System.exit(1);
} finally {
try {
if (stmt != null)
stmt.close();
} catch (SQLException se2) {
}
try {
if (conn != null)
conn.close();
} catch (SQLException se) {
se.printStackTrace();
}
}
}
public static String get(String institutionCode) {
return bankList.get(institutionCode);
}
}