@Test
 public void columnOrderOfgetTypeInfo() throws SQLException {
   ResultSet rs = meta.getTypeInfo();
   assertTrue(rs.next());
   ResultSetMetaData rsmeta = rs.getMetaData();
   assertEquals(rsmeta.getColumnCount(), 18);
   assertEquals(rsmeta.getColumnName(1), "TYPE_NAME");
   assertEquals(rsmeta.getColumnName(2), "DATA_TYPE");
   assertEquals(rsmeta.getColumnName(3), "PRECISION");
   assertEquals(rsmeta.getColumnName(4), "LITERAL_PREFIX");
   assertEquals(rsmeta.getColumnName(5), "LITERAL_SUFFIX");
   assertEquals(rsmeta.getColumnName(6), "CREATE_PARAMS");
   assertEquals(rsmeta.getColumnName(7), "NULLABLE");
   assertEquals(rsmeta.getColumnName(8), "CASE_SENSITIVE");
   assertEquals(rsmeta.getColumnName(9), "SEARCHABLE");
   assertEquals(rsmeta.getColumnName(10), "UNSIGNED_ATTRIBUTE");
   assertEquals(rsmeta.getColumnName(11), "FIXED_PREC_SCALE");
   assertEquals(rsmeta.getColumnName(12), "AUTO_INCREMENT");
   assertEquals(rsmeta.getColumnName(13), "LOCAL_TYPE_NAME");
   assertEquals(rsmeta.getColumnName(14), "MINIMUM_SCALE");
   assertEquals(rsmeta.getColumnName(15), "MAXIMUM_SCALE");
   assertEquals(rsmeta.getColumnName(16), "SQL_DATA_TYPE");
   assertEquals(rsmeta.getColumnName(17), "SQL_DATETIME_SUB");
   assertEquals(rsmeta.getColumnName(18), "NUM_PREC_RADIX");
 }
 public ResultSet getTypeInfo() throws SQLException {
   _conn.checkOpen();
   try {
     return DelegatingResultSet.wrapResultSet(_conn, _meta.getTypeInfo());
   } catch (SQLException e) {
     handleException(e);
     throw new AssertionError();
   }
 }
 @Test
 public void getTypeInfo() throws SQLException {
   ResultSet rs = meta.getTypeInfo();
   assertNotNull(rs);
   assertTrue(rs.next());
   assertEquals(rs.getString("TYPE_NAME"), "BLOB");
   assertTrue(rs.next());
   assertEquals(rs.getString("TYPE_NAME"), "INTEGER");
   assertTrue(rs.next());
   assertEquals(rs.getString("TYPE_NAME"), "NULL");
   assertTrue(rs.next());
   assertEquals(rs.getString("TYPE_NAME"), "REAL");
   assertTrue(rs.next());
   assertEquals(rs.getString("TYPE_NAME"), "TEXT");
   assertFalse(rs.next());
 }
