jdbcversion.java

一个用于确定当前正在使用的Oracle的版本的小程序

// Code starts here
import java.sql.*;

import oracle.jdbc.driver.*;

class JDBCVersion
{
public static void main (String args [])
	throws SQLException {
	// Load the Oracle JDBC driver
	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
	// Change the following code line to reflect a valid connection to your server
	Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@ct21wd:1521:dbora9i","scott","tiger");
	// Create Oracle DatabaseMetaData object
	DatabaseMetaData meta = conn.getMetaData ();
	// Gets driver info:
	System.out.println("\n=============\nDatabase Product Name is ... " + meta.getDatabaseProductName());
	System.out.println("\nDatabase Product Version is  " + meta.getDatabaseProductVersion());
	System.out.println("\n=============\nJDBC Driver Name is ........ " + meta.getDriverName());
	System.out.println("\nJDBC Driver Version is ..... " + meta.getDriverVersion());
	System.out.println("\nJDBC Driver Major Version is " + meta.getDriverMajorVersion());
	System.out.println("\nJDBC Driver Minor Version is " + meta.getDriverMinorVersion());
	System.out.println("\n============="); }
}
// Code ends here