Exemplo n.º 1
0
  private void jButton1ActionPerformed(
      java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton1ActionPerformed
    conexioninicio ci = new conexioninicio();
    Connection con = null;

    try {
      Class.forName("org.gjt.mm.mysql.Driver");
      con = DriverManager.getConnection(ci.getURl(), ci.getLogin(), ci.getPassword());
      Statement stmt = con.createStatement();
      String cadenasql =
          "select nombre,apPat,apMat,calle,numExt,colonia,municipio,cp,email,numTel,curp,idadmon,contraseña,nombreest from persona natural join admin natural join estado where idadmon="
              + "'"
              + User
              + "'";
      ResultSet rs = stmt.executeQuery(cadenasql);
      while (rs.next()) {
        nombre.setText(rs.getString("nombre"));
        apPat.setText(rs.getString("apPat"));
        apMat.setText(rs.getString("apMat"));
        calle.setText(rs.getString("calle"));
        num.setText(rs.getString("numExt"));
        colonia.setText(rs.getString("colonia"));
        municipio.setText(rs.getString("municipio"));
        cp.setText(rs.getString("cp"));
        email.setText(rs.getString("email"));
        telefono.setText(rs.getString("numTel"));
        curp.setText(rs.getString("curp"));
        idamin.setText(rs.getString("idadmon"));
        contraseñaactual.setText(rs.getString("contraseña"));
        this.jComboBox1.setSelectedItem(rs.getString("nombreest"));
      }
    } catch (Exception e) {
      System.out.println(e.getMessage());
    } // TODO add your handling code here:
  } // GEN-LAST:event_jButton1ActionPerformed