public JobIniciado retornaUltimoLote(Connection conn, String job, int operacao) throws SQLException { String sql = " select job, operacao, tripulacao,recurso, max(data_fim) \n" + "from joblote where job = ? and operacao = ? \n" + "group by job, operacao, tripulacao, recurso "; PreparedStatement stmt = null; ResultSet rs = null; JobIniciado iniciado = null; stmt = conn.prepareStatement(sql); stmt.setString(1, job.trim().replace(".", "")); stmt.setInt(2, operacao); rs = stmt.executeQuery(); if (rs.next()) { iniciado = new JobIniciado(); iniciado.setJob(rs.getString(1)); iniciado.setOperacao(rs.getInt(2)); iniciado.setTripulacao(rs.getDouble(3)); iniciado.setRecurso(rs.getString(4)); Timestamp data = rs.getTimestamp(5); iniciado.setData(Validacoes.getDataHoraString(data)); } return iniciado; }
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(); }
/** Creates new form TelaUsuarios */ public TelaUsuarios( java.awt.Frame parent, boolean modal, JTextField campoCodigo, JTextField proximoCampo, JLabel nomeUsuario) { super(parent, modal); initComponents(); teclasAtalhos(); alinharColunasLinhasTabela(); this.campoCodigo = campoCodigo; this.proximoCampo = proximoCampo; this.nomeUsuario = nomeUsuario; mudarCampoComEnter(); alteraComportamentoEnterTabela(); setLocationRelativeTo(null); setResizable(false); setDefaultCloseOperation(DO_NOTHING_ON_CLOSE); Validacoes.selecionaTextoTextField(); setModal(true); setTitle("Usuarios"); jTextFieldPesquisa.grabFocus(); }