/**
* Vrati seznam objektu
*
* @return Klic je ID_BILDING, hodnota je BILDING_COL
* @throws SQLException
*/
public Map<Integer, String> getList() throws SQLException {
Map<Integer, String> listOfCustomers = new LinkedHashMap<>();
OracleDataSource ods = DataBase.getConnection();
try (Connection conn = ods.getConnection();
PreparedStatement stmt =
conn.prepareStatement("SELECT * FROM BILDING ORDER BY BILDING_COL"); ) {
try (ResultSet rs = stmt.executeQuery()) {
while (rs.next()) {
listOfCustomers.put(
rs.getInt("ID_BILDING"),
rs.getString("ID_BILDING") + " " + rs.getString("BILDING_COL"));
}
}
}
return listOfCustomers;
}
/**
* Vlozime noveho workera
*
* @param nazev
* @param type
* @return
* @throws SQLException
*/
public int insert(String nazev, String type) throws SQLException {
OracleDataSource ods = DataBase.getConnection();
try (Connection conn = ods.getConnection();
PreparedStatement stmt =
conn.prepareStatement(
"INSERT INTO BILDING (BILDING_COL, TYPE_BILDING_ID) VALUES(?,?)"); ) {
stmt.setString(1, nazev);
stmt.setString(2, type);
stmt.execute();
try (Statement stmt2 = conn.createStatement();
ResultSet rs =
stmt2.executeQuery("SELECT ID_BILDING FROM BILDING ORDER BY ID_BILDING DESC")) {
rs.next();
return rs.getInt("ID_BILDING");
}
}
}
/**
* Vratime bilding se zadanym ID
*
* @param id
* @return Klic je atribut bilding, hodnota je typu bilding. Vypisovat pomoci .toString()
* @throws SQLException
* @throws Exception
*/
public Map<String, Object> get(int id) throws SQLException, Exception {
Map<String, Object> map = new HashMap<>();
OracleDataSource ods = DataBase.getConnection();
try (Connection conn = ods.getConnection();
PreparedStatement stmt =
conn.prepareStatement("SELECT * FROM BILDING WHERE ID_BILDING = ?"); ) {
stmt.setInt(1, id);
try (ResultSet rs = stmt.executeQuery()) {
if (rs.next()) {
map.put("ID_BILDING", id);
map.put("BILDING_COL", rs.getString("BILDING_COL"));
} else {
return null;
}
}
}
return map;
}