示例#4
0
  public static void main(String[] args) {
    Connection connection = null; // 从其它地方获取链接
    try {
      DatabaseMetaData dbmd = connection.getMetaData();

      // 得到类型信息
      ResultSet resultSet = dbmd.getTypeInfo();

      while (resultSet.next()) {
        // 得到数据库指定的类型名
        String typeName = resultSet.getString("TYPE_NAME");

        // 得到 java.sql.Type 映射的类型
        short dataType = resultSet.getShort("DATA_TYPE");
      }

    } catch (SQLException e) {
    }
  }
  public static void main(String args[]) {

    Connection connection = null;
    SQLMXJdbcRowSet jrs = null;
    Statement stmt = null;
    ResultSet rs = null;
    DatabaseMetaData dbMeta = null;
    ResultSetMetaData rsMD = null;
    int rowNo;

    try {
      Class.forName("org.trafodion.jdbc.t2.T2Driver");
    } catch (Exception e) {
      e.printStackTrace();
      System.out.println(e.getMessage());
      return;
    }
    try {
      String url = "jdbc:t2jdbc:";
      connection = DriverManager.getConnection(url);
      stmt = connection.createStatement();
      try {
        stmt.executeUpdate("drop table jdbcrsdemo");
      } catch (SQLException e) {
      }
      stmt.executeUpdate(
          "create table jdbcrsdemo (c1 char(20), c2 smallint, c3 integer, c4 largeint, c5 varchar(120), c6 numeric(10,2), c7 decimal(10,2),c8 date, c9 time, c10 timestamp, c11 float, c12 double precision)");
      stmt.executeUpdate(
          "insert into jdbcrsdemo values('Doberman Pinscher', 100, 12345678, 123456789012, 'Canine', 100.12, 100.12, {d '2005-12-23'}, {t '10:11:12'}, {ts '2000-12-23 10:11:12'}, 100.12, 100.12)");
      stmt.executeUpdate(
          "insert into jdbcrsdemo values('Rottweiler', 150, -12345678, -123456789012, 'Canine', -100.12, -100.12, {d '2005-12-24'}, {t '10:11:12'}, {ts '2005-12-24 10:11:12'}, -100.12, -100.12)");
      stmt.executeUpdate(
          "insert into jdbcrsdemo values('Tiger', 101, -12345678, 123456789012, 'Feline', -100.12, 100.12, {d '2005-12-25'}, {t '10:11:12'}, {ts '2005-12-25 10:11:12.0'}, -100.12, 100.12)");

      System.out.println("Creating JdbcRowSet");
      jrs = new SQLMXJdbcRowSet();
      jrs.setUrl(url);

      for (int i = 0; i < 5; i++) {
        switch (i) {
          case 0:
            System.out.println("");
            System.out.println("Simple Select ");
            jrs.setCommand("select * from jdbcrsdemo");
            jrs.execute();
            break;
          case 1:
            System.out.println("");
            System.out.println("Parameterized Select - CHAR");
            jrs.setCommand("select c1, c2 from jdbcrsdemo where c1 = ?");
            jrs.setString(1, "Rottweiler");
            jrs.execute();
            break;
          case 2:
            System.out.println("");
            System.out.println("Parameterized Select - INT");
            jrs.setCommand("select c1, c2, c3 from jdbcrsdemo where c2 = ?  or c2 = ?");
            jrs.setInt(1, 100);
            jrs.setInt(2, 150);
            jrs.execute();
            break;
          case 3:
            System.out.println("");
            System.out.println("Parameterized Select - TIMESTAMP");
            jrs.setCommand("select c1, c2, c3, c10 from jdbcrsdemo where c10 = ?");
            jrs.setTimestamp(1, Timestamp.valueOf("2005-12-25 10:11:12.0"));
            jrs.execute();
            break;
          case 4:
            System.out.println("");
            System.out.println("Parameterized Select - DECIMAL");
            jrs.setCommand("select c1, c2, c3, c7 from jdbcrsdemo where c7 = ? or c7 = ?");
            jrs.setBigDecimal(1, new BigDecimal("100.12"));
            jrs.setBigDecimal(2, new BigDecimal("-100.12"));
            jrs.execute();
            break;
        }
        rsMD = jrs.getMetaData();
        System.out.println("");
        System.out.println("Printing JdbcRowSet ResultSetMetaData ...");
        System.out.println("No. of Columns " + rsMD.getColumnCount());
        for (int j = 1; j <= rsMD.getColumnCount(); j++) {
          System.out.println(
              "Column "
                  + j
                  + " Data Type: "
                  + rsMD.getColumnTypeName(j)
                  + " Name: "
                  + rsMD.getColumnName(j));
        }
        System.out.println("");
        System.out.println("Fetching JdbcRowSet rows...");
        rowNo = 0;
        while (jrs.next()) {
          rowNo++;
          System.out.println("");
          System.out.println("Printing Row " + rowNo + " using getString(), getObject()");
          for (int j = 1; j <= rsMD.getColumnCount(); j++) {
            System.out.println("Column " + j + " - " + jrs.getString(j) + "," + jrs.getObject(j));
          }
        }
        System.out.println("");
      }

      System.out.println("Calling JdbcRowSet.getDatabaseMetaData()");
      dbMeta = jrs.getDatabaseMetaData();

      for (int k = 0; k < 4; k++) {
        switch (k) {
          case 0:
            System.out.println("");
            System.out.println("getTypeInfo() ");
            rs = dbMeta.getTypeInfo();
            break;
          case 1:
            System.out.println("");
            System.out.println("getCatalogs()");
            rs = dbMeta.getCatalogs();
            break;
          case 2:
            System.out.println("");
            System.out.println("getTables() ");
            rs = dbMeta.getTables(null, null, "JDB%", null);
            break;
          case 3:
            System.out.println("");
            System.out.println("getColumns()");
            rs = dbMeta.getColumns(null, null, "JDBCRSDEMO", "%");
            break;
          default:
            rs = null;
            continue;
        }

        if (rs != null) {
          rsMD = rs.getMetaData();
          System.out.println("");

          System.out.println("Printing ResultSetMetaData ...");
          System.out.println("No. of Columns " + rsMD.getColumnCount());
          for (int j = 1; j <= rsMD.getColumnCount(); j++) {
            System.out.println(
                "Column "
                    + j
                    + " Data Type: "
                    + rsMD.getColumnTypeName(j)
                    + " Name: "
                    + rsMD.getColumnName(j));
          }
          System.out.println("");
          System.out.println("Fetching resultSet rows...");
          rowNo = 0;
          while (rs.next()) {
            rowNo++;
            System.out.println("");
            System.out.println("Printing Row " + rowNo + " using getString(), getObject()");
            for (int j = 1; j <= rsMD.getColumnCount(); j++) {
              System.out.println("Column " + j + " - " + rs.getString(j) + "," + rs.getObject(j));
            }
          }
        }
        System.out.println("");
        System.out.println("End of Data");
        if (rs != null) rs.close();
      }
      System.out.println("Demo Completed");
    } catch (SQLException e) {
      SQLException nextException;

      nextException = e;
      do {
        System.out.println(nextException.getMessage());
        System.out.println("SQLState   " + nextException.getSQLState());
        System.out.println("Error Code " + nextException.getErrorCode());
      } while ((nextException = nextException.getNextException()) != null);
    } finally {
      try {
        if (connection != null) connection.close();
        if (jrs != null) jrs.close();
      } catch (SQLException sqle) {
        sqle.printStackTrace();
        System.out.println(sqle.getMessage());
      }
    }
  }
 @Test
 public void testTypeInfo() throws Exception {
   TestMMDatabaseMetaData.compareResultSet(dbMetadata.getTypeInfo()); // $NON-NLS-1$
 }
 public ResultSet getTypeInfo() throws SQLException {
   return throwExceptionDelegate.getTypeInfo();
 }