Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void consultarclienteActionPerformed(java.awt.event.ActionEvent evt) {
- try {
- con = DriverManager.getConnection("jdbc:mysql://localhost/muebleartestefanny", "root", "eafit");
- java.sql.Statement sentencia = con.createStatement();
- CallableStatement s = con.prepareCall("CALL Cons_Cliente (" + cedulacliente.getText() + " )");
- s.execute();
- while (s.getResultSet().next()) {
- System.out.println(s.getResultSet().GetValue(0));
- /*cedulacliente = s.GetValue(0));
- string nombre = Convert.ToString(s.GetValue(1));
- string apellido = Convert.ToString(s.GetValue(2));
- string telefono = Convert.ToString(s.GetValue(3));
- string direccion = Convert.ToString(s.GetValue(4));
- */
- cedulacliente.setString(s.getString("Cc_Cliente"));
- nombre.addItem(s.getString("Nombre"));
- apellido.addItem(s.getString("Apellido"));
- telefono.addItem(s.getString("Num_Telefono"));
- direccion.addItem(s.getString("Direccion"));
- }
- sentencia.close();
- con.close();
- } catch (Exception ex) {
- System.out.println(ex);
- }
Add Comment
Please, Sign In to add comment