Per JDBC vom DBMS unterstuetzte Funktionen ermitteln

[Thomas Darimont]

Hallo!

Schaut mal hier:

/**
 * 
 */
package de.tutorials;

import java.sql.Connection;
import java.sql.DatabaseMetaData;

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;

/**
 * @author Thomas
 * 
 */
public class MysqlExample {

	/**
	 * @param args
	 */
	public static void main(String[] args) throws Exception {
		Class.forName("com.mysql.jdbc.Driver");

		MysqlDataSource mds = new MysqlDataSource();
		mds.setServerName("localhost");
		mds.setDatabaseName("test");
		mds.setUser("root");
		mds.setPassword("foobar");

		Connection connection = mds.getConnection();

		DatabaseMetaData databaseMetaData = connection.getMetaData();

		System.out.println("SupportedNumericFunctions: "
				+ databaseMetaData.getNumericFunctions());

		System.out.println("SupportedStringFunctions: "
				+ databaseMetaData.getStringFunctions());

		System.out.println("SupportedSystemFunctions: "
				+ databaseMetaData.getSystemFunctions());

		System.out.println("SupportedTimeDateFunctions: "
				+ databaseMetaData.getTimeDateFunctions());

		connection.close();
	}

}

Gruss Tom