private void cargaCliente() { try { String sql = "SELECT concat(aombre, ' ', apellido) as cliente FROM cliente order by apellido "; z.snt = z.con.createStatement(); z.rs = z.snt.executeQuery(sql); cboCliente.removeAllItems(); while (z.rs.next()) { cboCliente.addItem(z.rs.getString("cliente")); } } catch (SQLException ex) { Logger.getLogger(FrmPedido.class.getName()).log(Level.SEVERE, null, ex); } }
private int buscaCodClient(String des, String tabla) { int retorno = 0; try { String sql = "SELECT id FROM " + tabla + " where concat(cliente.aombre, ' ', cliente.apellido) = '" + des + "'"; z.snt = z.con.createStatement(); z.rs = z.snt.executeQuery(sql); z.rs.next(); retorno = z.rs.getInt("id"); } catch (SQLException ex) { Logger.getLogger(FrmPedido.class.getName()).log(Level.SEVERE, null, ex); } return retorno; }