public void incluiIniciado(Connection conn, JobIniciado job) throws SQLException {
String sql =
"insert into jobsiniciados(job, operacao, data, tripulacao, ativo, recurso) values(?,?,?,?,?,?) ";
PreparedStatement stmt = null;
stmt = conn.prepareStatement(sql);
stmt.setString(1, job.getJob().trim().replace(".", ""));
stmt.setInt(2, job.getOperacao());
stmt.setTimestamp(3, Validacoes.converteDataStringEmFormatoTimeStamp(job.getData().trim()));
stmt.setDouble(4, job.getTripulacao());
stmt.setBoolean(5, true);
stmt.setString(6, job.getRecurso().trim());
stmt.executeUpdate();
}
public void alteraIniciado(Connection conn, JobIniciado job) throws SQLException {
String sql =
" update jobsiniciados set data = ?, ativo = ?, tripulacao = ?, recurso = ? "
+ " where job = ? and operacao = ? ";
PreparedStatement stmt = null;
stmt = conn.prepareStatement(sql);
stmt.setTimestamp(1, Validacoes.converteDataStringEmFormatoTimeStamp(job.getData().trim()));
stmt.setBoolean(2, true);
stmt.setDouble(3, job.getTripulacao());
stmt.setString(4, job.getRecurso().trim());
stmt.setString(5, job.getJob().trim().replace(".", ""));
stmt.setInt(6, job.getOperacao());
stmt.executeUpdate();
}
public boolean verificaSeSetorTemLinhaTempo(Connection conn, String setor) throws SQLException {
PreparedStatement stmt = null;
ResultSet rs = null;
String sql = "select linha_tempo from setor where setor = ? and linha_tempo = ? ";
stmt = conn.prepareStatement(sql);
stmt.setString(1, setor.trim());
stmt.setBoolean(2, true);
rs = stmt.executeQuery();
if (rs.next()) {
return true;
} else {
return false;
}
}