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;
}
