io.nflow.engine.internal.dao.DaoUtil Maven / Gradle / Ivy
package io.nflow.engine.internal.dao;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.List;
import org.joda.time.DateTime;
import org.joda.time.base.BaseDateTime;
import org.springframework.jdbc.core.ResultSetExtractor;
public class DaoUtil {
static final FirstColumnLengthExtractor firstColumnLengthExtractor = new FirstColumnLengthExtractor();
private DaoUtil() {
// prevent instantiation
}
public static Timestamp toTimestamp(BaseDateTime time) {
return time == null ? null : new Timestamp(time.getMillis());
}
public static DateTime toDateTime(Timestamp time) {
return time == null ? null : new DateTime(time.getTime());
}
static final class FirstColumnLengthExtractor implements ResultSetExtractor {
@Override
public Integer extractData(ResultSet rs) throws SQLException {
return rs.getMetaData().getColumnDisplaySize(1);
}
}
public static Integer getInt(ResultSet rs, String columnLabel) throws SQLException {
int value = rs.getInt(columnLabel);
return rs.wasNull() ? null : value;
}
public static Long getLong(ResultSet rs, String columnLabel) throws SQLException {
long value = rs.getLong(columnLabel);
return rs.wasNull() ? null : value;
}
public static final class ColumnNamesExtractor implements ResultSetExtractor> {
static final ColumnNamesExtractor columnNamesExtractor = new ColumnNamesExtractor();
private ColumnNamesExtractor() {
}
@Override
public List extractData(ResultSet rs) throws SQLException {
ResultSetMetaData metadata = rs.getMetaData();
int columnCount = metadata.getColumnCount();
List columnNames = new ArrayList<>(columnCount);
for (int col = 1; col <= columnCount; col++) {
columnNames.add(metadata.getColumnName(col));
}
return columnNames;
}
}
}