@Override
  public boolean actualizarpersona(Persona persona) {
    boolean flat = false;
    String query =
        "UPDATE persona SET nombre='"
            + persona.getNombre()
            + "',apepat='"
            + persona.getApepat()
            + "',apemat='"
            + persona.getApemat()
            + "',sexo='"
            + persona.getSexo()
            + "',dni='"
            + persona.getDni()
            + "',celular='"
            + persona.getCelular()
            + "',direccion='"
            + persona.getDireccion()
            + "' WHERE id_persona ="
            + persona.getId_persona()
            + "";

    try {
      cn.execC(query);
      cn.Commit();

      return true;
    } catch (Exception EX) {
      cn.RollBack();

      return false;
    }
  }
 @Override
 public boolean eliminarpersona(String id_persona) {
   boolean flat = false;
   String query = "DELETE FROM persona WHERE id_persona=" + id_persona + "";
   try {
     cn.execC(query);
     cn.Commit();
     return true;
   } catch (Exception EX) {
     cn.RollBack();
     return false;
   }
 }
  @Override
  public boolean agregarpersona(Persona persona) {
    boolean flat = false;
    Statement st = null;
    String query =
        "INSERT INTO persona (nombre,apepat,apemat,sexo,dni,celular,direccion)"
            + " VALUES('"
            + persona.getNombre()
            + "',"
            + "'"
            + persona.getApepat()
            + "',"
            + "'"
            + persona.getApemat()
            + "',"
            + "'"
            + persona.getSexo()
            + "',"
            + ""
            + persona.getDni()
            + ","
            + ""
            + persona.getCelular()
            + ","
            + "'"
            + persona.getDireccion()
            + "')";
    System.out.println(query);
    try {
      cn.execC(query);
      cn.Commit();

      return true;
    } catch (Exception EX) {
      cn.RollBack();

      return false;
    }
  }