Exemplo n.º 1
0
 protected void executeQuery(Statement stmt, String q) throws SQLException {
   q = q.replace("$PREFIX", getPrefix());
   LOG.info(" Executing " + q);
   ResultSet rs = stmt.executeQuery(q);
   StringBuilder header = new StringBuilder();
   for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
     if (i > 1) {
       header.append("|");
     }
     header.append(rs.getMetaData().getColumnName(i));
   }
   LOG.info(header);
   int seq = 0;
   while (true) {
     boolean valid = rs.next();
     if (!valid) break;
     seq++;
     StringBuilder line = new StringBuilder();
     for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
       if (i > 1) {
         line.append("|");
       }
       line.append(rs.getString(i));
     }
     LOG.info(seq + ":" + line);
   }
 }
Exemplo n.º 2
0
  /** EJECUTA UNA CONSULTA Y GENERA LA TABLA HTML */
  protected String getHTML(String SQL) throws Exception {
    StringBuffer html = new StringBuffer();
    html.append("<TABLE border='1'>");
    html.append("<TR>");

    if (conectar()) {
      ResultSet rs = ejecutarSQL(SQL);
      ResultSetMetaData rsm = rs.getMetaData();
      html.append("<TR>");
      for (int i = 1; i <= rsm.getColumnCount(); i++) {
        html.append("<TH>" + rsm.getColumnName(i) + "</TH>");
      }
      html.append("</TR>");
      while (rs.next()) {
        html.append("<TR>");
        for (int i = 1; i <= rsm.getColumnCount(); i++) {
          html.append("<TD>" + rs.getString(i) + ".</TD>");
        }
        html.append("</TR>");
      }
      desconectar();
    }

    html.append("</TR>");
    html.append("</TABLE>");
    return html.toString();
  } // Fin getHTML
Exemplo n.º 3
0
  protected ArrayList<String> getSQL(String SQL) throws Exception {
    StringBuffer html = new StringBuffer();
    ArrayList<String> v = new ArrayList<String>();

    if (conectar()) {
      ResultSet rs = ejecutarSQL(SQL);
      ResultSetMetaData rsm = rs.getMetaData();

      while (rs.next()) {
        String r = "";
        for (int i = 1; i <= rsm.getColumnCount(); i++) {
          r += rs.getString(i) + "-";
        }
        v.add(r);
      }
      desconectar();
    }

    return v;
  } // Fin getHTML
Exemplo n.º 4
0
  /** EJECUTA UNA CONSULTA Y GENERA XML */
  protected String getXML() throws Exception {
    StringBuffer xml = new StringBuffer();
    xml.append("<registros>");

    if (conectar()) {
      ResultSet rs = ejecutarSQL(this.SQL);
      while (rs.next()) {
        ResultSetMetaData rsm = rs.getMetaData();
        xml.append("<registro>");
        for (int i = 1; i <= rsm.getColumnCount(); i++) {
          xml.append("<" + rsm.getColumnName(i) + ">");
          xml.append(rs.getString(i));
          xml.append("</" + rsm.getColumnName(i) + ">");
        }
        xml.append("</registro>");
      }
      desconectar();
    }

    xml.append("</registros>");
    return xml.toString();
  } // Fin getXML
  //
  // Find all the methods for java.sql objects in the Connection which raise
  // SQLFeatureNotSupportedException.
  //
  private void connectionWorkhorse(
      Connection conn, HashSet<String> unsupportedList, HashSet<String> notUnderstoodList)
      throws Exception {
    vetSavepoint(conn, unsupportedList, notUnderstoodList);
    vetLargeObjects(conn, unsupportedList, notUnderstoodList);

    DatabaseMetaData dbmd = conn.getMetaData();
    PreparedStatement ps = conn.prepareStatement("select * from sys.systables where tablename = ?");

    ps.setString(1, "foo");

    ParameterMetaData parameterMetaData = ps.getParameterMetaData();
    ResultSet rs = ps.executeQuery();
    ResultSetMetaData rsmd = rs.getMetaData();
    Statement stmt = conn.createStatement();

    CallableStatement cs = conn.prepareCall("CALL SYSCS_UTIL.SET_RUNTIMESTATISTICS(0)");
    ParameterMetaData csmd = cs.getParameterMetaData();

    //
    // The vetObject() method calls all of the methods in these objects
    // in a deterministic order, calling the close() method last.
    // Inspect these objects in an order which respects the fact that
    // the objects are closed as a result of calling vetObject().
    //
    vetObject(dbmd, unsupportedList, notUnderstoodList);
    vetObject(stmt, unsupportedList, notUnderstoodList);
    vetObject(csmd, unsupportedList, notUnderstoodList);
    vetObject(cs, unsupportedList, notUnderstoodList);
    vetObject(rsmd, unsupportedList, notUnderstoodList);
    vetObject(rs, unsupportedList, notUnderstoodList);
    vetObject(parameterMetaData, unsupportedList, notUnderstoodList);
    vetObject(ps, unsupportedList, notUnderstoodList);
    vetObject(conn, unsupportedList, notUnderstoodList);

    // No need to close the objects. They were closed by vetObject().
  }
Exemplo n.º 6
0
 /**
  * M�todo de prueba Recibe como argumento el nombre del archivo de configuracion. Para usarlo:
  * java JDBCMiddler archivo.conf
  */
 protected static void main(String args[]) throws Exception {
   // Se recibe como argumento del main el archivo de
   // configuracion que contiene el driver
   // la url, el login y la clave
   String parametros[] = leerParametros(args[0]);
   int n = 1;
   JDBCMiddler middler =
       new JDBCMiddler(parametros[0], parametros[1], parametros[2], parametros[3]);
   if (middler.conectar()) {
     System.out.println(parametros[4]);
     ResultSet rs = middler.ejecutarSQL(parametros[4]);
     while (rs.next()) {
       ResultSetMetaData rsm = rs.getMetaData();
       System.out.println("****************************");
       System.out.println("Registro: " + (n++));
       for (int i = 1; i <= rsm.getColumnCount(); i++) {
         System.out.print(rsm.getColumnName(i) + ": ");
         System.out.println(rs.getString(i));
       }
     }
     middler.desconectar();
     System.out.println("todo bien");
   }
 } // fin main