![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e237. Connecting to a SQLServer DatabaseThis example connects to a SQLServer database using the NetDirect JDBC driver. For information about this driver, see e232 Getting JDBC Drivers for a Database.Connection connection = null; try { String driverName = "com.jnetdirect.jsql.JSQLDriver"; // NetDirect JDBC driver String serverName = "127.0.0.1"; String portNumber = "1433"; String mydatabase = serverName + ":" + portNumber; String url = "jdbc:JSQLConnect://" + mydatabase; // a JDBC url String username = "username"; String password = "password"; // Load the JDBC driver Class.forName(driverName); // Create a connection to the database connection = DriverManager.getConnection(url, username, password); } catch (ClassNotFoundException e) { // Could not find the database driver } catch (SQLException e) { // Could not connect to the database }
e236. Connecting to a MySQL Database e238. Listing All Available Parameters for Creating a JDBC Connection e239. Determining If a Database Supports Transactions e240. Committing and Rolling Back Updates to a Database e241. Handling a SQL Exception e242. Determining If a SQL Warning Occurred e243. Getting the Driver of a Connection e244. Setting the Number of Rows to Prefetch When Executing a SQL Query © 2002 Addison-Wesley. |