java getcolumns_Java DatabaseMetaData.getColumns方法代碼示例

本文整理匯總了Java中java.sql.DatabaseMetaData.getColumns方法的典型用法代碼示例。如果您正苦於以下問題：Java DatabaseMetaData.getColumns方法的具體用法？Java DatabaseMetaData.getColumns怎麽用？Java DatabaseMetaData.getColumns使用的例子？那麽恭喜您, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類java.sql.DatabaseMetaData的用法示例。

在下文中一共展示了DatabaseMetaData.getColumns方法的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於我們的係統推薦出更棒的Java代碼示例。

示例1: testBug61332

​點讚 3

​

import java.sql.DatabaseMetaData; //導入方法依賴的package包/類

/**

* Tests fix for BUG#61332 - Check if "LIKE" or "=" is sent

* to server in I__S query when no wildcards are supplied

* for schema parameter.

*

* @throws Exception

* if the test fails.

*/

public void testBug61332() throws Exception {

Properties props = new Properties();

props.setProperty("useInformationSchema", "true");

props.setProperty("statementInterceptors", StatementInterceptorBug61332.class.getName());

createDatabase("dbbug61332");

Connection testConn = getConnectionWithProps(props);

if (versionMeetsMinimum(5, 0, 7)) {

try {

createTable("dbbug61332.bug61332", "(c1 char(1))");

DatabaseMetaData metaData = testConn.getMetaData();

this.rs = metaData.getColumns("dbbug61332", null, "bug61332", null);

this.rs.next();

} finally {

}

}

}

開發者ID:JuanJoseFJ，項目名稱:ProyectoPacientes，代碼行數:28，

示例2: testGetColumnsUnsigned

​點讚 3

​

import java.sql.DatabaseMetaData; //導入方法依賴的package包/類

/**

* Tests whether or not unsigned columns are reported correctly in

* DBMD.getColumns

*

* @throws Exception

*/

public void testGetColumnsUnsigned() throws Exception {

try {

this.stmt.executeUpdate("DROP TABLE IF EXISTS testGetUnsignedCols");

this.stmt.executeUpdate("CREATE TABLE testGetUnsignedCols (field1 BIGINT, field2 BIGINT UNSIGNED)");

DatabaseMetaData dbmd = this.conn.getMetaData();

this.rs = dbmd.getColumns(this.conn.getCatalog(), null, "testGetUnsignedCols", "%");

assertTrue(this.rs.next());

// This row doesn't have 'unsigned' attribute

assertTrue(this.rs.next());

assertTrue(this.rs.getString(6).toLowerCase().indexOf("unsigned") != -1);

} finally {

this.stmt.executeUpdate("DROP TABLE IF EXISTS testGetUnsignedCols");

}

}

開發者ID:JuanJoseFJ，項目名稱:ProyectoPacientes，代碼行數:24，

示例3: testGetColumnsUsingInfoSchema

​點讚 3

​

import java.sql.DatabaseMetaData; //導入方法依賴的package包/類

/**

* Tests the implementation of Information Schema for columns.

*/

public void testGetColumnsUsingInfoSchema() throws Exception {

if (versionMeetsMinimum(5, 0, 7)) {

createTable("t1", "(c1 char(1))");

Properties props = new Properties();

props.put("useInformationSchema", "true");

Connection conn1 = null;

try {

conn1 = getConnectionWithProps(props);

DatabaseMetaData metaData = conn1.getMetaData();

this.rs = metaData.getColumns(null, null, "t1", null);

this.rs.next();

assertEquals("t1", this.rs.getString("TABLE_NAME"));

assertEquals("c1", this.rs.getString("COLUMN_NAME"));

assertEquals("CHAR", this.rs.getString("TYPE_NAME"));

assertEquals("1", this.rs.getString("COLUMN_SIZE"));

} finally {

if (conn1 != null) {

conn1.close();

}

}

}

}

開發者ID:rafallis，項目名稱:BibliotecaPS，代碼行數:26，

示例4: testBug31187

​點讚 3

​

import java.sql.DatabaseMetaData; //導入方法依賴的package包/類

public void testBug31187() throws Exception {

createTable("testBug31187", "(field1 int)");

Connection nullCatConn = getConnectionWithProps("nullCatalogMeansCurrent=false");

DatabaseMetaData dbmd = nullCatConn.getMetaData();

ResultSet dbTblCols = dbmd.getColumns(null, null, "testBug31187", "%");

boolean found = false;

while (dbTblCols.next()) {

String catalog = dbTblCols.getString("TABLE_CAT");

String table = dbTblCols.getString("TABLE_NAME");

boolean useLowerCaseTableNames = dbmd.storesLowerCaseIdentifiers();

if (catalog.equals(nullCatConn.getCatalog())

&& (((useLowerCaseTableNames && "testBug31187".equalsIgnoreCase(table)) |