Examples of java.sql.ResultSetMetaData

java.sql.ResultSetMetaData
Provides information about the columns in a ResultSet.

    ResultSet resultSet = null;
    try {
      // Maybe convert to an ArrayList for speed in the future.
      Vector resultVector = new Vector();
      resultSet = stmt.executeQuery();
      ResultSetMetaData metaData = resultSet.getMetaData();
      int columnCount = metaData.getColumnCount();
      while (resultSet.next()) {
        // convert recordset to hashmap
        HashMap hm = new HashMap();
        for (int i = 1; i <= columnCount; i++) {
          hm.put(metaData.getColumnName(i), resultSet.getObject(i));
        }
        resultVector.add(hm);
      }
      return resultVector;
    } catch (Exception e) {

View Full Code Here

  {
    ResultSet resultSet = null;
    ArrayList results = new ArrayList();
    try {
      resultSet = this.stmt.executeQuery();
      ResultSetMetaData metaData = resultSet.getMetaData();


      int columnCount = metaData.getColumnCount();
      while (resultSet.next()) {
        // convert recordset to hashmap
        int rowId = resultSet.getInt(idColumn);
        ArrayList rowList = new ArrayList();
        for (int i = 1; i <= columnCount; i++) {

View Full Code Here

      }


      out = new FileWriter(outputFile);


      ResultSet rs = stmt.executeQuery();
      ResultSetMetaData md = rs.getMetaData();
      int cc = md.getColumnCount();


      String columnNames = "";
      String columnValues = "";


      for (int i = 1; i <= cc; i++) {
        columnNames = columnNames + "\t" + md.getColumnName(i);
      }


      columnNames = columnNames+LINE_SEPARATOR;
      while (rs.next()) {
        for (int i = 1; i <= cc; i++) {

View Full Code Here

  {
    HashMap hm = new HashMap();
    ResultSet resultSet = null;
    try {
      resultSet = stmt.executeQuery();
      ResultSetMetaData md = resultSet.getMetaData();
      int cc = md.getColumnCount();


      for (int i = 0; i < cc; i++) {
        int ii = i + 1;
        hm.put((md.getColumnName(ii)).toLowerCase(), new Integer(md.getColumnType(ii)));
      }
    } catch (Exception e) {
      System.out.println("[Exception][CVDal.getTableMetaData] Exception Thrown: " + e);
      e.printStackTrace();
    } finally {

View Full Code Here


        // -----------------------------------
        // Add the Select (header) element ...
        // -----------------------------------
        try {
            ResultSetMetaData rmdata = object.getMetaData();
            List identList = new ArrayList(rmdata.getColumnCount());
            for ( int i = 1; i <= rmdata.getColumnCount(); i++ ) {
                identList.add(new ElementSymbol(rmdata.getColumnName(i)));
            }
            Select select = new Select(identList);
            resultsElement = produceMsg(select, rmdata, resultsElement);


            // -------------------------
            // Add the Table element ...
            // -------------------------
            resultsElement.addContent(new Element(TagNames.Elements.TABLE));
            Element tableElement = resultsElement.getChild(TagNames.Elements.TABLE);
            int rowCount = 0;
            int colCount = rmdata.getColumnCount();


            while ( object.next() && (object.getRow() <= endRow) ) {


                // -------------------------
                // Add the ROW element ...

View Full Code Here


        // -----------------------------------
        // Add the Select (header) element ...
        // -----------------------------------
        try {
            ResultSetMetaData rmdata = object.getMetaData();
            List identList = new ArrayList(rmdata.getColumnCount());
            for ( int i = 1; i <= rmdata.getColumnCount(); i++ ) {
                identList.add(new ElementSymbol(rmdata.getColumnName(i)));
            }
            Select select = new Select(identList);
            resultsElement = produceMsg(select, rmdata, resultsElement);


            // -------------------------
            // Add the Table element ...
            // -------------------------
            resultsElement.addContent(new Element(TagNames.Elements.TABLE));
            Element tableElement = resultsElement.getChild(TagNames.Elements.TABLE);
            int rowCount = 0;
            int colCount = rmdata.getColumnCount();


            while ( object.next() ) {


                // -------------------------
                // Add the ROW element ...

View Full Code Here

        file.write(b, 0, b.length);
        file.close();
        Csv csv = Csv.getInstance();
        csv.setNullString("\\N");
        ResultSet rs = csv.read(file.getName(), null, "UTF8");
        ResultSetMetaData meta = rs.getMetaData();
        assertEquals(4, meta.getColumnCount());
        assertEquals("A", meta.getColumnLabel(1));
        assertEquals("B", meta.getColumnLabel(2));
        assertEquals("C", meta.getColumnLabel(3));
        assertEquals("D", meta.getColumnLabel(4));
        assertTrue(rs.next());
        assertEquals(null, rs.getString(1));
        assertEquals("", rs.getString(2));
        // null is never quoted
        assertEquals("\\N", rs.getString(3));

View Full Code Here

        InputStreamReader reader = new InputStreamReader(IOUtils.openFileInputStream(fileName));
        String text = IOUtils.readStringAndClose(reader, -1).trim();
        text = StringUtils.replaceAll(text, "\n", " ");
        assertEquals("ID|NAME 1|Hello", text);
        ResultSet rs = stat.executeQuery("select * from csvread('" + fileName + "', null, null, '|', '')");
        ResultSetMetaData meta = rs.getMetaData();
        assertEquals(2, meta.getColumnCount());
        assertEquals("ID", meta.getColumnLabel(1));
        assertEquals("NAME", meta.getColumnLabel(2));
        assertTrue(rs.next());
        assertEquals("1", rs.getString(1));
        assertEquals("Hello", rs.getString(2));
        assertFalse(rs.next());
        conn.close();

View Full Code Here

        file.write(b, 0, b.length);
        file.close();
        Connection conn = getConnection("csv");
        Statement stat = conn.createStatement();
        ResultSet rs = stat.executeQuery("select * from csvread('" + fileName + "', null, null, ';', '''', '\\')");
        ResultSetMetaData meta = rs.getMetaData();
        assertEquals(2, meta.getColumnCount());
        assertEquals("A", meta.getColumnLabel(1));
        assertEquals("B", meta.getColumnLabel(2));
        assertTrue(rs.next());
        assertEquals("It's nice", rs.getString(1));
        assertEquals("\nHello*\n", rs.getString(2));
        assertFalse(rs.next());
        stat.execute("call csvwrite('" + fileName2 +
                "', 'select * from csvread(''" + fileName +
                "'', null, null, '';'', '''''''', ''\\'')', null, '+', '*', '#')");
        rs = stat.executeQuery("select * from csvread('" + fileName2 +
                "', null, null, '+', '*', '#')");
        meta = rs.getMetaData();
        assertEquals(2, meta.getColumnCount());
        assertEquals("A", meta.getColumnLabel(1));
        assertEquals("B", meta.getColumnLabel(2));
        assertTrue(rs.next());
        assertEquals("It's nice", rs.getString(1));
        assertEquals("\nHello*\n", rs.getString(2));
        assertFalse(rs.next());
        conn.close();

View Full Code Here

        FileObject file = fs.openFileObject(fileName, "rw");
        byte[] b = "a,b,c,d\n201,-2,0,18\n, \"abc\"\"\" ,,\"\"\n 1 ,2 , 3, 4 \n5, 6, 7, 8".getBytes();
        file.write(b, 0, b.length);
        file.close();
        ResultSet rs = Csv.getInstance().read(fileName, null, "UTF8");
        ResultSetMetaData meta = rs.getMetaData();
        assertEquals(4, meta.getColumnCount());
        assertEquals("A", meta.getColumnLabel(1));
        assertEquals("B", meta.getColumnLabel(2));
        assertEquals("C", meta.getColumnLabel(3));
        assertEquals("D", meta.getColumnLabel(4));
        assertTrue(rs.next());
        assertEquals("201", rs.getString(1));
        assertEquals("-2", rs.getString(2));
        assertEquals("0", rs.getString(3));
        assertEquals("18", rs.getString(4));

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of java.sql.ResultSetMetaData

au.com.bytecode.opencsv_voltpatches.ResultSetHelperService

ca.carleton.gcrc.contributions.Contributions

cn.org.rapid_framework.generator.provider.db.table.TableFactory

com.alibaba.druid.filter.encoding.EncodingConvertFilter

com.alibaba.druid.filter.logging.LogFilter

com.alibaba.druid.filter.trace.TraceFilter

com.alibaba.druid.util.JdbcUtils

com.alibaba.wasp.jdbc.TestJdbcBase

com.alibaba.wasp.jdbc.TestJdbcResultSet

com.bleujin.framework.db.bean.BasicRowProcessor

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.