/** * CloseConnection.java * Copyright (c) 2007 by Dr. Herong Yang. All rights reserved. */ import java.sql.*; public class CloseConnection { public static void main(String [] args) { Connection con = null; try { // Load Microsoft JDBC Driver 1.0 Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver"); // Obtaining a connection to SQL Server con = DriverManager.getConnection( "jdbc:sqlserver://localhost:1269;" + "user=sa;password=HerongYang"); // Connection is ready to use DatabaseMetaData meta = con.getMetaData(); System.out.println("Server name: " + meta.getDatabaseProductName()); System.out.println("Server version: " + meta.getDatabaseProductVersion()); // Closing the connection con.close(); if (con.isClosed()) System.out.println("Connection closed."); } catch (java.lang.ClassNotFoundException e) { System.err.println("ClassNotFoundException: " +e.getMessage()); } catch (SQLException e) { System.err.println("SQLException: " +e.getMessage()); } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)