Beispiel #1
0
  public Personal persona(int id) {

    String query = "SELECT * FROM  `" + nameTable() + "`  WHERE  " + nameField()[0] + "=?;";
    personal = new Personal();
    try {
      Connection con = Conexion.createConnection();
      PreparedStatement preparedStatement = con.prepareStatement(query);
      preparedStatement.setString(1, id + "");
      ResultSet p = preparedStatement.executeQuery();
      if (p.next()) {
        personal.id = p.getInt(nameField()[0]);
        personal.nombre = p.getString(nameField()[1]);
        personal.correo = p.getString(nameField()[2]);
        personal.seguroSocial = p.getString(nameField()[3]);
        personal.telefono = p.getLong(nameField()[4]);
        personal.direccion = p.getString(nameField()[5]);
        personal.lugarnaciemiento = p.getString(nameField()[6]);
        DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
        personal.fechanacimeinto = formatter.parse(p.getString(nameField()[7]));
        personal.puesto_id = p.getInt(nameField()[8]);
        personal.activo = p.getInt(nameField()[9]);
      }
    } catch (SQLException ex) {
      System.out.println(ex.getMessage());
    } catch (Exception e) {

    }

    return personal;
  }
Beispiel #2
0
  public static List<Personal> listaPersonal() {
    String query = "SELECT * FROM  " + nameTable();
    List<Personal> personas = new ArrayList<Personal>();

    try {
      Connection con = Conexion.createConnection();
      PreparedStatement preparedStatement = con.prepareStatement(query);
      ResultSet p = preparedStatement.executeQuery();
      while (p.next()) {
        Personal personal = new Personal();
        personal.id = p.getInt(nameField()[0]);
        personal.nombre = p.getString(nameField()[1]);
        personal.correo = p.getString(nameField()[2]);
        personal.seguroSocial = p.getString(nameField()[3]);
        personal.telefono = p.getLong(nameField()[4]);
        personal.direccion = p.getString(nameField()[5]);
        personal.lugarnaciemiento = p.getString(nameField()[6]);

        DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
        System.out.println(p.getString(nameField()[7]));
        personal.fechanacimeinto = formatter.parse(p.getString(nameField()[7]));
        personal.puesto_id = p.getInt(nameField()[8]);
        personal.activo = p.getInt(nameField()[9]);
        personas.add(personal);
      }
    } catch (SQLException ex) {
      System.out.println(ex.getMessage());
    } catch (Exception e) {

    }
    return personas;
  }
Beispiel #3
0
  private int Update() {
    int id = -1;
    if (personal != null) {
      String query =
          "UPDATE  "
              + nameTable()
              + " SET "
              + nameField()[1]
              + " = ?, "
              + nameField()[2]
              + " = ?, "
              + nameField()[3]
              + " = ?, "
              + nameField()[4]
              + " = ?, "
              + nameField()[5]
              + " = ?, "
              + nameField()[6]
              + " = ?, "
              + nameField()[7]
              + " = ?, "
              + nameField()[8]
              + " = ? "
              + " WHERE "
              + nameField()[0]
              + " = ? ;";

      try {
        Connection con = Conexion.createConnection();
        PreparedStatement insertar = con.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);
        insertar.setString(1, personal.nombre);
        insertar.setString(2, personal.correo);
        insertar.setString(3, personal.seguroSocial);
        insertar.setLong(4, personal.telefono);
        insertar.setString(5, personal.direccion);
        insertar.setString(6, personal.lugarnaciemiento);
        insertar.setDate(7, new java.sql.Date(personal.fechanacimeinto.getTime()));
        insertar.setInt(8, personal.puesto_id);
        insertar.setInt(9, personal.id);
        insertar.executeUpdate();
        ResultSet generate = insertar.getGeneratedKeys();
        if (generate.next()) {
          id = generate.getInt(1);
        }
        con.close();
      } catch (SQLException e) {
        System.out.println(e.getMessage());
        JOptionPane.showMessageDialog(
            null,
            "no se pudo Actualizar  " + "verifique su conexion a la base de datos",
            "Inntepco",
            JOptionPane.ERROR_MESSAGE);
      }
    }
    return id;
  }
Beispiel #4
0
  private int insertar() {
    int id = -1;
    if (personal != null) {
      String query =
          "insert into "
              + nameTable()
              + " "
              + Arrays.toString(nameField()).replace('[', '(').replace(']', ')')
              + " values (null,?,?,?,?,?,?,?,?,1)";

      try {
        Connection con = Conexion.createConnection();
        PreparedStatement insertar = con.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);
        insertar.setString(1, personal.nombre);
        insertar.setString(2, personal.correo);
        insertar.setString(3, personal.seguroSocial);
        insertar.setLong(4, personal.telefono);
        insertar.setString(5, personal.direccion);
        insertar.setString(6, personal.lugarnaciemiento);
        insertar.setDate(7, new java.sql.Date(personal.fechanacimeinto.getTime()));
        insertar.setInt(8, personal.puesto_id);

        insertar.executeUpdate();
        ResultSet generate = insertar.getGeneratedKeys();
        generate.next();
        id = generate.getInt(1);
        con.close();
      } catch (SQLException e) {
        System.out.println(e.getMessage());
        JOptionPane.showMessageDialog(
            null,
            "no se pudo insertar  " + "verifique su conexion a la base de datos",
            "Inntepco",
            JOptionPane.ERROR_MESSAGE);
      }
    }
    return id;
  }