Below program consists of steps to connect SQL server using JDBC
package com.javatutorials; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class SqlServerConnection { public static Connection connection = null; public static Connection getDbConnection() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connection = DriverManager .getConnection("jdbc:odbc:mydsn;user=sa;password=sa12$"); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return connection; } public static void closeConnection() { if (connection != null) try { connection.close(); } catch (SQLException e) { e.printStackTrace(); } } }