JDBC for SQL Server - Herong's Tutorial Examples - v3.13, by Herong Yang
JDBC-ODBC - Setting Current Database
This section describes how to select a database on the SQL Server to be the current database.
When you connect to a SQL Server, it will set the default database associated to the login name as the current database. You can set the current database to be a different database by including another property, database=name, in the connect URL string. Here is my sample program that connects to my SQL Server through the JDBC-ODBC Bridge and sets the current database to "AdventureWorksLT":
/* OdbcSqlServerCurrentDatabase.java * Copyright (c) HerongYang.com. All Rights Reserved. */ import java.sql.*; public class OdbcSqlServerCurrentDatabase { public static void main(String [] args) { Connection con = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection( "jdbc:odbc:SQL_SERVER;user=sa;password=HerongYang;" +"database=AdventureWorksLT"); // Checking the database name Statement sta = con.createStatement(); ResultSet res = sta.executeQuery("SELECT DB_NAME()"); res.next(); String name = res.getString(1); System.out.println("Current database: "+name); con.close(); } catch (Exception e) { System.err.println("Exception: "+e.getMessage()); } } }
The output confirms that the "database=name" property in the connection URL worked ok:
Current database: AdventureWorksLT
Table of Contents
JDBC (Java Database Connectivity) Introduction
Microsoft SQL Server Express Edition
Microsoft JDBC Driver for SQL Server
Microsoft JDBC Driver - Query Statements and Result Sets
Microsoft JDBC Driver - DatabaseMetaData Object
Microsoft JDBC Driver - DDL Statements
Microsoft JDBC Driver - DML Statements
SQL Server - PreparedStatement
SQL Server CLOB (Character Large Object) - TEXT
SQL Server BLOB (Binary Large Object) - BLOB
JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
JDBC-ODBC Bridge Driver - Flat Text Files
JDBC-ODBC Bridge Driver - MS Access
►JDBC-ODBC Bridge Driver - MS SQL Server
JDBC-ODBC - Configuring SQL Server for TCP/IP Connection
JDBC-ODBC - Creating DSN for SQL Server 2005
JDBC-ODBC - Connecting to SQL Server 2005
JDBC-ODBC - SQL Server and Driver Info
►JDBC-ODBC - Setting Current Database