Java sql driver class

Class DriverManager

NOTE: The DataSource interface, provides another way to connect to a data source. The use of a DataSource object is the preferred means of connecting to a data source.

• The jdbc.drivers system property which contains a colon separated list of fully qualified class names of JDBC drivers. Each driver is loaded using the system class loader:
  • jdbc.drivers=foo.bah.Driver:wombat.sql.Driver:bad.taste.ourDriver

  Implementation Note: DriverManager initialization is done lazily and looks up service providers using the thread context class loader. The drivers loaded and available to an application will depend on the thread context class loader of the thread that triggers driver initialization by DriverManager .

  When the method getConnection is called, the DriverManager will attempt to locate a suitable driver from amongst those loaded at initialization and those loaded explicitly using the same class loader as the current application.

  Method Summary

  Retrieves a Stream with all of the currently loaded JDBC drivers to which the current caller has access.

  Retrieves an Enumeration with all of the currently loaded JDBC drivers to which the current caller has access.

  Sets the maximum time in seconds that a driver will wait while attempting to connect to a database once the driver has been identified.

  Methods declared in class java.lang.Object

  Method Details

  getLogWriter

  Retrieves the log writer. The getLogWriter and setLogWriter methods should be used instead of the get/setlogStream methods, which are deprecated.

  setLogWriter

  Sets the logging/tracing PrintWriter object that is used by the DriverManager and all drivers. If a security manager exists, its checkPermission method is first called with a SQLPermission(«setLog») permission to check that the caller is allowed to call setLogWriter .

  getConnection

  Attempts to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers. Note: If a property is specified as part of the url and is also specified in the Properties object, it is implementation-defined as to which value will take precedence. For maximum portability, an application should only specify a property once.

  getConnection

  public static Connection getConnection (String url, String user, String password) throws SQLException

  Attempts to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers. Note: If the user or password property are also specified as part of the url , it is implementation-defined as to which value will take precedence. For maximum portability, an application should only specify a property once.

  getConnection

  Attempts to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers.

  getDriver

  Attempts to locate a driver that understands the given URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers.

  registerDriver

  Registers the given driver with the DriverManager . A newly-loaded driver class should call the method registerDriver to make itself known to the DriverManager . If the driver is currently registered, no action is taken.

  registerDriver

  Registers the given driver with the DriverManager . A newly-loaded driver class should call the method registerDriver to make itself known to the DriverManager . If the driver is currently registered, no action is taken.

  deregisterDriver

  Removes the specified driver from the DriverManager ‘s list of registered drivers. If a null value is specified for the driver to be removed, then no action is taken. If a security manager exists, its checkPermission method is first called with a SQLPermission(«deregisterDriver») permission to check that the caller is allowed to deregister a JDBC Driver. If the specified driver is not found in the list of registered drivers, then no action is taken. If the driver was found, it will be removed from the list of registered drivers. If a DriverAction instance was specified when the JDBC driver was registered, its deregister method will be called prior to the driver being removed from the list of registered drivers.

  getDrivers

  Retrieves an Enumeration with all of the currently loaded JDBC drivers to which the current caller has access. Note: The classname of a driver can be found using d.getClass().getName()

  drivers

  Retrieves a Stream with all of the currently loaded JDBC drivers to which the current caller has access.

  setLoginTimeout

  Sets the maximum time in seconds that a driver will wait while attempting to connect to a database once the driver has been identified.

  getLoginTimeout

  setLogStream

  Sets the logging/tracing PrintStream that is used by the DriverManager and all drivers. If a security manager exists, its checkPermission method is first called with a SQLPermission(«setLog») permission to check that the caller is allowed to call setLogStream .

  getLogStream

  println

  Report a bug or suggest an enhancement
  For further API reference and developer documentation see the Java SE Documentation, which contains more detailed, developer-targeted descriptions with conceptual overviews, definitions of terms, workarounds, and working code examples. Other versions.
  Java is a trademark or registered trademark of Oracle and/or its affiliates in the US and other countries.
  Copyright © 1993, 2023, Oracle and/or its affiliates, 500 Oracle Parkway, Redwood Shores, CA 94065 USA.
  All rights reserved. Use is subject to license terms and the documentation redistribution policy.

  Источник

  Java sql driver class

  The interface that every driver class must implement. The Java SQL framework allows for multiple database drivers. Each driver should supply a class that implements the Driver interface. The DriverManager will try to load as many drivers as it can find and then for any given connection request, it will ask each driver in turn to try to connect to the target URL. It is strongly recommended that each Driver class should be small and standalone so that the Driver class can be loaded and queried without bringing in vast quantities of supporting code. When a Driver class is loaded, it should create an instance of itself and register it with the DriverManager. This means that a user can load and register a driver by calling: Class.forName(«foo.bah.Driver») A JDBC driver may create a DriverAction implementation in order to receive notifications when DriverManager.deregisterDriver(java.sql.Driver) has been called.

  Method Summary

  Method Detail

  connect

  Connection connect(String url, Properties info) throws SQLException

  Attempts to make a database connection to the given URL. The driver should return «null» if it realizes it is the wrong kind of driver to connect to the given URL. This will be common, as when the JDBC driver manager is asked to connect to a given URL it passes the URL to each loaded driver in turn. The driver should throw an SQLException if it is the right driver to connect to the given URL but has trouble connecting to the database. The Properties argument can be used to pass arbitrary string tag/value pairs as connection arguments. Normally at least «user» and «password» properties should be included in the Properties object. Note: If a property is specified as part of the url and is also specified in the Properties object, it is implementation-defined as to which value will take precedence. For maximum portability, an application should only specify a property once.

  acceptsURL

  Retrieves whether the driver thinks that it can open a connection to the given URL. Typically drivers will return true if they understand the sub-protocol specified in the URL and false if they do not.

  getPropertyInfo

  DriverPropertyInfo[] getPropertyInfo(String url, Properties info) throws SQLException

  Gets information about the possible properties for this driver. The getPropertyInfo method is intended to allow a generic GUI tool to discover what properties it should prompt a human for in order to get enough information to connect to a database. Note that depending on the values the human has supplied so far, additional values may become necessary, so it may be necessary to iterate though several calls to the getPropertyInfo method.

  getMajorVersion

  getMinorVersion

  jdbcCompliant

  Reports whether this driver is a genuine JDBC Compliant™ driver. A driver may only report true here if it passes the JDBC compliance tests; otherwise it is required to return false . JDBC compliance requires full support for the JDBC API and full support for SQL 92 Entry Level. It is expected that JDBC compliant drivers will be available for all the major commercial databases. This method is not intended to encourage the development of non-JDBC compliant drivers, but is a recognition of the fact that some vendors are interested in using the JDBC API and framework for lightweight databases that do not support full database functionality, or for special databases such as document information retrieval where a SQL implementation may not be feasible.

  getParentLogger

  Logger getParentLogger() throws SQLFeatureNotSupportedException

  Return the parent Logger of all the Loggers used by this driver. This should be the Logger farthest from the root Logger that is still an ancestor of all of the Loggers used by this driver. Configuring this Logger will affect all of the log messages generated by the driver. In the worst case, this may be the root Logger.

  Submit a bug or feature
  For further API reference and developer documentation, see Java SE Documentation. That documentation contains more detailed, developer-targeted descriptions, with conceptual overviews, definitions of terms, workarounds, and working code examples.
  Copyright © 1993, 2023, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Also see the documentation redistribution policy.

  Источник

  Читайте также:  Get selected option value