Software Best Practices
Коллега прислал выдержку из нашего кода. В исходниках было немного разнесено, но на одном экране таки умещалось:
Я выделил отличия.
private static void deleteHourly(PreparedStatement stmt, Timestamp start, Timestamp end, int curveNum) throws SQLException
{
stmt.setInt(1, curveNum);
stmt.setInt(2, PositionValuationConstants.TIME_PERIOD_HOURLY);
stmt.setTimestamp(3, start);
stmt.setTimestamp(4, end);
stmt.execute();
}
private static void deleteHalfHourly(PreparedStatement stmt, Timestamp start, Timestamp end, int curveNum) throws SQLException
{
stmt.setInt(1, curveNum);
stmt.setInt(2, PosValConstants.TIME_PERIOD_TYPE_IND_HALFHOURLY);
stmt.setTimestamp(3, start);
stmt.setTimestamp(4, end);
stmt.execute();
}
private static void deleteDaily(PreparedStatement stmt, Timestamp start, Timestamp end, int curveNum) throws SQLException
{
stmt.setInt(1, curveNum);
stmt.setInt(2, PositionValuationConstants.TIME_PERIOD_DAILY);
stmt.setTimestamp(3, start);
stmt.setTimestamp(4, end);
stmt.execute();
}
{
stmt.setInt(1, curveNum);
stmt.setInt(2, PositionValuationConstants.TIME_PERIOD_HOURLY);
stmt.setTimestamp(3, start);
stmt.setTimestamp(4, end);
stmt.execute();
}
private static void deleteHalfHourly(PreparedStatement stmt, Timestamp start, Timestamp end, int curveNum) throws SQLException
{
stmt.setInt(1, curveNum);
stmt.setInt(2, PosValConstants.TIME_PERIOD_TYPE_IND_HALFHOURLY);
stmt.setTimestamp(3, start);
stmt.setTimestamp(4, end);
stmt.execute();
}
private static void deleteDaily(PreparedStatement stmt, Timestamp start, Timestamp end, int curveNum) throws SQLException
{
stmt.setInt(1, curveNum);
stmt.setInt(2, PositionValuationConstants.TIME_PERIOD_DAILY);
stmt.setTimestamp(3, start);
stmt.setTimestamp(4, end);
stmt.execute();
}
Я выделил отличия.
no subject
no subject
no subject