import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;
public class OracleConnection
{
public static void main(String args[]) throws Exception
{
//Oracle
Class.forName("oracle.jdbc.driver.OracleDriver"); //指定Oracle JDBC驱动程序
String url="jdbc:oracle:thin:@localhost:1521:orcl";
Connection conn = DriverManager.getConnection(url,"faith","faith");//连接url指定数据库
DatabaseMetaData dbmd = conn.getMetaData(); //获得所连接数据库的属性信息
System.out.println("JDBC驱动程序: "+dbmd.getDriverName()+","+dbmd.getDriverVersion()+"\n"+
"JDBC URL: "+dbmd.getURL()+"\n"+
"数据库: "+dbmd.getDatabaseProductName()+"\n"+
"数据库版本: "+dbmd.getDatabaseProductVersion()+"\n"+
"用户名: "+dbmd.getUserName()+"\n");
conn.close(); //关闭数据库连接
}
}