Java by API/java.sql/DriverManager
Содержание
- 1 DriverManager: getConnection(String url) (jdbc:odbc:technical_library)
- 2 DriverManager: getConnection(String url, Properties info)
- 3 DriverManager: getConnection(String url, String user, String password)
- 4 DriverManager: getDrivers()
- 5 DriverManager: registerDriver(Driver driver)
- 6 DriverManager: setLogWriter(PrintWriter out)
DriverManager: getConnection(String url) (jdbc:odbc:technical_library)
<source lang="java">
/*
* */
import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Main {
public static void main(String[] args) throws Exception { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Define the data source for the driver String sourceURL = "jdbc:odbc:technical_library"; // Create a connection through the DriverManager Connection databaseConnection = DriverManager.getConnection(sourceURL); System.out.println("Connection is: "+databaseConnection); } catch(ClassNotFoundException cnfe) { System.err.println(cnfe); } catch(SQLException sqle) { System.err.println(sqle); } }
}
</source>
DriverManager: getConnection(String url, Properties info)
<source lang="java">
import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.Properties; public class Main {
public static Connection getConnection(String dbURL, String user, String password) throws SQLException, ClassNotFoundException { Class.forName("com.mysql.jdbc.Driver"); Properties props = new Properties(); props.put("user", user); props.put("password", password); props.put("autoReconnect", "true"); return DriverManager.getConnection(dbURL, props); } public static void main(String[] args) { Connection conn = null; try { conn = getConnection("jdbc:mysql://localhost/empDB", "root", "pass"); } catch (Exception ex) { System.out.println("SQLException: " + ex.getMessage()); } }
}
</source>
DriverManager: getConnection(String url, String user, String password)
<source lang="java">
import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; public class Main {
public static void main(String[] args) throws Exception { setup(); } static Connection conn; static Statement st; public static void setup() { try { // Step 1: Load the JDBC driver. Class.forName("org.hsqldb.jdbcDriver"); System.out.println("Driver Loaded."); // Step 2: Establish the connection to the database. String url = "jdbc:hsqldb:data/tutorial"; conn = DriverManager.getConnection(url, "sa", ""); System.out.println("Got Connection."); st = conn.createStatement(); } catch (Exception e) { System.err.println("Got an exception! "); e.printStackTrace(); System.exit(0); } }
}
</source>
DriverManager: getDrivers()
<source lang="java">
import java.sql.Driver; import java.sql.DriverManager; public class Main {
public static void main(String[] args) throws Exception { Class driverClass = Class.forName("org.hsqldb.jdbcDriver"); DriverManager.registerDriver((Driver) driverClass.newInstance()); // Print out all loaded JDBC drivers. java.util.Enumeration e = java.sql.DriverManager.getDrivers(); while (e.hasMoreElements()) { Object driverAsObject = e.nextElement(); System.out.println("JDBC Driver=" + driverAsObject); } }
}
</source>
DriverManager: registerDriver(Driver driver)
<source lang="java">
import java.sql.Driver; import java.sql.DriverManager; public class Main {
public static void main(String[] args) throws Exception { Class driverClass = Class.forName("org.hsqldb.jdbcDriver"); DriverManager.registerDriver((Driver) driverClass.newInstance()); // Print out all loaded JDBC drivers. java.util.Enumeration e = java.sql.DriverManager.getDrivers(); while (e.hasMoreElements()) { Object driverAsObject = e.nextElement(); System.out.println("JDBC Driver=" + driverAsObject); } }
}
</source>
DriverManager: setLogWriter(PrintWriter out)
<source lang="java">
import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.SQLWarning; public class Main {
public static void main(String[] args) throws Exception { String dbURL = "jdbc:odbc:Companies"; try { // Load the jdbc-odbc bridge driver Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Enable logging DriverManager.setLogWriter(new PrintWriter((System.err))); System.out.println("Getting Connection"); Connection conn = DriverManager.getConnection(dbURL, "user", "password"); SQLWarning warn = conn.getWarnings(); while (warn != null) { System.out.println("SQLState: " + warn.getSQLState()); System.out.println("Message: " + warn.getMessage()); System.out.println("Vendor: " + warn.getErrorCode()); System.out.println(""); warn = warn.getNextWarning(); } conn.close(); } catch (ClassNotFoundException e) { System.out.println("Can"t load driver " + e); } catch (SQLException e) { System.out.println("Database access failed " + e); } }
}
</source>