public class SettingsDaoImpl extends JdbcTemplate implements SettingsDao {
@Override
public Settings loadSettings() {
Settings res = new Settings();
Connection conn = null;
try {
conn = getDataSource().getConnection();
PreparedStatement ps = conn.prepareStatement("select name, value from settings");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
String name = rs.getString("name");
String value = rs.getString("value");
res.setSetting(name, value);
}
System.out.println("Settings were loaded");
return res;
} catch (SQLException e) {
throw new RuntimeException(e);