コード例 #1
0
  @Override
  public boolean eliminarPersona(int id_persona) {

    boolean flat = false;
    String query = "DELETE FROM persona WHERE id_persona=" + id_persona + "";
    Statement st = null;
    try {
      st = cn.conexion().createStatement();
      st.executeUpdate(query);
      cn.guardar();
      cn.cerrar();
      flat = true;
    } catch (Exception e) {
      cn.restaurar();
      cn.cerrar();
      System.out.println("ERROR" + e.getMessage());
    } finally {
      if (cn.conexion() != null) {

        cn.cerrar();
      }
    }

    return flat;
  }
コード例 #2
0
  @Override
  /*public List<Venta> listarVenta() {
          List<Venta> lista=null;
          Statement st=null;
          ResultSet rs=null;
          Venta ve=null;
          String query="select * from persona";
          try {
              lista = new ArrayList<>();
              st= conexion().createStatement();
              rs=st.executeQuery(query);
              while (rs.next()) {

                  ve =new Venta();
                  ve.setId_persona(rs.getInt("id_persona"));
                  ve.setNombre(rs.getString("nombre"));
                  ve.setApepat(rs.getString("apepat"));
                  ve.setApemat(rs.getNString("apemat"));
  //              per.setFecha_nac(rs.getNString("yyyy-mm-dd"));
                  ve.setSexo(rs.getNString("sexo"));
                  ve.setDni(rs.getInt("dni"));
                  ve.setCelular(rs.getInt("celular"));
                  ve.setTelefono(rs.getInt("telefono"));
                  ve.setDireccion(rs.getString("direccion"));
                  lista.add(ve);
              }
              cerrar();
          } catch (Exception e) {
              System.out.println("ERROR:"+e.getMessage());
              e.printStackTrace();
             cerrar();
          }
          return lista;

      }*/

  @Override
  public boolean eliminarVenta(int id_venta) {
    boolean flat = false;
    String query = "DELETE FROM persona WHERE id_persona=" + id_venta + "";
    Statement st = null;
    try {
      st = cn.conexion().createStatement();
      st.executeUpdate(query);
      cn.guardar();
      cn.cerrar();
      flat = true;
    } catch (Exception e) {
      cn.restaurar();
      cn.cerrar();
      System.out.println("ERROR" + e.getMessage());
    } finally {
      if (cn.conexion() != null) {

        cn.cerrar();
      }
    }

    return flat;
  }
コード例 #3
0
  @Override
  public boolean actualizarPersona(Persona persona) {
    boolean flat = false;
    String query =
        "UPDATE persona SET nombre='"
            + persona.getNombre()
            + "',"
            + "apell_pater='"
            + persona.getApell_pater()
            + "',"
            + "apell_mater='"
            + persona.getApell_mater()
            + "',"
            + "direccion='"
            + persona.getDireccion()
            + "',"
            + "correo='"
            + persona.getCorreo()
            + "',"
            + "telefono="
            + persona.getTelefono()
            + ","
            + "celular='"
            + persona.getCelular()
            + "',"
            + "ruc='"
            + persona.getRuc()
            + "',"
            + "nro_documento ='"
            + persona.getNro_documento()
            + "',"
            + "tipo_persona='"
            + persona.getTipo_persona()
            + "',"
            + "tipo_documento ='"
            + persona.getTipo_documento()
            + "',"
            + "genero ='"
            + persona.getGenero()
            + "' WHERE id_persona ="
            + persona.getId_persona()
            + "";
    Statement st = null;
    try {
      st = cn.conexion().createStatement();
      st.executeUpdate(query);
      cn.guardar();
      cn.cerrar();
      flat = true;
    } catch (Exception e) {
      cn.restaurar();
      cn.cerrar();
      System.out.println("ERROR" + e.getMessage());
    } finally {
      if (cn.conexion() != null) {
        cn.cerrar();
      }
    }

    return flat;
  }