Example #1
0
  /**
   * @param user
   * @param apps
   */
  public void insert(UsuarioDTO user, AppsDTO apps) {

    Connection conn = null;
    PreparedStatement ps = null;
    try {
      conn = super.getConnectionMySql();
      ps = conn.prepareStatement(SQL_INSERT);

      ps.setString(1, user.getMail());
      ps.setString(2, user.getPassword());
      ps.setString(3, user.getAutomobil());
      ps.setString(4, user.getModelo());
      ps.setInt(5, user.getAnioAuto());
      ps.setString(6, user.getNombre());
      ps.setString(7, user.getApellido());
      ps.setString(8, user.getRut());
      ps.setString(9, user.getDv());
      ps.setDate(10, user.getFechaNacimiento());
      ps.setTimestamp(11, user.getFechaInscripcion());
      ps.setString(12, user.getKeyAppMobil());
      ps.setString(13, apps.getNombreApp());
      ps.setString(14, apps.getAmbienteApp());
      ps.setBoolean(15, user.isConfirmaEnvioMails());

      ps.execute();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      close(ps, conn);
    }
  }